MMPUR_CAT_ITM

Transparent Table Application Table
96 Fields 9 CDS Views

Catalog items stored for search

MMPUR_CAT_ITM is an SAP database table in S/4HANA. Catalog items stored for search. It contains 96 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_Catalogitem view from BASIC Cross catalog item Search:Interface View
I_CatalogItemSupplier view from BASIC Basic view for catalog item supplier
I_CatalogMaterialText view inner BASIC CDS View for Catalog Material Text
I_Ctlgitem_Longtext view from BASIC Long text for catalog Items
I_Ctlgitem_Mgptext view from BASIC Material Group Text
I_OpnCtlgItem view from BASIC Catalog Item
I_Priceconversion view from BASIC Basic view for Price Conversion
P_Srhdatvalid view from BASIC
P_validdate view from BASIC

Fields (96)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ctlg_itm_key MMPUR_CAT_D_ITM_KEY Catalog Item Key
KEY cat_itm_hash MMPUR_CAT_D_ITM_HSH Item Hash Key
price_key MMPUR_CAT_D_PRC_KEY Price Key
ext_product_id MMPUR_CAT_EXT_PRD_ID External Product ID
ws_service_id MMPUR_CAT_WS_SERV_ID Catalog Web Serv ID
ws_serv_name MMPUR_CAT_WS_SERV_NAME Cat Webservice Name
catalog_name MMPUR_CAT_CTLG_NAME Catalog name
intcatalogname MMPUR_CAT_INT_CTLG_NAME Int Catalog name
vendor_name MMPUR_CAT_VENDOR_NAME Vendor Name
vendor MMPUR_CAT_VENDOR Vendor
vendor_mat MMPUR_CAT_VENDOR_MAT Vendor Product
item_type MMPUR_CAT_ITEM_TYPE Item Type
service MMPUR_CAT_SERVICE Service
price_valid_from MMPUR_CAT_PR_VAL_FRM Price From
price_valid_to MMPUR_CAT_PR_VAL_TO Price To
price_quantity MMPUR_CAT_ITM_QUANTITY Net Price Quantity
tax MMPUR_CAT_PERCNT Percentage
matnr MMPUR_CAT_MATNR Material
matgroup MMPUR_CAT_MATGROUP Material Group
manufactname MMPUR_CAT_MANFCT_NAME Manufacturer Name
manufactcode MMPUR_CAT_MANUFACT_CODE Manufacturer
manufactmat MMPUR_CAT_MANFCT_MAT Manufacturer Mat
leadtime WSI_OCI_LEADTIME Delivery Time
unit MMPUR_CAT_UNIT Unit Of Measure
content_unit MMPUR_CAT_UNIT Unit Of Measure
packaging_qty MMPUR_CAT_QUANT_15 Quantity
minorder_qty MMPUR_CAT_QUANT_15 Quantity
lotsize MMPUR_CAT_QUANT_15 Quantity
contract MMPUR_CAT_CONTRACT Contract Account
contract_item MMPUR_CAT_CONTRACT_ITM Contract Item
ext_quote_id MMPUR_CAT_EXT_QUOTE_ID External Quote ID
ext_quote_item MMPUR_CAT_EXT_ITM_ID External Item ID
ext_schema_type MMPUR_CAT_EXT_SCHEMA_TYPE External Schema Type
ext_category_id MMPUR_CAT_CATAEGORY_ID External Category ID
ext_category MMPUR_CAT_EXT_CATEGORY External Category
average_rating MMPUR_CAT_RATNG Rating
assortment_ind CHAR2 Component of the Version Number
parent_id MMPUR_CAT_PARENT_ITM Parent Item
isdirty BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
deletion_ind BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
catalog_managed MMPUR_CAT_IS_CATALOG_MANAGED Is Catalog Managed
is_frm_prod_mstr MMPUR_CAT_IS_FRM_PROD_MSTR Is Material Master
is_ctlg_itm MMPUR_CAT_IS_CATALOG_ITM Is Catalog Item
created_on abap.dats
changed_at MMPUR_CAT_CHANGD_AT Changed On
changed_by MMPUR_CAT_CHANGD_BY Changed By
sustainable_cmpl MMPUR_CAT_SUSTAINABLE_CMPL Item Sustainable Com
dir_em_value MMPUR_CAT_DIRECT_EM_VALUE Direct Emission Val
dir_em_unit MMPUR_CAT_DIRECT_EM_UNIT Direct Emission Unit
indir_em_value MMPUR_CAT_TEMP_VALUE Temp Emission Value
indir_em_unit MMPUR_CAT_INDIR_EM_UNIT InDirect Emission Un
tp_em_value MMPUR_CAT_TEMP_VALUE Temp Emission Value
tp_em_unit MMPUR_CAT_TEMP_UNIT Temp Emission Unit
recycle_value MMPUR_CAT_RECYCLE_VALUE Recycle Value
recycle_unit MMPUR_CAT_RECYCLE_UNIT Recycle Unit
water_cons_value MMPUR_CAT_WATER_COM_VALUE Water Consumption Va
water_cons_unit MMPUR_CAT_WATER_COM_UNIT Water Consumption Un
engy_cons_value MMPUR_CONS_VAL Energy Consumption V
engy_cons_unit MMPUR_CONS_UNIT Energy Consumption U
wastegen_value MMPUR_WATE_GEN_VAL Waste Generated Valu
wastegen_unit MMPUR_WST_GEN_UNIT Waste Generated Unit
logsys COMT_LOGSYS Logical System
sld_sys_name MMPUR_SLD_SYSTEM Source Logical Sys
product_src_sys MMPUR_CAT_LOG_SYS ID of logical system
product_type MMPUR_CAT_PRD_TYPE Product Type
category MMPUR_CAT_CATEGORY Category GUID
unit_decimal ANDEC Rounding
prd_rel_exists MMPUR_CAT_PRD_REL_EXIST Product Relation Exists
update_timestamp TIMESTAMPL Time Stamp
is_prcscl_exist MMPUR_CAT_PRCSCL_EXIST Price Scale
dummy_cat_item DUMMY Dummy function in length 1
plant WERKS_D Plant
company_code BUKRS Company Code
sos_uom MEINS Base Unit
ekgrp EKGRP Purch. Group
ekorg EKORG Purchasing Org.
sos_validity_start KDATB Validity Start
sos_validity_end KDATE Validity End
sos_item_number EBELP Item
sos_price MMPUR_EXTRACTED_PRICE Net Price
sos_priceunit EPEIN Price Unit
sos_orderunit BBPRM Order Price Un.
sos_curr WAERS Currency
sos_num MMPUR_SOS_NUMBER SOS number
sos_type MMPUR_HUB_SOS_TYPE sos type
ref_mat_key MMPUR_CAT_D_ITM_KEY Catalog Item Key
src_list_fixed BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
src_list_blocked BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
src_list_valid_from ORDAB Valid From
src_list_valid_to ORDBI Valid to
src_list_id DZEORD Number
proposal_id MMPUR_PROPOSAL_ID Proposal ID
archiving_status MMPUR_ARCHIVING_STATUS_CODE Archiving Stat.
be_source_sys MMPUR_D_SOURCE_SYS Connected System ID
purblock MMPUR_D_PUR_BLOCK Purchasing Block

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.

