CRMS4D_SOM_MPEDD

Transparent Table Application Table
30 Fields 3 CDS Views

Draft table for entity R_SBSMSSPROCGELMCONTRDOCCHGTP

CRMS4D_SOM_MPEDD is an SAP database table in S/4HANA. Draft table for entity R_SBSMSSPROCGELMCONTRDOCCHGTP. It contains 30 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_SbsMssProcgElmContrDocChgD view_entity from EXTENSION Contract Document Change - Extn
I_SbsMssProcgElmConDocChgDrft view_entity from BASIC SMP Element for Document Change
R_SbsMssProcgElmContrDocChgD view_entity from BASIC SMP Element Document Change - Draft

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt 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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
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.

-- Draft table for entity R_SBSMSSPROCGELMCONTRDOCCHGTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_SOM_MPEDD (
    MANDT,                           -- 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]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_SOM_MPE_D_INCL_EEW_PS,     -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SUBSCRPNMASSPROCGELMNTUUID)
);

Learn More