DDCDS_ENTITY_ELEMENTS

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 DDCDS_ENTITY_ELEMENTS.
-- 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: DDCDS_E_ELEM_V

CREATE VIEW DDCDS_ENTITY_ELEMENTS AS
SELECT
  cast(stob.strucobjn as abap.char(30)) AS entity_name,
  cast(stob.as4local as abap.char(1)) AS entity_state,
  cast(elements.fieldname as abap.char(30)) AS element_name,
  cast(elements.leng as abap.numc(6) ) AS length,
  cast(elements.decimals as abap.numc(6) ) AS decimals,
  cast(elements.domname as abap.char(30)) AS domain_name,
  cast(elements.rollname as abap.char(30)) AS data_element,
  cast(elements.reffield as abap.char(30)) AS ref_field,
  cast(elements.reftable as abap.char(30)) AS ref_table,
  cast(elements.keyflag as abap.char(1)) AS is_key,
  cast(elements.is_virtual as abap.char(1)) AS is_virtual,
  case when elements.fieldorigin = 'E' then 'X' else ' ' end AS is_external,
  cast(elements.simple_type as abap.char(30)) AS simple_type
FROM dd02b AS stob
INNER JOIN DDCDS_ENTITY_ELEMENTS_LIST AS elements ON /* join condition not captured in parsed metadata */
INNER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddddlsrc03nt AS _label_active ON _label_active.strucobjn = stob.strucobjn AND _label_active.as4local = stob.as4local AND _label_active.fieldname = elements.fieldname AND _label_active.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ddddlsrc03nt AS _label_active_en ON _label_active_en.strucobjn = stob.strucobjn AND _label_active_en.as4local = stob.as4local AND _label_active_en.fieldname = elements.fieldname AND _label_active_en.ddlanguage = 'E'  -- association [0..1]
LEFT OUTER JOIN ddddlsrc03nt AS _label_active_orig ON _label_active_orig.strucobjn = stob.strucobjn AND _label_active_orig.as4local = stob.as4local AND _label_active_orig.fieldname = elements.fieldname AND _label_active_orig.ddlanguage = tadir.masterlang  -- association [0..1]
LEFT OUTER JOIN ddfieldanno AS _label_active_fb ON _label_active_fb.strucobjn = stob.strucobjn AND _label_active_fb.lfieldname = elements.fieldname AND _label_active_fb.name = 'ENDUSERTEXT.LABEL'  -- association [0..1]
LEFT OUTER JOIN ddfieldanno AS _aggregation_default ON _aggregation_default.strucobjn = elements.strucobjn AND _aggregation_default.lfieldname = elements.fieldname AND _aggregation_default.name = 'AGGREGATION.DEFAULT'  -- association [0..1]
LEFT OUTER JOIN ddfieldanno AS _currency_code ON _currency_code.strucobjn = elements.strucobjn AND _currency_code.lfieldname = elements.fieldname AND _currency_code.name = 'SEMANTICS.AMOUNT.CURRENCYCODE'  -- association [0..1]
LEFT OUTER JOIN ddfieldanno AS _release_status ON _release_status.strucobjn = elements.strucobjn AND _release_status.lfieldname = elements.fieldname AND _release_status.name = 'API.ELEMENT.RELEASESTATE'  -- association [0..1]
LEFT OUTER JOIN dd04t AS _dte_label_active ON _dte_label_active.rollname = elements.rollname AND _dte_label_active.as4local = elements.as4local AND _dte_label_active.ddlanguage = $session.system_language AND _dte_label_active.as4vers = '0000'  -- association [0..1]
LEFT OUTER JOIN dd04t AS _dte_label_active_en ON _dte_label_active_en.rollname = elements.rollname AND _dte_label_active_en.as4local = elements.as4local AND _dte_label_active_en.ddlanguage = 'E' AND _dte_label_active_en.as4vers = '0000'  -- association [0..1]
LEFT OUTER JOIN dd04t AS _dte_label_active_orig ON _dte_label_active_orig.rollname = elements.rollname AND _dte_label_active_orig.as4local = elements.as4local AND _dte_label_active_orig.ddlanguage = tadir.masterlang AND _dte_label_active_orig.as4vers = '0000'  -- association [0..1]
;