P_ProcessedImpairmentLineItem

@AbapCatalog.sqlViewName: 'PPRCIMPLI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel: { usageType.serviceQuality: #D,
                 usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
define view P_ProcessedImpairmentLineItem
  with parameters
    P_Ledger              : fis_rldnr,
    P_CompanyCode         : fis_bukrs,
    P_CurrencyRole        : fis_curtp,
    P_LossAllowanceLayout : fins_key_figure_layout,
    P_FiscalYear          : gjahr,
    P_FiscalPeriod        : poper
  as select from P_GLACCImpairmentLineItem ( P_Ledger: $parameters.P_Ledger, P_CompanyCode: $parameters.P_CompanyCode, P_LossAllowanceLayout: :P_LossAllowanceLayout, P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod) as LineItems
    inner join   I_LedgerCompanyCodeCrcyRoles                                                                                                                                                                                       as CurrencyRoles on  LineItems.Ledger      = CurrencyRoles.Ledger
                                                                                                                                                                                                                                                     and LineItems.CompanyCode = CurrencyRoles.CompanyCode
{
  LineItems.Ledger,
  LineItems.CompanyCode,
  FiscalYear,
  FiscalPeriod,
  Country,
  CreditRiskClass,
  GeneralLedgerAgingIncrement,
  CompanyCodeCurrencyRole,
  GlobalCurrencyRole,
  FreeDefinedCurrency1Role,
  FreeDefinedCurrency2Role,
  FreeDefinedCurrency3Role,
  FreeDefinedCurrency4Role,
  FreeDefinedCurrency5Role,
  FreeDefinedCurrency6Role,
  FreeDefinedCurrency7Role,
  FreeDefinedCurrency8Role,
  GLAccount,
  BusinessPartner,
  Customer,
  LossAllowanceSortSequenceValue,
  LossAllowanceKeyFigure,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  SubLedgerAcctLineItemType,
  @Semantics.currencyCode:true
  case when CompanyCodeCurrencyRole = :P_CurrencyRole then CompanyCodeCurrency
       when GlobalCurrencyRole = :P_CurrencyRole then GlobalCurrency
       when FreeDefinedCurrency1Role = :P_CurrencyRole then FreeDefinedCurrency1
       when FreeDefinedCurrency2Role = :P_CurrencyRole then FreeDefinedCurrency2
       when FreeDefinedCurrency3Role = :P_CurrencyRole then FreeDefinedCurrency3
       when FreeDefinedCurrency4Role = :P_CurrencyRole then FreeDefinedCurrency4
       when FreeDefinedCurrency5Role = :P_CurrencyRole then FreeDefinedCurrency5
       when FreeDefinedCurrency6Role = :P_CurrencyRole then FreeDefinedCurrency6
       when FreeDefinedCurrency7Role = :P_CurrencyRole then FreeDefinedCurrency7
       when FreeDefinedCurrency8Role = :P_CurrencyRole then FreeDefinedCurrency8
    else cast('' as vdm_v_display_currency)
  end                                                                                                                                  as      DisplayCurrency,
  @DefaultAggregation:#SUM
  @Semantics.amount.currencyCode: 'DisplayCurrency'
  case when CompanyCodeCurrencyRole = :P_CurrencyRole then cast(AmountInCompanyCodeCurrency as farp_amount_display_crcy preserving type)
       when GlobalCurrencyRole = :P_CurrencyRole then cast(AmountInGlobalCurrency as farp_amount_display_crcy preserving type)
       when FreeDefinedCurrency1Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency1 as farp_amount_display_crcy preserving type)
       when FreeDefinedCurrency2Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency2 as farp_amount_display_crcy preserving type)
       when FreeDefinedCurrency3Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency3 as farp_amount_display_crcy preserving type)
       when FreeDefinedCurrency4Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency4 as farp_amount_display_crcy preserving type)
       when FreeDefinedCurrency5Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency5 as farp_amount_display_crcy preserving type)
       when FreeDefinedCurrency6Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency6 as farp_amount_display_crcy preserving type)
       when FreeDefinedCurrency7Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency7 as farp_amount_display_crcy preserving type)
       when FreeDefinedCurrency8Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency8 as farp_amount_display_crcy preserving type)
    else cast('0' as farp_amount_display_crcy)
  end                                                                                                                                  as      AmountInDisplayCurrency
}
union all select distinct from I_LossAllowanceKeyFigureLayout
{
  key $parameters.P_Ledger                                                                                                                                                                                    as      Ledger,
  key $parameters.P_CompanyCode                                                                                                                                                                               as      CompanyCode,
  key $parameters.P_FiscalYear                                                                                                                                                                                as      FiscalYear,
  key $parameters.P_FiscalPeriod                                                                                                                                                                              as      FiscalPeriod,

