SAP AUT_D_DBTABLOG Audit Trail (ILM): Storage of Archived Table Logs Table

Overview

AUT_D_DBTABLOG is a standard SAP S/4HANA table that stores Audit Trail (ILM): Storage of Archived Table Logs data. There are total 14 fields in the AUT_D_DBTABLOG table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AUT_D_DBTABLOG belongs to Audit trail enhancements (ILM) (BC-SRV-ASF-AT) module and is located in the package Enhancements Audit Trail (ILM) (S_AUT).

In addition, following links provide an overview of foreign key relationships, if any, that link AUT_D_DBTABLOG to other SAP tables and standard CDS views available based on AUT_D_DBTABLOG table in S/4HANA 2020.

Techincal Settings of AUT_D_DBTABLOG

Below are technical details of the table AUT_D_DBTABLOG

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of AUT_D_DBTABLOG Fields

The following table gives you an overview of the fields available in AUT_D_DBTABLOG

FieldDescriptionData ElementCheck TableData TypeLength
LOGDATE(8-character) Date for SYSTSYDATSDATS8
LOGTIMETIME Data Element for SYSTSYTIMETIMS6
LOGIDUnique identification of an entry in DBTABLOGLOGIDCHAR18
TABNAMETable NameTABNAMECHAR30
LOGKEYVariable key part of tableLOGKEYCHAR250
HOSTNAMEHost NameMSHOSTCHAR20
USERNAMEUser Name in User Master RecordXUBNAMECHAR12
TCODETransaction CodeTCODECHAR20
PROGNAMEABAP Program NamePROGRAMMCHAR40
OPTYPEOperation type of SQL statementOPTYPECHAR1
VERSNOComponent of the Version NumberCHAR2CHAR2
LANGUAGELanguage KeySYLANGULANG1
DATALNActual length of vardataDATALNINT25
LOGDATAModified Data RecordLOGDATALRAW16000

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AUT_D_DBTABLOG

Other References