P_EBPAO_TR_TOTALVARIANCE2

@AbapCatalog.sqlViewName: 'PEBPAOTRTOTVARC2'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_EBPAO_TR_TotalVariance2
  with parameters
    P_Ledger               : fins_ledger,
    P_FromFiscalYearPeriod : fins_fyearperiod,
    P_ToFiscalYearPeriod   : fins_fyearperiod,
    P_CurrencyRole         : fac_crcyrole
  as select from P_EBPAO_TR_TotalVariance1( P_Ledger               : :P_Ledger,
                                            P_FromFiscalYearPeriod : :P_FromFiscalYearPeriod,
                                            P_ToFiscalYearPeriod   : :P_ToFiscalYearPeriod ) as VarianceCost
    inner join   I_LedgerCompanyCodeCrcyRoles                                                as LedgerCompanyCodeCrcyRole on  LedgerCompanyCodeCrcyRole.CompanyCode = VarianceCost.CompanyCode
                                                                                                                          and LedgerCompanyCodeCrcyRole.Ledger      = :P_Ledger
{
  key VarianceCost.CompanyCode,
  key VarianceCost.OrderID,

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