Which tables does I_ProductionModelComponent use?

I_ProductionModelComponent reads from 2 data source(s): I_BillOfMaterialItem, I_ProductionModel.

How many fields does I_ProductionModelComponent have?

I_ProductionModelComponent has 73 fields. Key fields: ProductionModelUUID, ProductionModelComponentUUID.

I_ProductionModelComponent

DDL: I_PRODUCTIONMODELCOMPONENT Type: view_entity COMPOSITE Package: MPE_PRODUCTION_MODEL_CDS

Production Model Component

I_ProductionModelComponent is a Composite CDS View that provides data about "Production Model Component" in SAP S/4HANA. It reads from 2 data sources (I_BillOfMaterialItem, I_ProductionModel) and exposes 73 fields with key fields ProductionModelUUID, ProductionModelComponentUUID. It has 1 association to related views. Part of development package MPE_PRODUCTION_MODEL_CDS.

Data Sources (2)

Source	Alias	Join Type
I_BillOfMaterialItem	BOMItem	from
I_ProductionModel	ProductionModel	inner

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_MaterialText	_MaterialText	`_MaterialText.Material = BOMItem.BillOfMaterialComponent and _MaterialText.Language = $session.system_language`

Annotations (7)

Name	Value	Level
EndUserText.label	Production Model Component	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#COMPOSITE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (73)

