/FTI/V_BCO_PROP_DETAIL_VIEW

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 /FTI/V_BCO_PROP_DETAIL_VIEW.
-- 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.
-- SQL view name: /FTI/V_BCO_PRDT

CREATE VIEW /FTI/V_BCO_PROP_DETAIL_VIEW AS
SELECT
  bco.name AS bco_name,
  lib_i.bbid AS bbid,
  lib_i.objty AS objty,
  lib_i.objid AS objid,
  lib_i.filename AS objfile,
  sobj.filename AS sobjfile,
  sobj.objid AS sobj,
  prop.paramname AS paramname,
  sobj.img_activity AS img_act_sobj,
  bcs.activity AS img_act_bcs,
  bcs.objectname AS cust_obj_bcs,
  bcs.objecttype AS cust_typ_bcs,
  prop.id AS property_id,
  bco.id AS bco_id
FROM /smb/bb_lib_i AS lib_i
LEFT OUTER JOIN /smb/bb_img_sobj AS sobj ON /* join condition not captured in parsed metadata */
INNER JOIN /fti/bco_prop AS prop ON /* join condition not captured in parsed metadata */
INNER JOIN /fti/bco AS bco ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scprreca AS bcs ON /* join condition not captured in parsed metadata */
;