P_RSAU_LOG

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_LOG.
-- 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: PRSAULOG

CREATE VIEW P_RSAU_LOG AS
SELECT
  _log.log_tstmp AS log_tstmp,
  _log.event AS msg,
  _log.slgproc AS slgproc,
  _log.slgmand AS slgmand,
  _log.sid AS sid,
  _log.instance AS instance,
  _log.counter AS counter,
  substring( _log.slgproc, 11, 2 ) AS tasktype,
  substring( _log.slgproc, 8, 3 ) AS taskno,
  _log.slgltrm2 AS slgltrm2,
  _log.slguser AS slguser,
  _usr.useralias AS useralias,
  _usr.FullName AS FullName,
  _usr.smtp_addr AS smtp_addr,
  _usr.class AS class,
  _usr.text AS class_shtxt,
  _log.slgtc AS slgtc,
  coalesce( tran_tx.ttext, tran_tx_e.ttext ) AS slgtc_tx,
  _log.slgrepna AS slgrepna,
  coalesce( prog_tx.text, prog_tx_e.text ) AS slgrepna_tx,
  _log.term_ipv6 AS term_ipv6,
  _log.sal_data AS sal_data,
  _log.suid_globaluid AS epp,
  _log.mfd_flag AS mfd_flag,
  _log.alert_flag AS alert_flag,
  _meta.area AS area,
  _meta.subid AS subid,
  _meta.subclasid AS subclasid,
  _meta.txsubclsid AS txsubclsid,
  _meta.severity AS severity,
  _meta.severity_s AS severity_s,
  _meta.txseverity AS txseverity,
  _meta.txt AS txt,
  _meta.var_set_1 AS var_set_1,
  concat( cast( tstmp_to_dats( _log.log_tstmp , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as abap.char(12) ), cast( tstmp_to_tims( _log.log_tstmp , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as abap.char(6) ) ) AS slgdattim,
  tstmp_to_dats( _log.log_tstmp , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS sal_date,
  tstmp_to_tims( _log.log_tstmp, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS sal_time
FROM CDS_GET_RSAU_LOG AS _log
LEFT OUTER JOIN I_RSAU_META_DATA AS _meta ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RSAU_UGROUP AS _usr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tstct AS tran_tx ON tran_tx.tcode = _log.slgtc AND tran_tx.sprsl = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tstct AS tran_tx_e ON tran_tx_e.tcode = _log.slgtc AND tran_tx_e.sprsl = 'E'  -- association [0..1]
LEFT OUTER JOIN tstct AS tran1_tx ON ( ( _log.sal_data = 'AU3' OR _log.sal_data = 'AU4' ) AND tran1_tx.tcode = _log.sal_data AND tran1_tx.sprsl = $session.system_language )  -- association [0..1]
LEFT OUTER JOIN tstct AS tran1_tx_e ON ( ( _log.sal_data = 'AU3' OR _log.sal_data = 'AU4' ) AND tran1_tx_e.tcode = _log.sal_data AND tran1_tx_e.sprsl = 'E' )  -- association [0..1]
LEFT OUTER JOIN trdirt AS prog_tx ON prog_tx.name = _log.slgrepna AND prog_tx.sprsl = $session.system_language  -- association [0..1]
LEFT OUTER JOIN trdirt AS prog_tx_e ON prog_tx_e.name = _log.slgrepna AND prog_tx_e.sprsl = 'E'  -- association [0..1]
;