SAIS_DATA_FOR_SDMO

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

CREATE VIEW SAIS_DATA_FOR_SDMO AS
SELECT
  tcd.tcode AS tcode,
  cast( tcd.cinfo as syhex01 preserving type ) AS cinfo,
  cast( coalesce( tx.ttext, tx_e.ttext ) as ttext_stct preserving type ) AS ttext,
  tcd.tcd_type AS tcd_type,
  coalesce( tx_typ.ddtext, tx_typ_e.ddtext) AS tcd_type_tx,
  tcd.lockstate AS lockstate,
  tcd.tstca_state AS tstca_state,
  cast(tcd.tstca_objct as xuobject preserving type ) AS tstca_objct,
  wbo.devclass AS devclass,
  wbo.ps_posid AS ps_posid,
  cast( wbo.ps_posidt as udtext preserving type ) AS ps_posidt,
  wbo.fctr_id AS fctr_id,
  wbo.dlvunit AS component,
  wbo.srcsystem AS srcsystem
FROM SUIM_HEAD_TRAN_ATTR_LABEL AS tcd
LEFT OUTER JOIN SAIS_WBO AS wbo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tstct AS tx ON (tx.tcode = tcd.tcode AND tx.sprsl = $session.system_language )  -- association [0..1]
LEFT OUTER JOIN tstct AS tx_e ON (tx_e.tcode = tcd.tcode AND tx_e.sprsl = 'E' )  -- association [0..1]
LEFT OUTER JOIN dd07t AS tx_typ ON (tx_typ.domname = 'SUIM_CINFO_TYPE' AND tx_typ.domvalue_l = tcd.tcd_type AND tx_typ.ddlanguage = $session.system_language )  -- association [0..1]
LEFT OUTER JOIN dd07t AS tx_typ_e ON (tx_typ_e.domname = 'SUIM_CINFO_TYPE' AND tx_typ_e.domvalue_l = tcd.tcd_type AND tx_typ_e.ddlanguage = 'E' )  -- association [0..1]
;