I_ProdnModOpActyCompInstance

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 8 data sources and exposes 36 fields with key fields ProductionModelUUID, BillOfOperationsVersion, BOOOperationInternalID, OperationActivity, OperationActyVersionCounter.

8 data source(s) 36 fields

Data Sources (8)

SourceAliasJoin Type
P_ProductionModelComponent BOMItem inner
I_BOOOperationChgStOANBasic BOOOperationDetails inner
P_ProdnModCompDgtlMockUpCharcs DigitalMockUpCharcs inner
I_ProdnModelComponentInstance HeaderComponentInstance inner
I_OpActyBOOOpBOMIndivItmAssgmt OpActivityComponentInstance from
I_OpActyNtwkElement OpactivityNetworkElement inner
P_ProdnModBOOOperation Operation inner
I_RoutingCompAllocSrchMod RoutingCompAllocSrchMod inner

Annotations (7)

NameValueLevelField
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 (36)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID P_ProductionModelComponent ProductionModelUUID
KEY BillOfOperationsVersion P_ProductionModelComponent BillOfOperationsVersion
KEY BOOOperationInternalID P_ProdnModBOOOperation BOOOperationInternalID
KEY OperationActivity I_OpActyBOOOpBOMIndivItmAssgmt OperationActivity
KEY OperationActyVersionCounter I_OpActyBOOOpBOMIndivItmAssgmt OperationActyVersionCounter
KEY BOOOpBOMItemInternalID I_OpActyBOOOpBOMIndivItmAssgmt BOOOpBOMItemInternalID
KEY OriglDgtlMockUpCharcsUUID I_OpActyBOOOpBOMIndivItmAssgmt OriglDgtlMockUpCharcsUUID
BOOOpInternalVersionCounter P_ProdnModBOOOperation BOOOpInternalVersionCounter
DgtlMockUpCharcsValue P_ProdnModCompDgtlMockUpCharcs DgtlMockUpCharcsValue
DgtlMockUpCharcsVislEntInstce P_ProdnModCompDgtlMockUpCharcs DgtlMockUpCharcsVislEntInstce
DgtlMockUpCharcsCADInstce P_ProdnModCompDgtlMockUpCharcs DgtlMockUpCharcsCADInstce
DgtlMockUpCharcsUUID I_OpActyBOOOpBOMIndivItmAssgmt DgtlMockUpCharcsUUID
DgtlMockUpInstceCount I_ProdnModelComponentInstance DgtlMockUpInstceCount
DgtlMockUpTrnsfmtnMatrixCount I_ProdnModelComponentInstance DgtlMockUpTrnsfmtnMatrixCount
ProductionModelComponentUUID P_ProductionModelComponent ProductionModelComponentUUID
BillOfMaterial P_ProductionModelComponent BillOfMaterial
BillOfMaterialVariant P_ProductionModelComponent BillOfMaterialVariant
BillOfMaterialCategory P_ProductionModelComponent BillOfMaterialCategory
BillOfMaterialVariantUsage P_ProductionModelComponent BillOfMaterialVariantUsage
Plant P_ProductionModelComponent Plant
BillOfOperationsGroup P_ProductionModelComponent BillOfOperationsGroup
BillOfOperationsType P_ProductionModelComponent BillOfOperationsType
BillOfOperationsVariant P_ProductionModelComponent BillOfOperationsVariant
Material P_ProductionModelComponent Material
BillOfMaterialVersion P_ProductionModelComponent BillOfMaterialVersion
Operation P_ProdnModBOOOperation Operation_2
OpActyNtwkElementExternalID I_OpActyNtwkElement OpActyNtwkElementExternalID
ReferenceDesignatorValue P_ProdnModCompDgtlMockUpCharcs ReferenceDesignatorValue
BillOfMaterialItemNodeNumber P_ProductionModelComponent BillOfMaterialItemNodeNumber
InheritedNodeNumberForBOMItem P_ProductionModelComponent InheritedNodeNumberForBOMItem
InheritedNodeNumberVersionBOM P_ProductionModelComponent InheritedNodeNumberVersionBOM
BOMItemInternalChangeCount P_ProductionModelComponent BOMItemInternalChangeCount
BillOfMaterialItemQuantity
BillOfMaterialItemUnit P_ProductionModelComponent 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   P_ProdnModBOOOperation         as Operation                on  Operation.BillOfOperationsType        = BOOOperationDetails.BillOfOperationsType
                                                                            and Operation.BillOfOperationsGroup       = BOOOperationDetails.BillOfOperationsGroup
                                                                            and Operation.BOOOperationInternalID      = BOOOperationDetails.BOOOperationInternalID
                                                                            and Operation.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
                                                                            and RoutingCompAllocSrchMod.BillOfOperationsVersion    = BOOOperationDetails.BillOfOperationsVersion
    inner join   P_ProductionModelComponent     as BOMItem                  on  BOMItem.BillOfMaterial               = RoutingCompAllocSrchMod.BillOfMaterial
                                                                            and BOMItem.BillOfMaterialVariant        = RoutingCompAllocSrchMod.BillOfMaterialVariant
                                                                            and BOMItem.BillOfMaterialCategory       = RoutingCompAllocSrchMod.BillOfMaterialCategory
                                                                            and BOMItem.BillOfMaterialItemNodeNumber = RoutingCompAllocSrchMod.BillOfMaterialItemNodeNumber
                                                                            and BOMItem.BillOfOperationsGroup        = Operation.BillOfOperationsGroup
                                                                            and BOMItem.BillOfOperationsType         = Operation.BillOfOperationsType
                                                                            and BOMItem.BillOfOperationsVariant      = Operation.BillOfOperationsVariant
                                                                            and BOMItem.BillOfOperationsVersion      = RoutingCompAllocSrchMod.BillOfOperationsVersion
    inner join   P_ProdnModCompDgtlMockUpCharcs as DigitalMockUpCharcs      on  DigitalMockUpCharcs.DgtlMockUpUUID       = BOMItem.ProductionModelComponentUUID
                                                                            and DigitalMockUpCharcs.DgtlMockUpCharcsValue = OpActivityComponentInstance.OriglDgtlMockUpCharcsCharUUID
    inner join   I_ProdnModelComponentInstance  as HeaderComponentInstance  on  BOMItem.ProductionModelUUID               = HeaderComponentInstance.ProductionModelUUID
                                                                            and BOMItem.BillOfOperationsVersion           = HeaderComponentInstance.BillOfOperationsVersion
                                                                            and BOMItem.ProductionModelComponentUUID      = HeaderComponentInstance.ProductionModelComponentUUID
                                                                            and DigitalMockUpCharcs.DgtlMockUpCharcsValue = HeaderComponentInstance.DgtlMockUpCharcsValue //INST_GUID

  association to I_ProdnModOpActyComponent as _OperationActivityComponent on  $projection.ProductionModelUUID         = _OperationActivityComponent.ProductionModelUUID
                                                                          and $projection.BillOfOperationsVersion     = _OperationActivityComponent.BillOfOperationsVersion
                                                                          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
                                                                          and $projection.BillOfOperationsVersion = _ProductionModel.BillOfOperationsVersion
{
  key    BOMItem.ProductionModelUUID,
  key    BOMItem.BillOfOperationsVersion,
  key    Operation.BOOOperationInternalID,
  key    OpActivityComponentInstance.OperationActivity,
  key    OpActivityComponentInstance.OperationActyVersionCounter,
  key    OpActivityComponentInstance.BOOOpBOMItemInternalID,
  key    OpActivityComponentInstance.OriglDgtlMockUpCharcsUUID, //INST_GUID

         Operation.BOOOpInternalVersionCounter,
         DigitalMockUpCharcs.DgtlMockUpCharcsValue, //INST_GUID

         DigitalMockUpCharcs.DgtlMockUpCharcsVislEntInstce,
         DigitalMockUpCharcs.DgtlMockUpCharcsCADInstce,
         OpActivityComponentInstance.DgtlMockUpCharcsUUID, //TMXGUID

         HeaderComponentInstance.DgtlMockUpInstceCount,
         HeaderComponentInstance.DgtlMockUpTrnsfmtnMatrixCount,
         BOMItem.ProductionModelComponentUUID,
         BOMItem.BillOfMaterial,
         BOMItem.BillOfMaterialVariant,
         BOMItem.BillOfMaterialCategory,
         BOMItem.BillOfMaterialVariantUsage,
         BOMItem.Plant,
         BOMItem.BillOfOperationsGroup,
         BOMItem.BillOfOperationsType,
         BOMItem.BillOfOperationsVariant,
         BOMItem.Material,
         BOMItem.BillOfMaterialVersion,
         Operation.Operation_2   as Operation,
         OpactivityNetworkElement.OpActyNtwkElementExternalID,
         DigitalMockUpCharcs.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'

Learn More