SAP Table ODQDATA_F

Operational Delta Queue: Data Storage for One-Off Extraction

ODQDATA_F (Operational Delta Queue: Data Storage for One-Off Extraction) 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 ODQDATA_F to other SAP tables.

ODQDATA_F table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
RID Request ODQ_RID DEC 23 9
UNITNO Unit Number ODQ_UNITNO INT4 10 0
MODELNAME Provider ODQ_MODELNAME CHAR 16 0
QUEUENAME Queue Name ODQ_QUEUENAME ODQSTATE CHAR 32 0
LINES Number of Lines ODQ_LINES INT4 10 0
RAWSIZE Size in Bytes ODQ_RAWSIZE DEC 19 0
COMPSIZE Compressed Size in Bytes ODQ_COMPSIZE DEC 19 0
DATAFORMAT Data Format ODQ_DATAFORMAT CHAR 1 0
NULL Automatic Format Selection
A Uncompressed asXML
B Uncompressed basXML
C Compressed basXML (EXPORT/IMPORT)
G GZIP-Compressed basXML
XDATA RSTR 0 0

ODQDATA_F foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ODQDATA_F CLIENT ODQDATA_F CLIENT T000 Clients MANDT
ODQDATA_F QUEUENAME ODQDATA_F CLIENT ODQSTATE Operational Delta Queue: Queue Status CLIENT
ODQDATA_F QUEUENAME ODQDATA_F MODELNAME ODQSTATE Operational Delta Queue: Queue Status MODELNAME
ODQDATA_F QUEUENAME ODQDATA_F QUEUENAME ODQSTATE Operational Delta Queue: Queue Status QUEUENAME