MMPUR_CAT_ITM

Transparent Table Application Table
95 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 95 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 (95)

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
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]
    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