MMPUR_CAT_ITM - Catalog items stored for search

Catalog items stored for search information is stored in SAP table MMPUR_CAT_ITM.
It is part of development package VDM_MM_PUR_CATALOG in software component MM-PUR-REQ. This development package consists of objects that can be grouped under "Catalog core CDS views".

Fields for table MMPUR_CAT_ITM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
CTLG_ITM_KEY	Catalog Item Key	X	MMPUR_CAT_D_ITM_KEY	INT4	4
CAT_ITM_HASH	Catalog Item Hash Key	X	MMPUR_CAT_D_ITM_HSH	CHAR	180
PRICE_KEY	Price Key		MMPUR_CAT_D_PRC_KEY	INT4	4	MMPUR_CAT_PRCONV
EXT_PRODUCT_ID	External Product ID		MMPUR_CAT_EXT_PRD_ID	CHAR	80
WS_SERVICE_ID	Catalog Web Service ID		MMPUR_CAT_WS_SERV_ID	CHAR	40
WS_SERV_NAME	catalog Web service name		MMPUR_CAT_WS_SERV_NAME	CHAR	500
CATALOG_NAME	Product Catalog Name		MMPUR_CAT_CTLG_NAME	CHAR	500
INTCATALOGNAME	Internal catalog name		MMPUR_CAT_INT_CTLG_NAME	CHAR	500
VENDOR_NAME	Vendor Name		MMPUR_CAT_VENDOR_NAME	CHAR	500
VENDOR	Vendor		MMPUR_CAT_VENDOR	CHAR	20
VENDOR_MAT	Material ID By Vendor		MMPUR_CAT_VENDOR_MAT	CHAR	80
ITEM_TYPE	Item Type		MMPUR_CAT_ITEM_TYPE	CHAR	2
SERVICE	Service		MMPUR_CAT_SERVICE	CHAR	2
PRICE_VALID_FROM	Price valid from		MMPUR_CAT_PR_VAL_FRM	DEC	8
PRICE_VALID_TO	Price valid To		MMPUR_CAT_PR_VAL_TO	DEC	8
PRICE_QUANTITY	Net Price Quantity		MMPUR_CAT_ITM_QUANTITY	CHAR	30
TAX	Data element for Percentage		MMPUR_CAT_PERCNT	DEC	3
MATNR	Material		MMPUR_CAT_MATNR	CHAR	80
MATGROUP	Material Group		MMPUR_CAT_MATGROUP	CHAR	40
MANUFACTNAME	Manufacturer Name		MMPUR_CAT_MANFCT_NAME	CHAR	510
MANUFACTCODE	Manufacturer		MMPUR_CAT_MANUFACT_CODE	CHAR	20
MANUFACTMAT	Manufacturing Material		MMPUR_CAT_MANFCT_MAT	CHAR	500
LEADTIME	Delivery Time in Days of the Shopping Cart Line		WSI_OCI_LEADTIME	CHAR	10
UNIT	Unit Of Measure		MMPUR_CAT_UNIT	CHAR	6
CONTENT_UNIT	Unit Of Measure		MMPUR_CAT_UNIT	CHAR	6
PACKAGING_QTY	Dataelement for quantity of char 15		MMPUR_CAT_QUANT_15	CHAR	30
MINORDER_QTY	Dataelement for quantity of char 15		MMPUR_CAT_QUANT_15	CHAR	30
LOTSIZE	Dataelement for quantity of char 15		MMPUR_CAT_QUANT_15	CHAR	30
CONTRACT	Contract Account		MMPUR_CAT_CONTRACT	CHAR	20
CONTRACT_ITEM	Contract Item		MMPUR_CAT_CONTRACT_ITM	CHAR	20
EXT_QUOTE_ID	External Quote ID		MMPUR_CAT_EXT_QUOTE_ID	CHAR	70
EXT_QUOTE_ITEM	External Quote Item		MMPUR_CAT_EXT_ITM_ID	CHAR	20
EXT_SCHEMA_TYPE	External Schema Type		MMPUR_CAT_EXT_SCHEMA_TYPE	CHAR	20
EXT_CATEGORY_ID	External Category ID		MMPUR_CAT_CATAEGORY_ID	CHAR	120
EXT_CATEGORY	External Category		MMPUR_CAT_EXT_CATEGORY	CHAR	80
AVERAGE_RATING	Rating		MMPUR_CAT_RATNG	DEC	2
ASSORTMENT_IND	Component of the Version Number		CHAR2	CHAR	4
PARENT_ID	Parent Item		MMPUR_CAT_PARENT_ITM	CHAR	80
ISDIRTY	Boolean Variable (X = True, - = False, Space = Unknown)		BOOLEAN	CHAR	2
DELETION_IND	Boolean Variable (X = True, - = False, Space = Unknown)		BOOLEAN	CHAR	2
CATALOG_MANAGED	Is Catalog Managed		MMPUR_CAT_IS_CATALOG_MANAGED	CHAR	2
IS_FRM_PROD_MSTR	Is From Material Master		MMPUR_CAT_IS_FRM_PROD_MSTR	CHAR	2
IS_CTLG_ITM	Is Catalog Item		MMPUR_CAT_IS_CATALOG_ITM	CHAR	2
CREATED_ON				DATS	16
CHANGED_AT	Changed Date Item		MMPUR_CAT_CHANGD_AT	DEC	8
CHANGED_BY	Changed By		MMPUR_CAT_CHANGD_BY	CHAR	24
SUSTAINABLE_CMPL	Item Sustainable Compliance		MMPUR_CAT_SUSTAINABLE_CMPL	CHAR	4
DIR_EM_VALUE	Direct Emission Value		MMPUR_CAT_DIRECT_EM_VALUE	DEC	12
DIR_EM_UNIT	Direct Emission Unit		MMPUR_CAT_DIRECT_EM_UNIT	CHAR	6
INDIR_EM_VALUE	Temp Emission Value		MMPUR_CAT_TEMP_VALUE	DEC	12
INDIR_EM_UNIT	InDirect Emission Unit		MMPUR_CAT_INDIR_EM_UNIT	CHAR	6
TP_EM_VALUE	Temp Emission Value		MMPUR_CAT_TEMP_VALUE	DEC	12
TP_EM_UNIT	Temp Emission Unit		MMPUR_CAT_TEMP_UNIT	CHAR	6
RECYCLE_VALUE	Recycle Value		MMPUR_CAT_RECYCLE_VALUE	DEC	12
RECYCLE_UNIT	Recycle Unit		MMPUR_CAT_RECYCLE_UNIT	CHAR	6
WATER_CONS_VALUE	Water Consumption Value		MMPUR_CAT_WATER_COM_VALUE	DEC	12
WATER_CONS_UNIT	Water Consumption Unit		MMPUR_CAT_WATER_COM_UNIT	CHAR	6
ENGY_CONS_VALUE	Energy Consumption Value		MMPUR_CONS_VAL	DEC	12
ENGY_CONS_UNIT	Energy Consumption Unit		MMPUR_CONS_UNIT	CHAR	6
WASTEGEN_VALUE	Waste Generated Value		MMPUR_WATE_GEN_VAL	DEC	12
WASTEGEN_UNIT	Waste Generated Unit		MMPUR_WST_GEN_UNIT	CHAR	6
LOGSYS	Original System		COMT_LOGSYS	CHAR	20
SLD_SYS_NAME	Source Logical System		MMPUR_SLD_SYSTEM	CHAR	120
PRODUCT_SRC_SYS	Business Document Service: ID of Logical System		MMPUR_CAT_LOG_SYS	CHAR	20
PRODUCT_TYPE	Product Type		MMPUR_CAT_PRD_TYPE	CHAR	4
CATEGORY	Category		MMPUR_CAT_CATEGORY	RAW	16
UNIT_DECIMAL	No. of decimal places for rounding		ANDEC	INT2	2
PRD_REL_EXISTS	Product Relation Exists		MMPUR_CAT_PRD_REL_EXIST	CHAR	2
UPDATE_TIMESTAMP	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
IS_PRCSCL_EXIST	If price scale exist		MMPUR_CAT_PRCSCL_EXIST	CHAR	2
.INCLUDE				MMPUR_CA_INCL_CAT_ITM	0
DUMMY_CAT_ITEM	Dummy function in length 1		DUMMY	CHAR	2
PLANT	Plant		WERKS_D	CHAR	8
COMPANY_CODE	Company Code		BUKRS	CHAR	8
SOS_UOM	Base Unit of Measure		MEINS	UNIT	6
EKGRP	Purchasing Group		EKGRP	CHAR	6
EKORG	Purchasing organization		EKORG	CHAR	8
SOS_VALIDITY_START	Start of Validity Period		KDATB	DATS	16
SOS_VALIDITY_END	End of Validity Period		KDATE	DATS	16
SOS_ITEM_NUMBER	Item Number of Purchasing Document		EBELP	NUMC	10
SOS_PRICE	Price of extracted product from back-end system		MMPUR_EXTRACTED_PRICE	CURR	6
SOS_PRICEUNIT	Price unit		EPEIN	DEC	3
SOS_ORDERUNIT	Order Price Unit (Purchasing)		BBPRM	UNIT	6
SOS_CURR	Currency Key		WAERS	CUKY	10
SOS_NUM	Document number for source of supply		MMPUR_SOS_NUMBER	CHAR	20
SOS_TYPE	SOS type		MMPUR_HUB_SOS_TYPE	CHAR	2
REF_MAT_KEY	Catalog Item Key		MMPUR_CAT_D_ITM_KEY	INT4	4
SRC_LIST_FIXED	Boolean Variable (X = True, - = False, Space = Unknown)		BOOLEAN	CHAR	2
SRC_LIST_BLOCKED	Boolean Variable (X = True, - = False, Space = Unknown)		BOOLEAN	CHAR	2
SRC_LIST_VALID_FROM	Source List Record Valid From		ORDAB	DATS	16
SRC_LIST_VALID_TO	Source List Record Valid To		ORDBI	DATS	16
SRC_LIST_ID	Number of Source List Record		DZEORD	NUMC	10
PROPOSAL_ID	Proposal ID		MMPUR_PROPOSAL_ID	RAW	16
ARCHIVING_STATUS	Archiving Status Code		MMPUR_ARCHIVING_STATUS_CODE	CHAR	2
BE_SOURCE_SYS	Connected System ID		MMPUR_D_SOURCE_SYS	CHAR	20
PURBLOCK	Purchasing Block		MMPUR_D_PUR_BLOCK	CHAR	2