1. Home
  2. Resources
  3. SAP Tables
  4. PROP - Forecast parameters

SAP Table PROP

Forecast parameters

PROP (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 PROP to other SAP tables.

PROP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PNUM1 Pointer: forecast parameters PNUM1 NUMC 10 0
HSNUM Number for history HSNUM CHAR 2 0
VERSP Version number of forecast parameters VERSP CHAR 2 0
PNUM2 Pointer for forecast results PNUM2 PROW NUMC 10 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
VBKEZ Indicator: base forecast on consumption values VBKEZ CHAR 1 0
X Yes
NULL No
STATU LIS version status VSSTA CHAR 1 0
VETXT Version description VETXT CHAR 40 0
PRWUG Forecast: Lower limit PRWUG QUAN 13 3
PRWOG Forecast: Upper limit PRWOG QUAN 13 3
PRROS Forecast: Sale rate PRROS QUAN 13 3
PRKUM Cumulative forecast result PRKUM QUAN 13 3
PRZGF Pointer: Forecast weighting factor PRZGF NUMC 10 0
AKTPE Current period AKTPE DEC 3 0
FAUSR Indicator: correction of outliers for forecast FAUSR CHAR 1 0
X Yes
NULL No
SIGMA Sigma factor SIGMX DEC 3 2
0 Text
FLGEXC Indicator: automatic correction of outliers FLGEXC CHAR 1 0
FLGCOR Indicator: use corrected historical values for forecast FLGCOR CHAR 1 0

PROP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PROP PNUM2 PROP PRDAT PROW Forecast Values ERTAG
PROP PNUM2 PROP MANDT PROW Forecast Values MANDT
PROP PNUM2 PROP PNUM2 PROW Forecast Values PNUM2
PROP PROPR PROP MANDT MPRP Forecast Profiles MANDT
PROP PROPR PROP PROPR MPRP Forecast Profiles PROPR