SAIS_GET_RDDPRCHK

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_GET_RDDPRCHK.
-- 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_RDDPRCHK

CREATE VIEW SAIS_GET_RDDPRCHK AS
SELECT
  dd02l.tabname AS tabname,
  coalesce( coalesce( _text_active.ddtext, _text_english.ddtext ), _text_original.ddtext ) AS ddtext,
  dd02l.tabclass AS tabclass,
  dd02l.clidep AS clidep,
  case when dd02l.clidep = 'X' then '' else '' end as clidep_i AS clidepXthenelseendasclidep_i,
  dd02l.mainflag AS mainflag,
  dd02l.contflag AS contflag,
  dd02l.abap_language_version AS abap_lv,
  dd09.tabkat AS tabkat,
  dd09.tabart AS tabart,
  dd09.protokoll AS protokoll,
  case when dd09.protokoll = 'X' then '' else '' end as protokoll_i AS protokollXthenelseendasprotokoll_i,
  sais_tddat.cclass AS cclass,
  sais_tddat.cclass_tx AS cclass_tx,
  wbo.devclass AS devc,
  wbo.dlvunit AS dlvu,
  wbo.ps_posid AS ps_posid,
  tcdob.object AS object,
  coalesce( _tcdobt_active.obtext, _tcdobt_english.obtext ) AS obtext
FROM dd02l
LEFT OUTER JOIN SAIS_WBO AS wbo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tcdob ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SAIS_TDDAT AS sais_tddat ON dd02l.tabname = sais_tddat.tabname  -- association [0..1]
LEFT OUTER JOIN dd09l AS dd09 ON dd02l.tabname = dd09.tabname AND dd02l.as4local = dd09.as4local AND dd02l.as4vers = dd09.as4vers  -- association [0..1]
LEFT OUTER JOIN tcdobt AS _tcdobt_active ON _tcdobt_active.object = tcdob.object AND _tcdobt_active.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tcdobt AS _tcdobt_english ON _tcdobt_english.object = tcdob.object AND _tcdobt_english.spras = 'E'  -- 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 = wbo.masterlang AND _text_original.as4vers = '0000'  -- association [0..1]
;