DDL_OBJECT_NAMES

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 DDL_OBJECT_NAMES.
-- 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.

CREATE VIEW DDL_OBJECT_NAMES AS
SELECT
  src.ddlname AS CDS_DDL,
  dep_entity.objectname AS CDS_ENTITY,
  dep_db_view.objectname AS CDS_DB_VIEW,
  src.parentname AS CDS_PARENT_VIEW,
  src.source_type AS CDS_OBJECT_TYPE,
  src.as4local AS STATE,
  coalesce( _text_active.ddlanguage, _text_english.ddlanguage ) AS TEXT_LANGUAGE,
  coalesce( _text_active.ddtext, _text_english.ddtext ) AS TEXT
FROM ddddlsrc AS src
LEFT OUTER JOIN ddddlsrct AS _text_active ON _text_active.ddlname = src.ddlname AND _text_active.as4local = src.as4local AND _text_active.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ddddlsrct AS _text_english ON _text_english.ddlname = src.ddlname AND _text_english.as4local = src.as4local AND _text_english.ddlanguage = 'E'  -- association [0..1]
;