I_CATALOGITEM
Cross catalog item Search:Interface View
I_CATALOGITEM is a CDS View in S/4HANA. Cross catalog item Search:Interface View. It contains 97 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CntrlPurContrMaterialVH | view | from | CONSUMPTION | C-View for Material F4 Help in Central Purchase Contract |
| C_Procurementitems | view | from | CONSUMPTION | Procurement Items for search |
| ESH_N_CATALOG_ITEM | view | from | ||
| I_CatalogItemMngTP | view | from | TRANSACTIONAL | Catalog Item Draft View |
| I_CatalogMaterial | view | from | COMPOSITE | CDS View for Catalog Material |
| P_CtlgItemImage | view | from | CONSUMPTION | Catalog Item and Associated Image URLs |
Fields (97)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Material | CtlgMaterial,Material | 3 |
| KEY | OpnCtlgItemID | OpnCtlgItemID | 3 |
| KEY | PlantName | CtlgPlant,Plant,PlantName | 3 |
| BaseUnit | BaseUnit | 1 | |
| CalculatedPrice | CalculatedPrice | 1 | |
| CompanyCode | CompanyCode | 3 | |
| Currency | Currency | 1 | |
| Decimals | Decimals | 1 | |
| IsOpnCtlgItem | IsOpnCtlgItem | 1 | |
| IsOpnCtlgItmFrmMatlMstr | IsOpnCtlgItmFrmMatlMstr | 1 | |
| IsOpnCtlgManaged | IsOpnCtlgManaged | 1 | |
| ItemType | ItemType | 1 | |
| LogicalSystem | LogicalSystem | 1 | |
| Manufacturer | Manufacturer | 1 | |
| MaterialGroupName | MaterialGroupName | 1 | |
| NetPriceAmount | NetPriceAmount | 1 | |
| OpenCatalogMaterialGroup | MaterialGroup | 2 | |
| OpenCatalogPackingQuantityVal | OpnCtlgPackingQty | 1 | |
| OpenCatalogReferenceContractID | ContractAccount | 1 | |
| OpenCatalogUnitOfMeasure | MaterialBaseUnit | 1 | |
| OpenCatalogUserRatingValue | UsageRating | 1 | |
| OpnCtlgArchivingStatus | ArchivingStatus | 1 | |
| OpnCtlgCategoryID | OpnCtlgCategoryID | 1 | |
| OpnCtlgChangedBy | OpnCtlgChangedBy | 1 | |
| OpnCtlgChangedDateTimeValue | ChangedDateTime | 1 | |
| OpnCtlgComCurrencyID | OpnCtlgComCurrencyID | 1 | |
| OpnCtlgContentUnit | OpnCtlgContentUnit | 1 | |
| OpnCtlgContractItem | OpnCtlgContractItem | 1 | |
| OpnCtlgDirectEmissionUnit | OpnCtlgDirectEmissionUnit | 1 | |
| OpnCtlgDirectEmissionValue | OpnCtlgDirectEmissionValue | 1 | |
| OpnCtlgEnergyConsumptionUnit | OpnCtlgEnergyConsumptionUnit | 1 | |
| OpnCtlgEnergyConsumptionValue | OpnCtlgEnergyConsumptionValue | 1 | |
| OpnCtlgExternalCategory | OpnCtlgExternalCategory | 1 | |
| OpnCtlgExternalCategoryID | OpnCtlgExternalCategoryID | 1 | |
| OpnCtlgExternalProductID | OpnCtlgExternalProductID | 1 | |
| OpnCtlgExternalQuoteID | OpnCtlgExternalQuoteID | 1 | |
| OpnCtlgExtQuoteItem | OpnCtlgExtQuoteItem | 1 | |
| OpnCtlgExtSchemaType | OpnCtlgExtSchemaType | 1 | |
| OpnCtlgFilterValue | OpnCtlgFilterValue | 1 | |
| OpnCtlgHasPriceScale | OpnCtlgHasPriceScale | 1 | |
| OpnCtlgHasProdRelationExists | OpnCtlgHasProdRelationExists | 1 | |
| OpnCtlgIndrctEmissionUnit | OpnCtlgIndrctEmissionUnit | 1 | |
| OpnCtlgIndrctEmissionValue | OpnCtlgIndrctEmissionValue | 1 | |
| OpnCtlgIntCatalogName | OpnCtlgIntCatalogName | 1 | |
| OpnCtlgIsServiceMaterialType | Service | 1 | |
| OpnCtlgItemCurrency | OpnCtlgItemCurrency | 1 | |
| OpnCtlgItemPrice | OpnCtlgItemPrice | 1 | |
| OpnCtlgItemPriceQuantityValue | NetPriceQuantity | 1 | |
| OpnCtlgItemSustainCompliance | OpnCtlgItemSustainCompliance | 1 | |
| OpnCtlgLeadTmeAnncmntDuDaysVal | LeadTimeAnncmntDueInDays | 1 | |
| OpnCtlgMainImageID | OpnCtlgMainImageID | 1 | |
| OpnCtlgMainImageName | OpnCtlgMainImageName | 1 | |
| OpnCtlgMainImageText | OpnCtlgMainImageText | 1 | |
| OpnCtlgMainImageURL | OpnCtlgMainImageURL | 1 | |
| OpnCtlgMaterialIDBySupplier | OpnCtlgMaterialIDBySupplier | 1 | |
| OpnCtlgMatlFixedLotSizeQtyVal | MaterialFixedLotSizeQuantity | 1 | |
| OpnCtlgMfrMaterialNumber | ManufacturerMaterial | 1 | |
| OpnCtlgMinOrderQuantityValue | OpnCtlgMinOrderQuantity | 1 | |
| OpnCtlgPrcAmountInComCurrency | OpnCtlgPrcComCurrency | 1 | |
| OpnCtlgPriceID | OpnCtlgPriceID | 1 | |
| OpnCtlgPriceValdtyEndDteVal | OpnCtlgPrcValidityEndDate | 1 | |
| OpnCtlgPriceValdtyStartDteVal | OpnCtlgPrcValidityStartDate | 1 | |
| OpnCtlgPriceValidFromDateTime | PriceValidityStartDate | 1 | |
| OpnCtlgPriceValidToDateTime | PriceValidityEndDate | 1 | |
| OpnCtlgRecycleUnit | OpnCtlgRecycleUnit | 1 | |
| OpnCtlgRecycleValue | OpnCtlgRecycleValue | 1 | |
| OpnCtlgSourceListValidFromDate | ValidFrom | 1 | |
| OpnCtlgSourceListValidToDate | ValidTo | 1 | |
| OpnCtlgSrchLongText | OpnCtlgSrchLongText | 1 | |
| OpnCtlgSupplierID | OpnCtlgSupplierID | 1 | |
| OpnCtlgSupplierName | OpnCtlgSupplierName | 1 | |
| OpnCtlgSystemName | OpnCtlgSystemName | 1 | |
| OpnCtlgTempEMissionUnit | OpnCtlgTempEMissionUnit | 1 | |
| OpnCtlgTempEmissionValue | OpnCtlgTempEmissionValue | 1 | |
| OpnCtlgWasteGeneratedUnit | OpnCtlgWasteGeneratedUnit | 1 | |
| OpnCtlgWasteGeneratedValue | OpnCtlgWasteGeneratedValue | 1 | |
| OpnCtlgWaterConsumptionUnit | OpnCtlgWaterConsumptionUnit | 1 | |
| OpnCtlgWaterConsumptionValue | OpnCtlgWaterConsumptionValue | 1 | |
| OpnCtlgWebServiceID | OpnCtlgWebServiceID | 3 | |
| OpnCtlgWebServiceName | OpnCtlgWebServiceName | 1 | |
| OrderPriceUnitQty | PurchasingDocumentPriceUnit | 1 | |
| OrderQuantityUnit | PurchasingDocumentOrderQty | 1 | |
| ParentItem | ParentItem | 1 | |
| PricingScaleType | PricingScaleType | 1 | |
| ProcurementHubSourceSystem | ProcurementHubSourceSystem | 1 | |
| ProductCatalogName | ProductCatalogName | 1 | |
| ProductType | ProductType | 1 | |
| PurchasingDocument | PurchasingDocument | 1 | |
| PurchasingDocumentItem | PurchasingDocumentItem | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| PurReqnSourceOfSupplyType | PurchasingDocumentType | 1 | |
| SourceLogicalSystem | SourceLogicalSystem | 1 | |
| SourceOfSupplyIsBlocked | SourceOfSupplyIsBlocked | 1 | |
| SourceOfSupplyIsFixed | SourceOfSupplyIsFixed | 1 | |
| TaxTolerancePercent | TaxTolerancePercent | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Cross catalog item Search:Interface View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CATALOGITEM (
MATERIAL,
OPNCTLGITEMID,
PLANTNAME,
BASEUNIT,
CALCULATEDPRICE,
COMPANYCODE,
CURRENCY,
DECIMALS,
ISOPNCTLGITEM,
ISOPNCTLGITMFRMMATLMSTR,
ISOPNCTLGMANAGED,
ITEMTYPE,
LOGICALSYSTEM,
MANUFACTURER,
MATERIALGROUPNAME,
NETPRICEAMOUNT,
OPENCATALOGMATERIALGROUP,
OPENCATALOGPACKINGQUANTITYVAL,
OPENCATALOGREFERENCECONTRACTID,
OPENCATALOGUNITOFMEASURE,
OPENCATALOGUSERRATINGVALUE,
OPNCTLGARCHIVINGSTATUS,
OPNCTLGCATEGORYID,
OPNCTLGCHANGEDBY,
OPNCTLGCHANGEDDATETIMEVALUE,
OPNCTLGCOMCURRENCYID,
OPNCTLGCONTENTUNIT,
OPNCTLGCONTRACTITEM,
OPNCTLGDIRECTEMISSIONUNIT,
OPNCTLGDIRECTEMISSIONVALUE,
OPNCTLGENERGYCONSUMPTIONUNIT,
OPNCTLGENERGYCONSUMPTIONVALUE,
OPNCTLGEXTERNALCATEGORY,
OPNCTLGEXTERNALCATEGORYID,
OPNCTLGEXTERNALPRODUCTID,
OPNCTLGEXTERNALQUOTEID,
OPNCTLGEXTQUOTEITEM,
OPNCTLGEXTSCHEMATYPE,
OPNCTLGFILTERVALUE,
OPNCTLGHASPRICESCALE,
OPNCTLGHASPRODRELATIONEXISTS,
OPNCTLGINDRCTEMISSIONUNIT,
OPNCTLGINDRCTEMISSIONVALUE,
OPNCTLGINTCATALOGNAME,
OPNCTLGISSERVICEMATERIALTYPE,
OPNCTLGITEMCURRENCY,
OPNCTLGITEMPRICE,
OPNCTLGITEMPRICEQUANTITYVALUE,
OPNCTLGITEMSUSTAINCOMPLIANCE,
OPNCTLGLEADTMEANNCMNTDUDAYSVAL,
OPNCTLGMAINIMAGEID,
OPNCTLGMAINIMAGENAME,
OPNCTLGMAINIMAGETEXT,
OPNCTLGMAINIMAGEURL,
OPNCTLGMATERIALIDBYSUPPLIER,
OPNCTLGMATLFIXEDLOTSIZEQTYVAL,
OPNCTLGMFRMATERIALNUMBER,
OPNCTLGMINORDERQUANTITYVALUE,
OPNCTLGPRCAMOUNTINCOMCURRENCY,
OPNCTLGPRICEID,
OPNCTLGPRICEVALDTYENDDTEVAL,
OPNCTLGPRICEVALDTYSTARTDTEVAL,
OPNCTLGPRICEVALIDFROMDATETIME,
OPNCTLGPRICEVALIDTODATETIME,
OPNCTLGRECYCLEUNIT,
OPNCTLGRECYCLEVALUE,
OPNCTLGSOURCELISTVALIDFROMDATE,
OPNCTLGSOURCELISTVALIDTODATE,
OPNCTLGSRCHLONGTEXT,
OPNCTLGSUPPLIERID,
OPNCTLGSUPPLIERNAME,
OPNCTLGSYSTEMNAME,
OPNCTLGTEMPEMISSIONUNIT,
OPNCTLGTEMPEMISSIONVALUE,
OPNCTLGWASTEGENERATEDUNIT,
OPNCTLGWASTEGENERATEDVALUE,
OPNCTLGWATERCONSUMPTIONUNIT,
OPNCTLGWATERCONSUMPTIONVALUE,
OPNCTLGWEBSERVICEID,
OPNCTLGWEBSERVICENAME,
ORDERPRICEUNITQTY,
ORDERQUANTITYUNIT,
PARENTITEM,
PRICINGSCALETYPE,
PROCUREMENTHUBSOURCESYSTEM,
PRODUCTCATALOGNAME,
PRODUCTTYPE,
PURCHASINGDOCUMENT,
PURCHASINGDOCUMENTITEM,
PURCHASINGORGANIZATION,
PURREQNSOURCEOFSUPPLYTYPE,
SOURCELOGICALSYSTEM,
SOURCEOFSUPPLYISBLOCKED,
SOURCEOFSUPPLYISFIXED,
TAXTOLERANCEPERCENT,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
PRIMARY KEY (MATERIAL, OPNCTLGITEMID, PLANTNAME)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA