1. Home
  2. Resources
  3. SAP Tables
  4. ODQREQ - Operational DeltaQueue: General Request

SAP Table ODQREQ

Operational DeltaQueue: General Request

ODQREQ (Operational DeltaQueue: General Request) 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 ODQREQ to other SAP tables.

ODQREQ table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
RID Request ODQ_RID DEC 23 9
SUBSCRIBER_TYPE Subscriber Type ODQ_SUBSCRIBER_TYPE CHAR 16 0
SUBSCRIBER_ID Subscriber ODQ_SUBSCRIBER_ID CHAR 32 0
SUBSCRIPTION_ID Subscription for Delta Queue ODQ_SUBSCRIPTION_ID ODQSSN DEC 23 9
EXTRACTION_MODE Extraction Mode ODQ_EXTRACTION_MODE CHAR 1 0
C Delta Initialization with Data Transfer
D Delta
F Standard Extraction (Full)
S Delta Initialization without Data Transfer
P Delta Without Explicit Delta Initialization (Push)
TSN_LOW Lower Limit for TSN ODQ_TSN_LOW DEC 23 9
TSN_HIGH Upper Limit for TSN ODQ_TSN_HIGH DEC 23 9
TABNAME Table Name TABNAME CHAR 30 0
STATUS_ICON Status ODQ_STATUS_ICON CHAR 4 0
NULL Not Defined
@0V@ Confirmed
@0W@ Invalid
@5C@ Cancel Extraction
@5Y@ Confirmed and flagged for deletion
@6Q@ Extraction Scheduled
@9O@ Extraction Failed
@9P@ Extraction Successful
@9Y@ Extraction Running
@F1@ Invalid and flagged for deletion
REALTIME Object is in real-time mode ODQ_REALTIME CHAR 1 0
NULL False
X True
# Undefined

ODQREQ foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ODQREQ CLIENT ODQREQ CLIENT T000 Clients MANDT
ODQREQ SUBSCRIPTION_ID ODQREQ SUBSCRIBER_ID ODQSSN Operational Delta Queue: Subscription SUBSCRIBER_ID
ODQREQ SUBSCRIPTION_ID ODQREQ SUBSCRIPTION_ID ODQSSN Operational Delta Queue: Subscription SUBSCRIPTION_ID
ODQREQ SUBSCRIPTION_ID ODQREQ CLIENT ODQSSN Operational Delta Queue: Subscription CLIENT
ODQREQ SUBSCRIPTION_ID ODQREQ SUBSCRIBER_TYPE ODQSSN Operational Delta Queue: Subscription SUBSCRIBER_TYPE