SAP table MPRP (Forecast Profiles)

SAP table MPRP has 2 primary key fields being MANDT,PROPR.

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
PROPR Forecast profile CHAR 4 0 PROPR
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
PERAN Number of historical periods DEC 3 0 PERAN
ANZPR Number of forecast periods DEC 3 0 ANZPR
PERIN Number of periods for initialization DEC 3 0 PERIN
FIMON Fixed periods DEC 3 0 FIMON
PERIO Number of periods per seasonal cycle DEC 3 0 PERIO
KZINI Initialization indicator CHAR 1 0 KZINI
M Manual initialization
X Initialization by system
SIGGR Tracking limit DEC 5 3 SIGGR
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)
GEWGR Weighting group CHAR 2 0 * GEWGR
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

MPRP foreign key relationships

Table Field Check Table Check Field
0 MPRP MANDT T000 Clients MANDT