I_TableChangeLog

DDL: I_TABLECHANGELOG SQL: ITABLECHANGELOG Type: view
16 Fields 2 Data Sources 1 Associations

Change log table

I_TableChangeLog is a CDS View that provides data about "Change log table" in SAP S/4HANA. It reads from 2 data sources (tddat, dbtablog) and exposes 16 fields with key fields LogDate, LogTime, LogID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
tddat MaintenanceArea left_outer
dbtablog TableLogs from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_User _User $projection.UserID = _User.UserID

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ITABLECHANGELOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Change log table view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY LogDate dbtablog logdate Date
KEY LogTime dbtablog logtime TIME Data Element for SYST
KEY LogID dbtablog logid Unique identification of an entry in DBTABLOG
TableName dbtablog tabname Table/Constant Value
cclassendasTableAuthorizationGroup
LogKey dbtablog logkey Variable key part of table
HostName dbtablog hostname Hostname
UserID dbtablog username User who owns item
UserDescriptionendasUserDescription
TransactionCode dbtablog tcode Undefined range (can be used for patch levels)
ProgramName dbtablog progname Tcode/program
OperationType dbtablog optype OP
Version dbtablog versno Note version
Language dbtablog language Report Text Language
DataLength dbtablog dataln Actual length of vardata
LoggedData dbtablog logdata Modified Data Record

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 I_TableChangeLog.
-- 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: ITABLECHANGELOG

CREATE VIEW I_TableChangeLog AS
SELECT
  TableLogs.logdate AS LogDate,
  TableLogs.logtime AS LogTime,
  TableLogs.logid AS LogID,
  TableLogs.tabname AS TableName,
  case when MaintenanceArea.cclass is null then '&NC&' when MaintenanceArea.cclass = '' then '&NC&' else MaintenanceArea.cclass end as TableAuthorizationGroup AS cclassendasTableAuthorizationGroup,
  TableLogs.logkey AS LogKey,
  TableLogs.hostname AS HostName,
  TableLogs.username AS UserID,
  case _User.UserDescription when '' then TableLogs.username else _User.UserDescription end as UserDescription AS UserDescriptionendasUserDescription,
  TableLogs.tcode AS TransactionCode,
  TableLogs.progname AS ProgramName,
  TableLogs.optype AS OperationType,
  TableLogs.versno AS Version,
  TableLogs.language AS Language,
  TableLogs.dataln AS DataLength,
  TableLogs.logdata AS LoggedData
FROM dbtablog AS TableLogs
LEFT OUTER JOIN tddat AS MaintenanceArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _User ON UserID = _User.UserID  -- association [0..1]
;

Learn More