P_EBPAO_WIPOVERVIEW1

@AbapCatalog: {
  sqlViewName: 'PEBPAOWIPOVW1',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
define view P_EBPAO_WIPOverview1
  with parameters
    P_Ledger             : fins_ledger,
    P_ToFiscalYearPeriod : fins_fyearperiod
  as select from I_JournalEntryItem
{
  key Ledger,
  key CompanyCode,
  key OrderID,
  key OrderItem,

      sum(AmountInCompanyCodeCurrency)  as AmountInCompanyCodeCurrency,
      sum(AmountInGlobalCurrency)       as AmountInGlobalCurrency,

      sum(AmountInFreeDefinedCurrency1) as AmountInFreeDefinedCurrency1,
      sum(AmountInFreeDefinedCurrency2) as AmountInFreeDefinedCurrency2,
      sum(AmountInFreeDefinedCurrency3) as AmountInFreeDefinedCurrency3,
      sum(AmountInFreeDefinedCurrency4) as AmountInFreeDefinedCurrency4,
      sum(AmountInFreeDefinedCurrency5) as AmountInFreeDefinedCurrency5,
      sum(AmountInFreeDefinedCurrency6) as AmountInFreeDefinedCurrency6,
      sum(AmountInFreeDefinedCurrency7) as AmountInFreeDefinedCurrency7,
      sum(AmountInFreeDefinedCurrency8) as AmountInFreeDefinedCurrency8
}
where
  (
       SubLedgerAcctLineItemType   = '09100'
    or SubLedgerAcctLineItemType   = '09110'
  )
  and  BusinessTransactionCategory = 'EBWP'
  and  FiscalYearPeriod            <= $parameters.P_ToFiscalYearPeriod
  and  Ledger                      = $parameters.P_Ledger
group by
  Ledger,
  CompanyCode,
  OrderID,
  OrderItem