P_RSAU_LOG_TCD

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

CREATE VIEW P_RSAU_LOG_TCD 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.smtp_addr AS smtp_addr,
  _usr.class AS class,
  _usr.text AS class_shtxt,
  _log.slgtc AS slgtc,
  _log.slgrepna AS slgrepna,
  _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,
  substring ( cast( floor( _log.log_tstmp) as char30 ) , 1, 14) 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 */
;