1. Home
  2. Resources
  3. SAP Tables
  4. 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.

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
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
X Initialization by system
M Manual initialization
SIGGR Tracking limit SIGGR DEC 5 3
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)
GEWGR Weighting group GEWGR CHAR 2 0
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

MPRP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MPRP MANDT MPRP MANDT T000 Clients MANDT