ODQTSNLOG

Transparent Table Application Table
8 Fields 2 CDS Views

Operational Delta Queue: Transaction Log

ODQTSNLOG is an SAP database table in S/4HANA. Operational Delta Queue: Transaction Log. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
ODQMON_UNITS_F1 view inner Monitor: Dateneinheiten
ODQMON_UNITS_F2 view inner Monitor: Dateneinheiten

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY tsn ODQ_TSN TSN
tid ODQ_TID Transaction ID
tasktype abap.char
timestamp TIMESTAMPL Time Stamp
wp_server MSNAME2 AS Instance
wp_index WPINDEX Number
wp_bname WPBNAME User Names

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.

-- Operational Delta Queue: Transaction Log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ODQTSNLOG (
    CLIENT,     -- Client [MANDT]
    TSN,        -- TSN [ODQ_TSN]
    TID,        -- Transaction ID [ODQ_TID]
    TASKTYPE,   -- abap.char
    TIMESTAMP,  -- Time Stamp [TIMESTAMPL]
    WP_SERVER,  -- AS Instance [MSNAME2]
    WP_INDEX,   -- Number [WPINDEX]
    WP_BNAME,   -- User Names [WPBNAME]
    PRIMARY KEY (CLIENT, TSN)
);

Learn More