Key	Field	Source Table	Source Field
KEY	ProductionModelUUID	I_ProductionModel	ProductionModelUUID
KEY	ProductionModelComponentUUID	I_BillOfMaterialItem	BillOfMaterialItemUUID
	BillOfMaterialCategory	I_BillOfMaterialItem	BillOfMaterialCategory
	BillOfMaterial
	BillOfMaterialVariant	I_BillOfMaterialItem	BillOfMaterialVariant
	BillOfMaterialItemNodeNumber	I_BillOfMaterialItem	BillOfMaterialItemNodeNumber
	BillOfMaterialVersion	I_BillOfMaterialItem	BillOfMaterialVersion
	ValidityStartDate	I_BillOfMaterialItem	ValidityStartDate
	ValidityEndDate	I_BillOfMaterialItem	ValidityEndDate
	EngineeringChangeDocument	I_BillOfMaterialItem	EngineeringChangeDocument
	ChgToEngineeringChgDocument	I_BillOfMaterialItem	ChgToEngineeringChgDocument
	InheritedNodeNumberForBOMItem	I_BillOfMaterialItem	InheritedNodeNumberForBOMItem
	InheritedNodeNumberVersionBOM	I_BillOfMaterialItem	InheritedNodeNumberVersionBOM
	BOMItemInternalChangeCount	I_BillOfMaterialItem	BOMItemInternalChangeCount
	BillOfMaterialComponent	I_BillOfMaterialItem	BillOfMaterialComponent
	MaterialName	_MaterialText	MaterialName
	BillOfMaterialItemCategory	I_BillOfMaterialItem	BillOfMaterialItemCategory
	BillOfMaterialItemNumber
	BillOfMaterialItemUnit	I_BillOfMaterialItem	BillOfMaterialItemUnit
	BillOfMaterialItemQuantity	I_BillOfMaterialItem	BillOfMaterialItemQuantity
	IsAssembly	I_BillOfMaterialItem	IsAssembly
	IsSubItem	I_BillOfMaterialItem	IsSubItem
	IsDeleted	I_BillOfMaterialItem	IsDeleted
	BOMItemSorter	I_BillOfMaterialItem	BOMItemSorter
	BOMItemHasFixedQuantity	I_BillOfMaterialItem	BOMItemHasFixedQuantity
	ComponentScrapInPercent	I_BillOfMaterialItem	ComponentScrapInPercent
	OperationScrapInPercent	I_BillOfMaterialItem	OperationScrapInPercent
	IsNetScrap	I_BillOfMaterialItem	IsNetScrap
	IsBulkMaterial	I_BillOfMaterialItem	IsBulkMaterial
	IsMaterialProvision	I_BillOfMaterialItem	IsMaterialProvision
	BOMItemIsSparePart	I_BillOfMaterialItem	BOMItemIsSparePart
	BOMItemIsSalesRelevant	I_BillOfMaterialItem	BOMItemIsSalesRelevant
	IsEngineeringRelevant	I_BillOfMaterialItem	IsEngineeringRelevant
	BOMItemIsPlantMaintRelevant	I_BillOfMaterialItem	BOMItemIsPlantMaintRelevant
	IsProductionRelevant	I_BillOfMaterialItem	IsProductionRelevant
	BOMItemIsCostingRelevant	I_BillOfMaterialItem	BOMItemIsCostingRelevant
	BOMIsRecursive	I_BillOfMaterialItem	BOMIsRecursive
	IsBOMRecursiveAllowed	I_BillOfMaterialItem	IsBOMRecursiveAllowed
	FollowUpGroup	I_BillOfMaterialItem	FollowUpGroup
	AlternativeItemGroup	I_BillOfMaterialItem	AlternativeItemGroup
	DependencyObjectNumber	I_BillOfMaterialItem	DependencyObjectNumber
	DiscontinuationGroup	I_BillOfMaterialItem	DiscontinuationGroup
	LeadTimeOffset	I_BillOfMaterialItem	LeadTimeOffset
	OperationLeadTimeOffset	I_BillOfMaterialItem	OperationLeadTimeOffset
	OpsLeadTimeOffsetUnit	I_BillOfMaterialItem	OpsLeadTimeOffsetUnit
	DistrKeyCompConsumption	I_BillOfMaterialItem	DistrKeyCompConsumption
	PurchasingGroup	I_BillOfMaterialItem	PurchasingGroup
	DeliveryDurationInDays	I_BillOfMaterialItem	DeliveryDurationInDays
	Creditor	I_BillOfMaterialItem	Creditor
	MaterialComponentPrice	I_BillOfMaterialItem	MaterialComponentPrice
	Currency	I_BillOfMaterialItem	Currency
	CostElement	I_BillOfMaterialItem	CostElement
	MaterialGroup	I_BillOfMaterialItem	MaterialGroup
	GoodsReceiptDuration	I_BillOfMaterialItem	GoodsReceiptDuration
	PurchasingOrganization	I_BillOfMaterialItem	PurchasingOrganization
	Size1	I_BillOfMaterialItem	Size1
	Size2	I_BillOfMaterialItem	Size2
	Size3	I_BillOfMaterialItem	Size3
	UnitOfMeasureForSize1To3	I_BillOfMaterialItem	UnitOfMeasureForSize1To3
	QuantityVariableSizeItem	I_BillOfMaterialItem	QuantityVariableSizeItem
	FormulaKey	I_BillOfMaterialItem	FormulaKey
	BOMItemDescription	I_BillOfMaterialItem	BOMItemDescription
	BOMItemText2	I_BillOfMaterialItem	BOMItemText2
	DocumentType	I_BillOfMaterialItem	DocumentType
	DocNumber	I_BillOfMaterialItem	DocNumber
	DocumentVersion	I_BillOfMaterialItem	DocumentVersion
	DocumentPart	I_BillOfMaterialItem	DocumentPart
	ProdOrderIssueLocation	I_BillOfMaterialItem	ProdOrderIssueLocation
	ProductionSupplyArea	I_BillOfMaterialItem	ProductionSupplyArea
	ExplosionType	I_BillOfMaterialItem	ExplosionType
	SpecialProcurementType	I_BillOfMaterialItem	SpecialProcurementType
	ReferencePoint	I_BillOfMaterialItem	ReferencePoint
	_ProductionModel		_ProductionModel

@EndUserText.label: 'Production Model Component'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}

