FAA_SDM_DOCIT_CP04

@AbapCatalog.sqlViewName: 'FAAVDOCITCP04'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'KFC ACDOCA aggregation'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL


define view FAA_SDM_DOCIT_CP04
  as select from    acdoca        as acdoca
    inner join      fins_tech_ledger  as ledger_a on  acdoca.rldnr         =  ledger_a.tech_ledger
                                              and ledger_a.tech_ledger <> ''
                                              and acdoca.awtyp         <> 'AMDP'
                                              and acdoca.mig_source    =  'A'
    left outer join faac_kfc_spec as kfc_spec on  kfc_spec.movcat     = acdoca.movcat
                                              and kfc_spec.slalittype = acdoca.slalittype
{
  key acdoca.rbukrs                                       as bukrs,
  key acdoca.gjahr,
  key acdoca.anlkl,
  key case
        when kfc_spec.key_figure_code is null then 'NULL'
        else kfc_spec.key_figure_code
      end                                                 as key_figure_code,
  key cast('10' as fis_selected_currency_branch)          as SelectedCurrencyBranch,
      @Semantics.currencyCode: true
  key cast(acdoca.rhcur as vdm_v_display_currency)        as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast(sum( acdoca.hsl ) as farp_amount_display_crcy) as AmountInDisplayCurrency
}
group by
  acdoca.rbukrs,
  acdoca.gjahr,
  acdoca.anlkl,
  kfc_spec.key_figure_code,
  acdoca.rhcur

union select from acdoca        as acdoca
  inner join      fins_tech_ledger  as ledger_a on  acdoca.rldnr         =  ledger_a.tech_ledger
                                            and ledger_a.tech_ledger <> ''
                                            and acdoca.awtyp         <> 'AMDP'
                                            and acdoca.mig_source    =  'A'
  left outer join faac_kfc_spec as kfc_spec on  kfc_spec.movcat     = acdoca.movcat
                                            and kfc_spec.slalittype = acdoca.slalittype
{
  key acdoca.rbukrs                                         as bukrs,
  key acdoca.gjahr,
  key acdoca.anlkl,
  key case
        when kfc_spec.key_figure_code is null then 'NULL'
        else kfc_spec.key_figure_code
      end                                                   as key_figure_code,
  key cast( '30' as fis_selected_currency_branch )          as SelectedCurrencyBranch,
      @Semantics.currencyCode: true
  key cast( acdoca.rkcur as vdm_v_display_currency )        as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast( sum( acdoca.ksl ) as farp_amount_display_crcy ) as AmountInDisplayCurrency
}
group by
  acdoca.rbukrs,
  acdoca.gjahr,
  acdoca.anlkl,
  kfc_spec.key_figure_code,
  acdoca.rkcur

union select from acdoca        as acdoca
  inner join      fins_tech_ledger  as ledger_a on  acdoca.rldnr         =  ledger_a.tech_ledger
                                            and ledger_a.tech_ledger <> ''
                                            and acdoca.awtyp         <> 'AMDP'
                                            and acdoca.mig_source    =  'A'
  left outer join faac_kfc_spec as kfc_spec on  kfc_spec.movcat     = acdoca.movcat
                                            and kfc_spec.slalittype = acdoca.slalittype
{
  key acdoca.rbukrs                                         as bukrs,
  key acdoca.gjahr,
  key acdoca.anlkl,
  key case
        when kfc_spec.key_figure_code is null then 'NULL'
        else kfc_spec.key_figure_code
      end                                                   as key_figure_code,
  key cast( 'F1' as fis_selected_currency_branch )          as SelectedCurrencyBranch,
      @Semantics.currencyCode: true
  key cast( acdoca.rocur as vdm_v_display_currency )        as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast( sum( acdoca.osl ) as farp_amount_display_crcy ) as AmountInDisplayCurrency
}
group by
  acdoca.rbukrs,
  acdoca.gjahr,
  acdoca.anlkl,
  kfc_spec.key_figure_code,
  acdoca.rocur

union select from acdoca        as acdoca
  inner join      fins_tech_ledger  as ledger_a on  acdoca.rldnr         =  ledger_a.tech_ledger
                                            and ledger_a.tech_ledger <> ''
                                            and acdoca.awtyp         <> 'AMDP'
                                            and acdoca.mig_source    =  'A'
  left outer join faac_kfc_spec as kfc_spec on  kfc_spec.movcat     = acdoca.movcat
                                            and kfc_spec.slalittype = acdoca.slalittype
{
  key acdoca.rbukrs                                         as bukrs,
  key acdoca.gjahr,
  key acdoca.anlkl,
  key case
        when kfc_spec.key_figure_code is null then 'NULL'
        else kfc_spec.key_figure_code
      end                                                   as key_figure_code,
  key cast( 'F2' as fis_selected_currency_branch )          as SelectedCurrencyBranch,
      @Semantics.currencyCode: true
  key cast( acdoca.rvcur as vdm_v_display_currency )        as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast( sum( acdoca.vsl ) as farp_amount_display_crcy ) as AmountInDisplayCurrency
}
group by
  acdoca.rbukrs,
  acdoca.gjahr,
  acdoca.anlkl,
  kfc_spec.key_figure_code,
  acdoca.rvcur
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FAAC_KFC_SPEC",
"FINS_TECH_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/