FINS_GL_DOCUMENT_AMT_AWITEM

@AbapCatalog.sqlViewName: 'GLDOCAMAWITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Get Amounts from all ledgers via DOCLN'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #X


//Amounts per Currency Type of a G/L Document for valuated ledgers.

//This is a speparate view because the transaction currency can be different

//in valued ledgers compared to non valued ledgers. Those values are stored with currency type 00.

//The system allows such deviation in the transaction currency if the account has XSALH set in SKB1.

define view FINS_GL_DOCUMENT_AMT_AWITEM 
  as select from acdoca
    inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and  ledger.valutyp between '1' and '3' 
{
  key acdoca.rbukrs                       as bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key cast('00' as curtype)               as currencyType,
  key acdoca.awitem,
  key acdoca.racct                        as hkont,
      acdoca.tsl                          as amount,
      acdoca.rtcur                        as currency,
      acdoca.docln
}
union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtph <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtph as currencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.hsl           as amount,
      acdoca.rhcur         as currency,
      acdoca.docln
}

union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtpk <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and  ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtpk as currencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.ksl           as amount,
      acdoca.rkcur         as currency,
      acdoca.docln
}

union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtpo <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and  ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtpo as currencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.osl           as amount,
      acdoca.rocur         as currency,
      acdoca.docln
}

union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtpv <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and  ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtpv as currencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.vsl           as amount,
      acdoca.rvcur         as currency,
      acdoca.docln
}

union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtpb <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and  ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtpb as currencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.bsl           as amount,
      acdoca.rbcur         as currency,
      acdoca.docln
}

union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtpc <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtpc as currencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.csl           as amount,
      acdoca.rccur         as currency,
      acdoca.docln
}

union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtpd <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and  ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtpd as CurrencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.dsl           as amount,
      acdoca.rdcur         as currency,
      acdoca.docln
}

union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtpe <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and  ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtpe as currencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.esl           as amount,
      acdoca.recur         as currency,
      acdoca.docln
}

union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtpf <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and  ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtpf as currencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.fsl           as amount,
      acdoca.rfcur         as currency,
      acdoca.docln
}

union

select from  acdoca
  inner join finsc_ld_cmp as currency_type on  currency_type.bukrs  =  acdoca.rbukrs
                                           and currency_type.rldnr  =  acdoca.rldnr
                                           and currency_type.curtpg <> ''
  inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
                                    and  ledger.valutyp between '1' and '3' 
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.rldnr,
  key currency_type.curtpg as currencyType,
  key acdoca.awitem,
  key acdoca.racct         as hkont,
      acdoca.gsl           as amount,
      acdoca.rgcur         as currency,
      acdoca.docln
}
    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FINSC_LD_CMP",
"FINSC_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/