C_ContractConsumption

@AbapCatalog.sqlViewName: 'CMMCONTRCNSMPN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality:  #D
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Contract Consumption'

define view C_ContractConsumption

  with parameters
    P_PurchaseContract : ebeln

  as select from I_PurchaseContractHistory   as PurchaseContractHistory
    inner join   I_PurchaseContract          as PurchaseContract       on PurchaseContract.ActivePurchasingDocument = PurchaseContractHistory.PurchaseContract

    inner join   I_PurContractClassification as ContractClassification on PurchaseContract.PurchaseContractType = ContractClassification.PurchasingDocumentType

    inner join   I_PurchaseContractItem      as PurchaseContractItem   on  PurchaseContractItem.PurchaseContract     = PurchaseContractHistory.PurchaseContract
                                                                       and PurchaseContractItem.PurchaseContractItem = PurchaseContractHistory.PurchaseContractItem

    inner join   I_CalendarDate              as CalendarDate           on CalendarDate.CalendarDate = PurchaseContractHistory.ReleaseOrderDate
    
{
  key PurchaseContractHistory.PurchaseContract,
  key PurchaseContractHistory.PurchaseContractItem,
  key ReleaseOrder,
  key ReleaseOrderItem,

      ContractClassification.PurchaseContractClassification,

      PurchaseContract.DocumentCurrency,
      OrderQuantityUnit,
      ReleaseOrderDate,
      
      // Added for Release Order History Facet

      CalendarDate.CalendarMonth,
      CalendarDate.CalendarQuarter,
      CalendarDate.CalendarWeek,
      CalendarDate.CalendarYear,
      //

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      PurchaseContract.PurchaseContractTargetAmount,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      TargetQuantity,
      
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      cast( unit_conversion
            (  quantity    => ReleaseOrderItemOrderQuantity,
               source_unit => ReleaseOrderItemQuantityUnit,
               target_unit => PurchaseContractItem.OrderQuantityUnit,
               error_handling => 'KEEP_UNCONVERTED'
             ) as abap.quan( 13, 0 )  )   as ReleaseOrderItemOrderQuantity,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      cast( currency_conversion
            ( amount          => ReleaseOrderItemNetAmount,
              source_currency => ReleaseOrderCurrency,
              target_currency => PurchaseContract.DocumentCurrency,
              exchange_rate_date => ReleaseOrderDate )
      as bwert )                          as ReleaseOrderItemNetAmount,

      @DefaultAggregation: #SUM
      cast( 1 as mm_number_release_order) as NumberOfReleasedOrders,

      //Added for DCL

      PurchaseContractHistory.Plant,
      PurchaseContractHistory.PurchasingOrganization,
      PurchaseContractHistory.CompanyCode,
      PurchaseContract.PurchasingGroup

}
where
  PurchaseContractHistory.PurchaseContract = $parameters.P_PurchaseContract
and ReleaseOrderItemIsDeleted = ''                        //3020959