      cast ('   ' as land1_gp preserving type )                                                                                                                                                               as      Country,
      cast ('   ' as ukm_risk_class preserving type )                                                                                                                                                         as      CreditRiskClass,
      cast ('               ' as fins_incrmnt preserving type )                                                                                                                                               as      GeneralLedgerAgingIncrement,
      cast ('' as fins_curtype_h )                                                                                                                                                                            as      CompanyCodeCurrencyRole,
      cast ('' as fins_curtype_k )                                                                                                                                                                            as      GlobalCurrencyRole,
      cast ('' as fins_curtype_o )                                                                                                                                                                            as      FreeDefinedCurrency1Role,
      cast ('' as fins_curtype_v)                                                                                                                                                                             as      FreeDefinedCurrency2Role,
      cast ('' as fins_curtype_b )                                                                                                                                                                            as      FreeDefinedCurrency3Role,
      cast ('' as fins_curtype_c )                                                                                                                                                                            as      FreeDefinedCurrency4Role,
      cast ('' as fins_curtype_d )                                                                                                                                                                            as      FreeDefinedCurrency5Role,
      cast ('' as fins_curtype_e )                                                                                                                                                                            as      FreeDefinedCurrency6Role,
      cast ('' as fins_curtype_f )                                                                                                                                                                            as      FreeDefinedCurrency7Role,
      cast ('' as fins_curtype_g )                                                                                                                                                                            as      FreeDefinedCurrency8Role,
      cast ('          ' as racct preserving type)                                                                                                                                                            as      GLAccount,
      cast ('          ' as bu_partner preserving type)                                                                                                                                                       as      BusinessPartner,
      cast ('          ' as kunnr preserving type)
                                                                                                                                                                                                              as      Customer,
      LossAllowanceSortSequenceValue,

      LossAllowanceKeyFigure,
      cast ('          ' as kostl preserving type )                                                                                                                                                           as      CostCenter,
      cast ('          ' as prctr preserving type )                                                                                                                                                           as      ProfitCenter,
      cast ('                ' as fkber preserving type )                                                                                                                                                     as      FunctionalArea,
      cast ('    ' as gsber preserving type )                                                                                                                                                                 as      BusinessArea,
      cast ('    ' as kokrs preserving type )                                                                                                                                                                 as      ControllingArea,
      cast ('          ' as fb_segment preserving type )                                                                                                                                                      as      Segment,
      cast ('          ' as kostl preserving type )                                                                                                                                                           as      PartnerCostCenter,
      cast ('          ' as prctr preserving type )                                                                                                                                                           as      PartnerProfitCenter,
      cast ('                ' as fkber preserving type )                                                                                                                                                     as      PartnerFunctionalArea,
      cast ('    ' as gsber preserving type )                                                                                                                                                                 as      PartnerBusinessArea,
      cast ('    ' as bukrs preserving type )                                                                                                                                                                 as      PartnerCompany,
      cast ('          ' as fb_segment preserving type )                                                                                                                                                      as      PartnerSegment,
      SubLedgerAcctLineItemType,
      cast('     ' as vdm_v_display_currency)                                                                                                                                                                 as      DisplayCurrency,
      cast(0 as farp_amount_display_crcy)                                                                                                                                                                     as      AmountInDisplayCurrency
}
where
  LossAllowanceLayout = $parameters.P_LossAllowanceLayout
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES",
"I_LOSSALLOWANCEKEYFIGURELAYOUT",
"P_GLACCIMPAIRMENTLINEITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/