-- Catalog items stored for search
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CAT_ITM (
    MANDT,                -- Client [MANDT]
    CTLG_ITM_KEY,         -- Catalog Item Key [MMPUR_CAT_D_ITM_KEY]
    CAT_ITM_HASH,         -- Item Hash Key [MMPUR_CAT_D_ITM_HSH]
    PRICE_KEY,            -- Price Key [MMPUR_CAT_D_PRC_KEY]
    EXT_PRODUCT_ID,       -- External Product ID [MMPUR_CAT_EXT_PRD_ID]
    WS_SERVICE_ID,        -- Catalog Web Serv ID [MMPUR_CAT_WS_SERV_ID]
    WS_SERV_NAME,         -- Cat Webservice Name [MMPUR_CAT_WS_SERV_NAME]
    CATALOG_NAME,         -- Catalog name [MMPUR_CAT_CTLG_NAME]
    INTCATALOGNAME,       -- Int Catalog name [MMPUR_CAT_INT_CTLG_NAME]
    VENDOR_NAME,          -- Vendor Name [MMPUR_CAT_VENDOR_NAME]
    VENDOR,               -- Vendor [MMPUR_CAT_VENDOR]
    VENDOR_MAT,           -- Vendor Product [MMPUR_CAT_VENDOR_MAT]
    ITEM_TYPE,            -- Item Type [MMPUR_CAT_ITEM_TYPE]
    SERVICE,              -- Service [MMPUR_CAT_SERVICE]
    PRICE_VALID_FROM,     -- Price From [MMPUR_CAT_PR_VAL_FRM]
    PRICE_VALID_TO,       -- Price To [MMPUR_CAT_PR_VAL_TO]
    PRICE_QUANTITY,       -- Net Price Quantity [MMPUR_CAT_ITM_QUANTITY]
    TAX,                  -- Percentage [MMPUR_CAT_PERCNT]
    MATNR,                -- Material [MMPUR_CAT_MATNR]
    MATGROUP,             -- Material Group [MMPUR_CAT_MATGROUP]
    MANUFACTNAME,         -- Manufacturer Name [MMPUR_CAT_MANFCT_NAME]
    MANUFACTCODE,         -- Manufacturer [MMPUR_CAT_MANUFACT_CODE]
    MANUFACTMAT,          -- Manufacturer Mat [MMPUR_CAT_MANFCT_MAT]
    LEADTIME,             -- Delivery Time [WSI_OCI_LEADTIME]
    UNIT,                 -- Unit Of Measure [MMPUR_CAT_UNIT]
    CONTENT_UNIT,         -- Unit Of Measure [MMPUR_CAT_UNIT]
    PACKAGING_QTY,        -- Quantity [MMPUR_CAT_QUANT_15]
    MINORDER_QTY,         -- Quantity [MMPUR_CAT_QUANT_15]
    LOTSIZE,              -- Quantity [MMPUR_CAT_QUANT_15]
    CONTRACT,             -- Contract Account [MMPUR_CAT_CONTRACT]
    CONTRACT_ITEM,        -- Contract Item [MMPUR_CAT_CONTRACT_ITM]
    EXT_QUOTE_ID,         -- External Quote ID [MMPUR_CAT_EXT_QUOTE_ID]
    EXT_QUOTE_ITEM,       -- External Item ID [MMPUR_CAT_EXT_ITM_ID]
    EXT_SCHEMA_TYPE,      -- External Schema Type [MMPUR_CAT_EXT_SCHEMA_TYPE]
    EXT_CATEGORY_ID,      -- External Category ID [MMPUR_CAT_CATAEGORY_ID]
    EXT_CATEGORY,         -- External Category [MMPUR_CAT_EXT_CATEGORY]
    AVERAGE_RATING,       -- Rating [MMPUR_CAT_RATNG]
    ASSORTMENT_IND,       -- Component of the Version Number [CHAR2]
    PARENT_ID,            -- Parent Item [MMPUR_CAT_PARENT_ITM]
    ISDIRTY,              -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    DELETION_IND,         -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    CATALOG_MANAGED,      -- Is Catalog Managed [MMPUR_CAT_IS_CATALOG_MANAGED]
    IS_FRM_PROD_MSTR,     -- Is Material Master [MMPUR_CAT_IS_FRM_PROD_MSTR]
    IS_CTLG_ITM,          -- Is Catalog Item [MMPUR_CAT_IS_CATALOG_ITM]
    CREATED_ON,           -- abap.dats
    CHANGED_AT,           -- Changed On [MMPUR_CAT_CHANGD_AT]
    CHANGED_BY,           -- Changed By [MMPUR_CAT_CHANGD_BY]
    SUSTAINABLE_CMPL,     -- Item Sustainable Com [MMPUR_CAT_SUSTAINABLE_CMPL]
    DIR_EM_VALUE,         -- Direct Emission Val [MMPUR_CAT_DIRECT_EM_VALUE]
    DIR_EM_UNIT,          -- Direct Emission Unit [MMPUR_CAT_DIRECT_EM_UNIT]
    INDIR_EM_VALUE,       -- Temp Emission Value [MMPUR_CAT_TEMP_VALUE]
    INDIR_EM_UNIT,        -- InDirect Emission Un [MMPUR_CAT_INDIR_EM_UNIT]
    TP_EM_VALUE,          -- Temp Emission Value [MMPUR_CAT_TEMP_VALUE]
    TP_EM_UNIT,           -- Temp Emission Unit [MMPUR_CAT_TEMP_UNIT]
    RECYCLE_VALUE,        -- Recycle Value [MMPUR_CAT_RECYCLE_VALUE]
    RECYCLE_UNIT,         -- Recycle Unit [MMPUR_CAT_RECYCLE_UNIT]
    WATER_CONS_VALUE,     -- Water Consumption Va [MMPUR_CAT_WATER_COM_VALUE]
    WATER_CONS_UNIT,      -- Water Consumption Un [MMPUR_CAT_WATER_COM_UNIT]
    ENGY_CONS_VALUE,      -- Energy Consumption V [MMPUR_CONS_VAL]
    ENGY_CONS_UNIT,       -- Energy Consumption U [MMPUR_CONS_UNIT]
    WASTEGEN_VALUE,       -- Waste Generated Valu [MMPUR_WATE_GEN_VAL]
    WASTEGEN_UNIT,        -- Waste Generated Unit [MMPUR_WST_GEN_UNIT]
    LOGSYS,               -- Logical System [COMT_LOGSYS]
    SLD_SYS_NAME,         -- Source Logical Sys [MMPUR_SLD_SYSTEM]
    PRODUCT_SRC_SYS,      -- ID of logical system [MMPUR_CAT_LOG_SYS]
    PRODUCT_TYPE,         -- Product Type [MMPUR_CAT_PRD_TYPE]
    CATEGORY,             -- Category GUID [MMPUR_CAT_CATEGORY]
    UNIT_DECIMAL,         -- Rounding [ANDEC]
    PRD_REL_EXISTS,       -- Product Relation Exists [MMPUR_CAT_PRD_REL_EXIST]
    UPDATE_TIMESTAMP,     -- Time Stamp [TIMESTAMPL]
    IS_PRCSCL_EXIST,      -- Price Scale [MMPUR_CAT_PRCSCL_EXIST]
    DUMMY_CAT_ITEM,       -- Dummy function in length 1 [DUMMY]
    PLANT,                -- Plant [WERKS_D]
    COMPANY_CODE,         -- Company Code [BUKRS]
    SOS_UOM,              -- Base Unit [MEINS]
    EKGRP,                -- Purch. Group [EKGRP]
    EKORG,                -- Purchasing Org. [EKORG]
    SOS_VALIDITY_START,   -- Validity Start [KDATB]
    SOS_VALIDITY_END,     -- Validity End [KDATE]
    SOS_ITEM_NUMBER,      -- Item [EBELP]
    SOS_PRICE,            -- Net Price [MMPUR_EXTRACTED_PRICE]
    SOS_PRICEUNIT,        -- Price Unit [EPEIN]
    SOS_ORDERUNIT,        -- Order Price Un. [BBPRM]
    SOS_CURR,             -- Currency [WAERS]
    SOS_NUM,              -- SOS number [MMPUR_SOS_NUMBER]
    SOS_TYPE,             -- sos type [MMPUR_HUB_SOS_TYPE]
    REF_MAT_KEY,          -- Catalog Item Key [MMPUR_CAT_D_ITM_KEY]
    SRC_LIST_FIXED,       -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    SRC_LIST_BLOCKED,     -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    SRC_LIST_VALID_FROM,  -- Valid From [ORDAB]
    SRC_LIST_VALID_TO,    -- Valid to [ORDBI]
    SRC_LIST_ID,          -- Number [DZEORD]
    PROPOSAL_ID,          -- Proposal ID [MMPUR_PROPOSAL_ID]
    ARCHIVING_STATUS,     -- Archiving Stat. [MMPUR_ARCHIVING_STATUS_CODE]
    BE_SOURCE_SYS,        -- Connected System ID [MMPUR_D_SOURCE_SYS]
    PURBLOCK,             -- Purchasing Block [MMPUR_D_PUR_BLOCK]
    PRIMARY KEY (MANDT, CTLG_ITM_KEY, CAT_ITM_HASH)
);

Learn More