I_Catalogitem

Cross catalog item Search:Interface View | view: ISRCHCATITM | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMPUR_CAT_ATMAIN, MMPUR_CAT_LNGTXT, MMPUR_CAT_MGPTXT, MMPUR_CAT_PRCONV, MMPUR_CAT_ATHTXT, MMPUR_CAT_ATTCHM, MMPUR_CAT_ITM, MMPUR_CAT_ITM, MMPUR_CAT_ITM, LFA1
Column Name Description
OpnCtlgItemID Catalog Item Key
Column Name Description
💲 Item Currency (OpnCtlgItemCurrency):
OpnCtlgItemPrice Catalog Item Price
CalculatedPrice Catalog Item Price
💲 Item Currency (OpnCtlgComCurrencyID):
OpnCtlgPrcAmountInComCurrency Catalog Item Price in Common Currency
💲 Currency Key (Currency):
NetPriceAmount Price of extracted product from back-end system
Column Name Description
Column Name Description
ValidityEndDate End of Validity Period
ValidityStartDate Start of Validity Period
OpnCtlgSourceListValidFromDate Source List Record Valid From
OpnCtlgSourceListValidToDate Source List Record Valid To
Column Name Description
OpnCtlgIsServiceMaterialType Service Show values
IsMarkedForDeletion Boolean Variable (X = True, - = False, Space = Unknown) Show values
IsOpnCtlgManaged Is Catalog Managed Show values
IsOpnCtlgItmFrmMatlMstr Is From Material Master Show values
IsOpnCtlgItem Is Catalog Item Show values
SourceOfSupplyIsFixed Boolean Variable (X = True, - = False, Space = Unknown) Show values
SourceOfSupplyIsBlocked Boolean Variable (X = True, - = False, Space = Unknown) Show values
DeletionIndicator Boolean Variable (X = True, - = False, Space = Unknown) Show values
OpnCtlgArchivingStatus Archiving Status Code Show values
PurchasingIsBlocked Purchasing Block Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
OpnCtlgSrchLongText Search Long Text
MaterialGroupName Material Group Name CHAR80
OpnCtlgItemKey Catalog Item Hash Key MMPUR_CAT_CHR90
PricingScaleType null
OpnCtlgExternalProductID External Product ID CHAR40
OpnCtlgWebServiceID Catalog Web Service ID BBP_WS_SERVICE_ID
OpnCtlgWebServiceName catalog Web service name CHAR250
ProductCatalogName Product Catalog Name CHAR250
OpnCtlgIntCatalogName Internal catalog name CHAR250
OpnCtlgSupplierName Vendor Name CHAR250
OpnCtlgSupplierID Vendor CHAR10
OpnCtlgMaterialIDBySupplier Material ID By Vendor CHAR40
ItemType Item Type CHAR1
OpnCtlgPriceValdtyStartDteVal null
OpnCtlgPriceValdtyEndDteVal null
OpnCtlgPriceValidFromDateTime Price Valid From TZNTSTMPS
OpnCtlgPriceValidToDateTime Price Valid To TZNTSTMPS
OpnCtlgItemPriceQuantityValue Net Price Quantity CHAR15
TaxTolerancePercent Data element for Percentage
Material Material CHAR40
OpenCatalogMaterialGroup Material Group CHAR20
ManufacturerName Manufacturer Name CHAR255
Manufacturer Manufacturer CHAR10
OpnCtlgMfrMaterialNumber Manufacturing Material CHAR250
OpnCtlgLeadTmeAnncmntDuDaysVal Delivery Time in Days of the Shopping Cart Line CHAR5
OpenCatalogUnitOfMeasure Unit Of Measure CHAR3
OpnCtlgContentUnit Unit Of Measure CHAR3
OpenCatalogPackingQuantityVal Dataelement for quantity of char 15 CHAR15
OpnCtlgMinOrderQuantityValue Dataelement for quantity of char 15 CHAR15
OpnCtlgMatlFixedLotSizeQtyVal Dataelement for quantity of char 15 CHAR15
OpenCatalogReferenceContractID Contract Account CHAR10
OpnCtlgContractItem Contract Item CHAR10
OpnCtlgExternalQuoteID External Quote ID
OpnCtlgExtQuoteItem External Quote Item CHAR10
OpnCtlgExtSchemaType External Schema Type CHAR10
OpnCtlgExternalCategoryID External Category ID CHAR60
OpnCtlgExternalCategory External Category CHAR40
OpenCatalogUserRatingValue Rating
ParentItem Parent Item CHAR40
OpnCtlgChangedDateTimeValue null
OpnCtlgChangedBy Changed By UNAME
OpnCtlgItemSustainCompliance Item Sustainable Compliance CHAR2
OpnCtlgDirectEmissionValue Direct Emission Value
OpnCtlgDirectEmissionUnit Direct Emission Unit CHAR3
OpnCtlgIndrctEmissionValue Temp Emission Value
OpnCtlgIndrctEmissionUnit InDirect Emission Unit CHAR3
OpnCtlgTempEmissionValue Temp Emission Value
OpnCtlgTempEMissionUnit Temp Emission Unit CHAR3
OpnCtlgRecycleValue Recycle Value
OpnCtlgRecycleUnit Recycle Unit CHAR3
OpnCtlgWaterConsumptionValue Water Consumption Value
OpnCtlgWaterConsumptionUnit Water Consumption Unit CHAR3
OpnCtlgEnergyConsumptionValue Energy Consumption Value
OpnCtlgEnergyConsumptionUnit Energy Consumption Unit CHAR3
OpnCtlgWasteGeneratedValue Waste Generated Value
OpnCtlgWasteGeneratedUnit Waste Generated Unit CHAR3
LogicalSystem Original System LOGSYS
OpnCtlgSystemName Source Logical System TEXT60
SourceLogicalSystem Business Document Service: ID of Logical System CHAR10
ProductType Product Type COM_PRODUCT_TYPE
OpnCtlgCategoryID Category SYSUUID
Decimals No. of decimal places for rounding ANDEC
OpnCtlgHasProdRelationExists Product Relation Exists CHAR1
OpnCtlgHasPriceScale If price scale exist CHAR1
OpnCtlgMainImageText Catalog Main Image Name CHAR255
OpnCtlgMainImageName Catalog Main Image Name CHAR255
OpnCtlgMainImageURL Catalog Main Image URL
OpnCtlgMainImageID Search Image Key
PlantName Plant WERKS
CompanyCode Company Code BUKRS
PurchasingDocument Document number for source of supply
PurchasingDocumentItem Item Number of Purchasing Document EBELP
OrderPriceUnitQty Price unit DEC5
PurReqnSourceOfSupplyType SOS type
PurchasingOrganization Purchasing organization EKORG
OpnCtlgItemPrpslID Proposal ID SYSUUID
ProcurementHubSourceSystem Connected System ID
OpnCtlgFilterValue Filter value for Catalog Item
OpenCatalogExternalKey Catalog Item Key