CSN_EXPOSURE_CDS

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

CREATE VIEW CSN_EXPOSURE_CDS AS
SELECT
  esh_csn_cdscsn.cds_entity_name_raw AS EntityName,
  _label_text[1: ddlanguage = $parameters.P_Language].ddtext AS EntityLabel,
  esh_csn_cdscsn.release_contract AS ReleaseContract,
  esh_csn_cdscsn.release_state AS ReleaseState,
  esh_csn_cdscsn.modeling_pattern AS ModelingPattern,
  header_annos.name AS HeaderAnnotationName,
  header_annos.value AS HeaderAnnotationValue,
  esh_csn_cdscsn.application_component AS ApplicationComponent,
  _ac_text[1: langu = $parameters.P_Language].name AS ApplicationComponentText,
  elements.fieldname AS Field,
  esh_csn_cdscsn.software_component AS SoftwareComponent,
  _tdevct[1: spras = $parameters.P_Language].ctext AS ComponentText
FROM esh_csn_cdscsn
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 ddheadanno AS header_annos 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 df14l AS appl_comps ON /* join condition not captured in parsed metadata */
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 = esh_csn_cdscsn.software_component  -- association [0..*]
;