ODQREQ
Operational DeltaQueue: General Request
ODQREQ is an SAP database table in S/4HANA. Operational DeltaQueue: General Request. It contains 11 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ODQMON_REQUESTS_H1 | view | union | Monitor: Requests | |
| ODQMON_UNITS_F2 | view | left_outer | Monitor: Dateneinheiten | |
| RV_P_ODQRequest | view | from | Monitor: Delta Queue Request | |
| RV_P_ODQRequest_Text | view | from | Monitor: Delta Queue Request | |
| RV_P_ODQRequester | view | from | Monitor: Delta Queue Requester | |
| RV_P_ODQRequester_Text | view | from | Monitor: Delta Queue Requester |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | rid | ODQ_RID | Request | |||
| subscriber_type | ODQ_SUBSCRIBER_TYPE | Subscriber Type | ||||
| subscriber_id | ODQ_SUBSCRIBER_ID | Subscriber | ||||
| subscription_id | ODQ_SUBSCRIPTION_ID | Subscription | ||||
| extraction_mode | ODQ_EXTRACTION_MODE | Extraction Mode | ||||
| tsn_low | ODQ_TSN_LOW | Lower Limit for TSN | ||||
| tsn_high | ODQ_TSN_HIGH | Upper Limit for TSN | ||||
| tabname | TABNAME | Table Name | ||||
| status_icon | ODQ_STATUS_ICON | Status | ||||
| realtime | ODQ_REALTIME | Real-Time Mode |
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 DeltaQueue: General Request
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ODQREQ (
CLIENT, -- Client [MANDT]
RID, -- Request [ODQ_RID]
SUBSCRIBER_TYPE, -- Subscriber Type [ODQ_SUBSCRIBER_TYPE]
SUBSCRIBER_ID, -- Subscriber [ODQ_SUBSCRIBER_ID]
SUBSCRIPTION_ID, -- Subscription [ODQ_SUBSCRIPTION_ID]
EXTRACTION_MODE, -- Extraction Mode [ODQ_EXTRACTION_MODE]
TSN_LOW, -- Lower Limit for TSN [ODQ_TSN_LOW]
TSN_HIGH, -- Upper Limit for TSN [ODQ_TSN_HIGH]
TABNAME, -- Table Name [TABNAME]
STATUS_ICON, -- Status [ODQ_STATUS_ICON]
REALTIME, -- Real-Time Mode [ODQ_REALTIME]
PRIMARY KEY (CLIENT, RID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA