FINS_REV_REC_COS_ACDOCP_VIEW

@AbapCatalog.sqlViewName: 'FINS_RR_ACDOCP'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Planvalues from ACDOCP'

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

//Adds dimension type of quantity unit to ACDOCP   

//Selects from ACDOCP and T006


define view FINS_REV_REC_COS_ACDOCP_VIEW
  as select
    a.category,
    a.rldnr,      
    a.rbukrs as bukrs,
    a.racct as hkont,
    a.aufnr,      
    a.kdauf,
    a.kdpos,
    a.ps_posid,
    a.ps_psp_pnr,
    a.service_doc_id,
    a.service_doc_item_id, 
    a.rwcur,
    a.rhcur,
    a.rkcur,
    a.rco_ocur,
    a.rvunit,       
    b.dimid as dimid,
    sum(a.wsl) as wsl,
    sum(a.ksl) as ksl,
    sum(a.hsl) as hsl,
    sum(a.co_osl) as co_osl,
    sum(a.vmsl) as vmsl
  from acdocp as a
  left outer join t006 as b on a.rvunit = b.msehi
  group by
    a.category,
    a.rldnr,      
    a.rbukrs,
    a.racct,      
    a.aufnr,      
    a.kdauf,
    a.kdpos,
    a.ps_posid,
    a.ps_psp_pnr,
    a.service_doc_id,
    a.service_doc_item_id,    
    a.rwcur,
    a.rhcur,
    a.rkcur,
    a.rco_ocur,
    a.rvunit,       
    b.dimid      
    ; 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCP",
"T006"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/