v_cosp_ori_4_view

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

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

define view v_cosp_ori_4_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,
         -- cast(mvflg as abap.int2) as incomp
         case mvflg
           when 'Y' then 1
           when '' then
             case megbtr
               when 0 then
                 case mefbtr
                   when 0 then
                     case
                       when ( meinb = '   ' and meinh = '   ' ) then 0
                       else 1
                     end
                   else 0
                 end
               else 0
             end
           else 0
         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
    where wtkat = 'A'
      and xcosp = 'X'
      and not (
          mvflg = ''
      and megbtr = 0
      and mefbtr = 0
      and meinb <> '   '
      and meinh <> '   '
--      and meinh <> meinb
     );

     
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"T000",
"TJ01",
"V_COEP_ORI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/