MMPUR_MPS_ITEM

Transparent Table Application Table
22 Fields 2 CDS Views

Model Product Specification Item

MMPUR_MPS_ITEM is an SAP database table in S/4HANA. Model Product Specification Item. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ModProdSpecItem view_entity from EXTENSION MPS Item - Extension
R_ModProdSpecItem view from BASIC Model Product Specification Item

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY modprodspecitemuuid MMPUR_MPS_ITEM_UUID MPS Item UUID
modelproductspecificationuuid MMPUR_MPS_UUID UUID
modelproductspecification MMPUR_MPS_ID ID
modelproductspecificationitem MMPUR_MPS_ITEM_ID Item ID
modprodspecalternativeitemid MMPUR_MPS_ALTERNATIVE_ITEM_ID Alt. Item ID
modprodspecformatteditemid MMPUR_MPS_FORMATTED_ITEM_ID Hierarchy Number
plant EWERK Plant
modprodspecitemparentid MMPUR_MPS_ITEM_PARENT_ID Parent ID
purchasingisitemset MMPUR_IS_ITEMSET Item Set
purchasingdocumentitemcategory PSTYP Item Category
modprodspecitemdescription MMPUR_MPS_ITEM_DESCRIPTION Description
product MATNR Material
producttypecode PRODUCT_TYPE Product Type Group
materialgroup MATKL Material Group
orderquantity MMPUR_MPS_ITEM_QUANTITY Quantity
orderquantityunit MMPUR_MPS_ITEM_QUANTITY_UNIT Quantity Unit
creationdatetime MMPUR_MPS_CREATION_DATE_TIME Created On
createdbyuser MMPUR_MPS_CREATED_BY_USER Created By
lastchangedatetime MMPUR_MPS_LAST_CHG_DATE_TIME Changed On
lastchangedbyuser MMPUR_MPS_LAST_CHANGED_BY_USER Changed By
dummy_mmpur_mps_incl_eew_ps MMPUR_MPS_ITEM_INCL_EEW Ext. Include

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.

-- Model Product Specification Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_MPS_ITEM (
    MANDT,                           -- Client [MANDT]
    MODPRODSPECITEMUUID,             -- MPS Item UUID [MMPUR_MPS_ITEM_UUID]
    MODELPRODUCTSPECIFICATIONUUID,   -- UUID [MMPUR_MPS_UUID]
    MODELPRODUCTSPECIFICATION,       -- ID [MMPUR_MPS_ID]
    MODELPRODUCTSPECIFICATIONITEM,   -- Item ID [MMPUR_MPS_ITEM_ID]
    MODPRODSPECALTERNATIVEITEMID,    -- Alt. Item ID [MMPUR_MPS_ALTERNATIVE_ITEM_ID]
    MODPRODSPECFORMATTEDITEMID,      -- Hierarchy Number [MMPUR_MPS_FORMATTED_ITEM_ID]
    PLANT,                           -- Plant [EWERK]
    MODPRODSPECITEMPARENTID,         -- Parent ID [MMPUR_MPS_ITEM_PARENT_ID]
    PURCHASINGISITEMSET,             -- Item Set [MMPUR_IS_ITEMSET]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [PSTYP]
    MODPRODSPECITEMDESCRIPTION,      -- Description [MMPUR_MPS_ITEM_DESCRIPTION]
    PRODUCT,                         -- Material [MATNR]
    PRODUCTTYPECODE,                 -- Product Type Group [PRODUCT_TYPE]
    MATERIALGROUP,                   -- Material Group [MATKL]
    ORDERQUANTITY,                   -- Quantity [MMPUR_MPS_ITEM_QUANTITY]
    ORDERQUANTITYUNIT,               -- Quantity Unit [MMPUR_MPS_ITEM_QUANTITY_UNIT]
    CREATIONDATETIME,                -- Created On [MMPUR_MPS_CREATION_DATE_TIME]
    CREATEDBYUSER,                   -- Created By [MMPUR_MPS_CREATED_BY_USER]
    LASTCHANGEDATETIME,              -- Changed On [MMPUR_MPS_LAST_CHG_DATE_TIME]
    LASTCHANGEDBYUSER,               -- Changed By [MMPUR_MPS_LAST_CHANGED_BY_USER]
    DUMMY_MMPUR_MPS_INCL_EEW_PS,     -- Ext. Include [MMPUR_MPS_ITEM_INCL_EEW]
    PRIMARY KEY (MANDT, MODPRODSPECITEMUUID)
);

Learn More