I_ProductionModelComponent

@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 P_ProductionModelComponent as BOMItem
  //  left outer to one join P_ProdnModCompDgtlMockUpCharcs as DgtlMockUpCharcsValue on  DgtlMockUpCharcsValue.DgtlMockUpUUID        = BOMItem.ProductionModelComponentUUID

  //                                                                                 and DgtlMockUpCharcsValue.DgtlMockUpInstceCount < '0002'

  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..1] to I_ProductionModel             as _ProductionModel         on  $projection.ProductionModelUUID     = _ProductionModel.ProductionModelUUID
                                                                                  and $projection.BillOfOperationsVersion = _ProductionModel.BillOfOperationsVersion
  association [0..*] to I_ProdnModelComponentInstance as _HeaderComponentInstance on  $projection.ProductionModelUUID          = _HeaderComponentInstance.ProductionModelUUID
                                                                                  and $projection.ProductionModelComponentUUID = _HeaderComponentInstance.ProductionModelComponentUUID
                                                                                  and $projection.BillOfOperationsVersion      = _HeaderComponentInstance.BillOfOperationsVersion

{
  key    BOMItem.ProductionModelUUID,
  key    BOMItem.BillOfOperationsVersion,
  key    BOMItem.ProductionModelComponentUUID,
         BOMItem.BillOfMaterialCategory,
         cast( BOMItem.BillOfMaterial as cs_stlnr preserving type )           as BillOfMaterial,
         BOMItem.Material,
         BOMItem.Plant,
         BOMItem.BillOfMaterialVariantUsage,
         BOMItem.BillOfMaterialVariant,
         BOMItem.BillOfMaterialVersion,
         BOMItem.BillOfOperationsGroup,
         BOMItem.BillOfOperationsType,
         BOMItem.BillOfOperationsVariant,
         BOMItem.BillOfMaterialItemNodeNumber,
         BOMItem.ValidityStartDate,
         BOMItem.ValidityEndDate,
         BOMItem.EngineeringChangeDocument,
         BOMItem.ChgToEngineeringChgDocument,
         BOMItem.InheritedNodeNumberForBOMItem,
         BOMItem.InheritedNodeNumberVersionBOM,
         BOMItem.BOMItemInternalChangeCount,
         BOMItem.BillOfMaterialComponent,
         //    _MaterialText.MaterialName,

         BOMItem.ComponentDescription,
         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.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,

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

//  (

//       BOMItem.BillOfMaterialCategory = 'K'

//    or BOMItem.BillOfMaterialCategory = 'M'

//  )