SUIM_SUSO_LIST

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 SUIM_SUSO_LIST.
-- 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: SUIM_SUSO_LST

CREATE VIEW SUIM_SUSO_LIST AS
SELECT
  root.objct AS objct,
  coalesce( obj_tx.ttext, obj_txe.ttext ) AS ttext,
  root.oclss AS oclss,
  coalesce( tobc_tx.ctext, tobc_txe.ctext ) AS clsstext,
  attr.num AS num,
  attr.field AS field,
  auth_fld.fieldtext AS ftext,
  attr.modifier AS modifier,
  attr.moddate AS moddate,
  attr.modtime AS modtime,
  attr.ABAP_LANGUAGE_VERSION AS ABAP_LANGUAGE_VERSION,
  attr.devclass AS devclass,
  attr.masterlang AS masterlang,
  attr.dlvunit AS dlvunit,
  attr.ps_posid AS ps_posid,
  attr.author AS author,
  attr.srcsystem AS srcsystem,
  attr.newrel AS newrel,
  attr.orglvl AS orglvl,
  attr.orgfld AS orgfld,
  attr.actvt AS actvt,
  doc.docbtn AS docbtn,
  flg.flg2 AS flg2,
  flg.flg2t AS flg2t,
  flg.flg4 AS flg4,
  flg.flg4t AS flg4t,
  flg.flg5 AS flg5,
  flg.flg5t AS flg5t,
  flg.flg3 AS flg3,
  flg.flg3t AS flg3t
FROM tobj AS root
LEFT OUTER JOIN SUIM_SUSO_LIST_ATTR AS attr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_SUSO_LIST_DOC AS doc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_SUSO_LIST_VORFLG AS flg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tobjt AS obj_tx ON (obj_tx.langu = $session.system_language AND obj_tx.object = root.objct )  -- association [0..1]
LEFT OUTER JOIN tobjt AS obj_txe ON (obj_txe.langu = 'E' AND obj_txe.object = root.objct)  -- association [0..1]
LEFT OUTER JOIN tobct AS tobc_tx ON (tobc_tx.langu = $session.system_language AND tobc_tx.oclss = root.oclss )  -- association [0..1]
LEFT OUTER JOIN tobct AS tobc_txe ON (tobc_txe.langu = 'E' AND tobc_txe.oclss = root.oclss)  -- association [0..1]
LEFT OUTER JOIN SUIM_AUTH_LIST AS auth_fld ON (auth_fld.Fieldname = attr.field )  -- association [0..1]
;