CRMS4D_SOM_MPED

Transparent Table Application Table
24 Fields 2 CDS Views

Subscription Mass Processing Element of Document Change

CRMS4D_SOM_MPED is an SAP database table in S/4HANA. Subscription Mass Processing Element of Document Change. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SbsMssProcgElmContrDocChg view_entity from EXTENSION SMPE Contract Document Change - Extn
I_SbsMssProcgElmContrDocChg view_entity from BASIC SMP Element for Document Change

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY subscrpnmassprocgelmntuuid CRMS4_SOM_MPRE_UUID UUID
createdbyuser ABP_CREATION_USER Created By
creationdatetime ABP_CREATION_TSTMPL Created On
lastchangedbyuser ABP_LASTCHANGE_USER Changed By
locallastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
subscrpnmassprocguuid CRMS4_SOM_MPR_UUID Mass Processing UUID
subscrpnmassprocgid CRMS4_SOM_MPR_ID Mass Processing ID
sbsmssprocgelmntprocdatdtetme CRMS4_SOM_MPRE_PROCD_AT Processed At
subscrpnmassprocgelmntsts CRMS4_SOM_MPRE_STATUS Status
subscrpnmassprocgelmntlghandle BALLOGHNDL Handle
subscriptioncontract CRMT_OBJECT_ID_DB Transaction ID
subscriptionchangeorder CRMT_OBJECT_ID_DB Transaction ID
sbsmssprocgelmfllwupdoc CRMT_OBJECT_ID ID
sbsmssprocgelmntactvtndtetme CRMS4_ACTIVATION_TSTMP Activation Timestamp
sbsmssprocgelmntsoldtoparty CRMT_SOLD_TO_PART Customer
sbsmssprocgelmcontractaccount VKONT_KK Contract Acct
subscrpnmassprocgelmntslsorg VKORG Sales Org.
sbsmssprocgelmdistrchnl CRMT_DISTRIBUTION_CHANNEL Distribution Channel
subscrpnmassprocgelmntdivn CRMT_DIVISION Division
subscrpnmassprocgelmntslsoffc VKBUR Sales Office
subscrpnmassprocgelmntslsgrp VKGRP Sales Group
sbsmssprocgelmslsorguntid CRMT_SALES_ORG Sales Org. ID
dummy_som_mpe_d_incl_eew_ps CFD_DUMMY Dummy

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 Mass Processing Element of Document Change
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_SOM_MPED (
    CLIENT,                          -- Client [MANDT]
    SUBSCRPNMASSPROCGELMNTUUID,      -- UUID [CRMS4_SOM_MPRE_UUID]
    CREATEDBYUSER,                   -- Created By [ABP_CREATION_USER]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    LASTCHANGEDBYUSER,               -- Changed By [ABP_LASTCHANGE_USER]
    LOCALLASTCHANGEDATETIME,         -- Changed On [ABP_LASTCHANGE_TSTMPL]
    SUBSCRPNMASSPROCGUUID,           -- Mass Processing UUID [CRMS4_SOM_MPR_UUID]
    SUBSCRPNMASSPROCGID,             -- Mass Processing ID [CRMS4_SOM_MPR_ID]
    SBSMSSPROCGELMNTPROCDATDTETME,   -- Processed At [CRMS4_SOM_MPRE_PROCD_AT]
    SUBSCRPNMASSPROCGELMNTSTS,       -- Status [CRMS4_SOM_MPRE_STATUS]
    SUBSCRPNMASSPROCGELMNTLGHANDLE,  -- Handle [BALLOGHNDL]
    SUBSCRIPTIONCONTRACT,            -- Transaction ID [CRMT_OBJECT_ID_DB]
    SUBSCRIPTIONCHANGEORDER,         -- Transaction ID [CRMT_OBJECT_ID_DB]
    SBSMSSPROCGELMFLLWUPDOC,         -- ID [CRMT_OBJECT_ID]
    SBSMSSPROCGELMNTACTVTNDTETME,    -- Activation Timestamp [CRMS4_ACTIVATION_TSTMP]
    SBSMSSPROCGELMNTSOLDTOPARTY,     -- Customer [CRMT_SOLD_TO_PART]
    SBSMSSPROCGELMCONTRACTACCOUNT,   -- Contract Acct [VKONT_KK]
    SUBSCRPNMASSPROCGELMNTSLSORG,    -- Sales Org. [VKORG]
    SBSMSSPROCGELMDISTRCHNL,         -- Distribution Channel [CRMT_DISTRIBUTION_CHANNEL]
    SUBSCRPNMASSPROCGELMNTDIVN,      -- Division [CRMT_DIVISION]
    SUBSCRPNMASSPROCGELMNTSLSOFFC,   -- Sales Office [VKBUR]
    SUBSCRPNMASSPROCGELMNTSLSGRP,    -- Sales Group [VKGRP]
    SBSMSSPROCGELMSLSORGUNTID,       -- Sales Org. ID [CRMT_SALES_ORG]
    DUMMY_SOM_MPE_D_INCL_EEW_PS,     -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, SUBSCRPNMASSPROCGELMNTUUID)
);

Learn More