I_PRODUCT

CDS View
142 Fields 100 CDS Views

Product

I_PRODUCT is a CDS View in S/4HANA. Product. It contains 142 fields. 100 CDS views read from this table.

CDS Views using this table (100)

ViewTypeJoinVDMDescription
/SCMTMS/VE_PRDRT view_entity from BOPF: Product Root Representation Node
/VSCEW/A_Product view_entity from Product
/VSCEW/CC_Product_VH view_entity from Scenario Product VH
/VSCEW/I_ProductPlantMRP view_entity union Product Plant MRP Area
A_ATPRlvtProductMRPAreaSegment view_entity inner CONSUMPTION Product Availability per Segment
A_ClfnProduct view from BASIC Product
A_Product view from COMPOSITE Product
A_WhsePhysInventoryItem view_entity left_outer COMPOSITE Warehouse Physical Inventory Item
C_BufPositioningProdVH view_entity from CONSUMPTION Product Value Help
C_ChmlCmplncProductParamVH view from CONSUMPTION Chml Cmplnc Material val help with Param
C_CSPRProduct view from CONSUMPTION Count Products with RFID: Product
C_CustomerReturnPlantVH view from CONSUMPTION Value Help for Production Plant of Returns Order
C_CustomerReturnProductVH view from CONSUMPTION Value Help for Product of Returns Order
C_EAMProductQuickVw view from CONSUMPTION Product Quick View
C_ExistingProcurementProduct view left_outer CONSUMPTION Existing procurement products
C_GRC_ProductChangeLog view inner CONSUMPTION Product change log
C_MaterialBySlsOrgDistrChnl view from CONSUMPTION Materials By Sales Org and Distr Channel
C_ProcmtQltyMgmtDsbldProd view from CONSUMPTION QM in procurement disabled product
C_ProdAssgblToStoreVH view_entity from CONSUMPTION Product Assignable to Store
C_ProductBasicInfo view from CONSUMPTION Product Basic Info View
C_ProductObjPg view from CONSUMPTION Product Object Page
C_ProductObjPgVariant view from CONSUMPTION Product Object Page - Variant
C_QuickCreateProduct view from CONSUMPTION Consumption view for Quick Create
C_RecipeIngredientMaterialVH view from CONSUMPTION Recipe Ingredient Material Value Help
C_RptvManufacturingProductVH view from CONSUMPTION Repetitive Manufacturing Product
C_SalesInsightMaterialVH view from CONSUMPTION Sales Insight: Material Value Help
C_SchedProdnProductGroupVH view_entity inner CONSUMPTION Value Help for Product Group
C_SlsDocItemCustomerMaterialVH view inner CONSUMPTION Customer Material
C_SrvcOrdTmplProductVH view from CONSUMPTION Value Help for Product for Templates
Crms4v_Product view from Common Product Data with All Texts
Crms4v_ProductSales view from Product Sales
Crms4v_ProductUnit view from Product Unit of Measure
FAC_productVH view from Data Source for Account Assignment Type
I_ActiveLogisticalProduct view from COMPOSITE Active Logistical Product composite view
I_AsstmtMdlMDGenerationError view inner COMPOSITE Error During Assortment Postprocessing
I_AsstmtMdlMDGenerationError_1 view_entity inner BASIC Error During Assortment Postprocessing
I_AsstmtMdlMDGenerationError_2 view_entity inner BASIC Error During Assortment Postprocessing
I_ChangeRecordProduct view from COMPOSITE Change Record Material
I_CnsldtnMasterData view union_all COMPOSITE Consolidation - Combined Master Data
I_CO_MaterialBalance view_entity inner COMPOSITE Colombia Material Balance
I_EWM_WhseOrderHndlgUnit view left_outer BASIC EWM Warehouse Order Handling Unit
I_GenericArticleVH view_entity from BASIC Generic Article
I_JITPackggMatlVH view_entity from COMPOSITE Packaging Material Value Help
I_MaterialUoMConversionFactor view inner BASIC Material uom conversion factor
I_MatlValnMngMrkdReldCostEst view_entity inner COMPOSITE Matl Valuations Marked and Reld Cost Est
I_PlndIndepRqmtSegment view inner COMPOSITE Planned Independent Requirement Segment
I_ProdExQltyInfoRecdInProcmt view inner COMPOSITE Products without Q-Info records
I_ProductChangeDocument view_entity from COMPOSITE Product Change Document
I_ProductDistrCtrListingTP view_entity inner TRANSACTIONAL Product Assignment to Distribution Center
I_ProductList view_entity from COMPOSITE Data model for product list
I_ProductStdVH view from COMPOSITE Product Value Help
I_ProductTrdClassfctnEndUse view left_outer BASIC Product Classfication for End Use
I_ProductVH view from COMPOSITE Product Value Help
I_ProductVH_2 view_entity from COMPOSITE Product Value Help
I_ProductWD view from TRANSACTIONAL Product BO Product Node (draft)
I_PT_SAFTBillgInvcListProd view_entity inner COMPOSITE Product from Invoice List Document
I_PT_SAFTBillingDeliveryProd view_entity inner COMPOSITE Product from Delivery Document
I_PT_SAFTSlsInvcBillgProduct view_entity inner COMPOSITE Product from Billing Document
I_RetailStoreProductImage view from COMPOSITE Retail Store Product Image Helper
I_RO_SAFTMatlDocHeader view_entity inner COMPOSITE RO SAFT Material Document Header
I_RO_SAFTMatlDocLineItem view_entity inner COMPOSITE RO SAFT Matl Doc Lines
I_SuVolRtrckgMaterialSource view from BASIC Subst Vol Retracking Material Source Details
I_TrdClassfctnProduct view from BASIC Product
I_VASProductVH view_entity from BASIC Value Added Services Product
P_acdoca_m_extract_agg view_entity inner COMPOSITE P_ACDOCA_M_EXTRACT Aggrigation
P_ARunRelChkRunMatlUoM view from COMPOSITE Multiple UoM's and Conversion Factors of Material
P_CnsldtnProduct view from COMPOSITE Consolidation Combined Material
P_ConfigurableProductPlantBase view union CONSUMPTION Simulation - Product Plant base for search
P_EBPAO_AdjustedOrder4Quantity view_entity inner COMPOSITE Evt-Bsd Production Acctg Ovw - Adjusted Order for Quantity
P_EWM_HandlingUnitHeader view_entity inner COMPOSITE Warehouse Handling Unit Header
P_EWM_PINVCOUNTITEM06 view left_outer CONSUMPTION Help view of PI Items - item info
P_EWM_PInvDocBusKeyItem view_entity inner COMPOSITE Private view for Row of PInv Item with Quantity in Whse
P_MatlInvtryUnivJrnlAggrgn view_entity inner COMPOSITE Material Inventroy Aggregation from ACDOCA
P_Matval_Manage_Cost view_entity inner COMPOSITE Manage Material Valuations, table of cost estimates
P_MRPMaterialCrossPlantStatus view from COMPOSITE MRP Material Status
P_MSPWWorkItem view inner BASIC MPW: Worklist of proposed movements (helper)
P_NumberOfProductVar_F4543 view_entity from CONSUMPTION Number of Product Variants
P_PCLblProdCmbndByBusProc view inner COMPOSITE Union Products by Business Processes
P_PCLblProdCmbndByBusProc view from COMPOSITE Union Products by Business Processes
P_PhysInvtryNotPosted_L2 view_entity inner COMPOSITE Not posted master data
P_Prchinforecords_FS view left_outer BASIC private factsheet - purchasing info records
P_Product_Fs view from BASIC Private Factsheet - Product
P_ProductSearch view from BASIC Product anchor view for CDS search model
P_ProductWD view from COMPOSITE union
P_RtlPromnItmStoreSlsUoM_F4674 view inner COMPOSITE Retail Promotion Items with Qty in Sales Unit
P_Salesview_Fs view left_outer COMPOSITE Private Factsheet - Sales View
P_SI4_TrainingData10 view left_outer COMPOSITE Sales Performance Prediction
P_SimulationObjectSearch view inner CONSUMPTION Simulation - Simulation Objects Search
P_SlowMoMatPredCnsmpnDelta view_entity left_outer COMPOSITE Consumption Delta
P_SlowMoMatPredStockDelta view_entity left_outer COMPOSITE Stock Delta
P_SlowMoMatPrMoCnsmpnDelta view_entity left_outer COMPOSITE Consumption Delta
P_SlowMoMatPrMoStockDelta view_entity left_outer COMPOSITE Stock Delta
P_SpecAssignedMatlForKeyDate view from COMPOSITE Specification Material Assignment for Key Date
P_SPP_PredictionData06 view left_outer COMPOSITE Prediction Data 06
P_SPP_TrainingData06 view left_outer COMPOSITE Training Data 06
P_StRpBillgDocSuplrInvcItem view left_outer COMPOSITE Sales and Purchase Inv Item with Tax for Statutory Reporting
R_MatlValnInvtryPerFsclPerd view_entity inner COMPOSITE M EXTRACT with references
R_ProductTP view_entity from TRANSACTIONAL Product
R_ProductTP_2 view_entity from TRANSACTIONAL Product - TP
SHSM_ASSGND_PROD_TO_DISTCTR_V view inner Products Assigned to Distribution Ctrs

