Fins_Rev_Rec_Cons_Check_View

@AbapCatalog.sqlViewName: 'FINS_RR_CONS_CHK'
@AbapCatalog.compiler.compareFilter: true
@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 Fins_Rev_Rec_Cons_Check_View
  as select
    a.rldnr  as rldnr,
    rbukrs   as bukrs,
    a.gjahr  as docyear,
    belnr,
    poper,
    accasty,
    accas,
    //ps_posid, ps_psp_pnr, paobjnr, aufnr, kdauf, kdpos,

    //rwcur,

    rhcur,
    //rkcur,

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

    //sum(wsl) as wsl,

    sum(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

  from         acdoca       as a
    inner join finsc_ld_cmp as v on  a.rbukrs = v.bukrs
                                 and a.rldnr  = v.rldnr
  where
          vorgn     = 'TBRR'
    and   not(
        a.bstat     = 'C'
        and a.poper = '000'
      )
  group by
    a.rldnr,
    rbukrs,
    gjahr,
    belnr,
    poper,
    accasty,
    accas,
    //         ps_posid, ps_psp_pnr, paobjnr, aufnr, kdauf, kdpos,

    //         rwcur,

    rhcur
  //         rkcur,

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

  ; 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FINSC_LD_CMP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/