- Home
- Resources
- SAP Tables
- MPRP - Forecast Profiles
SAP Table MPRP
Forecast Profiles
MPRP (Forecast Profiles) 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 MPRP to other SAP tables.
Source: MPRP (Forecast Profiles)
MPRP table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
PROPR |
Forecast profile |
PROPR |
|
CHAR |
|
4 |
0 |
|
PRMOD |
Forecast model |
PRMOD |
|
CHAR |
|
1 |
0 |
Possible values
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 |
|
PERAN |
Number of historical periods |
PERAN |
|
DEC |
|
3 |
0 |
|
ANZPR |
Number of forecast periods |
ANZPR |
|
DEC |
|
3 |
0 |
|
PERIN |
Number of periods for initialization |
PERIN |
|
DEC |
|
3 |
0 |
|
FIMON |
Fixed periods |
FIMON |
|
DEC |
|
3 |
0 |
|
PERIO |
Number of periods per seasonal cycle |
PERIO |
|
DEC |
|
3 |
0 |
|
KZINI |
Initialization indicator |
KZINI |
|
CHAR |
|
1 |
0 |
Possible values
X |
Initialization by system |
M |
Manual initialization |
|
SIGGR |
Tracking limit |
SIGGR |
|
DEC |
|
5 |
3 |
|
MODAW |
Model Selection Indicator |
MODAW |
|
CHAR |
|
1 |
0 |
Possible values
T |
Examine for trend |
S |
Examine for seasonal fluctuations |
A |
Examine for trend and seasonal fluctuations |
|
MODAV |
Model selection procedure |
MODAV |
|
CHAR |
|
1 |
0 |
Possible values
1 |
Model selection by significance test |
2 |
Analytical model selection procedure |
|
KZPAR |
Indicator for parameter optimization |
KZPAR |
|
CHAR |
|
1 |
0 |
Possible values
|
OPGRA |
Optimization level |
OPGRA |
|
CHAR |
|
1 |
0 |
Possible values
F |
Fine (high optimization level) |
M |
Middle (middle optimization level) |
G |
Rough (low optimization level) |
|
GEWGR |
Weighting group |
GEWGR |
|
CHAR |
|
2 |
0 |
|
ALPHA |
Basic value smoothing using alpha factor |
ALPHA |
|
DEC |
|
3 |
2 |
Possible values
|
BETA1 |
Trend value smoothing using the beta factor |
BETA1 |
|
DEC |
|
3 |
2 |
Possible values
|
GAMMA |
Seasonal index smoothing using gamma factor |
GAMMA |
|
DEC |
|
3 |
2 |
Possible values
|
DELTA |
MAD (mean absolute deviation) smoothing using delta factor |
DELTA |
|
DEC |
|
3 |
2 |
Possible values
|
MPRP foreign key relationships
Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
MPRP |
MANDT |
MPRP |
MANDT |
T000 |
Clients |
MANDT |