v_ml_bcf_view

@AbapCatalog.sqlViewName: 'FMLV_BCF'
@EndUserText.label: 'LOCAL: Material Ledger BCF'
define view v_ml_bcf_view as
    select key rclnt,
           key rldnr,  
           key kalnr, 
           key y.fiscal_year    as gjahr,
           key poper,           
           
           erkrs,
           kokrs,
           rbukrs,
           bwkey,
           bwtar,
           matnr,
           kzbws,
           sobkz,
           xobew,
           mat_kdauf,
           mat_kdpos,
           mat_pspnr,
           mat_lifnr, 
           mat_ps_posid,
           racct,   
           ktopl,
           periv,
           
           werks,
           prctr,
           segment,                  

           mlast,
           vprsv, 

           rhcur,
           hsl,
           hsalkv,
           rkcur,
           ksl,
           ksalkv,
           rocur, 
           osl,
           osalkv,
           rvcur, 
           vsl,
           vsalkv,                      
            
           runit,          
           lbkum                 
      from      v_ml_bcf_l2_view as b
     inner join v_ml_years_view  as y   on y.mandt  = b.rclnt
                                       and y.fiscal_year >= b.gjahr
     inner join marv             as m   on m.mandt  = b.rclnt
                                       and m.bukrs  = b.rbukrs
                                       and m.lfgja >= y.fiscal_year       
  
  union
    select 
           key rclnt,
           key rldnr,  
           key kalnr, 
           key gjahr,
           key poper,           
           
           erkrs,
           kokrs,
           rbukrs,
           bwkey,
           bwtar,
           matnr,
           kzbws,
           sobkz,
           xobew,
           mat_kdauf,
           mat_kdpos,
           mat_pspnr,
           mat_lifnr, 
           mat_ps_posid,           
           racct,   
           ktopl,
           periv,
           
           werks,
           prctr,
           segment,                  

           mlast,
           vprsv, 
           
           rhcur,
           hsl,
           hsalkv,
           rkcur,
           ksl,
           ksalkv,
           rocur, 
           osl,
           osalkv,
           rvcur, 
           vsl,
           vsalkv,                    
                
           runit,      
           lbkum  
      from v_ml_bcf_l1_view
     ;            
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"V_ML_BCF_L1_VIEW",
"V_ML_BCF_L2_VIEW",
"V_ML_YEARS_VIEW",
"MARV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/