SAP table PROP (Forecast Parameters)

SAP table PROP has 4 primary key fields being MANDT,PNUM1,HSNUM,VERSP.

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 MANDT
PNUM1 Pointer: forecast parameters NUMC 10 0 PNUM1
HSNUM Number for history CHAR 2 0 HSNUM
VERSP Version number of forecast parameters CHAR 2 0 VERSP
PNUM2 Pointer for forecast results NUMC 10 0 PROW PNUM2
PROPR Forecast profile CHAR 4 0 MPRP PROPR
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)
KZINI Initialization indicator CHAR 1 0 KZINI
M Manual initialization
X Initialization by system
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
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
EPSIL Epsilon factor DEC 3 2 EPSIL
SIGGR Tracking limit DEC 5 3 SIGGR
PRDAT Date of last forecast DATS 8 0 PRDAT
PERAN Number of historical periods DEC 3 0 PERAN
PERIN Number of periods for initialization DEC 3 0 PERIN
PERIO Number of periods per seasonal cycle DEC 3 0 PERIO
PEREX Number of periods for ex-post forecasting DEC 3 0 PEREX
ANZPR Number of forecast periods DEC 3 0 ANZPR
FIMON Fixed periods DEC 3 0 FIMON
GWERT Basic value QUAN 13 3 GWERT
GWER1 Basic value of the 2nd order QUAN 13 3 GWER2
GWER2 Basic value of the 2nd order QUAN 13 3 GWER2
VMGWE Basic value of previous period QUAN 13 3 VMGWE
VMGW1 Base value of the second order in previous period QUAN 13 3 VMGW2
VMGW2 Base value of the second order in previous period QUAN 13 3 VMGW2
TWERT Trend value QUAN 13 3 TWERT
VMTWE Trend value of previous period QUAN 13 3 VMTWE
PRMAD Mean absolute deviation (MAD) QUAN 13 3 PRMAD
VMMAD Mean absolute devaition of previous period QUAN 13 3 VMMAD
FSUMM Error total QUAN 13 3 FSUMM
VMFSU Error total for the previous period QUAN 13 3 VMFSU
GEWGR Weighting group CHAR 2 0 GEWGR
THKOF Theil coefficient DEC 5 2 THKOF
AUSNA Exception message bar CHAR 30 0 AUSNA
PROAB Forecast flow control CHAR 10 0 PROAB
VBKEZ Indicator: base forecast on consumption values CHAR 1 0 VBKEZ
STATU LIS version status CHAR 1 0 VSSTA
VETXT Version description CHAR 40 0 VETXT
PRWUG Forecast: Lower limit QUAN 13 3 PRWUG
PRWOG Forecast: Upper limit QUAN 13 3 PRWOG
PRROS Forecast: Sale rate QUAN 13 3 PRROS
PRKUM Cumulative forecast result QUAN 13 3 PRKUM
PRZGF Pointer: Forecast weighting factor NUMC 10 0 PRZGF
AKTPE Current period DEC 3 0 AKTPE
FAUSR Indicator: correction of outliers for forecast CHAR 1 0 FAUSR
SIGMA Sigma factor DEC 3 2 SIGMX
FLGEXC Indicator: automatic correction of outliers CHAR 1 0 FLGEXC
FLGCOR Indicator: use corrected historical values for forecast CHAR 1 0 FLGCOR

PROP foreign key relationships

Table Field Check Table Check Field
0 PROP PNUM2 PROW Forecast Values MANDT
0 PROP PNUM2 PROW Forecast Values PNUM2
0 PROP PNUM2 PROW Forecast Values ERTAG
1 PROP PROPR MPRP Forecast Profiles MANDT
1 PROP PROPR MPRP Forecast Profiles PROPR