P_SU2X_COMP_INTV_TRAN

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_COMP_INTV_TRAN.
-- 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_INTV_TR

CREATE VIEW P_SU2X_COMP_INTV_TRAN AS
SELECT
  wbo.object AS object,
  wbo.obj_name AS obj_name,
  usob_sm.modifier AS modifier,
  usob_sm.moddate AS moddate,
  usob_sm.modtime AS modtime,
  usob_sm.okflag AS okflag,
  usob_sm.abap_language_version AS al_vers,
  wbo.devclass AS devclass,
  wbo.dlvunit AS dlvunit,
  wbo.ps_posid AS ps_posid,
  wbo.srcsystem AS srcsystem,
  wbo.author AS author,
  wbo.masterlang AS masterlang,
  wbo.OBJSTABLTY AS objstablty,
  coalesce( _tx_sy.ttext, _tx_en.ttext) AS stext,
  tcd.cinfo AS cinfo
FROM P_SU2X_WBO AS wbo
LEFT OUTER JOIN tstc AS tcd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usob_sm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tstct AS _tx_sy ON _tx_sy.sprsl = $session.system_language AND tcd.tcode = _tx_sy.tcode  -- association [0..1]
LEFT OUTER JOIN tstct AS _tx_en ON _tx_en.sprsl = 'E' AND tcd.tcode = _tx_en.tcode  -- association [0..1]
;