P_SU2X_HEAD_SUCO

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 P_SU2X_HEAD_SUCO.
-- 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: PSU2X_HEAD_SUCO

CREATE VIEW P_SU2X_HEAD_SUCO AS
SELECT
  uhash.name AS name,
  uhash.type AS type,
  sm.modifier AS modifier,
  sm.moddate AS moddate,
  sm.modtime AS modtime,
  sm.okflag AS okflag,
  uhash.object AS object,
  uhash.obj_name AS obj_name,
  tx.text AS stext,
  wbo.srcsystem AS srcsystem,
  wbo.author AS author,
  wbo.devclass AS devclass,
  wbo.dlvunit AS dlvunit,
  wbo.ps_posid AS ps_posid,
  wbo.masterlang AS masterlang,
  suco.referredobjtype AS m_object,
  suco.referredobjname AS m_name,
  x.cnt AS x_cnt,
  x.cnt_c AS x_cnt_c
FROM usob_container AS suco
LEFT OUTER JOIN usob_containert AS tx ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usobhash AS uhash ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usob_sm AS sm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SU2X_WBO AS wbo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tadir AS wbo_m ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SU2X_USOBX_CNT AS x ON /* join condition not captured in parsed metadata */
;