Which tables does I_ProdnModOpActyCompInstance use?

I_ProdnModOpActyCompInstance reads from 10 data source(s): I_BillOfMaterialComponent, I_BillOfOperationsOpBasic, I_BOOOperationChgStOANBasic, P_ProdnModelDgtlMockUpInstance, I_DigitalMockUpCharcs, I_OpActyBOOOpBOMIndivItmAssgmt, I_OpActyNtwkElement, I_BillOfOperationsOperation, I_ProductionModel, I_RoutingCompAllocSrchMod.

I_ProdnModOpActyCompInstance

Q: How many fields does I_ProdnModOpActyCompInstance have?

I_ProdnModOpActyCompInstance has 31 fields. Key fields: ProductionModelUUID, BOOOperationInternalID, OperationActivity, OperationActyVersionCounter, BOOOpBOMItemInternalID.

DDL: I_PRODNMODOPACTYCOMPINSTANCE Type: view_entity COMPOSITE

Prodn Model Op Acty Component Instance

I_ProdnModOpActyCompInstance is a Composite CDS View that provides data about "Prodn Model Op Acty Component Instance" in SAP S/4HANA. It reads from 10 data sources and exposes 31 fields with key fields ProductionModelUUID, BOOOperationInternalID, OperationActivity, OperationActyVersionCounter, BOOOpBOMItemInternalID. It has 1 association to related views.

Data Sources (10)

Source	Alias	Join Type
I_BillOfMaterialComponent	BOMItem	inner
I_BillOfOperationsOpBasic	BOOOpBasic	inner
I_BOOOperationChgStOANBasic	BOOOperationDetails	inner
P_ProdnModelDgtlMockUpInstance	DgtlMockUpInstance	inner
I_DigitalMockUpCharcs	DigitalMockUpCharcs	inner
I_OpActyBOOOpBOMIndivItmAssgmt	OpActivityComponentInstance	from
I_OpActyNtwkElement	OpactivityNetworkElement	inner
I_BillOfOperationsOperation	Operation	inner
I_ProductionModel	ProductionModel	inner
I_RoutingCompAllocSrchMod	RoutingCompAllocSrchMod	inner

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	P_ProdnModCompInstceRefDsgntr	_CompInstceRefDesignator	`$projection.DgtlMockUpCharcsUUID = _CompInstceRefDesignator.DgtlMockUpCharcsUUID`

Annotations (7)

Name	Value	Level
EndUserText.label	Prodn Model Op Acty Component Instance	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 (31)

Key	Field	Source Table	Source Field
KEY	ProductionModelUUID	I_ProductionModel	ProductionModelUUID
KEY	BOOOperationInternalID	I_BillOfOperationsOperation	BOOOperationInternalID
KEY	OperationActivity	I_OpActyBOOOpBOMIndivItmAssgmt	OperationActivity
KEY	OperationActyVersionCounter	I_OpActyBOOOpBOMIndivItmAssgmt	OperationActyVersionCounter
KEY	BOOOpBOMItemInternalID	I_OpActyBOOOpBOMIndivItmAssgmt	BOOOpBOMItemInternalID
KEY	OriglDgtlMockUpCharcsUUID	I_OpActyBOOOpBOMIndivItmAssgmt	OriglDgtlMockUpCharcsUUID
	DgtlMockUpCharcsValue	I_DigitalMockUpCharcs	DgtlMockUpCharcsValue
	BillOfMaterial	I_ProductionModel	BillOfMaterial
	BillOfMaterialVariant	I_ProductionModel	BillOfMaterialVariant
	BillOfMaterialCategory	I_ProductionModel	BillOfMaterialCategory
	BillOfMaterialVariantUsage	I_ProductionModel	BillOfMaterialVariantUsage
	Plant	I_ProductionModel	Plant
	BillOfOperationsGroup	I_ProductionModel	BillOfOperationsGroup
	BillOfOperationsType	I_ProductionModel	BillOfOperationsType
	BillOfOperationsVariant	I_ProductionModel	BillOfOperationsVariant
	BillOfOperationsVersion	I_ProductionModel	BillOfOperationsVersion
	Material	I_ProductionModel	Material
	BillOfMaterialVersion	I_ProductionModel	BillOfMaterialVersion
	Operation	I_BillOfOperationsOpBasic	Operation_2
	OpActyNtwkElementExternalID	I_OpActyNtwkElement	OpActyNtwkElementExternalID
	ProductionModelComponentUUID	I_BillOfMaterialComponent	BillOfMaterialItemUUID
	DgtlMockUpCharcsUUID	I_OpActyBOOOpBOMIndivItmAssgmt	DgtlMockUpCharcsUUID
	ReferenceDesignatorValue	_CompInstceRefDesignator	ReferenceDesignatorValue
	BillOfMaterialItemNodeNumber	I_BillOfMaterialComponent	BillOfMaterialItemNodeNumber
	InheritedNodeNumberForBOMItem	I_BillOfMaterialComponent	InheritedNodeNumberForBOMItem
	InheritedNodeNumberVersionBOM	I_BillOfMaterialComponent	InheritedNodeNumberVersionBOM
	BOMItemInternalChangeCount	I_BillOfMaterialComponent	BOMItemInternalChangeCount
	BillOfMaterialItemQuantity
	BillOfMaterialItemUnit	I_BillOfMaterialComponent	BillOfMaterialItemUnit
	_OperationActivityComponent		_OperationActivityComponent
	_ProductionModel		_ProductionModel

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

