AUT_D_DBTABLOG SAP (Audit Trail (ILM): Storage of Archived Table Logs) Table details
Dictionary Type: Table
Description: Audit Trail (ILM): Storage of Archived Table Logs
Description: Audit Trail (ILM): Storage of Archived Table Logs
ABAP Code to SELECT data from AUT_D_DBTABLOG
Related tables to AUT_D_DBTABLOG
Access table AUT_D_DBTABLOG
Related tables to AUT_D_DBTABLOG
Access table AUT_D_DBTABLOG
Table field list including key, data, relationships and ABAP select examples
AUT_D_DBTABLOG is a standard SAP Table which is used to store Audit Trail (ILM): Storage of Archived Table Logs data and is available within R/3 SAP systems depending on the version and release level.
The AUT_D_DBTABLOG table consists of various fields, each holding specific information or linking keys about Audit Trail (ILM): Storage of Archived Table Logs data available in SAP. These include LOGTIME (TIME Data Element for SYST), LOGID (Unique identification of an entry in DBTABLOG), TABNAME (Table Name), LOGKEY (Variable key part of table).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP AUT_D_DBTABLOG table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| LOGDATE | (8-character) Date for SYST | SYDATS | DATS | 8 | SYDATS | ||||
| LOGTIME | TIME Data Element for SYST | SYTIME | TIMS | 6 | SYTIME | ||||
| LOGID | Unique identification of an entry in DBTABLOG | LOGID | CHAR | 18 | CHAR18 | ||||
| TABNAME | Table Name | TABNAME | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
| LOGKEY | Variable key part of table | LOGKEY | CHAR | 250 | CHAR250 | ||||
| HOSTNAME | Host Name | MSHOST | CHAR | 20 | MSHOST | ||||
| USERNAME | User Name in User Master Record | XUBNAME | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
| TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD | ||
| PROGNAME | ABAP Program Name | PROGRAMM | CHAR | 40 | Assigned to domain | PROGRAMM | RID | ||
| OPTYPE | Operation type of SQL statement | OPTYPE | CHAR | 1 | OPTYPE | ||||
| VERSNO | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
| LANGUAGE | Language Key | SYLANGU | LANG | 1 | ISOLA | SYLANGU | |||
| DATALN | Actual length of vardata | DATALN | INT2 | 5 | DATALN | ||||
| LOGDATA | Modified Data Record | LOGDATA | LRAW | 16000 | LOGDATA |
| Key field | Non-key field |
How do I retrieve data from SAP table AUT_D_DBTABLOG using ABAP code
The following ABAP code Example will allow you to do a basic selection on AUT_D_DBTABLOG to SELECT all data from the tableDATA: WA_AUT_D_DBTABLOG TYPE AUT_D_DBTABLOG.
SELECT SINGLE *
FROM AUT_D_DBTABLOG
INTO CORRESPONDING FIELDS OF WA_AUT_D_DBTABLOG
WHERE...
How to access SAP table AUT_D_DBTABLOG
Within an ECC or HANA version of SAP you can also view further information about AUT_D_DBTABLOG and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects