dhamb_base_dp_table

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_table.
-- 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_table AS
SELECT
  dd02l.tabname AS objectname,
  dd02l.clidep AS clidep,
  dd02t.ddtext AS objectdescr,
  dd02l.contflag AS contflag,
  dd09l.tabart AS tabart,
  tadir.devclass AS devclass,
  df14l.ps_posid AS component,
  df14t.name AS compdescr,
  tdevc.component AS component_id,
  tdevc.dlvunit AS dlvunit,
  concat( dd02l.as4date, dd02l.as4time ) AS lastchange
FROM tadir
INNER JOIN dd02l ON /* join condition not captured in parsed metadata */
INNER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd09l 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 */
;