v_ml_check1b_view

@AbapCatalog.sqlViewName: 'FMLV_CHECK1B'
@EndUserText.label: 'Material Ledger check migrated data vs. CKMCLCR'
define view v_ml_check1b_view as
select
       key c1.mandt          as mandt,
       key c2.rldnr          as rldnr,
       key c1.kalnr          as kalnr,
       key c1.bdatj          as bdatj,
       key c1.poper          as poper,
       key c1.untper         as untper,
       key c1.curtp          as curtp,
       coalesce(c2.bukrs,'') as bukrs,

       case
         when ( c2.waers is null      or  c2.salk3 is null )     then   8
         when ( c1.waers <> c2.waers  or  c1.salk3 <> c2.salk3 ) then   4
         else                                                           0
       end as   sysubrc

        from      ckmlcr              as c1
  inner join      ckmlhd              as hd   on hd.mandt  = c1.mandt
                                             and hd.kalnr  = c1.kalnr
  inner join v_ml_max_gjahr_perio_view as p   on p.mandt   = c1.mandt
                                             and p.kalnr   = c1.kalnr
                                             and p.gjahr   = c1.bdatj
                                             and p.poper   = c1.poper
  inner join      v_ml_max_lbkum_view as l    on l.mandt   = c1.mandt
                                             and l.kalnr   = c1.kalnr
//  inner join      v_ml_mig_ckmlv_view as v    on  v.mandt  = c1.mandt

//                                             and  v.bwkey  = hd.bwkey

  inner join      v_ml_p_gap_view     as v    on  v.mandt  = c1.mandt
                                             and  v.kalnr  = c1.kalnr
  left outer join v_ml_check1_l3_view as c2   on c2.mandt  = c1.mandt
                                             and c2.kalnr  = c1.kalnr
                                             and c2.bdatj  = c1.bdatj
                                             and c2.poper  = c1.poper
                                             and c2.untper = c1.untper
                                             and c2.curtp  = c1.curtp

//        where (    c1.bdatj > v.ml_start_year

//              or ( c1.bdatj = v.ml_start_year and c1.poper >= v.ml_start_poper )

//             )

       where (     c1.bdatj > v.first_gjahr
              or ( c1.bdatj = v.first_gjahr and c1.poper >= v.first_perio )
              )
  ;
                  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"V_ML_CHECK1_L3_VIEW",
"V_ML_MAX_GJAHR_PERIO_VIEW",
"V_ML_MAX_LBKUM_VIEW",
"V_ML_P_GAP_VIEW",
"CKMLCR",
"CKMLHD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/