P_EBPAO_WIPTrend2

@AbapCatalog: {
  sqlViewName: 'PEBPAOWIPTREND2',
  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_WIPTrend2
  with parameters
    P_Ledger             : fins_ledger,
    P_ToFiscalYearPeriod : fins_fyearperiod,
    P_CurrencyRole       : fis_curtp
  as select from P_EBPAO_WIPTrend1( P_Ledger              : :P_Ledger,
                                    P_ToFiscalYearPeriod  : :P_ToFiscalYearPeriod ) as WIPCost
    inner join   I_LedgerCompanyCodeCrcyRoles                                       as CurrencyRole on  CurrencyRole.CompanyCode = WIPCost.CompanyCode
                                                                                                    and CurrencyRole.Ledger      = :P_Ledger
{
  key WIPCost.CompanyCode,
  key WIPCost.OrderID,
  key WIPCost.OrderItem,
  key WIPCost.FiscalYearPeriod,

      cast(
        case :P_CurrencyRole
           when CurrencyRole.CompanyCodeCurrencyRole  then WIPCost.AmountInCompanyCodeCurrency
           when CurrencyRole.GlobalCurrencyRole       then WIPCost.AmountInGlobalCurrency
           when CurrencyRole.FreeDefinedCurrency1Role then WIPCost.AmountInFreeDefinedCurrency1
           when CurrencyRole.FreeDefinedCurrency2Role then WIPCost.AmountInFreeDefinedCurrency2
           when CurrencyRole.FreeDefinedCurrency3Role then WIPCost.AmountInFreeDefinedCurrency3
           when CurrencyRole.FreeDefinedCurrency4Role then WIPCost.AmountInFreeDefinedCurrency4
           when CurrencyRole.FreeDefinedCurrency5Role then WIPCost.AmountInFreeDefinedCurrency5
           when CurrencyRole.FreeDefinedCurrency6Role then WIPCost.AmountInFreeDefinedCurrency6
           when CurrencyRole.FreeDefinedCurrency7Role then WIPCost.AmountInFreeDefinedCurrency7
           when CurrencyRole.FreeDefinedCurrency8Role then WIPCost.AmountInFreeDefinedCurrency8
         else 0
      end as farp_amount_display_crcy) as AmountInDisplayCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES",
"P_EBPAO_WIPTREND1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/