SAIS_TDDAT_MAINT_TABL

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 SAIS_TDDAT_MAINT_TABL.
-- 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: SAIS_TDDAT_TABL

CREATE VIEW SAIS_TDDAT_MAINT_TABL AS
SELECT
  dd02l.tabname AS tabname,
  cast( 'DDIC Table' as char20 ) AS dobj_type,
  dd02l.tabclass AS tabclass,
  tbrg.bezei AS bezei,
  coalesce( _sap.cclass, '<No SAP-Default>' ) AS sap_cclass,
  coalesce( coalesce( _text_active.ddlanguage, _text_english.ddlanguage ), _text_original.ddlanguage ) AS ddlanguage,
  coalesce( coalesce( _text_active.ddtext, _text_english.ddtext ), _text_original.ddtext ) AS ddtext,
  tadir.devclass AS devclass,
  tdevc.dlvunit AS dlvunit,
  df14l.ps_posid AS ps_posid,
  dd02l.mainflag AS mainflag,
  dd02l.clidep AS clidep,
  dd02l.masterlang AS masterlang
FROM dd02l
INNER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tddat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SAIS_TDDAT_TBRG AS tbrg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tddat_sap AS _sap ON _sap.tabname = dd02l.tabname  -- association [0..1]
LEFT OUTER JOIN dd02t AS _text_active ON _text_active.tabname = dd02l.tabname AND _text_active.as4local = dd02l.as4local AND _text_active.ddlanguage = $session.system_language AND _text_active.as4vers = '0000'  -- association [0..1]
LEFT OUTER JOIN dd02t AS _text_english ON _text_english.tabname = dd02l.tabname AND _text_english.as4local = dd02l.as4local AND _text_english.ddlanguage = 'E' AND _text_english.as4vers = '0000'  -- association [0..1]
LEFT OUTER JOIN dd02t AS _text_original ON _text_original.tabname = dd02l.tabname AND _text_original.as4local = dd02l.as4local AND _text_original.ddlanguage = tadir.masterlang AND _text_original.as4vers = '0000'  -- association [0..1]
;