C_TableChangeLog

DDL: C_TABLECHANGELOG SQL: CTABLECHANGELOG Type: view
15 Fields 1 Data Sources

Change Log Table Attributes

C_TableChangeLog is a CDS View that provides data about "Change Log Table Attributes" in SAP S/4HANA. It reads from 1 data source (I_TableChangeLog) and exposes 15 fields with key fields LogDate, LogTime, LogID.

Data Sources (1)

SourceAliasJoin Type
I_TableChangeLog I_TableChangeLog from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CTABLECHANGELOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Change Log Table Attributes view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY LogDate LogDate Date
KEY LogTime LogTime TIME Data Element for SYST
KEY LogID LogID Unique identification of an entry in DBTABLOG
TableName TableName Table/View Name
TableAuthorizationGroup TableAuthorizationGroup
LogKey LogKey Variable key part of table
HostName HostName Hostname
UserID UserID User Name
TransactionCode TransactionCode Transaction Code
ProgramName ProgramName Tcode/program
OperationType OperationType OP
Version Version XML Vers.
Language Language Report Text Language
DataLength DataLength Actual length of vardata
LoggedData LoggedData 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 C_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: CTABLECHANGELOG

CREATE VIEW C_TableChangeLog AS
SELECT
  LogDate,
  LogTime,
  LogID,
  TableName,
  TableAuthorizationGroup,
  LogKey,
  HostName,
  UserID,
  TransactionCode,
  ProgramName,
  OperationType,
  Version,
  Language,
  DataLength,
  LoggedData
FROM I_TableChangeLog
;

Learn More