MDO_SUBSCRIPTION

Transparent Table Temporary Data
30 Fields 1 CDS Views

Subscription distribution model

MDO_SUBSCRIPTION is an SAP database table in S/4HANA. Subscription distribution model. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDOSubscriptionDistribution view_entity from Distribution Model

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY id mdo_id ID
isactive mdo_isactive Is Active
model mdo_model Distribution Model
frequency mdo_frequency Frequency
calltype mdo_calltype Mode
businessobjecttype mdo_businessobjecttype Business Object Type
odmobjecttype mdo_odm_objectname ODM Type
providerapplicationapi mdo_providerapplicationapi Provider API
providerapplicationapiversion mdo_providerapplicationapiver API Version
providerapplicationtype mdo_providerapplicationtype Application Type
providerapplicationtypeversion mdo_providerapplicationtypever Type Version
keymappingwriteisallowed mdo_keymappingwriteisallowed Write Key Mapping
keymappinguseisallowed mdo_keymappinguseisallowed Use Key Mapping
keymappingdistrisallowed mdo_keymappingdistrisallowed Indicator
ismarkedfordeletion mdo_ismarkedfordeletion Marked for Deletion
islocalmodel mdo_islocalmodel Is Local Model
isgeneratedbydpp mdo_isgeneratedbydpp Is Generated
confirmation mdo_confirmation Confirmation
packagesize mdo_packagesize Package Size
lastactivatedat mdo_lastactivatedat Last Activated At
lastactivatedby mdo_lastactivatedby Last Activated By
recurrence mdo_recurrence Recurrence Pattern
creationdate mdo_creationdate Created On
createdbyuser mdo_createdbyuser Created By User
lastchangedate mdo_lastchangedate Last Change Date
lastchangedbyuser mdo_lastchangedbyuser Last Changed By User
validitystartdate mdo_validitystartdate Valid From
validityenddate mdo_validityenddate Valid To
cutoffdate mdo_cutoffdate Date

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.

-- Subscription distribution model
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDO_SUBSCRIPTION (
    CLIENT,                          -- Client [mandt]
    ID,                              -- ID [mdo_id]
    ISACTIVE,                        -- Is Active [mdo_isactive]
    MODEL,                           -- Distribution Model [mdo_model]
    FREQUENCY,                       -- Frequency [mdo_frequency]
    CALLTYPE,                        -- Mode [mdo_calltype]
    BUSINESSOBJECTTYPE,              -- Business Object Type [mdo_businessobjecttype]
    ODMOBJECTTYPE,                   -- ODM Type [mdo_odm_objectname]
    PROVIDERAPPLICATIONAPI,          -- Provider API [mdo_providerapplicationapi]
    PROVIDERAPPLICATIONAPIVERSION,   -- API Version [mdo_providerapplicationapiver]
    PROVIDERAPPLICATIONTYPE,         -- Application Type [mdo_providerapplicationtype]
    PROVIDERAPPLICATIONTYPEVERSION,  -- Type Version [mdo_providerapplicationtypever]
    KEYMAPPINGWRITEISALLOWED,        -- Write Key Mapping [mdo_keymappingwriteisallowed]
    KEYMAPPINGUSEISALLOWED,          -- Use Key Mapping [mdo_keymappinguseisallowed]
    KEYMAPPINGDISTRISALLOWED,        -- Indicator [mdo_keymappingdistrisallowed]
    ISMARKEDFORDELETION,             -- Marked for Deletion [mdo_ismarkedfordeletion]
    ISLOCALMODEL,                    -- Is Local Model [mdo_islocalmodel]
    ISGENERATEDBYDPP,                -- Is Generated [mdo_isgeneratedbydpp]
    CONFIRMATION,                    -- Confirmation [mdo_confirmation]
    PACKAGESIZE,                     -- Package Size [mdo_packagesize]
    LASTACTIVATEDAT,                 -- Last Activated At [mdo_lastactivatedat]
    LASTACTIVATEDBY,                 -- Last Activated By [mdo_lastactivatedby]
    RECURRENCE,                      -- Recurrence Pattern [mdo_recurrence]
    CREATIONDATE,                    -- Created On [mdo_creationdate]
    CREATEDBYUSER,                   -- Created By User [mdo_createdbyuser]
    LASTCHANGEDATE,                  -- Last Change Date [mdo_lastchangedate]
    LASTCHANGEDBYUSER,               -- Last Changed By User [mdo_lastchangedbyuser]
    VALIDITYSTARTDATE,               -- Valid From [mdo_validitystartdate]
    VALIDITYENDDATE,                 -- Valid To [mdo_validityenddate]
    CUTOFFDATE,                      -- Date [mdo_cutoffdate]
    PRIMARY KEY (CLIENT, ID)
);

Learn More