...
C_NOTAGE = v_snapshot_date - c_duedt.
IB_PMCL_01/2 | IB_PMCL_03/4 | IB_PMCL_06/5 | |
C_SNAPWK = Max c_snapwk from DBPMCL03/4 -> Not use Use loading date -> Week | => Loading date -> week +1 | => Loading date -> week +1 | => Loading date -> week |
Filter on loading | C_PLANFLG = X | C_CLOSFLG = X | C_PLANFLG = X |
C_NOTAGE (Delay of Notification) | = snap date - c_duedt | ||
KPI | 3.2 Next week | 3.3 Portfolio | 3.2 Current week |
Rules & Explanations
KPI 3.02 Planned Activity (Nb of Calls)
Planned Activity (Nb of Calls) = BW_RKF_MVPMCL01_0001
= K_COUNTER with C_PLANFLG = X
Planned Activity Executed (Nb of Calls) = BW_RKF_MVPMCL01_0002
= K_COUNTER with C_PLANFLG = X and C_EXEFLG = X
C_EXEFLG : get from transformation DBPMCL01 -> DBPMCL01 (/BIC/C_EXEFLG=' ';), which lookup DBPMOR01
DBPMOR01 --> DBPMOR01 real location to determine C_EXEFLG
C_INACFLG
1. Get from DTS_ZBW_V_MPLA --> C_MPLAN2
...