1. Home
  2. Resources
  3. SAP Tables
  4. MPOP - Forecast Parameters

SAP Table MPOP

Forecast Parameters

MPOP (Forecast Parameters) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MPOP to other SAP tables.

Source: MPOP (Forecast Parameters)

MPOP table fields

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

MPOP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MPOP MANDT MPOP MANDT T000 Clients MANDT
MPOP MATNR MPOP MANDT MARA General Material Data MANDT
MPOP MATNR MPOP MATNR MARA General Material Data MATNR
MPOP PROPR MPOP MANDT MPRP Forecast Profiles MANDT
MPOP PROPR MPOP PROPR MPRP Forecast Profiles PROPR
MPOP WERKS MPOP MANDT T001W Plants/Branches MANDT
MPOP WERKS MPOP WERKS T001W Plants/Branches WERKS