MDO_SUBSCRIPTION

Transparent Table Temporary Data
34 Fields 1 CDS Views

Subscription distribution model

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDOSubscriptionDistribution view_entity from Distribution Model

Fields (34)

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
tenantid MDO_TENANTID Tenant ID
subaccountid MDO_SUBACCOUNTID Subaccount ID
mdohostname MDO_HOSTNAME Host Name
mdouiurl MDO_APPLICATIONROUTERURL Application URL

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]
    TENANTID,                        -- Tenant ID [MDO_TENANTID]
    SUBACCOUNTID,                    -- Subaccount ID [MDO_SUBACCOUNTID]
    MDOHOSTNAME,                     -- Host Name [MDO_HOSTNAME]
    MDOUIURL,                        -- Application URL [MDO_APPLICATIONROUTERURL]
    PRIMARY KEY (CLIENT, ID)
);

Learn More