Fields (142)

KeyField CDS FieldsUsed in Views
KEY Product ActiveProduct,Material,PackagingMaterial,Product,ProductForEdit,SubstVolRetrackingSource,SubstVolRetrackingSrceName,SuVolRtrckgSrcePrimSrchName,SuVolRtrckgSrceSecdrySrchName 30
KEY ProductGroup MaterialGroup,ProductGroup 28
KEY ProductType ProductType 27
KEY ProductUUID product_uuid,ProductUUID 4
_BaseUnitOfMeasure _BaseUnitOfMeasure 1
_BR_ANPCode _BR_ANPCode 1
_BR_ANPCodeText _BR_ANPCodeText 1
_Brand _Brand 1
_BrandText _BrandText 1
_ChemicalComplianceRelevant _ChemicalComplianceRelevant 1
_ChemicalComplianceRlvtText _ChemicalComplianceRlvtText 1
_CreatedByUserContactCard _CreatedByUserContactCard 1
_CrossPlantConfigurableProduct _CrossPlantConfigurableProduct 1
_Division _Division 1
_DivisionText _DivisionText 1
_ExternalProductGroup _ExternalProductGroup 1
_ExtProdGrpText _ExtProdGrpText 1
_ItemCategoryGroup _ItemCategoryGroup 2
_ItemCategoryGroupText _ItemCategoryGroupText 2
_LastChangedByUser _LastChangedByUser 1
_LastChangedByUserContactCard _LastChangedByUserContactCard 1
_MaterialText _MaterialText 1
_ProductCategory _ProductCategory 1
_ProductCategoryText _ProductCategoryText 1
_ProductGroup _ProductGroup 2
_ProductGroup_2 _ProductGroup,_ProductGroup_2 8
_ProductGroupText _ProductGroupText 1
_ProductGroupText_2 _ProductGroupText_2 1
_ProductHierarchy _ProductHierarchy 1
_ProductHierarchyText _ProductHierarchyText 1
_ProductStatus _ProductStatus 3
_ProductStatusText _ProductStatusText 1
_ProductType _ProductType 8
_ProductType_2 _ProductType 1
_ProductTypeName _ProductTypeName 1
_ProdUnivHierarchyNode _ProdUnivHierarchyNode 1
_Text _PackagingMaterialText,_Text 2
AdjustmentProfile AdjustmentProfile 1
ANPCode ANPCode 3
ArticleCategory ArticleCategory 5
AssortmentListType AssortmentListType 2
AuthorizationGroup AuthorizationGroup,ProductAuthorizationGroup 21
BaseUnit BaseUnit,UnitOfMeasure,ValuationQuantityUnit 24
BaseUnitSpecificProductHeight BaseUnitSpecificProductHeight 2
BaseUnitSpecificProductLength BaseUnitSpecificProductLength 2
BaseUnitSpecificProductWidth BaseUnitSpecificProductWidth 2
BasicMaterial BasicMaterial 1
Brand Brand 3
ChangeNumber ChangeNumber 1
ComparisonPriceQuantity ComparisonPriceQuantity 2
CompetitorID CompetitorID 4
ContentUnit ContentUnit 2
CountryOfOrigin CountryOfOrigin,herkl 3
CreatedByUser CreatedByUser,SubstVolRetrackingSrceCrtedBy 9
CreationDate CreationDate 7
CreationDateTime CreationDateTime 2
CreationTime CreationTime 3
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 4
CrossPlantStatus CrossPlantStatus 6
CrossPlantStatusValidityDate CrossPlantStatusValidityDate 4
DangerousGoodsIndProfile dgprofl 1
Division Division 6
ExternalProductGroup ExternalProductGroup 3
GrossContent GrossContent 2
GrossWeight GrossWeight 6
HandlingIndicator HandlingIndicator 1
HandlingUnitType HandlingUnitType 1
HasEmptiesBOM HasEmptiesBOM 2
HasTextilePartsWthAnimalOrigin HasTextilePartsWthAnimalOrigin 2
HasVariableTareWeight HasVariableTareWeight 1
IndustrySector IndustrySector 2
IndustryStandardName IndustryStandardName 2
InternationalArticleNumberCat InternationalArticleNumberCat 2
IsApprovedBatchRecordReqd IsApprovedBatchRecordReqd 1
IsBatchManagementRequired IsBatchManagementRequired 6
IsChemicalComplianceRelevant IsChemicalComplianceRelevant 1
IsMarkedForDeletion IsMarkedForDeletion 4
IsPilferable IsPilferable 1
IsRelevantForHzdsSubstances IsRelevantForHzdsSubstances 1
ItemCategoryGroup ItemCategoryGroup 4
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 1
LastChangeDate LastChangeDate 6
LastChangeDateTime LastChangeDateTime,SubstVolRetrckgSrceChgdDteTme 3
LastChangedByUser LastChangedByUser 6
LastChangeTime LastChangeTime 2
LowLevelCode LowLevelCode 1
ManufacturerNumber ManufacturerNumber 4
ManufacturerPartProfile ManufacturerPartProfile 3
MaterialRevisionLevel MaterialRevisionLevel 1
MaterialVolume MaterialVolume 2
MaximumCapacity MaximumCapacity 1
MaximumPackagingHeight MaximumPackagingHeight 1
MaximumPackagingLength MaximumPackagingLength 1
MaximumPackagingWidth MaximumPackagingWidth 1
NetContent NetContent 2
NetWeight NetWeight,ntgew 6
OvercapacityTolerance OvercapacityTolerance 1
OwnInventoryManagedProduct Material,OwnInventoryManagedProduct 2
PackagingMaterialGroup PackagingMaterialGroup 1
ProdNoInGenProdInPrepackProd ProdNoInGenProdInPrepackProd 2
ProductCategory ProductCategory 4
ProductConfiguration ProductConfiguration 1
ProductDocumentChangeNumber ProductDocumentChangeNumber 1
ProductDocumentNumber ProductDocumentNumber 1
ProductDocumentPageCount ProductDocumentPageCount 1
ProductDocumentPageFormat ProductDocumentPageFormat 1
ProductDocumentPageNumber ProductDocumentPageNumber 1
ProductDocumentType ProductDocumentType 1
ProductDocumentVersion ProductDocumentVersion 1
ProductExternalID ProductExternalID 6
ProductHierarchy ProductHierarchy 5
ProductIsConfigurable ProductIsConfigurable 4
ProductIsLocked ProductIsLocked 1
ProductManufacturerNumber ProductManufacturerNumber 7
ProductMeasurementUnit ProductMeasurementUnit 2
ProductOldID ProductOldID 5
ProductSeasonUsageCategory ProductSeasonUsageCategory 2
ProductStandardID ProductStandardID 6
ProductValidEndDate ProductValidEndDate 2
ProductValidStartDate ProductValidStartDate 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 3
QltyMgmtInProcmtIsActive QltyMgmtInProcmtIsActive 2
QualityInspectionGroup QualityInspectionGroup 1
QuarantinePeriod QuarantinePeriod 1
SalesProduct SalesProduct 1
SalesStatus SalesStatus 2
SalesStatusValidityDate SalesStatusValidityDate 1
SegmentationStrategy SegmentationStrategy 1
SerialIdentifierAssgmtProfile SerialIdentifierAssgmtProfile 1
SerialNoExplicitnessLevel SerialNoExplicitnessLevel 2
SerialNumberProfile SerialNumberProfile 1
SizeOrDimensionText SizeOrDimensionText 3
SourceOfSupply SourceOfSupply 2
StandardHandlingUnitType StandardHandlingUnitType 1
TimeUnitForQuarantinePeriod TimeUnitForQuarantinePeriod 1
UnitForMaxPackagingDimensions UnitForMaxPackagingDimensions 1
ValidityStartDate ValidityStartDate 2
VarblPurOrdUnitIsActive VarblPurOrdUnitIsActive 1
VolumeUnit VolumeUnit 2
WarehouseProductGroup WarehouseProductGroup 1
WarehouseStorageCondition WarehouseStorageCondition 1
WeightUnit gewei,WeightUnit 7

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.

