P_RSAU_META_DATA

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_RSAU_META_DATA.
-- 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: PRSAU_META_DATA

CREATE VIEW P_RSAU_META_DATA AS
SELECT
  tsl1d.area AS area,
  tsl1d.subid AS subid,
  concat(tsl1d.area, tsl1d.subid ) AS msg,
  coalesce( _tx_active.txt, _tx_en.txt) AS txt,
  tsl1d.subclasid AS subclasid,
  tsl1d.severity AS severity,
  attr.var_set_1 AS var_set_1
FROM tsl1d
LEFT OUTER JOIN tsl1t AS _tx_active ON tsl1d.area = _tx_active.area AND tsl1d.subid = _tx_active.subid AND _tx_active.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tsl1t AS _tx_en ON tsl1d.area = _tx_en.area AND tsl1d.subid = _tx_en.subid AND _tx_en.spras = 'E'  -- association [0..1]
LEFT OUTER JOIN tsl1d_attr AS attr ON tsl1d.area = attr.area AND tsl1d.subid = attr.subid  -- association [0..1]
;