C_PURREQUISITIONNOTOUCH

@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality:  #D
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.sqlViewName: 'CMMPRNOTOUCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Purchase Requisition No Touch Rate'
@VDM.viewType : #CONSUMPTION
@Analytics.dataCategory: #CUBE
@Metadata.allowExtensions:true

define view C_PurRequisitionNoTouch

  with parameters
    P_DisplayCurrency        : displaycurrency,
    P_StartDate    : badat,
    P_EndDate      : badat
//    P_PriceForLowCostItem    : mm_a_low_cost_value,

//

//    P_PriceForMediumCostItem : mm_a_medium_cost_value,

//

//    P_PriceForHighCostItem   : mm_a_high_cost_value


  as select from    P_PurRequisitionNoTouch1(  P_DisplayCurrency: $parameters.P_DisplayCurrency,
                                               P_StartDate: $parameters.P_StartDate,
                                               P_EndDate: $parameters.P_EndDate) as Requisition

    left outer join I_PurchasingCategoryMatlGroup                                as PurchasingCategoryMatlGroup on Requisition.MaterialGroup = PurchasingCategoryMatlGroup.MaterialGroup

  association [1..1] to I_CalendarDate           as _RelevantDates          on $projection.CreationDate = _RelevantDates.CalendarDate
  
  association [1..1] to I_Material               as _Material               on $projection.Material = _Material.Material

  association [1..1] to I_MaterialGroup          as _MaterialGroup          on $projection.MaterialGroup = _MaterialGroup.MaterialGroup

  association [1..1] to I_Supplier               as _Supplier               on $projection.Supplier = _Supplier.Supplier

  association [1..1] to I_Plant                  as _Plant                  on $projection.Plant = _Plant.Plant

  association [1..1] to I_PurchasingOrganization as _PurchasingOrganization on $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization

  association [1..1] to I_PurchasingGroup        as _PurchasingGroup        on $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup

  association [1..1] to I_PurReqnItemClassfctn   as _PurReqnItemClassfctn   on _PurReqnItemClassfctn.PurReqnItemClassification = $projection.PurReqnItemClassification

  association [1..1] to I_PurReqnNoTouchType     as _PurReqnNoTouchType     on _PurReqnNoTouchType.PurReqnNoTouchType = $projection.PurReqnNoTouchType

