subshlp_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 subshlp_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: H_SUBSHLP_CDS

CREATE VIEW subshlp_cds AS
SELECT
  dd31s.shlpname AS shlpname,
  dd31s.subshlp AS subshlp,
  dd31s.as4local AS as4locals,
  dd30t.as4local AS as4localt,
  dd30l.hotkey AS hotkey,
  dd30t.ddtext AS ddtext,
  dd30t.ddlanguage AS ddlanguage,
  dd31s.shposition AS shposition,
  dd30l.issimple AS issimple
FROM dd30t
LEFT OUTER JOIN dd31s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd30l ON /* join condition not captured in parsed metadata */
;