ODQSSN

Transparent Table Application Table
12 Fields 2 CDS Views

Operationale DeltaQueue: Abonnement

ODQSSN is an SAP database table in S/4HANA. Operationale DeltaQueue: Abonnement. 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.

-- Operationale DeltaQueue: Abonnement
-- 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