SAP Table ODQTSN

Operational Delta Queue: Last Synchronized Replication - TSN

ODQTSN (Operational Delta Queue: Last Synchronized Replication - TSN) 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 ODQTSN to other SAP tables.

ODQTSN table fields

Field Data element Checktable Datatype Length Decimals
TSNTYPE Transaction Sequence Number (TSN) Type ODQ_TSNTYPE CHAR 1 0
S Start of Transaction (before DB Changes)
E End of Transaction (after DB Changes)
R Synchronization Time for Replication
TSN Transaction Sequence Number (TSN) ODQ_TSN DEC 23 9
LOCK_DURATION UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL DEC 21 7
TIMESTAMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL DEC 21 7
WP_SERVER Application Server Name MSNAME2 CHAR 40 0
WP_INDEX Work Process Number WPINDEX INT4 10 0
WP_BNAME User Currently Served WPBNAME CHAR 12 0