SUIM_SUSO_LIST_ATTR

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

CREATE VIEW SUIM_SUSO_LIST_ATTR AS
SELECT
  root.objct AS objct,
  root.num AS num,
  root.field AS field,
  attr.modifier AS modifier,
  attr.moddate AS moddate,
  attr.modtime AS modtime,
  case when ( actvt.actvt_num = 0 and root.field = 'ACTVT' ) then '' when ( actvt.actvt_num > 0 and root.field = 'ACTVT' ) then '' else '' end as actvt AS fieldACTVTthenelseendasactvt,
  wbo.devclass AS devclass,
  wbo.masterlang AS masterlang,
  wbo.dlvunit AS dlvunit,
  wbo.ps_posid AS ps_posid,
  wbo.author AS author,
  wbo.srcsystem AS srcsystem,
  attr.abap_language_version AS ABAP_LANGUAGE_VERSION,
  coalesce (usorg.field, '' ) AS orgfld
FROM SUIM_SUSO_FLD_LIST AS root
LEFT OUTER JOIN tobj_attr AS attr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SAIS_WBO AS wbo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_SUSO_CNT_ACTVT AS actvt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tobjvor ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usorg ON (usorg.field = root.field)  -- association [0..1]
;