{
  key PurchaseRequisition,
  key PurchaseRequisitionItem,

      @ObjectModel.foreignKey.association: '_Supplier'
  key Supplier,
      @EndUserText.label: 'Touch Type'
      @ObjectModel.foreignKey.association: '_PurReqnNoTouchType'
      PurReqnNoTouchType,

      @ObjectModel.foreignKey.association: '_PurchasingGroup'
      PurchasingGroup,

      @ObjectModel.foreignKey.association: '_PurchasingOrganization'
      @Consumption.valueHelpDefinition: [{ entity: { name : 'C_PurchasingOrgValueHelp', element : 'PurchasingOrganization' } }]
      PurchasingOrganization,

      @ObjectModel.foreignKey.association: '_MaterialGroup'
      Requisition.MaterialGroup,

      @ObjectModel.foreignKey.association: '_Material'
      Material,

      @ObjectModel.foreignKey.association: '_Plant'
      Requisition.Plant,

      @ObjectModel.text.element: ['PurgCatName']
      @Consumption.labelElement: 'PurgCatName'
      PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory                                 as PurchasingCategory,
      @Semantics.text: true
      PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName                                        as PurgCatName,

      CompanyCode,

      CostCenter,

      CreatedByUser,
      CreationDate,
      
      @Semantics.calendar.year: true
      _RelevantDates.CalendarYear,
      _RelevantDates.CalendarQuarter,
      _RelevantDates.CalendarMonth,
      _RelevantDates.CalendarWeek,

      @ObjectModel.foreignKey.association:'_PurReqnItemClassfctn'
      PurReqnItemClassification,
      
      //Added for displaying PR value in document view

      @Semantics.unitOfMeasure: true
      BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @EndUserText.label: 'Quantity Requested'
      @DefaultAggregation: null
      //@Analytics.hidden: true

      RequestedQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @EndUserText.label: 'Price Unit'
      @DefaultAggregation: null
      //@Analytics.hidden: true

      PurReqnPriceQuantity,  
      @Semantics.currencyCode: true
      PurReqnItemCurrency,
      @EndUserText.label: 'Valuation Price'
      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      @DefaultAggregation: #SUM
      //@Analytics.hidden: true

      PurchaseRequisitionPrice,

      @DefaultAggregation: #SUM
      @EndUserText.label: 'No Touch Count'
      cast( case when PurReqnNoTouchType = 'N' then 1 else 0 end as abap.int4 )                          as NmbrOfPurReqnWithNoTouch,

      @DefaultAggregation: #SUM
      @EndUserText.label: 'Low Touch Count'
      cast( case when PurReqnNoTouchType = 'L' then 1 else 0 end as abap.int4 )                          as NmbrOfPurReqnWithLow,

      @DefaultAggregation: #SUM
      @EndUserText.label: 'High Touch Count'
      cast( case when PurReqnNoTouchType = 'H' then 1 else 0 end as abap.int4 )                          as NmbrOfPurReqnWithHighTouch,

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'No Touch Count'

//      NmbrOfPurReqnWithNoTouch,

//

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'Low Touch Count'

//      NmbrOfPurReqnWithLow,

//

//      @DefaultAggregation: #SUM

//      @EndUserText.label: 'High Touch Count'

//      NmbrOfPurReqnWithHighTouch,


      @DefaultAggregation: #SUM
      cast( 1 as abap.int4 )                                                                             as PurchaseRequisitionItemCount,
      
//      //High Touch

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice  <=  $parameters.P_PriceForLowCostItem

//                      then NmbrOfPurReqnWithHighTouch

//      //                      else I_CalendarYear.NumberOfDays      //3053587

//               end as abap.int4 )                                        as HighTouchLowCostItemsValue,

//

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice >$parameters.P_PriceForLowCostItem  and PurchaseRequisitionPrice <= $parameters.P_PriceForMediumCostItem

//                       then NmbrOfPurReqnWithHighTouch

//      //                       else I_CalendarYear.NumberOfDays     //3053587

//                end as abap.int4 )                                       as HighTouchMediumCostItemsValue,

//

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForMediumCostItem and PurchaseRequisitionPrice <= $parameters.P_PriceForHighCostItem

//                      then NmbrOfPurReqnWithHighTouch

//      //                      else I_CalendarYear.NumberOfDays      //3053587

//               end as abap.int4 )                                        as HighTouchHighCostItemsValue,

//

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForHighCostItem

//                      then NmbrOfPurReqnWithHighTouch

//      //                      else I_CalendarYear.NumberOfDays      //3053587

//               end as abap.int4 )                                        as HighTouchVeryHighCostItmsVal,

//

//      // No Touch

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice  <=  $parameters.P_PriceForLowCostItem

//                      then NmbrOfPurReqnWithNoTouch

//      //                      else I_CalendarYear.NumberOfDays      //3053587

//               end as abap.int4 )                                        as NoTouchLowCostItemValue,

//

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice >$parameters.P_PriceForLowCostItem  and PurchaseRequisitionPrice <= $parameters.P_PriceForMediumCostItem

//                       then NmbrOfPurReqnWithNoTouch

//      //                       else I_CalendarYear.NumberOfDays     //3053587

//                end as abap.int4 )                                       as NoTouchMediumCostItemValue,

//

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForMediumCostItem and PurchaseRequisitionPrice <= $parameters.P_PriceForHighCostItem

//                      then NmbrOfPurReqnWithNoTouch

//      //                      else I_CalendarYear.NumberOfDays      //3053587

//               end as abap.int4 )                                        as NoTouchHighCostItemValue,

//

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForHighCostItem

//                      then NmbrOfPurReqnWithNoTouch

//      //                      else I_CalendarYear.NumberOfDays      //3053587

//               end as abap.int4 )                                        as NoTouchVeryHighCostItemValue,

//               

//      //Low Touch

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice  <=  $parameters.P_PriceForLowCostItem

//                      then NmbrOfPurReqnWithLow

//      //                      else I_CalendarYear.NumberOfDays      //3053587

//               end as abap.int4 )                                        as LowTouchLowCostItemValue,

//

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice >$parameters.P_PriceForLowCostItem  and PurchaseRequisitionPrice <= $parameters.P_PriceForMediumCostItem

//                       then NmbrOfPurReqnWithLow

//      //                       else I_CalendarYear.NumberOfDays     //3053587

//                end as abap.int4 )                                       as LowTouchMediumCostItemValue,

//

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForMediumCostItem and PurchaseRequisitionPrice <= $parameters.P_PriceForHighCostItem

//                      then NmbrOfPurReqnWithLow

//      //                      else I_CalendarYear.NumberOfDays      //3053587

//               end as abap.int4 )                                        as LowTouchHighCostItemValue,

//

//      @DefaultAggregation: #SUM

//      cast(case when PurchaseRequisitionPrice > $parameters.P_PriceForHighCostItem

//                      then NmbrOfPurReqnWithLow

//      //                      else I_CalendarYear.NumberOfDays      //3053587

//               end as abap.int4 )                                        as LowTouchVeryHighCostItemValue,

               

      _Material,
      _MaterialGroup,
      _Plant,
      _Supplier,
      _PurchasingGroup,
      _PurchasingOrganization,
      _PurReqnItemClassfctn,
      _PurReqnNoTouchType

}