I_ProdnModOperationComponent

@EndUserText.label: 'Production Model Operation Component'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
define view entity I_ProdnModOperationComponent
  as select from I_RoutingCompAllocSrchMod  as OperationComponent
    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
    inner join   P_ProdnModBOOOperation     as BOOOpBasic on  BOOOpBasic.BillOfOperationsType    = OperationComponent.BillOfOperationsType
                                                          and BOOOpBasic.BillOfOperationsGroup   = OperationComponent.BillOfOperationsGroup
                                                          and BOOOpBasic.BOOOperationInternalID  = OperationComponent.BOOOperationInternalID
    //                                                          and BOOOpBasic.BOOOpInternalVersionCounter = OperationComponent.BOOOpBOMItemIntVersCounter

                                                          and BOOOpBasic.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        to I_ProductionModelOperation as _Operation           on  $projection.ProductionModelUUID        = _Operation.ProductionModelUUID
                                                                           and $projection.BillOfOperationsVersion    = _Operation.BillOfOperationsVersion
                                                                           and $projection.BillOfMaterial             = _Operation.BillOfMaterial
                                                                           and $projection.BillOfMaterialVariant      = _Operation.BillOfMaterialVariant
                                                                           and $projection.BillOfMaterialCategory     = _Operation.BillOfMaterialCategory
                                                                           and $projection.BillOfMaterialVariantUsage = _Operation.BillOfMaterialVariantUsage
                                                                           and $projection.Plant                      = _Operation.Plant
                                                                           and $projection.BillOfOperationsGroup      = _Operation.BillOfOperationsGroup
                                                                           and $projection.BillOfOperationsType       = _Operation.BillOfOperationsType
                                                                           and $projection.BillOfOperationsVariant    = _Operation.BillOfOperationsVariant
                                                                           and $projection.BOOOperationInternalID     = _Operation.BOOOperationInternalID
  association        to I_ProductionModel          as _ProductionModel     on  $projection.ProductionModelUUID     = _ProductionModel.ProductionModelUUID
                                                                           and $projection.BillOfOperationsVersion = _ProductionModel.BillOfOperationsVersion
{
  key          BOMItem.ProductionModelUUID,
  key          BOOOpBasic.BillOfOperationsVersion,
  key          OperationComponent.BOOOperationInternalID,
  key          OperationComponent.BOOOpBOMItemInternalID,
               BOOOpBasic.BOOOpInternalVersionCounter,
               cast( BOMItem.BillOfMaterial as cs_stlnr )                           as BillOfMaterial,
               BOMItem.BillOfMaterialVariant,
               BOMItem.BillOfMaterialCategory,
               BOMItem.BillOfMaterialVariantUsage,
               BOMItem.Plant,
               BOMItem.BillOfOperationsGroup,
               BOMItem.BillOfOperationsType,
               BOMItem.BillOfOperationsVariant,
               BOMItem.Material,
               BOMItem.BillOfMaterialVersion,
               BOOOpBasic.Operation_2                                               as Operation,
               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,
               BOMItem.BillOfMaterialItemUnit,
               @Semantics.quantity.unitOfMeasure: 'ProdnModBOMCompAssgdQtyUnit'
               OperationComponent.BillOfMaterialItemQuantity                        as ProdnModBOMCompAssgdQuantity,
               OperationComponent.BillOfMaterialItemUnit                            as ProdnModBOMCompAssgdQtyUnit,
               @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
               BOMItem.BillOfMaterialItemQuantity,
               @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.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,
               @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.PreliminaryMaterial,
               BOMItem.IsPMAssemblyRelevant,
               BOMItem.BillOfMaterialItemObjectType,
               BOMItem.BOMItemRecordCreationDate,
               BOMItem.BOMItemCreatedByUser,
               BOMItem.BOMItemLastChangeDate,
               BOMItem.BOMItemLastChangedByUser,
               OperationComponent.CreatedByUser,
               OperationComponent.CreationDate,
               OperationComponent.LastChangeDate,
               OperationComponent.LastChangedByUser,

               /* Associations */
               _BOMItemCategoryText,
               _DistrKeyText,
               _ExplosionTypeText,
               _SpecialProcTypeText,
               _AltItemStrategyText,
               _ReferencePointText,
               _CostingRelevantText,
               _MatProvisionIndText,
               _IssueLocationText,
               _ProdSupplyAreaText,
               _SparePartText,
               _SalesRelevantText,
               _PurchasingOrgText,
               _PurchasingGroupText,
               _MaterialGroupText,
               _SupplierText,
               _CostElementText,
               _MaterialText,

               /* Associations */
               _Operation,
               _ProductionModel
}
where
  OperationComponent.BillOfOperationsType = 'V'
// and(

//      OperationComponent.BillOfMaterialCategory = 'K'

//   or OperationComponent.BillOfMaterialCategory = 'M'

// )