MMPUR_CAT_ITM

Catalog items stored for search | #masterdata | Component: Purchase Requisitions
Column Name Description
MANDT Client
CTLG_ITM_KEY Catalog Item Key
CAT_ITM_HASH Catalog Item Hash Key
Column Name Description
💲 Currency Key (SOS_CURR):
SOS_PRICE Price of extracted product from back-end system
Column Name Description
Column Name Description
CREATED_ON null
SOS_VALIDITY_START Start of Validity Period
SOS_VALIDITY_END End of Validity Period
SRC_LIST_VALID_FROM Source List Record Valid From
SRC_LIST_VALID_TO Source List Record Valid To
Column Name Description
SERVICE Service Show values
ISDIRTY Boolean Variable (X = True, - = False, Space = Unknown) Show values
DELETION_IND Boolean Variable (X = True, - = False, Space = Unknown) Show values
CATALOG_MANAGED Is Catalog Managed Show values
IS_FRM_PROD_MSTR Is From Material Master Show values
IS_CTLG_ITM Is Catalog Item Show values
SRC_LIST_FIXED Boolean Variable (X = True, - = False, Space = Unknown) Show values
SRC_LIST_BLOCKED Boolean Variable (X = True, - = False, Space = Unknown) Show values
ARCHIVING_STATUS Archiving Status Code Show values
PURBLOCK Purchasing Block Show values
Column Name Description Domain name
EXT_PRODUCT_ID External Product ID CHAR40
WS_SERVICE_ID Catalog Web Service ID BBP_WS_SERVICE_ID
WS_SERV_NAME catalog Web service name CHAR250
CATALOG_NAME Product Catalog Name CHAR250
INTCATALOGNAME Internal catalog name CHAR250
VENDOR_NAME Vendor Name CHAR250
VENDOR Vendor CHAR10
VENDOR_MAT Material ID By Vendor CHAR40
ITEM_TYPE Item Type CHAR1
PRICE_VALID_FROM Price valid from BCOS_TSTMP
PRICE_VALID_TO Price valid To BCOS_TSTMP
PRICE_QUANTITY Net Price Quantity CHAR15
TAX Data element for Percentage
MATNR Material CHAR40
MATGROUP Material Group CHAR20
MANUFACTNAME Manufacturer Name CHAR255
MANUFACTCODE Manufacturer CHAR10
MANUFACTMAT Manufacturing Material CHAR250
LEADTIME Delivery Time in Days of the Shopping Cart Line CHAR5
UNIT Unit Of Measure CHAR3
CONTENT_UNIT Unit Of Measure CHAR3
PACKAGING_QTY Dataelement for quantity of char 15 CHAR15
MINORDER_QTY Dataelement for quantity of char 15 CHAR15
LOTSIZE Dataelement for quantity of char 15 CHAR15
CONTRACT Contract Account CHAR10
CONTRACT_ITEM Contract Item CHAR10
EXT_QUOTE_ID External Quote ID
EXT_QUOTE_ITEM External Quote Item CHAR10
EXT_SCHEMA_TYPE External Schema Type CHAR10
EXT_CATEGORY_ID External Category ID CHAR60
EXT_CATEGORY External Category CHAR40
AVERAGE_RATING Rating
ASSORTMENT_IND Component of the Version Number CHAR2
PARENT_ID Parent Item CHAR40
CHANGED_AT Changed Date Item BCOS_TSTMP
CHANGED_BY Changed By UNAME
SUSTAINABLE_CMPL Item Sustainable Compliance CHAR2
DIR_EM_VALUE Direct Emission Value
DIR_EM_UNIT Direct Emission Unit CHAR3
INDIR_EM_VALUE Temp Emission Value
INDIR_EM_UNIT InDirect Emission Unit CHAR3
TP_EM_VALUE Temp Emission Value
TP_EM_UNIT Temp Emission Unit CHAR3
RECYCLE_VALUE Recycle Value
RECYCLE_UNIT Recycle Unit CHAR3
WATER_CONS_VALUE Water Consumption Value
WATER_CONS_UNIT Water Consumption Unit CHAR3
ENGY_CONS_VALUE Energy Consumption Value
ENGY_CONS_UNIT Energy Consumption Unit CHAR3
WASTEGEN_VALUE Waste Generated Value
WASTEGEN_UNIT Waste Generated Unit CHAR3
LOGSYS Original System LOGSYS
SLD_SYS_NAME Source Logical System TEXT60
PRODUCT_SRC_SYS Business Document Service: ID of Logical System CHAR10
PRODUCT_TYPE Product Type COM_PRODUCT_TYPE
CATEGORY Category SYSUUID
UNIT_DECIMAL No. of decimal places for rounding ANDEC
PRD_REL_EXISTS Product Relation Exists CHAR1
UPDATE_TIMESTAMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
IS_PRCSCL_EXIST If price scale exist CHAR1
DUMMY_CAT_ITEM Dummy function in length 1 DUMMY
PLANT Plant WERKS
COMPANY_CODE Company Code BUKRS
EKGRP Purchasing Group EKGRP
EKORG Purchasing organization EKORG
SOS_ITEM_NUMBER Item Number of Purchasing Document EBELP
SOS_PRICEUNIT Price unit DEC5
SOS_NUM Document number for source of supply
SOS_TYPE SOS type
REF_MAT_KEY Catalog Item Key
SRC_LIST_ID Number of Source List Record NUM5
PROPOSAL_ID Proposal ID SYSUUID
BE_SOURCE_SYS Connected System ID