C_LinkedExistingProdnVers

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Linked Existing Production Version'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
} 
define view entity C_LinkedExistingProdnVers
  as select from R_ProductionVersionTP

  association [1..1] to C_LinkedProdnVersBOO as _RoutingStatusText on  $projection.Material                 = _RoutingStatusText.Material
                                                                   and $projection.Plant                    = _RoutingStatusText.Plant
                                                                   and $projection.BillOfOperationsType     = _RoutingStatusText.BillOfOperationsType
                                                                   and $projection.BillOfOperationsGroup    = _RoutingStatusText.BillOfOperationsGroup
                                                                   and $projection.BillOfOperationsVariant  = _RoutingStatusText.BillOfOperationsVariant
                                                                   and _RoutingStatusText.ValidityStartDate <= $session.system_date
                                                                   and _RoutingStatusText.ValidityEndDate   >= $session.system_date

  association [1..1] to C_LinkedProdnVersBOM as _BillOfMaterial    on  $projection.Material              = _BillOfMaterial.Material
                                                                   and $projection.Plant                 = _BillOfMaterial.Plant
                                                                   and $projection.BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant
                                                                   and _BillOfMaterial.ValidityStartDate <= $session.system_date
                                                                   and _BillOfMaterial.ValidityEndDate   >= $session.system_date


{
  key Material,
  key Plant,
  key ProductionVersion,
      ProductionVersionText,
      ChangeHistoryCount,
      ChangeNumber,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      BillOfOperationsType,
      BillOfOperationsGroup,
      BillOfOperationsVariant,
      BillOfMaterialVariantUsage,
      BillOfMaterialVariant,
      ProductionLine,
      ProductionSupplyArea,
      ProductionVersionGroup,
      MainProduct,
      MaterialCostApportionmentStruc,
      IssuingStorageLocation,
      ReceivingStorageLocation,
      OriginalBatchReferenceMaterial,
      QuantityDistributionKey,
      ProductionVersionStatus,
      ProductionVersionLastCheckDate,
      RateBasedPlanningStatus,
      PreliminaryPlanningStatus,
      BOMCheckStatus,
      ValidityStartDate,
      ValidityEndDate,
      ProductionVersionLock,
      ProdnVersIsAllowedForRptvMfg,
      HasVersionCtrldBOMAndRouting,
      PlanningAndExecutionBOMIsDiff,
      ExecBillOfMaterialVariantUsage,
      ExecBillOfMaterialVariant,
      ExecBillOfOperationsType,
      ExecBillOfOperationsGroup,
      ExecBillOfOperationsVariant,
      EWMWarehouse,
      DestinationStorageBin,
      ProcurementType,
      MaterialProcurementProfile,
      UsgeProbltyWthVersCtrlInPct,
      MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      MaterialMinLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      MaterialMaxLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      CostingLotSize,
      TargetProductionSupplyArea,
      MRPController,
      MaterialName,
      PlantName,
      MRPResponsible,
      @EndUserText.label: 'Routing CheckStatus Text'
      RoutingCheckStatusText,
      ProductionVersionLockText,
      BillOfOperationsTypeName,
      OvrlProdnVersChkSts,
      _RoutingStatusText.BillOfOperationsDesc as BillOfOperationsDesc,
      _BillOfMaterial.BOMHeaderText           as BOMHeaderText,

      /* Associations */
      _BillOfOperations,
      _BillOfOperationsGroup,
      _BillOfOperationsType,
      _BillOfOperationsTypeText,
      _ChangeMaster,
      _IssuingStorageLocation,
      _MainProduct,
      _Material,
      _MaterialBaseUnit,
      _MaterialText,
      _MatlCostApportionmentStruc,
      _MatlProcurementProfile,
      _OriglBatchReferenceMaterial,
      _Plant,
      _ProdnVersLockText,
      _ProdnVersLockVH,
      _Product,
      _ProductionLine,
      _ProductionSupplyArea,
      _ProductionVersionGroup,
      _ProductPlant,
      _QuantityDistributionKey,
      _ReceivingStorageLocation,
      _RoutingStatusText,
      _TargetProductionSupplyArea
}