I_ProdnModOpActyComponent

@EndUserText.label: 'Production Model Activity Component'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
define view entity I_ProdnModOpActyComponent
  as select from I_OpActyBOOOpBOMItmAssgmt   as OperationActivityComponent
    inner join   I_OpActyNtwkElement         as OpactivityNetworkElement on  OpactivityNetworkElement.OpActyNtwkElementElement       = OperationActivityComponent.OperationActivity
                                                                         and OpactivityNetworkElement.OpActyNtwkElementElmntVersCntr = OperationActivityComponent.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_RoutingCompAllocSrchMod   as OperationComponent       on  OperationComponent.BOOOpBOMItemInternalID  = OperationActivityComponent.BOOOpBOMItemInternalID
                                                                         and OperationComponent.BillOfOperationsType    = BOOOperationDetails.BillOfOperationsType
                                                                         and OperationComponent.BillOfOperationsGroup   = BOOOperationDetails.BillOfOperationsGroup
                                                                         and OperationComponent.BOOOperationInternalID  = BOOOperationDetails.BOOOperationInternalID
                                                                         and OperationComponent.BillOfOperationsVersion = BOOOperationDetails.BillOfOperationsVersion
    inner join   P_ProductionModelComponent  as BOMItem                  on  BOMItem.BillOfMaterial               = OperationComponent.BillOfMaterial
                                                                         and BOMItem.BillOfMaterialVariant        = OperationComponent.BillOfMaterialVariant
                                                                         and BOMItem.BillOfMaterialCategory       = OperationComponent.BillOfMaterialCategory
                                                                         and BOMItem.BillOfMaterialItemNodeNumber = OperationComponent.BillOfMaterialItemNodeNumber
                                                                         and BOMItem.BillOfOperationsGroup        = OperationComponent.BillOfOperationsGroup
                                                                         and BOMItem.BillOfOperationsType         = OperationComponent.BillOfOperationsType
                                                                         and BOMItem.BillOfOperationsVariant      = OperationComponent.BillOfOperationsVariant
                                                                         and BOMItem.BillOfOperationsVersion      = OperationComponent.BillOfOperationsVersion
  association [0..1] to I_MaterialText               as _MaterialText                on  _MaterialText.Material = BOMItem.BillOfMaterialComponent
                                                                                     and _MaterialText.Language = $session.system_language
  association [0..1] to I_BomItemCategoryText        as _BOMItemCategoryText         on  $projection.BillOfMaterialItemCategory = _BOMItemCategoryText.BillOfMaterialItemCategory
                                                                                     and _BOMItemCategoryText.Language          = $session.system_language
  association [0..1] to I_MRPQuantityDistrKeyText    as _DistrKeyText                on  $projection.Plant                   = _DistrKeyText.Plant
                                                                                     and $projection.DistrKeyCompConsumption = _DistrKeyText.QuantityDistributionKey
                                                                                     and _DistrKeyText.Language              = $session.system_language
  association [0..1] to I_ExplosionTypeVH            as _ExplosionTypeText           on  $projection.ExplosionType = _ExplosionTypeText.ExplosionType
  association [0..1] to I_SpecialProcurementType     as _SpecialProcTypeText         on  $projection.Plant                  = _SpecialProcTypeText.Plant
                                                                                     and $projection.SpecialProcurementType = _SpecialProcTypeText.SpecialProcurementType
  association [0..1] to I_AltItemStrategyVH          as _AltItemStrategyText         on  $projection.AlternativeItemStrategy = _AltItemStrategyText.AlternativeItemStrategy
                                                                                     and _AltItemStrategyText.Language       = $session.system_language
  association [0..1] to I_ReferencePointVH           as _ReferencePointText          on  $projection.ReferencePoint = _ReferencePointText.ReferencePoint
  association [0..1] to I_BOMItemCostingRelevant     as _CostingRelevantText         on  $projection.MaterialCompCostingRelevancy = _CostingRelevantText.BOMItemIsCostingRelevant
  association [0..1] to I_MatProvisionIndicatorVH    as _MatProvisionIndText         on  $projection.MaterialProvisionType = _MatProvisionIndText.IsMaterialProvision
  association [0..1] to I_StorageLocation            as _IssueLocationText           on  $projection.Plant                  = _IssueLocationText.Plant
                                                                                     and $projection.ProdOrderIssueLocation = _IssueLocationText.StorageLocation
  association [0..1] to I_ProductionSupplyAreaText   as _ProdSupplyAreaText          on  $projection.Plant                = _ProdSupplyAreaText.Plant
                                                                                     and $projection.ProductionSupplyArea = _ProdSupplyAreaText.ProductionSupplyArea
                                                                                     and _ProdSupplyAreaText.Language     = $session.system_language
  association [0..1] to I_BOMItemSparePart           as _SparePartText               on  $projection.MatlComponentSparePartType = _SparePartText.BOMItemIsSparePart
  association [0..1] to I_BOMItemSalesRelevant       as _SalesRelevantText           on  $projection.BOMItemSalesRelevancy = _SalesRelevantText.BOMItemIsSalesRelevant
  association [0..1] to I_PurchasingOrganization     as _PurchasingOrgText           on  $projection.PurchasingOrganization = _PurchasingOrgText.PurchasingOrganization
  association [0..1] to I_PurchasingGroup            as _PurchasingGroupText         on  $projection.PurchasingGroup = _PurchasingGroupText.PurchasingGroup
  association [0..1] to I_MaterialGroupText          as _MaterialGroupText           on  $projection.MaterialGroup   = _MaterialGroupText.MaterialGroup
                                                                                     and _MaterialGroupText.Language = $session.system_language
  association [0..1] to I_Supplier                   as _SupplierText                on  $projection.Creditor = _SupplierText.Supplier
  association [0..1] to I_CostElementText            as _CostElementText             on  $projection.CostElement   = _CostElementText.CostElement // Need to add key fields

                                                                                     and _CostElementText.Language = $session.system_language
  association [0..1] to I_ProductSupplyPlanning      as _MaterialPlant               on  $projection.BillOfMaterialComponent = _MaterialPlant.Product
                                                                                     and $projection.Plant                   = _MaterialPlant.Plant



  association [0..*] to I_ProdnModOpActyCompInstance as _OpActivityComponentInstance on  $projection.ProductionModelUUID         = _OpActivityComponentInstance.ProductionModelUUID
                                                                                     and $projection.BillOfOperationsVersion     = _OpActivityComponentInstance.BillOfOperationsVersion
                                                                                     and $projection.BOOOperationInternalID      = _OpActivityComponentInstance.BOOOperationInternalID
                                                                                     and $projection.OperationActivity           = _OpActivityComponentInstance.OperationActivity
                                                                                     and $projection.OperationActyVersionCounter = _OpActivityComponentInstance.OperationActyVersionCounter
                                                                                     and $projection.BOOOpBOMItemInternalID      = _OpActivityComponentInstance.BOOOpBOMItemInternalID
  association        to I_ProdnModOperationActivity  as _ProdnModOperationActivity   on  $projection.ProductionModelUUID         = _ProdnModOperationActivity.ProductionModelUUID
                                                                                     and $projection.BillOfOperationsVersion     = _ProdnModOperationActivity.BillOfOperationsVersion
                                                                                     and $projection.BillOfMaterial              = _ProdnModOperationActivity.BillOfMaterial
                                                                                     and $projection.BillOfMaterialVariant       = _ProdnModOperationActivity.BillOfMaterialVariant
                                                                                     and $projection.BillOfMaterialCategory      = _ProdnModOperationActivity.BillOfMaterialCategory
                                                                                     and $projection.BillOfMaterialVariantUsage  = _ProdnModOperationActivity.BillOfMaterialVariantUsage
                                                                                     and $projection.Plant                       = _ProdnModOperationActivity.Plant
                                                                                     and $projection.BillOfOperationsGroup       = _ProdnModOperationActivity.BillOfOperationsGroup
                                                                                     and $projection.BillOfOperationsType        = _ProdnModOperationActivity.BillOfOperationsType
                                                                                     and $projection.BillOfOperationsVariant     = _ProdnModOperationActivity.BillOfOperationsVariant
                                                                                     and $projection.BOOOperationInternalID      = _ProdnModOperationActivity.BOOOperationInternalID
                                                                                     and $projection.OperationActivity           = _ProdnModOperationActivity.OperationActivity
                                                                                     and $projection.OperationActyVersionCounter = _ProdnModOperationActivity.OperationActyVersionCounter
  association        to I_ProductionModel            as _ProductionModel             on  $projection.ProductionModelUUID     = _ProductionModel.ProductionModelUUID
                                                                                     and $projection.BillOfOperationsVersion = _ProductionModel.BillOfOperationsVersion
{
  key BOMItem.ProductionModelUUID,
  key BOMItem.BillOfOperationsVersion,
  key BOOOperationDetails.BOOOperationInternalID,
  key OperationActivityComponent.OperationActivity,
  key OperationActivityComponent.OperationActyVersionCounter,
  key OperationActivityComponent.BOOOpBOMItemInternalID,
      BOOOperationDetails.BOOOpInternalVersionCounter,
      BOMItem.BillOfMaterial,
      BOMItem.BillOfMaterialVariant,
      BOMItem.BillOfMaterialCategory,
      BOMItem.BillOfMaterialVariantUsage,
      BOMItem.Plant,
      BOMItem.BillOfOperationsGroup,
      BOMItem.BillOfOperationsType,
      BOMItem.BillOfOperationsVariant,
      BOMItem.Material,
      BOMItem.BillOfMaterialVersion,
      OpactivityNetworkElement.OpActyNtwkElementExternalID,
      BOMItem.ProductionModelComponentUUID,
      BOMItem.BillOfMaterialItemNodeNumber,
      BOMItem.ValidityStartDate,
      BOMItem.ValidityEndDate,
      BOMItem.EngineeringChangeDocument,
      BOMItem.ChgToEngineeringChgDocument,
      BOMItem.InheritedNodeNumberForBOMItem,
      BOMItem.InheritedNodeNumberVersionBOM,
      BOMItem.BOMItemInternalChangeCount,
      BOMItem.BillOfMaterialComponent,
      BOMItem.ComponentDescription,
      BOMItem.BillOfMaterialItemCategory,
      cast( BOMItem.BillOfMaterialItemNumber as cs_sposn preserving type ) as BillOfMaterialItemNumber,
      @Semantics.quantity.unitOfMeasure: 'ProdnModBOMCompAssgdQtyUnit'
      OperationActivityComponent.BillOfMaterialItemQuantity                as ProdnModBOMCompAssgdQuantity,
      OperationActivityComponent.BillOfMaterialItemUnit                    as ProdnModBOMCompAssgdQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      BOMItem.BillOfMaterialItemQuantity,
      BOMItem.BillOfMaterialItemUnit,
      @Semantics.booleanIndicator: true
      BOMItem.IsAssembly,
      @Semantics.booleanIndicator: true
      BOMItem.IsSubItem,
      @Semantics.booleanIndicator: true
      BOMItem.IsDeleted,
      BOMItem.IdentifierBOMItem,
      BOMItem.BOMItemSorter,
      @Semantics.booleanIndicator: true
      BOMItem.BOMItemHasFixedQuantity,
      BOMItem.ComponentScrapInPercent,
      BOMItem.OperationScrapInPercent,
      @Semantics.booleanIndicator: true
      BOMItem.IsNetScrap,
      @Semantics.booleanIndicator: true
      BOMItem.IsBulkMaterial,
      @Semantics.booleanIndicator: true
      _MaterialPlant.IsBulkMaterialComponent,
      BOMItem.IsMaterialProvision                                          as MaterialProvisionType,
      BOMItem.BOMItemIsSparePart                                           as MatlComponentSparePartType,
      BOMItem.BOMItemIsSalesRelevant                                       as BOMItemSalesRelevancy,
      @Semantics.booleanIndicator: true
      BOMItem.IsEngineeringRelevant,
      @Semantics.booleanIndicator: true
      BOMItem.BOMItemIsPlantMaintRelevant,
      @Semantics.booleanIndicator: true
      BOMItem.IsProductionRelevant,
      BOMItem.BOMItemIsCostingRelevant                                     as MaterialCompCostingRelevancy,
      @Semantics.booleanIndicator: true
      BOMItem.BOMIsRecursive,
      @Semantics.booleanIndicator: true
      BOMItem.IsBOMRecursiveAllowed,
      BOMItem.FollowUpGroup,
      BOMItem.AlternativeItemGroup,
      BOMItem.MaterialIsCoProduct,
      BOMItem.AlternativeItemPriority,
      BOMItem.AlternativeItemStrategy,
      @Semantics.booleanIndicator: true
      BOMItem.IsALE,
      BOMItem.UsageProbabilityPercent,
      BOMItem.IsPMAssemblyRelevant,
      BOMItem.DocumentIsCreatedByCAD,
      BOMItem.DependencyObjectNumber,
      BOMItem.DiscontinuationGroup,
      BOMItem.LeadTimeOffset,
      BOMItem.OperationLeadTimeOffset,
      BOMItem.OpsLeadTimeOffsetUnit,
      BOMItem.DistrKeyCompConsumption,
      BOMItem.IsPhantomItem,
      BOMItem.PurchasingGroup,
      BOMItem.DeliveryDurationInDays,
      BOMItem.Creditor,
      @Semantics.amount.currencyCode : 'Currency'
      BOMItem.MaterialComponentPrice,
      //      BOMItem.MaterialPriceUnitQty,

      BOMItem.Currency,
      BOMItem.CostElement,
      BOMItem.MaterialGroup,
      BOMItem.GoodsReceiptDuration,
      BOMItem.PurchasingOrganization,
      BOMItem.PreliminaryMaterial,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      BOMItem.Size1,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      BOMItem.Size2,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureForSize1To3'
      BOMItem.Size3,
      BOMItem.UnitOfMeasureForSize1To3,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeCompUnitOfMeasure'
      BOMItem.QuantityVariableSizeItem,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeItemUnit'
      cast(BOMItem.NumberOfVariableSizeItem as pph_roanz preserving type)  as VariableSizeItemQuantity,
      BOMItem.UnitOfMeasureForVarSizeItem                                  as VariableSizeItemUnit,
      BOMItem.FormulaKey,
      BOMItem.VariableSizeCompUnitOfMeasure,
      BOMItem.BOMItemDescription,
      BOMItem.BOMItemText2,
      BOMItem.DocumentType,
      BOMItem.DocNumber,
      BOMItem.DocumentVersion,
      BOMItem.DocumentPart,
      BOMItem.ProdOrderIssueLocation,
      BOMItem.ProductionSupplyArea,
      BOMItem.ExplosionType,
      BOMItem.SpecialProcurementType,
      BOMItem.ReferencePoint,
      BOMItem.BillOfMaterialItemObjectType,
      OperationActivityComponent.AssemblySequenceNumber,
      BOMItem.BOMItemRecordCreationDate,
      BOMItem.BOMItemCreatedByUser,
      BOMItem.BOMItemLastChangeDate,
      BOMItem.BOMItemLastChangedByUser,
      OperationActivityComponent.CreatedByUser,
      OperationActivityComponent.CreationDateTime,
      OperationActivityComponent.ChangedBy,
      OperationActivityComponent.LastChangeDateTime,

      /* Associations */
      _BOMItemCategoryText,
      _DistrKeyText,
      _ExplosionTypeText,
      _SpecialProcTypeText,
      _AltItemStrategyText,
      _ReferencePointText,
      _CostingRelevantText,
      _MatProvisionIndText,
      _IssueLocationText,
      _ProdSupplyAreaText,
      _SparePartText,
      _SalesRelevantText,
      _PurchasingOrgText,
      _PurchasingGroupText,
      _MaterialGroupText,
      _SupplierText,
      _CostElementText,
      _MaterialText,
      _ProdnModOperationActivity,
      _ProductionModel,
      _OpActivityComponentInstance
}
where
  OperationActivityComponent.BillOfOperationsType = 'V'
// and(

//      OperationComponent.BillOfMaterialCategory       = 'K'

//   or OperationComponent.BillOfMaterialCategory       = 'M'

// )