V_ML_P_GAP_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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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":""
}
}*/