V_ML_P_GAP_VIEW

CDS View

LOCAL: Material Ledger Gap in Periods

V_ML_P_GAP_VIEW is a CDS View in S/4HANA. LOCAL: Material Ledger Gap in Periods. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
v_ml_account_l1_view view inner LOCAL: Material Ledger Periods
v_ml_check1a_view view inner Material Ledger check migrated data vs. CKMCLCR
v_ml_check1b_view view inner Material Ledger check migrated data vs. CKMCLCR
v_ml_check2a_view view inner Material Ledger check migrated data vs. CKMCLPP
v_ml_check2b_view view inner Material Ledger check migrated data vs. CKMCLPP
@AbapCatalog.sqlViewName: 'FMLV_P_GAP'
@EndUserText.label: 'LOCAL: Material Ledger Gap in Periods'
define view v_ml_p_gap_view as
   select key mandt,
          key kalnr,
          bwkey,
          cast( lpad( cast( div( max_gjahr_perio, 1000 ) as abap.char(12)  ), 4, '0' ) as abap.numc(4) )  as first_gjahr,
          cast( lpad( cast( mod( max_gjahr_perio, 1000 ) as abap.char(12)  ), 3, '0' ) as abap.numc(3) )  as first_perio

     from  v_ml_p_gap_l4_view
    ;
            
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"V_ML_P_GAP_L4_VIEW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/