@AbapCatalog.sqlViewName: 'FINSGLDOCAAMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@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_ALL_AMOUNTS
as select from acdoca
inner join finsc_ledger as ledger on ledger.rldnr = acdoca.rldnr
and ledger.xleading = 'X'
{
key acdoca.rbukrs as bukrs,
key acdoca.gjahr,
key acdoca.belnr,
key acdoca.tsl as balance_amount,
key cast( '00' as fins_curtype ) as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.wsl as amount,
acdoca.rwcur as currency,
acdoca.rtcur as balance_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.curtph <> ''
{
key currency_type.bukrs,
key acdoca.gjahr,
key acdoca.belnr,
key acdoca.tsl as balance_amount,
key currency_type.curtph as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.hsl as amount,
acdoca.rhcur as currency,
acdoca.rtcur as balance_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.tsl as balance_amount,
key currency_type.curtpk as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.ksl as amount,
acdoca.rkcur as currency,
acdoca.rtcur as balance_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.tsl as balance_amount,
key currency_type.curtpo as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.osl as amount,
acdoca.rocur as currency,
acdoca.rtcur as balance_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.tsl as balance_amount,
key currency_type.curtpv as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.vsl as amount,
acdoca.rvcur as currency,
acdoca.rtcur as balance_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.tsl as balance_amount,
key currency_type.curtpb as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.bsl as amount,
acdoca.rbcur as currency,
acdoca.rtcur as balance_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.tsl as balance_amount,
key currency_type.curtpc as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.csl as amount,
acdoca.rccur as currency,
acdoca.rtcur as balance_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.tsl as balance_amount,
key currency_type.curtpd as CurrencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.dsl as amount,
acdoca.rdcur as currency,
acdoca.rtcur as balance_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.tsl as balance_amount,
key currency_type.curtpe as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.esl as amount,
acdoca.recur as currency,
acdoca.rtcur as balance_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.tsl as balance_amount,
key currency_type.curtpf as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.fsl as amount,
acdoca.rfcur as currency,
acdoca.rtcur as balance_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.tsl as balance_amount,
key currency_type.curtpg as currencyType,
acdoca.awitem,
acdoca.racct as hkont,
acdoca.gsl as amount,
acdoca.rgcur as currency,
acdoca.rtcur as balance_currency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FINSC_LD_CMP",
"FINSC_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/