C_RecommendedProductionVersion

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Recommended Prodn Vers'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
@ObjectModel.usageType:{ serviceQuality: #C, sizeCategory: #S, dataClass: #MIXED }
@Search.searchable: true
@Metadata.allowExtensions: true
@Consumption.dbHints:['USE_HEX_PLAN']

define root view entity C_RecommendedProductionVersion
  provider contract transactional_query
  as projection on R_RecmddProductionVersionTP
{

          @Search:{ defaultSearchElement: true, fuzzinessThreshold: 0.9, ranking: #HIGH }
          //      @UI.fieldGroup:[{qualifier:'MaterialFieldGroup', position:10 }]

          @Consumption.semanticObject: 'Material'
          @ObjectModel.text.element: ['MaterialName']
          @UI.textArrangement: #TEXT_LAST
  key     Material,
  key     Plant,
  key     RecommendedProductionVersion,
          ProductionVersion,
          ProductionVersionText,
          BillOfOperationsType,
          BillOfOperationsGroup,
          BillOfOperationsVariant,
          BillOfMaterialVariantUsage,
          BillOfMaterialVariant,
          ProductionLine,
          ProductionSupplyArea,
          ProductionVersionGroup,
          MainProduct,
          MaterialCostApportionmentStruc,
          IssuingStorageLocation,
          ReceivingStorageLocation,
          OriginalBatchReferenceMaterial,
          QuantityDistributionKey,
          ProductionVersionStatus,
          ProductionVersionLastCheckDate,
          RateBasedPlanningStatus,
          PreliminaryPlanningStatus,
          BOMCheckStatus,
          ValidityStartDate,
          ValidityEndDate,
          @ObjectModel:{text.element:  [ 'ProductionVersionLockText' ]  }
          @ObjectModel.foreignKey.association: '_ProdnVersLockVH'
          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,
          CreationDate,
          CreatedByUser,
          LastChangeDate,
          LastChangedByUser,
          ProdnVersLastChangeDateTime,
          RecmddProductionVersionStatus,
          ProducerEventType,
          ProducerBusinessObjectType,
          //      ProdnVersProposalReason,

          _Plant.PlantName,
          @Search.defaultSearchElement: true
          //      @UI.lineItem: [{ label: 'Material', position: 10, type: #AS_FIELDGROUP, valueQualifier: 'MaterialFieldGroup'}]

          //      @UI.fieldGroup:[{qualifier:'MaterialFieldGroup', position:20, emphasized: true}]

          _MaterialText.MaterialName as MaterialName,
          _ProdnVersLockText.ProductionVersionLockText,
          @EndUserText.label: 'Bill Of Material'
          @EndUserText.quickInfo: 'Bill Of Material'
          _MaterialBOM.BillOfMaterial,
          @EndUserText.quickInfo: 'BOM Category'
          @EndUserText.label: 'BOM Category'
          _MaterialBOM.BillOfMaterialCategory,

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

}
//So only 180 days data will show for rejected proposal list

where
  (
        ProdnVersProposalAgeInDays    <= 180
    and RecmddProductionVersionStatus =  '2'
  )
  or    RecmddProductionVersionStatus <> '2'