SAP Table DBTABLOG
Log Records of Table Changes
DBTABLOG (Log Records of Table Changes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DBTABLOG to other SAP tables.
DBTABLOG table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LOGDATE
(8-character) Date for SYST
|
SYDATS |
DATS
|
8 | 0 | ||||||||||
|
LOGTIME
TIME Data Element for SYST
|
SYTIME |
TIMS
|
6 | 0 | ||||||||||
|
LOGID
Unique identification of an entry in DBTABLOG
|
LOGID |
CHAR
|
18 | 0 | ||||||||||
|
TABNAME
Table Name
|
TABNAME |
CHAR
|
30 | 0 | ||||||||||
|
LOGKEY
Variable key part of table
|
LOGKEY |
CHAR
|
250 | 0 | ||||||||||
|
HOSTNAME
Host Name
|
MSHOST |
CHAR
|
20 | 0 | ||||||||||
|
USERNAME
User Name in User Master Record
|
XUBNAME |
CHAR
|
12 | 0 | ||||||||||
|
TCODE
Transaction Code
|
TCODE |
CHAR
|
20 | 0 | ||||||||||
|
PROGNAME
ABAP Program Name
|
PROGRAMM |
CHAR
|
40 | 0 | ||||||||||
|
OPTYPE
Operation type of SQL statement
|
OPTYPE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
VERSNO
Version Number Component
|
CHAR2 |
CHAR
|
2 | 0 | ||||||||||
|
LANGUAGE
Language Key
|
SYLANGU |
LANG
|
1 | 0 | ||||||||||
|
DATALN
Actual length of vardata
|
DATALN |
INT2
|
5 | 0 | ||||||||||
|
LOGDATA
Modified Data Record
|
LOGDATA |
LRAW
|
16000 | 0 | ||||||||||