C_RSAU_LOG_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 C_RSAU_LOG_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: C_RSAU_BUF

CREATE VIEW C_RSAU_LOG_VIEW AS
SELECT
  _header.event AS eventID,
  _header.log_tstmp AS timestamp,
  _header.slgproc AS slgproc,
  _header.slgmand AS slgmand,
  _header.sid AS sid,
  _header.instance AS instance,
  _header.counter AS counter,
  _header.slgtc AS slgtc,
  _header.slgrepna AS slgrepna,
  _reports_vh.description AS description,
  cast( ' ' as char255 ) AS rsau_text,
  _DOCU.text AS text,
  _pseudo_attr.var_set_1 AS pseudo_vars,
  _header.slgltrm2 AS slgltrm2,
  _header.sal_data AS sal_data,
  coalesce( _text_active.raw_text, _text_english.raw_text) AS raw_text,
  _user.UserID AS UserID,
  _user.UserDescription AS UserDescription,
  _header.suid_globaluid AS rsau_epp,
  case when _user.UserID like 'CB%' then 'X' when _user.UserID like 'CC%' then 'X' when _user.UserID like 'CP%' then 'X' when _user.UserID like 'SAP_INTE_%' then 'X' when _user.UserID like '_SAP%' then 'X' when _user.UserID = 'SAP_CUST_INI' then 'X' when _user.UserID = 'SAP*' then 'X' when _user.UserID = 'SAP_CUST_BUS' then 'X' when _user.UserID = 'SAP_WFRT' then 'X' else ' ' end as is_relevant AS UserIDSAP_WFRTthenXelseendasis_relevant
FROM rsau_log AS _header
LEFT OUTER JOIN I_RSAU_MESSAGETEXT AS _text_active ON _text_active.msgid = _header.event AND _text_active.spras = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_RSAU_MESSAGETEXT AS _text_english ON _text_english.msgid = _header.event AND _text_english.spras = 'E'  -- association [0..*]
LEFT OUTER JOIN tsl1d_attr AS _pseudo_attr ON _pseudo_attr.event = _header.event  -- association [0..*]
LEFT OUTER JOIN I_User AS _user ON _user.UserID = _header.slguser  -- association [0..1]
LEFT OUTER JOIN I_RSAU_EVENTS_VH AS _events_vh ON eventID = _events_vh.EventID  -- association [0..1]
LEFT OUTER JOIN I_RSAU_SLGREPNA_VH AS _reports_vh ON slgrepna = _reports_vh.report  -- association [0..1]
LEFT OUTER JOIN I_RSAU_TCODE_VH AS _tcodes_vh ON slgtc = _tcodes_vh.tcode  -- association [0..1]
LEFT OUTER JOIN I_RSAU_EVENT_DOCU AS _DOCU ON eventID = _DOCU.eventid AND _DOCU.language = $session.system_language  -- association [0..1]
;