ODQSSNQUE_V

17 Fields 4 CDS Views

Generated Table for View

ODQSSNQUE_V is an SAP database table in S/4HANA. Generated Table for View. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
ODQMON_QUEUES_H1 view from Monitor: Delta Queues
ODQMON_REQUESTS_H1 view inner Monitor: Requests
ODQMON_SUBSCRIPTIONS_H1 view from Monitor: Abonnements
ODQMON_UNITS_F2 view inner Monitor: Dateneinheiten

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY subscriber_type ODQ_SUBSCRIBER_TYPE Subscriber Type
KEY subscriber_id ODQ_SUBSCRIBER_ID Subscriber
KEY subscription_id ODQ_SUBSCRIPTION_ID Subscription
KEY modelname ODQ_MODELNAME Provider
KEY queuename ODQ_QUEUENAME Queue Name
commitment_level ODQ_COMMITMENT_LEVEL Commitment
queuestate ODQ_QUEUESTATE Queue Status
tsn_confirmed ODQ_TSN TSN
tsn_requested ODQ_TSN TSN
cre_user SYUNAME User Name
cre_tstmp TIMESTAMP Time Stamp
mod_user SYUNAME User Name
mod_tstmp TIMESTAMP Time Stamp
realtime ODQ_REALTIME Real-Time Mode
projection ODQ_PROJECTION Projection
selection_cond ODQ_SELECTION_COND Selection Condition

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ODQSSNQUE_V (
    CLIENT,            -- Client [MANDT]
    SUBSCRIBER_TYPE,   -- Subscriber Type [ODQ_SUBSCRIBER_TYPE]
    SUBSCRIBER_ID,     -- Subscriber [ODQ_SUBSCRIBER_ID]
    SUBSCRIPTION_ID,   -- Subscription [ODQ_SUBSCRIPTION_ID]
    MODELNAME,         -- Provider [ODQ_MODELNAME]
    QUEUENAME,         -- Queue Name [ODQ_QUEUENAME]
    COMMITMENT_LEVEL,  -- Commitment [ODQ_COMMITMENT_LEVEL]
    QUEUESTATE,        -- Queue Status [ODQ_QUEUESTATE]
    TSN_CONFIRMED,     -- TSN [ODQ_TSN]
    TSN_REQUESTED,     -- TSN [ODQ_TSN]
    CRE_USER,          -- User Name [SYUNAME]
    CRE_TSTMP,         -- Time Stamp [TIMESTAMP]
    MOD_USER,          -- User Name [SYUNAME]
    MOD_TSTMP,         -- Time Stamp [TIMESTAMP]
    REALTIME,          -- Real-Time Mode [ODQ_REALTIME]
    PROJECTION,        -- Projection [ODQ_PROJECTION]
    SELECTION_COND,    -- Selection Condition [ODQ_SELECTION_COND]
    PRIMARY KEY (CLIENT, SUBSCRIBER_TYPE, SUBSCRIBER_ID, SUBSCRIPTION_ID, MODELNAME, QUEUENAME)
);

Learn More