define view entity I_ProductionModelComponent
  as select from I_BillOfMaterialItem as BOMItem
    inner join   I_ProductionModel    as ProductionModel on  ProductionModel.BillOfMaterialCategory = BOMItem.BillOfMaterialCategory
                                                         and ProductionModel.BillOfMaterial         = BOMItem.BillOfMaterial
                                                         and ProductionModel.BillOfMaterialVariant  = BOMItem.BillOfMaterialVariant
                                                         and ProductionModel.BillOfMaterialVersion  = BOMItem.BillOfMaterialVersion
  association [0..1] to I_MaterialText    as _MaterialText    on  _MaterialText.Material = BOMItem.BillOfMaterialComponent
                                                              and _MaterialText.Language = $session.system_language
  association        to I_ProductionModel as _ProductionModel on  $projection.ProductionModelUUID = _ProductionModel.ProductionModelUUID
{
  key    ProductionModel.ProductionModelUUID,
  key    BOMItem.BillOfMaterialItemUUID                                       as ProductionModelComponentUUID,
         BOMItem.BillOfMaterialCategory,
         cast( BOMItem.BillOfMaterial as cs_stlnr preserving type )           as BillOfMaterial,
         BOMItem.BillOfMaterialVariant,
         BOMItem.BillOfMaterialItemNodeNumber,
         BOMItem.BillOfMaterialVersion,
         BOMItem.ValidityStartDate,
         BOMItem.ValidityEndDate,
         BOMItem.EngineeringChangeDocument,
         BOMItem.ChgToEngineeringChgDocument,
         BOMItem.InheritedNodeNumberForBOMItem,
         BOMItem.InheritedNodeNumberVersionBOM,
         BOMItem.BOMItemInternalChangeCount,
         BOMItem.BillOfMaterialComponent,
         _MaterialText.MaterialName,
         BOMItem.BillOfMaterialItemCategory,
         cast( BOMItem.BillOfMaterialItemNumber as cs_sposn preserving type ) as BillOfMaterialItemNumber,
         BOMItem.BillOfMaterialItemUnit,
         @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
         BOMItem.BillOfMaterialItemQuantity,
         @Semantics.booleanIndicator: true                  
         BOMItem.IsAssembly,
         @Semantics.booleanIndicator: true                  
         BOMItem.IsSubItem,
         @Semantics.booleanIndicator: true                  
         BOMItem.IsDeleted,
         BOMItem.BOMItemSorter,
         @Semantics.booleanIndicator: true                  
         BOMItem.BOMItemHasFixedQuantity,
         BOMItem.ComponentScrapInPercent,
         BOMItem.OperationScrapInPercent,
         @Semantics.booleanIndicator: true                  
         BOMItem.IsNetScrap,
         @Semantics.booleanIndicator: true                  
         BOMItem.IsBulkMaterial,
         @Semantics.booleanIndicator: true         
         BOMItem.IsMaterialProvision,
         @Semantics.booleanIndicator: true                  
         BOMItem.BOMItemIsSparePart,
         @Semantics.booleanIndicator: true                  
         BOMItem.BOMItemIsSalesRelevant,
         @Semantics.booleanIndicator: true                  
         BOMItem.IsEngineeringRelevant,
         @Semantics.booleanIndicator: true                  
         BOMItem.BOMItemIsPlantMaintRelevant,
         @Semantics.booleanIndicator: true                  
         BOMItem.IsProductionRelevant,
         @Semantics.booleanIndicator: true                  
         BOMItem.BOMItemIsCostingRelevant,
         @Semantics.booleanIndicator: true                  
         BOMItem.BOMIsRecursive,
         @Semantics.booleanIndicator: true                  
         BOMItem.IsBOMRecursiveAllowed,
         BOMItem.FollowUpGroup,
         BOMItem.AlternativeItemGroup,
         BOMItem.DependencyObjectNumber,
         BOMItem.DiscontinuationGroup,
         BOMItem.LeadTimeOffset,
         BOMItem.OperationLeadTimeOffset,
         BOMItem.OpsLeadTimeOffsetUnit,
         BOMItem.DistrKeyCompConsumption,
         BOMItem.PurchasingGroup,
         BOMItem.DeliveryDurationInDays,
         BOMItem.Creditor,
         @Semantics.amount.currencyCode : 'Currency'
         BOMItem.MaterialComponentPrice,
//         BOMItem.MaterialPriceUnitQty,

         BOMItem.Currency,
         BOMItem.CostElement,
         BOMItem.MaterialGroup,
         BOMItem.GoodsReceiptDuration,
         BOMItem.PurchasingOrganization,
//         @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'         

//         BOMItem.NumberOfVariableSizeItem,

         @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
         BOMItem.Size1,
         @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
         BOMItem.Size2,
         @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
         BOMItem.Size3,
         BOMItem.UnitOfMeasureForSize1To3,
         @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
         BOMItem.QuantityVariableSizeItem,
         BOMItem.FormulaKey,
         BOMItem.BOMItemDescription,
         BOMItem.BOMItemText2,
         BOMItem.DocumentType,
         BOMItem.DocNumber,
         BOMItem.DocumentVersion,
         BOMItem.DocumentPart,
         BOMItem.ProdOrderIssueLocation,
         BOMItem.ProductionSupplyArea,
         BOMItem.ExplosionType,
         BOMItem.SpecialProcurementType,
         BOMItem.ReferencePoint,

         //      /* Associations */

         _ProductionModel
}

Depth:

I_ProductionModelComponent view_entity

I_BillOfMaterialItem view
I_ProductionModel view_entity

R_ProductionModelComponentTP view_entity