FINS_GL_DOCUMENT_AMT_DOCLN

@AbapCatalog.sqlViewName: 'FINSGLDOCAMTLN'
@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'

//This view assumes the the amount of a certain currency type is equal in all ledgers.

//The transaction currency (wsl) is retrieved from one specific ledger. Postings with

//unique currency types allow the caller of the accounting interface to change the transaction

//amount for a non leading ledger. 

define view FINS_GL_DOCUMENT_AMT_DOCLN with parameters ledger : rldnr
  as select from acdoca
{
  key rbukrs                       as bukrs,
  key gjahr,
  key belnr,
  key docln,
  key cast( '00' as fins_curtype ) as currencyType,
      awitem,
      racct                        as hkont,
      wsl                          as amount,
      rwcur                        as currency
}
 where rldnr = :ledger

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtph as currencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.hsl           as amount,
      acdoca.rhcur         as currency
}

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtpk as currencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.ksl           as amount,
      acdoca.rkcur         as currency
}

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtpo as currencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.osl           as amount,
      acdoca.rocur         as currency
}

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtpv as currencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.vsl           as amount,
      acdoca.rvcur         as currency
}

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtpb as currencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.bsl           as amount,
      acdoca.rbcur         as currency
}

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtpc as currencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.csl           as amount,
      acdoca.rccur         as currency
}

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtpd as CurrencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.dsl           as amount,
      acdoca.rdcur         as currency
}

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtpe as currencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.esl           as amount,
      acdoca.recur         as currency
}

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtpf as currencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.fsl           as amount,
      acdoca.rfcur         as currency
}

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 <> ''
{
  key currency_type.bukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
  key currency_type.curtpg as currencyType,
      acdoca.awitem,
      acdoca.racct         as hkont,
      acdoca.gsl           as amount,
      acdoca.rgcur         as currency
}