CSN_EXPOSURE_CDS_DEFAULT_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 CSN_EXPOSURE_CDS_DEFAULT_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: CSNEXPCDSDEFNFT
-- Parameters: P_Language : abap.lang

CREATE VIEW CSN_EXPOSURE_CDS_DEFAULT_NFT AS
SELECT
  stob.strucobjn_raw AS EntityName,
  _label_text[1: ddlanguage = $parameters.P_Language].ddtext AS EntityLabel,
  api_state.compatibility_contract AS ReleaseContract,
  api_state.release_state AS ReleaseState,
  coalesce( api_state_c2.compatibility_contract, coalesce ( api_state_c1.compatibility_contract, api_state_c0.compatibility_contract ) ) AS ReleaseContractMax,
  coalesce( api_state_c2.release_state, coalesce ( api_state_c1.release_state, api_state_c0.release_state ) ) AS ReleaseStateMax,
  api_state_c0.release_state AS ReleaseStateC0,
  api_state_c0.compatibility_contract AS ReleaseContractC0,
  api_state_c1.release_state AS ReleaseStateC1,
  api_state_c1.compatibility_contract AS ReleaseContractC1,
  api_state_c2.release_state AS ReleaseStateC2,
  api_state_c2.compatibility_contract AS ReleaseContractC2,
  annoMPMap.AnnotationEnumKey AS ModelingPattern,
  _annoMPText[1: Language = $parameters.P_Language].Description AS ModelingPatternDescription,
  annoExtr.value AS AnalyticsDataExtractable,
  header_annos.name AS HeaderAnnotationName,
  header_annos.value AS HeaderAnnotationValue,
  appl_comps.ps_posid AS ApplicationComponent,
  _ac_text[1: langu = $parameters.P_Language].name AS ApplicationComponentText,
  elements.fieldname AS Field,
  tdevc.dlvunit AS SoftwareComponent,
  _tdevct[1: spras = $parameters.P_Language].ctext AS ComponentText
FROM dd02b AS stob
INNER JOIN ddldependency AS dep ON /* join condition not captured in parsed metadata */
INNER JOIN dd02bnd AS node_info ON /* join condition not captured in parsed metadata */
INNER JOIN DDCDS_USED_SESSION_VARIABLE AS session_var ON /* join condition not captured in parsed metadata */
INNER JOIN tadir 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 CSN_EXPOSURE_CDS_ARS_APIS_NFT AS api_state_c0 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CSN_EXPOSURE_CDS_ARS_APIS_NFT AS api_state_c1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CSN_EXPOSURE_CDS_ARS_APIS_NFT AS api_state_c2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS annoMP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS annoExtr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SADL_GW_DDLA_AnnotationEnum AS annoMPMap ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS header_annos ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l AS appl_comps ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd03nd AS elements ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SADL_GW_DDLA_AnnotationEnumT AS _annoMPText ON _annoMPText.AnnotationKey = 'OBJECTMODEL.MODELINGPATTERN' AND _annoMPText.AnnotationEnumKey = annoMPMap.AnnotationEnumKey  -- association [0..*]
LEFT OUTER JOIN df14t AS _ac_text ON _ac_text.fctr_id = appl_comps.fctr_id AND _ac_text.as4local = 'A' AND _ac_text.addon = ''  -- association [0..*]
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  -- association [0..*]
LEFT OUTER JOIN tdevct AS _tdevct ON _tdevct.devclass = tadir.devclass  -- association [0..*]
;