C_RSAU_LOG_API

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

CREATE VIEW C_RSAU_LOG_API AS
SELECT
  _header.event AS eventID,
  _header.log_tstmp AS log_tstmp,
  _header.slgmand AS slgmand,
  _header.sid AS sid,
  _header.counter AS counter,
  cast( ' ' as abap.sstring( 255 )) AS param_a,
  cast( ' ' as abap.sstring( 255 )) AS param_b,
  cast( ' ' as abap.sstring( 255 )) AS param_c,
  cast( ' ' as abap.sstring( 255 )) AS param_d,
  _header.slgtc AS slgtc,
  _header.slgrepna AS slgrepna,
  cast( ' ' as abap.sstring( 1024 ) ) AS rsau_text,
  _pseudo_attr.var_set_1 AS pseudo_vars,
  _header.slgltrm2 AS slgltrm2,
  _header.sal_data AS sal_data,
  _events.raw_text AS raw_text,
  _usergrp.bname AS UserID,
  _usergrp.useralias AS useralias,
  _usergrp.smtp_addr AS email_adress,
  _usergrp.UserDescription AS UserDescription,
  'X' AS is_relevant
FROM rsau_log AS _header
INNER JOIN RSAU_LOG_DISP_FILT_X AS flt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RSAU_EVENTS_VH AS _events ON _events.EventID = _header.event  -- association [0..1]
LEFT OUTER JOIN tsl1d_attr AS _pseudo_attr ON _pseudo_attr.event = _header.event  -- association [0..*]
LEFT OUTER JOIN I_RSAU_UGROUP AS _usergrp ON ( _usergrp.bname = _header.slguser AND _usergrp.mandt = _header.slgmand )  -- association [0..1]
;