SAIS_TDDAT_MAINT_STOB

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

CREATE VIEW SAIS_TDDAT_MAINT_STOB AS
SELECT
  stob.strucobjn AS tabname,
  #TABCLASS.'VIEW' AS tabclass,
  coalesce( _sap.cclass, '<No SAP-Default>' ) AS sap_cclass,
  tbrg.bezei AS bezei,
  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,
  stob.mainflag AS mainflag,
  stob.clidep AS clidep,
  tadir.masterlang AS masterlang
FROM dd02b AS stob
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 = stob.strucobjn  -- association [0..1]
LEFT OUTER JOIN dd02bt AS _text_active ON _text_active.strucobjn = stob.strucobjn AND _text_active.as4local = stob.as4local AND _text_active.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN dd02bt AS _text_english ON _text_english.strucobjn = stob.strucobjn AND _text_english.as4local = stob.as4local AND _text_english.ddlanguage = 'E'  -- association [0..1]
LEFT OUTER JOIN dd02bt AS _text_original ON _text_original.strucobjn = stob.strucobjn AND _text_original.as4local = stob.as4local AND _text_original.ddlanguage = tadir.masterlang  -- association [0..1]
LEFT OUTER JOIN ddldependency AS _stob ON _stob.ddlname = stob.strucobjn AND _stob.state = 'A' AND _stob.objecttype = 'VIEW'  -- association [0..2]
;