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
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
I Operation type INSERT
U Operation type UPDATE
D Operation type DELETE
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