/SMB/V_FILE_DEF_ADMIN_DATA

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view /SMB/V_FILE_DEF_ADMIN_DATA.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW /SMB/V_FILE_DEF_ADMIN_DATA AS
SELECT
  lib_h.bbid AS bbid,
  lib_h.sir_bb_id AS sir_bb_id,
  lib_i.seqnum AS seqnum,
  lib_i.objid AS objid,
  lib_i.objty AS objty,
  sobj.filename AS filename,
  def_img.created_by AS created_by,
  def_img.created_on AS created_on,
  def_img.gmd_status as gmd_status AS bbidasbbid,
  def_bcs.gmd_status AS gmd_status
FROM /smb/bb_lib_h AS lib_h
INNER JOIN /smb/bb_lib_i AS lib_i ON /* join condition not captured in parsed metadata */
INNER JOIN /smb/bb_img_sobj AS sobj ON /* join condition not captured in parsed metadata */
INNER JOIN /smb/sobj_def AS def_img ON /* join condition not captured in parsed metadata */
INNER JOIN /smb/ecat_def AS def_ecat ON /* join condition not captured in parsed metadata */
INNER JOIN /smb/bc_def_info AS def_bcs ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): /smb/bb_lib_h
;