@AbapCatalog.sqlViewName: 'FINSRR_ACDOCABAL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Acdoca balance for introducing a new accounting principle'
@ClientDependent: true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
//Has the parameters p_gjahr_high and p_gjahr_low
//Balance per account assignment object, GL account, slalittype, personal number, resource and ledger
//Used by report FINS_REV_REC_ACDOCA_BAL
//Selects from ACDOCA with selection condition p_gjahr_low <= ACDOCA.gjahr <= p_gjahr_high
define view Fins_Rev_Rec_Acdoca_Balance
with parameters
p_gjahr_high : gjahr,
p_gjahr_low : gjahr
as select
a.rldnr as rldnr,
objnr,
ps_posid,
ps_psp_pnr,
aufnr,
kdauf,
kdpos,
service_doc_id,
service_doc_item_id,
service_contract_id,
service_contract_item_id,
vtkey,
vtpos,
//paobjnr,
//gjahr, poper, fiscyearper, budat,
racct,
slalittype,
//gkont,
rbukrs,
werks,
rbusa,
prctr,
//segment, rfarea, scope,
//pbukrs, rassc, sbusa, pprctr, psegment, sfarea,
//matnr, hkgrp, lifnr, kunnr,
pernr,
rsrce,
accasty,
accas,
cast ('X' as kka_yes_no) as ebrr_indicator,
rwcur,
rhcur,
rkcur,
rocur,
rvcur,
rbcur,
rccur,
rdcur,
recur,
rfcur,
rgcur,
rco_ocur,
runit,
sum(wsl) as wsl,
sum(hsl) as hsl,
sum(ksl) as ksl,
sum(kfsl) as kfsl,
sum(osl) as osl,
sum(vsl) as vsl,
sum(bsl) as bsl,
sum(csl) as csl,
sum(dsl) as dsl,
sum(esl) as esl,
sum(fsl) as fsl,
sum(gsl) as gsl,
sum(co_osl) as co_osl,
sum(msl) as msl
from acdoca as a
inner join finsc_ld_cmp as v on a.rbukrs = v.bukrs and a.rldnr = v.rldnr
inner join t000 as b on a.rclnt = b.mandt
where
(
a.mig_source <> ' '
or(
a.mig_source = ' '
and not(
a.bstat = 'C'
and a.poper = '000'
)
)
)
and a.vorgn = 'TBRR'
and a.ryear >= :p_gjahr_low
and a.ryear <= :p_gjahr_high
group by
a.rldnr,
objnr,
ps_posid,
ps_psp_pnr,
aufnr,
kdauf,
kdpos,
service_doc_id,
service_doc_item_id,
service_contract_id,
service_contract_item_id,
vtkey,
vtpos,
//paobjnr,
//gjahr, poper, fiscyearper, budat,
racct,
slalittype,
//gkont,
rbukrs,
werks,
rbusa,
prctr,
//segment, rfarea, scope,
//pbukrs, rassc, sbusa, pprctr, psegment, sfarea,
//matnr, hkgrp, lifnr, kunnr,
pernr,
rsrce,
accasty,
accas,
rwcur,
rhcur,
rkcur,
rocur,
rvcur,
rbcur,
rccur,
rdcur,
recur,
rfcur,
rgcur,
rco_ocur,
runit
union all select
a.rldnr as rldnr,
objnr,
ps_posid,
ps_psp_pnr,
aufnr,
kdauf,
kdpos,
service_doc_id,
service_doc_item_id,
service_contract_id,
service_contract_item_id,
vtkey,
vtpos,
//paobjnr,
//gjahr, poper, fiscyearper, budat,
racct,
slalittype,
//gkont,
rbukrs,
werks,
rbusa,
prctr,
//segment, rfarea, scope,
//pbukrs, rassc, sbusa, pprctr, psegment, sfarea,
//matnr, hkgrp, lifnr, kunnr,
pernr,
rsrce,
accasty,
accas,
cast (' ' as kka_yes_no) as ebrr_indicator,
rwcur,
rhcur,
rkcur,
rocur,
rvcur,
rbcur,
rccur,
rdcur,
recur,
rfcur,
rgcur,
rco_ocur,
runit,
sum(wsl) as wsl,
sum(hsl) as hsl,
sum(ksl) as ksl,
sum(kfsl) as kfsl,
sum(osl) as osl,
sum(vsl) as vsl,
sum(bsl) as bsl,
sum(csl) as csl,
sum(dsl) as dsl,
sum(esl) as esl,
sum(fsl) as fsl,
sum(gsl) as gsl,
sum(co_osl) as co_osl,
sum(msl) as msl
from acdoca as a
inner join finsc_ld_cmp as v on a.rbukrs = v.bukrs and a.rldnr = v.rldnr
inner join t000 as b on a.rclnt = b.mandt
where
(
a.mig_source <> ' '
or(
a.mig_source = ' '
and not(
a.bstat = 'C'
and a.poper = '000'
)
)
)
and a.vorgn != 'TBRR'
and a.ryear >= :p_gjahr_low
and a.ryear <= :p_gjahr_high
group by
a.rldnr,
objnr,
ps_posid,
ps_psp_pnr,
aufnr,
kdauf,
kdpos,
service_doc_id,
service_doc_item_id,
service_contract_id,
service_contract_item_id,
vtkey,
vtpos,
//paobjnr,
//gjahr, poper, fiscyearper, budat,
racct,
slalittype,
//gkont,
rbukrs,
werks,
rbusa,
prctr,
//segment, rfarea, scope,
//pbukrs, rassc, sbusa, pprctr, psegment, sfarea,
//matnr, hkgrp, lifnr, kunnr,
pernr,
rsrce,
accasty,
accas,
rwcur,
rhcur,
rkcur,
rocur,
rvcur,
rbcur,
rccur,
rdcur,
recur,
rfcur,
rgcur,
rco_ocur,
runit;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FINSC_LD_CMP",
"T000"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/