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 DHAMB_BASE_DP_CDS_NODES.
-- 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.
-- Parameters: iv_langu : abap.lang
CREATE VIEW DHAMB_BASE_DP_CDS_NODES AS
SELECT
ddldependency.objectname AS objectname,
ddddlsrct.ddtext AS objectdescr,
dd02bnd.dbtabname AS basetable,
tadir.devclass AS devclass,
df14l.ps_posid AS component,
df14t.name AS compdescr,
tdevc.component AS component_id,
tdevc.dlvunit AS dlvunit,
concat( ddddlsrc.as4date, ddddlsrc.as4time ) AS lastchange,
case when ( dd02b.clidep = 'X' ) and ( dd02b.cliindep <> 'X' ) then 'X' else ' ' end as clidep AS cliindepXthenXelseendasclidep,
case when c1.state is null then ' ' when c1.state = 'RELEASED' then 'C1' when c1.state = 'NO' then 'C0' else 'C0' end as cds_type AS stateNOthenC0elseC0endascds_type,
c1.state AS c1_state,
case when dd02bnd.tbfunc_included <> '' then ' ' when ddhead_alt_key.cnt > 0 then ' ' when ddhead_delta.cnt > 0 then 'X' else ' ' end as changedatacapture AS cnt0thenXelseendaschangedatacapture
FROM tadir
INNER JOIN ddldependency ON /* join condition not captured in parsed metadata */
INNER JOIN ddddlsrc ON /* join condition not captured in parsed metadata */
INNER JOIN tdevc ON /* join condition not captured in parsed metadata */
INNER JOIN dd02bnd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARS_APIS_RELEASED_C1_OR_GROUPS AS c1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd_cds_header_annotations AS ddhead_enabled ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHAMB_AUTH_CDSEXTRCTNDELTA AS ddhead_delta ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddddlsrct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dhamb_base_dp_cds_alt_key AS ddhead_alt_key ON /* join condition not captured in parsed metadata */
;