V_Coss_R_3s_View

@AbapCatalog.sqlViewName: 'V_COSS_R_3S'

//@ClientHandling.algorithm: #SESSION_VARIABLE

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

@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'CO Object: Cost Totals for Internal Postings ("Rev.") Part3s'
define view V_Coss_R_3s_View as 
  select
--       key fields of totals (w/o period block)  
         key c.mandt,
         key lednr, 
         key objnr,     
         key gjahr,
         key '11' as wrttp,           
         key versn,     
         key kstar,
         key hrkft,
         key c.vrgng,
         key parob,      
         key uspob, 
         key beknz,
         key twaer,

--       period
         perio,
         meinh,

--       value fields         
         wtgbtr,
         wogbtr,
         wkgbtr,
         wkfbtr,
         pagbtr,
         pafbtr,
         megbtr,
         mefbtr,

--       add attributes         
         beltp, 
         timestmp,          
         bukrs, 
         fkber, 
         segment, 
         geber, 
         grant_nbr, 
         budget_pd,

--------------------------------------------           
         -- muvflg,
         case when c.mvflg = '' and c.megbtr = 0 and c.mefbtr = 0
            then case when c.meinb = c.meinh or T_MEINH.dimid = T_MEINB.dimid then 0 else 1 end
         else
            case when c.mvflg = 'Y' then 1
                 when c.mvflg = '' and c.megbtr = 0 and c.mefbtr = 0 then 1
            else 0 end
         end as muvflg         
                     
    from            v_coep_ori  as c
    inner join      tj01        as j
                                on  j.vrgng = c.vrgng
                                and j.wtkat = 'A'
                                and j.xcoss = 'X'
    left outer join t006        as  T_MEINB               
                                on  T_MEINB.mandt = c.mandt              
                                and T_MEINB.msehi = c.meinb                 
    left outer join t006        as  T_MEINH               
                                on  T_MEINH.mandt = c.mandt             
                                and T_MEINH.msehi = c.meinh 
/* add logsys check */                                                    
    inner join tka01       as t  on     t.mandt    = c.mandt
                                and     t.kokrs    = c.kokrs
    inner join t000        as s  on     s.mandt    = c.mandt
                                and (   s.logsys   = c.logsyso  
                                     or c.logsyso  = '' 
                                     or (    ( c.accasty = 'KS'       or c.accasty = 'KL' ) 
                                         and ( s.logsys = t.logsystem or t.logsystem = '' )
                                         ) 
                                     )
           where c.wrttp = '11'   
    ;     
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"T000",
"T006",
"TJ01",
"TKA01",
"V_COEP_ORI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/