Follow us on LinkedIn for your next SAP project
← Back to Search

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 Possible values
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
MODAV
Model selection procedure
 MODAV
CHAR
 1 0
KZPAR
Indicator for parameter optimization
 KZPAR
CHAR
 1 0
OPGRA
Optimization level
 OPGRA
CHAR
 1 0
KZINI
Initialization indicator
 KZINI
CHAR
 1 0
PRMOD
Forecast model
 PRMOD
CHAR
 1 0
ALPHA
Basic value smoothing using alpha factor
 ALPHA
DEC
 3 2
BETA1
Trend value smoothing using the beta factor
 BETA1
DEC
 3 2
GAMMA
Seasonal index smoothing using gamma factor
 GAMMA
DEC
 3 2
DELTA
MAD (mean absolute deviation) smoothing using delta factor
 DELTA
DEC
 3 2
EPSIL
Epsilon factor
 EPSIL
DEC
 3 2
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
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
SIGMA
Sigma factor
 SIGMX
DEC
 3 2
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 MANDT PROW
Forecast Values
 MANDT
PROP PNUM2 PROP PNUM2 PROW
Forecast Values
 PNUM2
PROP PNUM2 PROP PRDAT PROW
Forecast Values
 ERTAG
PROP PROPR PROP MANDT MPRP
Forecast Profiles
 MANDT
PROP PROPR PROP PROPR MPRP
Forecast Profiles
 PROPR