Fins_Rev_Rec_Cons_Check_View

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Consistency check of ACDOCA items'

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

//Consistency check of ACDOCA items: 

//Checks the balance per document number and account assignment

//Checks only the balance of HSL 

//Checks only revenue recognition documents

//Selects from ACDOCA


define view entity Fins_Rev_Rec_Cons_Check_View
  as select
  from         acdoca       as a
    inner join finsc_ld_cmp as v on  a.rbukrs = v.bukrs
                                 and a.rldnr  = v.rldnr
{
    a.rldnr  as rldnr,
    a.rbukrs as bukrs,
    a.gjahr  as docyear,
    a.belnr,
    a.poper,
    a.accasty,
    a.accas,
    //ps_posid, ps_psp_pnr, paobjnr, aufnr, kdauf, kdpos,

    //rwcur,

    a.rhcur,
    //rkcur,

    //rocur, rvcur, rbcur, rccur, rdcur, recur, rfcur, rgcur,

    //sum(wsl) as wsl,

    @Semantics.amount.currencyCode: 'rhcur'
    sum(a.hsl) as hsl
    //sum(ksl) as ksl,

    //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

}
  where
          a.vorgn     = 'TBRR'
    and   not(
        a.bstat     = 'C'
        and a.poper = '000'
      )
  group by
    a.rldnr,
    a.rbukrs,
    a.gjahr,
    a.belnr,
    a.poper,
    a.accasty,
    a.accas,
    //         ps_posid, ps_psp_pnr, paobjnr, aufnr, kdauf, kdpos,

    //         rwcur,

    a.rhcur
  //         rkcur,

  //         rocur, rvcur, rbcur, rccur, rdcur, recur, rfcur, rgcur

  ;