I_OpnCtlgItem

Catalog Item | view: IOPNCTLGITEM | Extraction: Not supported | Component: Purchase Requisitions
Column Name Description
OpnCtlgItemID Catalog Item Key
OpnCtlgItemKey Catalog Item Hash Key
Column Name Description
Column Name Description
Column Name Description
OpnCtlgPrcValidityStartDate Date on which the record was created
OpnCtlgPrcValidityEndDate Date on which the record was created
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
Column Name Description Domain name
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
NetPriceQuantity Net Price Quantity CHAR15
TaxTolerancePercent Data element for Percentage
Material Material CHAR40
MaterialGroup Material Group CHAR20
ManufacturerName Manufacturer Name CHAR255
Manufacturer Manufacturer CHAR10
ManufacturerMaterial Manufacturing Material CHAR250
OpnCtlgLeadTmeAnncmntDuDaysVal Delivery Time in Days of the Shopping Cart Line CHAR5
UnitOfMeasure Unit Of Measure CHAR3
OpnCtlgContentUnit Unit Of Measure CHAR3
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
OpenCatalogUserRatingValue 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
OpnCtlgItemPrpslID Proposal ID SYSUUID