/FTI/V_BCO_PROP_KEY_FIELD_VIEW

DDL: /FTI/V_DDL_BCO_PROP_KEY_FIELDS SQL: /FTI/V_BCO_KEY Type: view
4 Fields 2 Data Sources

/FTI/V_BCO_PROP_KEY_FIELD_VIEW is a CDS View in SAP S/4HANA. It reads from 2 data sources (/fti/bco, /fti/bco_prop) and exposes 4 fields.

Data Sources (2)

SourceAliasJoin Type
/fti/bco bco from
/fti/bco_prop prop inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName /FTI/V_BCO_KEY view
ClientDependent true view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
bco_id /fti/bco id WorklistID
bco_name /fti/bco name Zone name
filename /fti/bco_prop filename URL or Filenam Path
paramname /fti/bco_prop paramname Parameter

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_KEY_FIELD_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_KEY

CREATE VIEW /FTI/V_BCO_PROP_KEY_FIELD_VIEW AS
SELECT
  bco.id AS bco_id,
  bco.name AS bco_name,
  prop.filename AS filename,
  prop.paramname AS paramname
FROM /fti/bco AS bco
INNER JOIN /fti/bco_prop AS prop ON /* join condition not captured in parsed metadata */
;

Learn More