SUIM_2X_HEAD_RF

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_2X_HEAD_RF.
-- 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: SUIM2X_HEADRF

CREATE VIEW SUIM_2X_HEAD_RF AS
SELECT
  appl_type.ident AS ident,
  rf.funcname AS tech_name,
  rf.funcname AS name,
  appl_type.ddtext AS ddtext,
  appl_type.type AS type,
  texts.description AS description,
  usob_sm.modifier AS modifier,
  usob_sm.moddate AS moddate,
  usob_sm.modtime AS modtime,
  usob_sm.okflag AS okflag,
  okflag_text.ddtext AS okflag_text,
  wbo.srcsystem AS source,
  wbo.author AS author,
  wbo.devclass AS devclass,
  tdevc.dlvunit AS dlvunit,
  df14l.ps_posid AS ps_posid,
  su2x_wbo.srcsystem AS source_su2x,
  su2x_wbo.author AS author_su2x,
  su2x_tdevc.dlvunit AS dlvunit_su2x
FROM enlfdir AS rf
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 tfdir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_2X_APPL_TYPE AS appl_type ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usob_sm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_2X_RF_SUSH_NAME AS sush_name 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 SUIM_2X_TEXTS AS texts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_2X_HEAD_OKFLAG AS okflag_text ON /* join condition not captured in parsed metadata */
;