V_COSS_PER_1_VIEW

@AbapCatalog.sqlViewName: 'V_COSS_PER_1'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'COSS totals in all currencies/valuations - 1'

//@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view V_COSS_PER_1_VIEW as

  select
--           key '00'         as lednr,
           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 case when parobsrc = '1' then parob1 else case when parobsrc = '2' then paccasty else '' end end as parob,        not needed for KSII     
           key a.uspob      as uspob,
           key a.co_beknz   as beknz,
           key a.rwcur      as twaer,

           key a.rldnr      as rldnr,
           key a.poper      as perio,
           
--           rvunit       as meinh,
           co_meinh     as meinh,
           rbukrs       as bukrs,           
           bstat,
           tk.xwbuk     as xwbuk,
           
           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(pfsl)    as pfsl,
           sum(pfsl2)   as pfsl2,
           sum(pfsl3)   as pfsl3,           

--           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 = ''
                                     and t.xcoss = 'X'
                                     --- redundant check: and t.wtkat = 'A'
    inner join tka01        as tk on     tk.mandt   = a.rclnt                    --- check logical system for relevanz for totals    !do not delete this condition!
                                     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
           a.kokrs,
           objnr,
           gjahr,
           racct,
           a.vrgng,
           a.uspob,
           co_beknz,
           rwcur,

           rldnr,
           poper,
           
--           rvunit,
           co_meinh,
           rbukrs,           
           bstat,
           xwbuk,
           
           rco_ocur,
           rkcur,
           rocur,
           rvcur,           
           rbcur,           
           rccur,
           rdcur,
           recur,
           rfcur,
           rgcur,
           rhcur    
    ;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"T000",
"TJ01",
"TKA01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/