SAP table DBTABLOG (Log Records of Table Changes)
SAP table DBTABLOG has 3 primary key fields being LOGDATE,LOGTIME,LOGID.
| Field |
Description |
Data Type |
Length |
Decimals |
Checktable |
Data Element |
|
| LOGDATE |
(8-character) Date for SYST |
DATS |
8 |
0 |
|
SYDATS
|
|
| LOGTIME |
TIME Data Element for SYST |
TIMS |
6 |
0 |
|
SYTIME
|
|
| LOGID |
Unique identification of an entry in DBTABLOG |
CHAR |
18 |
0 |
|
LOGID
|
|
| TABNAME |
Table Name |
CHAR |
30 |
0 |
|
TABNAME
|
|
| LOGKEY |
Variable key part of table |
CHAR |
250 |
0 |
|
LOGKEY
|
|
| HOSTNAME |
Host Name |
CHAR |
20 |
0 |
|
MSHOST
|
|
| USERNAME |
User Name in User Master Record |
CHAR |
12 |
0 |
|
XUBNAME
|
|
| TCODE |
Transaction Code |
CHAR |
20 |
0 |
|
TCODE
|
|
| PROGNAME |
ABAP Program Name |
CHAR |
40 |
0 |
|
PROGRAMM
|
|
| OPTYPE |
Operation type of SQL statement |
CHAR |
1 |
0 |
|
OPTYPE
|
| D |
Operation type DELETE |
| I |
Operation type INSERT |
| U |
Operation type UPDATE |
|
| VERSNO |
Component of the Version Number |
CHAR |
2 |
0 |
|
CHAR2
|
|
| LANGUAGE |
Language Key |
LANG |
1 |
0 |
|
SYLANGU
|
|
| DATALN |
Actual length of vardata |
INT2 |
5 |
0 |
|
DATALN
|
|
| LOGDATA |
Modified Data Record |
LRAW |
16000 |
0 |
|
LOGDATA
|
|