TPLogs_ALOG_Records

DDL: TPLOGS_ALOG_RECORDS SQL: TPLOGS_ALOG_RECS Type: view Package: STTO
9 Fields 1 Data Sources

CTS: ALOG records with file name

TPLogs_ALOG_Records is a CDS View that provides data about "CTS: ALOG records with file name" in SAP S/4HANA. It reads from 1 data source (tplogs_header) and exposes 9 fields with key fields trkorr, trtime, tarsystem, trcli, trstep. Part of development package STTO.

Data Sources (1)

SourceAliasJoin Type
tplogs_header alog from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName TPLOGS_ALOG_RECS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CTS: ALOG records with file name view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY trkorr tplogs_header trkorr Virtual Transport
KEY trtime tplogs_header trtime Time Stamp
KEY tarsystem tplogs_header tarsystem Transport Target
KEY trcli tplogs_header trcli Source client
KEY trstep tplogs_header trstep Step
retcode tplogs_header retcode Return code
host tplogs_header host Host rule
tppid tplogs_header tppid PID
tpstat_key tplogs_header tpstat_key Time Stamp

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 TPLogs_ALOG_Records.
-- 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: TPLOGS_ALOG_RECS

CREATE VIEW TPLogs_ALOG_Records AS
SELECT
  alog.trkorr AS trkorr,
  alog.trtime AS trtime,
  alog.tarsystem AS tarsystem,
  alog.trcli AS trcli,
  alog.trstep AS trstep,
  alog.retcode AS retcode,
  alog.host AS host,
  alog.tppid AS tppid,
  alog.tpstat_key AS tpstat_key
FROM tplogs_header AS alog
;

Learn More