P_SU2X_HEAD_HT

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

CREATE VIEW P_SU2X_HEAD_HT AS
SELECT
  uhash.object AS object,
  uhash.obj_name AS obj_name,
  uhash.name AS name,
  uhash.type AS type,
  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.srcsystem AS srcsystem,
  wbo.author AS author,
  wbo.masterlang AS masterlang,
  tdevc.dlvunit AS dlvunit,
  df14l.ps_posid AS ps_posid,
  su2x_tdevc.dlvunit AS su2x_dlvunit,
  su2x_wbo.author AS su2x_author,
  x.cnt AS x_cnt,
  x.cnt_c AS x_cnt_c
FROM usobhash AS uhash
LEFT OUTER JOIN usob_sm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tadir AS wbo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tadir AS su2x_wbo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tdevc AS su2x_tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l AS su2x_df14l 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 */
;