I_CatalogItemMngTP

Catalog Item Draft View | view: ICTLGITMMNGTP | TRAN | Extraction: Not supported | Component: Self-Service Procurement
Tables used: MMPUR_CAT_ATMAIN, MMPUR_CT_ITM_SRH, MMPUR_CAT_ATMAIN, MMPUR_CAT_ATTCHM, MMPUR_CAT_LNGTXT, MMPUR_CAT_MGPTXT, MMPUR_CAT_PRCONV, MMPUR_CAT_ATHTXT, MMPUR_CAT_ATTCHM, MMPUR_CAT_ITM, MMPUR_CAT_ITM, MMPUR_CAT_DSCTXT, T002, MAKT, MMPUR_CAT_ITM, LFA1
Column Name Description
OpnCtlgItemID Catalog Item Key
Column Name Description
💲 Currency Key (Currency):
NetPriceAmount Price of extracted product from back-end system
💲 Item Currency (OpnCtlgItemCurrency):
OpnCtlgItemPrice Catalog Item Price
Column Name Description
Column Name Description
ValidityEndDate End of Validity Period
ValidityStartDate Start of Validity Period
ValidFrom Source List Record Valid From
ValidTo Source List Record Valid To
OpnCtlgPrcValidityStartDate null
OpnCtlgPrcValidityEndDate null
Column Name Description
Service 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
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
ArchivingStatus Archiving Status Code Show values
Column Name Description Domain name
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
OpnCtlgMaterialIDBySupplier Material ID By Vendor CHAR40
ItemType Item Type CHAR1
NetPriceQuantity Net Price Quantity CHAR15
TaxTolerancePercent Data element for Percentage
MaterialGroup Material Group CHAR20
ManufacturerName Manufacturer Name CHAR255
Manufacturer Manufacturer CHAR10
ManufacturerMaterial Manufacturing Material CHAR250
LeadTimeAnncmntDueInDays Delivery Time in Days of the Shopping Cart Line CHAR5
OpnCtlgPackingQty Dataelement for quantity of char 15 CHAR15
OpnCtlgMinOrderQuantity Dataelement for quantity of char 15 CHAR15
MaterialFixedLotSizeQuantity Dataelement for quantity of char 15 CHAR15
ContractAccount 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
UsageRating Rating
ParentItem Parent Item CHAR40
ChangedDateTime 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
PlantName Plant WERKS
CompanyCode Company Code BUKRS
PurchasingDocument Document number for source of supply
PurchasingDocumentItem Item Number of Purchasing Document EBELP
PurchasingDocumentPriceUnit Price unit DEC5
PurchasingDocumentType SOS type
PurchasingOrganization Purchasing organization EKORG
ExternalDocumentReferenceID Catalog Item Key
OpnCtlgItemPrpslID Proposal ID SYSUUID
PlanningMaterial Material CHAR40
OpnCtlgSupplierID Account Number of Supplier LIFNR
Material Material Number MATNR
Language null
StatusCriticality null
DueDateCriticality null
CatalogItemDescription CATALOG DESCRIPTION TEXT255
ProductDescription Product Description CHAR255_CASE
OpnCtlgSearchTerm null
OpnCtlgSrchLongText Search Long Text
OpnCtlgMainImageName Catalog Main Image Name CHAR255
OpnCtlgMainImageURL Catalog Main Image URL
OpnCtlgMainImgURLHdr null