P_RSAU_BUF_VIEW

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

CREATE VIEW P_RSAU_BUF_VIEW AS
SELECT
  rsau_buf_data.area AS area,
  rsau_buf_data.subid AS subid,
  rsau_buf_data.slgdattim AS slgdattim,
  rsau_buf_data.slgproc AS slgproc,
  rsau_buf_data.slgmand AS slgmand,
  rsau_buf_data.sid AS sid,
  rsau_buf_data.instance AS instance,
  rsau_buf_data.counter AS counter,
  rsau_buf_data.slgltrm2 AS slgltrm2,
  rsau_buf_data.slguser AS slguser,
  rsau_buf_data.slgtc AS slgtc,
  rsau_buf_data.slgrepna AS slgrepna,
  rsau_buf_data.term_ipv6 AS term_ipv6,
  rsau_buf_data.sal_data AS sal_data,
  flg.mfd_flag AS mfd_flag,
  flg.alert_flag AS alert_flag,
  meta.subclasid AS subclasid,
  meta.severity AS severity,
  meta.txt AS txt,
  meta.var_set_1 AS var_set_1,
  concat(rsau_buf_data.area, rsau_buf_data.subid ) AS msg
FROM rsau_buf_data
LEFT OUTER JOIN rsau_buf_flag AS flg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RSAU_META_DATA AS meta ON /* join condition not captured in parsed metadata */
;