SSCH_CMS_CDS_NFT

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 SSCH_CMS_CDS_NFT.
-- 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: SCHCDSNFT
-- Parameters: P_Language : abap.lang

CREATE VIEW SSCH_CMS_CDS_NFT AS
SELECT
  _ants.cdsentity AS EntityName,
  _label_text[1: ddlanguage = $parameters.P_Language].ddtext AS EntityLabel,
  annoMP.value AS ModelingPattern
FROM ssch_cms_ants AS _ants
LEFT OUTER JOIN ddheadanno AS annoMP ON /* join condition not captured in parsed metadata */
INNER JOIN dd02b AS stob ON /* join condition not captured in parsed metadata */
INNER JOIN ddldependency AS dep ON /* join condition not captured in parsed metadata */
INNER JOIN ddddlsrc AS src ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CSN_EXPOSURE_CDS_ARS_APIS_NFT AS api_state ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddddlsrc02bt AS _label_text ON _label_text.ddlname = dep.ddlname AND _label_text.strucobjn = stob.strucobjn AND _label_text.as4local = stob.as4local AND dep.objecttype = 'STOB'  -- association [0..*]
;