v_cosp_ori_6_view

@AbapCatalog.sqlViewName: 'V_COSP_ORI_6'
@EndUserText.label: 'CO Object: Cost Totals for External Postings (part 6)'

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

define view v_cosp_ori_6_view as
  select c.mandt as mandt,
         kokrs,
         belnr,
         buzei,
         perio,
         wtgbtr,
         wogbtr,
         wkgbtr,
         wkfbtr,
         pagbtr,
         megbtr,
         mefbtr,
         lednr,
         objnr,
         gjahr,
--          wrttp,
         case
            when wrttp = 'U1' then '11'
            when wrttp = 'U4' then '04'
            else                    wrttp
         end as  wrttp,
         versn,
         kstar,
         hrkft,
         c.vrgng,
         vbund,
         pargb,
         beknz,
         twaer,
         meinh,
         meinb,
         mvflg,
         beltp,
         bukrs,
         fkber,
         segment,
         geber,
         grant_nbr,
         budget_pd,
         timestmp,
         case t6meinh.dimid
           when t6meinb.dimid then 0
           else 1
         end as incomp
    from v_coep_ori     as c
    inner join t000     as s  on     s.mandt    = c.mandt
                             and (   s.logsys   = c.logsyso
                                  or c.logsyso  = '' )
    inner join tj01
       on tj01.vrgng = c.vrgng
    left outer join t006 as t6meinb
       on t6meinb.mandt = c.mandt
      and t6meinb.msehi = c.meinb
    left outer join t006 as t6meinh
       on t6meinh.mandt = c.mandt
      and t6meinh.msehi = c.meinh
    where wtkat = 'A'
      and xcosp = 'X'
      and mvflg = ''               -- coep-mvflg = ''
      and megbtr = 0
      and mefbtr = 0
      and meinb <> '   '
      and meinh <> '   '
--      and meinh <> meinb            -- otherwise the dimension is the same
      ;
     
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"T000",
"T006",
"TJ01",
"V_COEP_ORI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/