ODQSSN

Transparent Table Application Table
12 Fields 2 CDS Views

Operational Delta Queue: Subscription

ODQSSN is an SAP database table in S/4HANA. Operational Delta Queue: Subscription. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
RV_P_ODQSubscription view from Monitor: Delta Queue Subscription
RV_P_ODQSubscription_Text view from Monitor: Delta Queue Subscription

Fields (12)

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
cre_user SYUNAME User Name
cre_tstmp TIMESTAMP Time Stamp
mod_user SYUNAME User Name
mod_tstmp TIMESTAMP Time Stamp
tsn_subscribed ODQ_TSN TSN
tsn_confirmed ODQ_TSN TSN
tsn_requested ODQ_TSN TSN
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 Delta Queue: Subscription
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ODQSSN (
    CLIENT,           -- Client [MANDT]
    SUBSCRIBER_TYPE,  -- Subscriber Type [ODQ_SUBSCRIBER_TYPE]
    SUBSCRIBER_ID,    -- Subscriber [ODQ_SUBSCRIBER_ID]
    SUBSCRIPTION_ID,  -- Subscription [ODQ_SUBSCRIPTION_ID]
    CRE_USER,         -- User Name [SYUNAME]
    CRE_TSTMP,        -- Time Stamp [TIMESTAMP]
    MOD_USER,         -- User Name [SYUNAME]
    MOD_TSTMP,        -- Time Stamp [TIMESTAMP]
    TSN_SUBSCRIBED,   -- TSN [ODQ_TSN]
    TSN_CONFIRMED,    -- TSN [ODQ_TSN]
    TSN_REQUESTED,    -- TSN [ODQ_TSN]
    REALTIME,         -- Real-Time Mode [ODQ_REALTIME]
    PRIMARY KEY (CLIENT, SUBSCRIBER_TYPE, SUBSCRIBER_ID, SUBSCRIPTION_ID)
);

Learn More