define view entity I_ProdnModOpActyCompInstance
  as select from I_OpActyBOOOpBOMIndivItmAssgmt as OpActivityComponentInstance
    inner join   I_OpActyNtwkElement            as OpactivityNetworkElement on  OpactivityNetworkElement.OpActyNtwkElementElement       = OpActivityComponentInstance.OperationActivity
                                                                            and OpactivityNetworkElement.OpActyNtwkElementElmntVersCntr = OpActivityComponentInstance.OperationActyVersionCounter
                                                                            and OpactivityNetworkElement.OpActyNtwkElementType          = 3
    inner join   I_BOOOperationChgStOANBasic    as BOOOperationDetails      on  BOOOperationDetails.ProduceOpActyNtwk             = OpactivityNetworkElement.OperationActivityNetwork
                                                                            and BOOOperationDetails.ProduceOpActyNtwkVersCounter  = OpactivityNetworkElement.OpActyNtwkVersionCounter
                                                                            or  BOOOperationDetails.SetupOpActyNtwk               = OpactivityNetworkElement.OperationActivityNetwork
                                                                            and BOOOperationDetails.SetupOpActyNtwkVersCounter    = OpactivityNetworkElement.OpActyNtwkVersionCounter
                                                                            or  BOOOperationDetails.TeardownOpActyNtwk            = OpactivityNetworkElement.OperationActivityNetwork
                                                                            and BOOOperationDetails.TeardownOpActyNtwkVersCounter = OpactivityNetworkElement.OpActyNtwkVersionCounter
    inner join   I_BillOfOperationsOperation    as Operation                on  Operation.BillOfOperationsType   = BOOOperationDetails.BillOfOperationsType
                                                                            and Operation.BillOfOperationsGroup  = BOOOperationDetails.BillOfOperationsGroup
                                                                            and Operation.BOOOperationInternalID = BOOOperationDetails.BOOOperationInternalID
    inner join   I_BillOfOperationsOpBasic      as BOOOpBasic               on  BOOOpBasic.BillOfOperationsType    = Operation.BillOfOperationsType
                                                                            and BOOOpBasic.BillOfOperationsGroup   = Operation.BillOfOperationsGroup
                                                                            and BOOOpBasic.BOOOperationInternalID  = Operation.BOOOperationInternalID
                                                                            and BOOOpBasic.BillOfOperationsVersion = BOOOperationDetails.BillOfOperationsVersion
    inner join   I_RoutingCompAllocSrchMod      as RoutingCompAllocSrchMod  on  RoutingCompAllocSrchMod.BOOOpBOMItemInternalID = OpActivityComponentInstance.BOOOpBOMItemInternalID
                                                                            and RoutingCompAllocSrchMod.BillOfOperationsType   = Operation.BillOfOperationsType
                                                                            and RoutingCompAllocSrchMod.BillOfOperationsGroup  = Operation.BillOfOperationsGroup
                                                                            and RoutingCompAllocSrchMod.BOOOperationInternalID = Operation.BOOOperationInternalID
    inner join   I_ProductionModel              as ProductionModel          on  ProductionModel.BillOfOperationsGroup   = Operation.BillOfOperationsGroup
                                                                            and ProductionModel.BillOfOperationsType    = Operation.BillOfOperationsType
                                                                            and ProductionModel.BillOfOperationsVariant = Operation.BillOfOperationsVariant
                                                                            and ProductionModel.BillOfOperationsVersion = RoutingCompAllocSrchMod.BillOfOperationsVersion
    inner join   I_BillOfMaterialComponent      as BOMItem                  on  BOMItem.BillOfMaterial               = RoutingCompAllocSrchMod.BillOfMaterial
                                                                            and BOMItem.BillOfMaterialVariant        = RoutingCompAllocSrchMod.BillOfMaterialVariant
                                                                            and BOMItem.BillOfMaterialCategory       = RoutingCompAllocSrchMod.BillOfMaterialCategory
                                                                            and BOMItem.BillOfMaterialItemNodeNumber = RoutingCompAllocSrchMod.BillOfMaterialItemNodeNumber
                                                                            and BOMItem.BillOfMaterialVersion        = ProductionModel.BillOfMaterialVersion
    inner join   P_ProdnModelDgtlMockUpInstance as DgtlMockUpInstance       on DgtlMockUpInstance.DgtlMockUpUUID = BOMItem.BillOfMaterialItemUUID
    inner join   I_DigitalMockUpCharcs          as DigitalMockUpCharcs      on  DigitalMockUpCharcs.DgtlMockUpCharcsUUID = OpActivityComponentInstance.DgtlMockUpCharcsUUID
                                                                            and DigitalMockUpCharcs.DgtlMockUpCharcsName = 'ORIGINAL_TMXGUID'

  association        to I_ProdnModOpActyComponent     as _OperationActivityComponent on  $projection.ProductionModelUUID         = _OperationActivityComponent.ProductionModelUUID
                                                                                     and $projection.BOOOperationInternalID      = _OperationActivityComponent.BOOOperationInternalID
                                                                                     and $projection.OperationActivity           = _OperationActivityComponent.OperationActivity
                                                                                     and $projection.OperationActyVersionCounter = _OperationActivityComponent.OperationActyVersionCounter
                                                                                     and $projection.BOOOpBOMItemInternalID      = _OperationActivityComponent.BOOOpBOMItemInternalID
  association        to I_ProductionModel             as _ProductionModel            on  $projection.ProductionModelUUID = _ProductionModel.ProductionModelUUID
  association [0..1] to P_ProdnModCompInstceRefDsgntr as _CompInstceRefDesignator    on  $projection.DgtlMockUpCharcsUUID = _CompInstceRefDesignator.DgtlMockUpCharcsUUID
{
  key    ProductionModel.ProductionModelUUID,
  key    Operation.BOOOperationInternalID,
  key    OpActivityComponentInstance.OperationActivity,
  key    OpActivityComponentInstance.OperationActyVersionCounter,
  key    OpActivityComponentInstance.BOOOpBOMItemInternalID,
  key    OpActivityComponentInstance.OriglDgtlMockUpCharcsUUID,
         DigitalMockUpCharcs.DgtlMockUpCharcsValue,
         ProductionModel.BillOfMaterial,
         ProductionModel.BillOfMaterialVariant,
         ProductionModel.BillOfMaterialCategory,
         ProductionModel.BillOfMaterialVariantUsage,
         ProductionModel.Plant,
         ProductionModel.BillOfOperationsGroup,
         ProductionModel.BillOfOperationsType,
         ProductionModel.BillOfOperationsVariant,
         ProductionModel.BillOfOperationsVersion,
         ProductionModel.Material,
         ProductionModel.BillOfMaterialVersion,
         BOOOpBasic.Operation_2         as Operation,
         OpactivityNetworkElement.OpActyNtwkElementExternalID,
         BOMItem.BillOfMaterialItemUUID as ProductionModelComponentUUID,
         OpActivityComponentInstance.DgtlMockUpCharcsUUID,
         _CompInstceRefDesignator.ReferenceDesignatorValue,
         BOMItem.BillOfMaterialItemNodeNumber,
         BOMItem.InheritedNodeNumberForBOMItem,
         BOMItem.InheritedNodeNumberVersionBOM,
         BOMItem.BOMItemInternalChangeCount,
         @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
         cast('1.000' as kmpmg )        as BillOfMaterialItemQuantity,
         BOMItem.BillOfMaterialItemUnit,
         _OperationActivityComponent,
         _ProductionModel
}
where
  OpActivityComponentInstance.BillOfOperationsType = 'V'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFMATERIALCOMPONENT",
