ODQSTATE

Transparent Table Application Table
8 Fields 1 CDS Views

Operational Delta Queue: Queue Status

ODQSTATE is an SAP database table in S/4HANA. Operational Delta Queue: Queue Status. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ODQMON_QUEUES_H1 view inner Monitor: Delta Queues

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY modelname ODQ_MODELNAME Provider
KEY queuename ODQ_QUEUENAME Queue Name
queuestate ODQ_QUEUESTATE Queue Status
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: Queue Status
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ODQSTATE (
    CLIENT,      -- Client [MANDT]
    MODELNAME,   -- Provider [ODQ_MODELNAME]
    QUEUENAME,   -- Queue Name [ODQ_QUEUENAME]
    QUEUESTATE,  -- Queue Status [ODQ_QUEUESTATE]
    TIMESTAMP,   -- Time Stamp [TIMESTAMPL]
    WP_SERVER,   -- AS Instance [MSNAME2]
    WP_INDEX,    -- Number [WPINDEX]
    WP_BNAME,    -- User Names [WPBNAME]
    PRIMARY KEY (CLIENT, MODELNAME, QUEUENAME)
);

Learn More