SAP table MPOP (Forecast Parameters)

SAP table MPOP has 3 primary key fields being MANDT,MATNR,WERKS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
VERSP Version number of forecast parameters CHAR 2 0 VERSP
PROPR Forecast profile CHAR 4 0 MPRP PROPR
MODAW Model Selection Indicator CHAR 1 0 MODAW
A Examine for trend and seasonal fluctuations
S Examine for seasonal fluctuations
T Examine for trend
MODAV Model selection procedure CHAR 1 0 MODAV
1 Model selection by significance test
2 Analytical model selection procedure
KZPAR Indicator for parameter optimization CHAR 1 0 KZPAR
OPGRA Optimization level CHAR 1 0 OPGRA
F Fine (high optimization level)
G Rough (low optimization level)
M Middle (middle optimization level)
KZINI Initialization indicator CHAR 1 0 KZINI
M Manual initialization
X Initialization by system
PRMOD Forecast model CHAR 1 0 PRMOD
0 No forecast/no external model
B 2nd order trend
D Constant model
G Moving average
J Automatic model selection
K Constant with smoothing factor adjustment
N No forecast/external model
O 2nd order trend with adjustment of smoothing factor
S Seasonal model
T Trend model
W Weighted moving average
X Seasonal trend model
ALPHA Basic value smoothing using alpha factor DEC 3 2 ALPHA
BETA1 Trend value smoothing using the beta factor DEC 3 2 BETA1
GAMMA Seasonal index smoothing using gamma factor DEC 3 2 GAMMA
DELTA MAD (mean absolute deviation) smoothing using delta factor DEC 3 2 DELTA
EPSIL Epsilon factor DEC 3 2 EPSIL
SIGGR Tracking limit DEC 5 3 SIGGR
PRDAT Date of last forecast DATS 8 0 PRDAT
PERAN Number of historical periods DEC 3 0 PERAN
PERIN Number of periods for initialization DEC 3 0 PERIN
PERIO Number of periods per seasonal cycle DEC 3 0 PERIO
PEREX Number of periods for ex-post forecasting DEC 3 0 PEREX
ANZPR Number of forecast periods DEC 3 0 ANZPR
FIMON Fixed periods DEC 3 0 FIMON
GWERT Basic value QUAN 13 3 GWERT
GWER1 Basic value of the 2nd order QUAN 13 3 GWER2
GWER2 Basic value of the 2nd order QUAN 13 3 GWER2
VMGWE Basic value of previous period QUAN 13 3 VMGWE
VMGW1 Base value of the second order in previous period QUAN 13 3 VMGW2
VMGW2 Base value of the second order in previous period QUAN 13 3 VMGW2
TWERT Trend value QUAN 13 3 TWERT
VMTWE Trend value of previous period QUAN 13 3 VMTWE
PRMAD Mean absolute deviation (MAD) QUAN 13 3 PRMAD
VMMAD Mean absolute devaition of previous period QUAN 13 3 VMMAD
FSUMM Error total QUAN 13 3 FSUMM
VMFSU Error total for the previous period QUAN 13 3 VMFSU
GEWGR Weighting group CHAR 2 0 * GEWGR
THKOF Theil coefficient DEC 5 2 THKOF
AUSNA Exception message bar CHAR 30 0 AUSNA
PROAB Forecast flow control CHAR 10 0 PROAB
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
PNUM1 Pointer: forecast parameters NUMC 10 0 * PNUM1
HSNUM Number for history CHAR 2 0 HSNUM
PNUM2 Pointer for forecast results NUMC 10 0 * PNUM2
PERIV Fiscal Year Variant CHAR 2 0 * PERIV

MPOP foreign key relationships

Table Field Check Table Check Field
0 MPOP MANDT T000 Clients MANDT
1 MPOP MATNR MARA General Material Data MANDT
1 MPOP MATNR MARA General Material Data MATNR
0 MPOP PROPR MPRP Forecast Profiles MANDT
0 MPOP PROPR MPRP Forecast Profiles PROPR
1 MPOP WERKS T001W Plants/Branches MANDT
1 MPOP WERKS T001W Plants/Branches WERKS