"I_BILLOFOPERATIONSOPBASIC",
"I_BILLOFOPERATIONSOPERATION",
"I_BOOOPERATIONCHGSTOANBASIC",
"I_DIGITALMOCKUPCHARCS",
"I_OPACTYBOOOPBOMINDIVITMASSGMT",
"I_OPACTYNTWKELEMENT",
"I_PRODUCTIONMODEL",
"I_ROUTINGCOMPALLOCSRCHMOD",
"P_PRODNMODCOMPINSTCEREFDSGNTR",
"P_PRODNMODELDGTLMOCKUPINSTANCE"
],
"ASSOCIATED":
[
"I_PRODNMODOPACTYCOMPONENT",
"I_PRODUCTIONMODEL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_ProdnModOpActyCompInstance view_entity

I_OpActyBOOOpBOMIndivItmAssgmt view
I_BillOfMaterialComponent view
I_BillOfOperationsOpBasic view
I_BillOfOperationsOperation view_entity
I_BOOOperationChgStOANBasic view
I_DigitalMockUpCharcs view
I_OpActyNtwkElement view
I_ProductionModel view_entity
I_RoutingCompAllocSrchMod view_entity
P_ProdnModelDgtlMockUpInstance view_entity

R_ProdnModOpActyCompInstanceTP view_entity