-- Product
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCT (
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTTYPE,
    PRODUCTUUID,
    _BASEUNITOFMEASURE,
    _BR_ANPCODE,
    _BR_ANPCODETEXT,
    _BRAND,
    _BRANDTEXT,
    _CHEMICALCOMPLIANCERELEVANT,
    _CHEMICALCOMPLIANCERLVTTEXT,
    _CREATEDBYUSERCONTACTCARD,
    _CROSSPLANTCONFIGURABLEPRODUCT,
    _DIVISION,
    _DIVISIONTEXT,
    _EXTERNALPRODUCTGROUP,
    _EXTPRODGRPTEXT,
    _ITEMCATEGORYGROUP,
    _ITEMCATEGORYGROUPTEXT,
    _LASTCHANGEDBYUSER,
    _LASTCHANGEDBYUSERCONTACTCARD,
    _MATERIALTEXT,
    _PRODUCTCATEGORY,
    _PRODUCTCATEGORYTEXT,
    _PRODUCTGROUP,
    _PRODUCTGROUP_2,
    _PRODUCTGROUPTEXT,
    _PRODUCTGROUPTEXT_2,
    _PRODUCTHIERARCHY,
    _PRODUCTHIERARCHYTEXT,
    _PRODUCTSTATUS,
    _PRODUCTSTATUSTEXT,
    _PRODUCTTYPE,
    _PRODUCTTYPE_2,
    _PRODUCTTYPENAME,
    _PRODUNIVHIERARCHYNODE,
    _TEXT,
    ADJUSTMENTPROFILE,
    ANPCODE,
    ARTICLECATEGORY,
    ASSORTMENTLISTTYPE,
    AUTHORIZATIONGROUP,
    BASEUNIT,
    BASEUNITSPECIFICPRODUCTHEIGHT,
    BASEUNITSPECIFICPRODUCTLENGTH,
    BASEUNITSPECIFICPRODUCTWIDTH,
    BASICMATERIAL,
    BRAND,
    CHANGENUMBER,
    COMPARISONPRICEQUANTITY,
    COMPETITORID,
    CONTENTUNIT,
    COUNTRYOFORIGIN,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CROSSPLANTSTATUS,
    CROSSPLANTSTATUSVALIDITYDATE,
    DANGEROUSGOODSINDPROFILE,
    DIVISION,
    EXTERNALPRODUCTGROUP,
    GROSSCONTENT,
    GROSSWEIGHT,
    HANDLINGINDICATOR,
    HANDLINGUNITTYPE,
    HASEMPTIESBOM,
    HASTEXTILEPARTSWTHANIMALORIGIN,
    HASVARIABLETAREWEIGHT,
    INDUSTRYSECTOR,
    INDUSTRYSTANDARDNAME,
    INTERNATIONALARTICLENUMBERCAT,
    ISAPPROVEDBATCHRECORDREQD,
    ISBATCHMANAGEMENTREQUIRED,
    ISCHEMICALCOMPLIANCERELEVANT,
    ISMARKEDFORDELETION,
    ISPILFERABLE,
    ISRELEVANTFORHZDSSUBSTANCES,
    ITEMCATEGORYGROUP,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LOWLEVELCODE,
    MANUFACTURERNUMBER,
    MANUFACTURERPARTPROFILE,
    MATERIALREVISIONLEVEL,
    MATERIALVOLUME,
    MAXIMUMCAPACITY,
    MAXIMUMPACKAGINGHEIGHT,
    MAXIMUMPACKAGINGLENGTH,
    MAXIMUMPACKAGINGWIDTH,
    NETCONTENT,
    NETWEIGHT,
    OVERCAPACITYTOLERANCE,
    OWNINVENTORYMANAGEDPRODUCT,
    PACKAGINGMATERIALGROUP,
    PRODNOINGENPRODINPREPACKPROD,
    PRODUCTCATEGORY,
    PRODUCTCONFIGURATION,
    PRODUCTDOCUMENTCHANGENUMBER,
    PRODUCTDOCUMENTNUMBER,
    PRODUCTDOCUMENTPAGECOUNT,
    PRODUCTDOCUMENTPAGEFORMAT,
    PRODUCTDOCUMENTPAGENUMBER,
    PRODUCTDOCUMENTTYPE,
    PRODUCTDOCUMENTVERSION,
    PRODUCTEXTERNALID,
    PRODUCTHIERARCHY,
    PRODUCTISCONFIGURABLE,
    PRODUCTISLOCKED,
    PRODUCTMANUFACTURERNUMBER,
    PRODUCTMEASUREMENTUNIT,
    PRODUCTOLDID,
    PRODUCTSEASONUSAGECATEGORY,
    PRODUCTSTANDARDID,
    PRODUCTVALIDENDDATE,
    PRODUCTVALIDSTARTDATE,
    PURCHASEORDERQUANTITYUNIT,
    QLTYMGMTINPROCMTISACTIVE,
    QUALITYINSPECTIONGROUP,
    QUARANTINEPERIOD,
    SALESPRODUCT,
    SALESSTATUS,
    SALESSTATUSVALIDITYDATE,
    SEGMENTATIONSTRATEGY,
    SERIALIDENTIFIERASSGMTPROFILE,
    SERIALNOEXPLICITNESSLEVEL,
    SERIALNUMBERPROFILE,
    SIZEORDIMENSIONTEXT,
    SOURCEOFSUPPLY,
    STANDARDHANDLINGUNITTYPE,
    TIMEUNITFORQUARANTINEPERIOD,
    UNITFORMAXPACKAGINGDIMENSIONS,
    VALIDITYSTARTDATE,
    VARBLPURORDUNITISACTIVE,
    VOLUMEUNIT,
    WAREHOUSEPRODUCTGROUP,
    WAREHOUSESTORAGECONDITION,
    WEIGHTUNIT,
    PRIMARY KEY (PRODUCT, PRODUCTGROUP, PRODUCTTYPE, PRODUCTUUID)
);

Learn More