CRMS4D_SOM_MPECD

Transparent Table Application Table
22 Fields 2 CDS Views

Draft table for entity R_SBSMSSPROCGELMCONITMPRCELMTP

CRMS4D_SOM_MPECD is an SAP database table in S/4HANA. Draft table for entity R_SBSMSSPROCGELMCONITMPRCELMTP. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SbsMssProcgElmCoItPrElmDrft view_entity from EXTENSION Mass Processing Price Elements - Extn
R_SbsMssProcgElmCoItPrElmDrft view_entity from BASIC Mass Process Item Price Element - Draft

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sbsmssprocgelmprccndnuuid CRMS4_SOM_MPREP_UUID MP Price Cond 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
subscrpnmassprocgelmntuuid CRMS4_SOM_MPRE_UUID UUID
conditiontype KSCHL Condition Type
conditionrateamount VFPRC_RATE_AMOUNT Condition Amount
conditioncurrency WAERS Currency
conditionquantity KPEIN Pricing Unit
conditionquantityunit KMEIN Unit of Measure
conditionrateratio VFPRC_ELEMENT_RATIO Ratio
conditionrateratiounit MSEHI Internal UoM
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
dummy_som_mpec_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_SBSMSSPROCGELMCONITMPRCELMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_SOM_MPECD (
    MANDT,                          -- Client [MANDT]
    SBSMSSPROCGELMPRCCNDNUUID,      -- MP Price Cond UUID [CRMS4_SOM_MPREP_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]
    SUBSCRPNMASSPROCGELMNTUUID,     -- UUID [CRMS4_SOM_MPRE_UUID]
    CONDITIONTYPE,                  -- Condition Type [KSCHL]
    CONDITIONRATEAMOUNT,            -- Condition Amount [VFPRC_RATE_AMOUNT]
    CONDITIONCURRENCY,              -- Currency [WAERS]
    CONDITIONQUANTITY,              -- Pricing Unit [KPEIN]
    CONDITIONQUANTITYUNIT,          -- Unit of Measure [KMEIN]
    CONDITIONRATERATIO,             -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONRATERATIOUNIT,         -- Internal UoM [MSEHI]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_SOM_MPEC_INCL_EEW_PS,     -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SBSMSSPROCGELMPRCCNDNUUID)
);

Learn More