v_ml_p_gap_l1b_view

@AbapCatalog.sqlViewName: 'FMLV_P_GAP_L1B'
@EndUserText.label: 'LOCAL: Material Ledger Gap in Periods'
define view v_ml_p_gap_l1b_view as
   select key h.mandt   as mandt,
          key h.kalnr   as kalnr,
          h.bwkey       as bwkey,
          meins,
          cast( bdatj as abap.int4 ) as gjahr,
          
          case
             when poper = '001'
               then 1
               else 0
          end as record_for_period_001,
          case
             when poper = '002'
               then 1
               else 0
          end as record_for_period_002,  
          case
             when poper = '003'
               then 1
               else 0
          end as record_for_period_003,
          case
             when poper = '004'
               then 1
               else 0
          end as record_for_period_004,
          case
             when poper = '005'
               then 1
               else 0
          end as record_for_period_005,
          case
             when poper = '006'
               then 1
               else 0
          end as record_for_period_006,  
          case
             when poper = '007'
               then 1
               else 0
          end as record_for_period_007,
          case
             when poper = '008'
               then 1
               else 0
          end as record_for_period_008,      
          case
             when poper = '009'
               then 1
               else 0
          end as record_for_period_009,  
          case
             when poper = '010'
               then 1
               else 0
          end as record_for_period_010,
          case
             when poper = '011'
               then 1
               else 0
          end as record_for_period_011,              
          case
             when poper = '012'
               then 1
               else 0
          end as record_for_period_012          
          
     from       ckmlpp    as p
    inner join  ckmlhd    as h   on  h.mandt = p.mandt
                                 and h.kalnr = p.kalnr          
    where untper = '000'                 
    ;           
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLHD",
"CKMLPP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/