DBTABLOG

Transparent Table Temporary Data
14 Fields 4 CDS Views

Protokollsätze zu Tabellenänderungen

DBTABLOG is an SAP database table in S/4HANA. Protokollsätze zu Tabellenänderungen. It contains 14 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_MAIFTableChangeLog view_entity from BASIC MAIF Table Change Log
I_TableChangeLog view from Change log table
P_TableChangeLogRecord view from BASIC
SAIS_DBTABLOG_CLI_TSTMP view_entity from DBTABLOG with Timestamp for Client Table

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY logdate sydats (8-character) Date for SYST
KEY logtime sytime TIME Data Element for SYST
KEY logid logid Unique identification of an entry in DBTABLOG
tabname tabname Table Name
logkey logkey Variable key part of table
hostname mshost Host
username xubname User
tcode tcode Transaction Code
progname programm Program Name
optype optype OP
versno char2 Component of the Version Number
language sylangu Language Key
dataln dataln Actual length of vardata
logdata logdata Modified Data Record

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Protokollsätze zu Tabellenänderungen
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DBTABLOG (
    LOGDATE,   -- (8-character) Date for SYST [sydats]
    LOGTIME,   -- TIME Data Element for SYST [sytime]
    LOGID,     -- Unique identification of an entry in DBTABLOG [logid]
    TABNAME,   -- Table Name [tabname]
    LOGKEY,    -- Variable key part of table [logkey]
    HOSTNAME,  -- Host [mshost]
    USERNAME,  -- User [xubname]
    TCODE,     -- Transaction Code [tcode]
    PROGNAME,  -- Program Name [programm]
    OPTYPE,    -- OP [optype]
    VERSNO,    -- Component of the Version Number [char2]
    LANGUAGE,  -- Language Key [sylangu]
    DATALN,    -- Actual length of vardata [dataln]
    LOGDATA,   -- Modified Data Record [logdata]
    PRIMARY KEY (LOGDATE, LOGTIME, LOGID)
);

Learn More