FINS_REV_REC_ACDOCA_API

@AbapCatalog.sqlViewName: 'FINS_RR_ACDOCAPI'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'View on ACDOCA for new project invoicing'

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

//Rev. Rec postings  of projects

//Used for new project invoicing - api repricing

//Selects from ACDOCA


define view FINS_REV_REC_ACDOCA_API 
with parameters
    P_Budat : budat
as select 


rldnr,
ps_psp_pnr,
pernr,
slalittype,
runit,
racct as hkont,
rsrce,

rwcur,
rhcur,
rkcur,
rocur,
rvcur,
rbcur,
rccur,
rdcur,
recur,
rfcur,
rgcur,
rco_ocur,

sum(msl) as msl,
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
    
from acdoca  
where   vorgn     = 'TBRR'
    and accasty = 'PR'
    and   not( bstat     = 'C'
           and poper = '000'
      )
   and  ( slalittype = '08000'
        or slalittype = '08100'
        or slalittype = '08102'
        or slalittype = '08200' )
   and budat <= $parameters.P_Budat
     
   
group by 
ps_psp_pnr,
pernr,
rldnr,
slalittype,
runit,
racct,
rsrce,

rwcur,
rhcur,
rkcur,
rocur,
rvcur,
rbcur,
rccur,
rdcur,
recur,
rfcur,
rgcur,
rco_ocur;