V_COSP_LVP_1_VIEW

@AbapCatalog.sqlViewName: 'V_COSP_LVP_1'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'COSP totals: all currencies/valuations - 1'
//@ClientHandling.type: #CLIENT_DEPENDENT 

//@ClientHandling.algorithm: #AUTOMATED

@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P

define view V_COSP_LVP_1_VIEW as

  select
           key a.rldnr      as rldnr,
           key a.rbukrs     as bukrs,           
           key a.kokrs      as kokrs,
           key a.objnr      as objnr,
           key a.gjahr      as gjahr,
--           key '04'         as wrttp,
           key a.racct      as kstar,
--           key a.hrkft      as hrkft,
           key a.vrgng      as vrgng,
           key a.rassc      as vbund,
           key a.sbusa      as pargb,           
           key a.co_beknz   as beknz,
           key a.rwcur      as twaer,

           key a.poper      as perio,
           
--           rvunit       as meinh,
           co_meinh     as meinh,     
           bstat,
           tk.xwbuk     as xwbuk,
           tk.ctyp      as kokrs_curtyp,
           
           rco_ocur,
           rkcur,
           rocur,
--           rocur as racur,
           rvcur,           
           rbcur,           
           rccur,
           rdcur,
           recur,
           rfcur,
           rgcur,
           rhcur,

--         value fields
           sum(wsl)     as wsl,
           sum(wsl2)    as wsl2,
           sum(wsl3)    as wsl3,
  
           sum(kfsl)    as kfsl,
           sum(kfsl2)   as kfsl2,
           sum(kfsl3)   as kfsl3,

           sum(ksl)     as ksl,   
           sum(osl)     as osl,    
           sum(co_osl)  as co_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(hsl)     as hsl,
                    
           sum(psl)     as psl,
           sum(psl2)    as psl2,
           sum(psl3)    as psl3,           

--           sum(vmsl)    as vmsl,
--           sum(vmfsl)   as vmfsl,
           sum(co_megbtr)   as vmsl,
           sum(co_mefbtr)   as vmfsl,           
           sum(msl)     as msl,
           sum(mfsl)    as mfsl

--           max(muvflg)  as muvflg
           
-----------------------------------------


    from     acdoca         as a       
    
    inner join tj01         as t  on     t.vrgng = a.vrgng                       --- only actuals relevant for primary postings
                                     and t.xcosp = 'X'
                                     and t.xcoss = ''

    inner join tka01        as tk on     tk.mandt   = a.rclnt                    --- check logical system for relevanz for totals   !do not delete this condition for MANDT!
                                     and tk.kokrs   = a.kokrs
    inner join t000         as s  on     s.mandt    = a.rclnt
                                     and ( s.logsys   = a.logsyso
                                           or a.logsyso  = ''
                                           or (    ( a.accasty = 'KS'        or a.accasty = 'KL'  )
                                               and ( s.logsys = tk.logsystem or tk.logsystem = '' )
                                              )
                                         )
    where a.accasty <> ''                                             --- actuals only 
      and a.objnr   <> ''                                             --- OBJNR is initial in case CO has been archived!
          
    group by
           rldnr,
           rbukrs,            
           a.kokrs,
           objnr,
           gjahr,
           racct,
           a.vrgng,
           rassc,
           sbusa,           
           co_beknz,
           rwcur,

           poper,
           
//           rvunit,

           co_meinh,          
           bstat,
           xwbuk,
           ctyp,
           
           rco_ocur,
           rkcur,
           rocur,
           rvcur,           
           rbcur,           
           rccur,
           rdcur,
           recur,
           rfcur,
           rgcur,
           rhcur    
    ;