SAP PROP Forecast parameters Table data and field list

PROP is a standard SAP Table which is used to store Forecast parameters data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PROP table consists of various fields, each holding specific information or linking keys about Forecast parameters data available in SAP. These include PNUM1 (Pointer: forecast parameters), HSNUM (Number for history), VERSP (Version number of forecast parameters), PNUM2 (Pointer for forecast results)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

PROP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP PROP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PROP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PNUM1Pointer: forecast parameters PNUM1NUMC10PNUM1
HSNUMNumber for history HSNUMCHAR2HSNUM
VERSPVersion number of forecast parameters VERSPCHAR2VERSP
PNUM2Pointer for forecast results PNUM2NUMC10PROWPNUM2
PROPRForecast profile PROPRCHAR4MPRPPROPRPPR
MODAWModel Selection Indicator MODAWCHAR1MODAW
MODAVModel selection procedure MODAVCHAR1MODAV
KZPARIndicator for parameter optimization KZPARCHAR1XFELD
OPGRAOptimization level OPGRACHAR1OPGRA
KZINIInitialization indicator KZINICHAR1KZINI
PRMODForecast model PRMODCHAR1PRMOD
ALPHABasic value smoothing using alpha factor ALPHADEC3(2) GLATT
BETA1Trend value smoothing using the beta factor BETA1DEC3(2) GLATT
GAMMASeasonal index smoothing using gamma factor GAMMADEC3(2) GLATT
DELTAMAD (mean absolute deviation) smoothing using delta factor DELTADEC3(2) GLATT
EPSILEpsilon factor EPSILDEC3(2) GLATT
SIGGRTracking limit SIGGRDEC5(3) SIGGR
PRDATDate of last forecast PRDATDATS8DATUM
PERANNumber of historical periods PERANDEC3PERAN
PERINNumber of periods for initialization PERINDEC3PERAN
PERIONumber of periods per seasonal cycle PERIODEC3PERAN
PEREXNumber of periods for ex-post forecasting PEREXDEC3PERAN
ANZPRNumber of forecast periods ANZPRDEC3PERAN
FIMONFixed periods FIMONDEC3PERAN
GWERTBasic value GWERTQUAN13(3) MENGV13
GWER1Basic value of the 2nd order GWER2QUAN13(3) MENGV13
GWER2Basic value of the 2nd order GWER2QUAN13(3) MENGV13
VMGWEBasic value of previous period VMGWEQUAN13(3) MENGV13
VMGW1Base value of the second order in previous period VMGW2QUAN13(3) MENGV13
VMGW2Base value of the second order in previous period VMGW2QUAN13(3) MENGV13
TWERTTrend value TWERTQUAN13(3) MENGV13
VMTWETrend value of previous period VMTWEQUAN13(3) MENGV13
PRMADMean absolute deviation (MAD) PRMADQUAN13(3) MENG13
VMMADMean absolute devaition of previous period VMMADQUAN13(3) MENG13
FSUMMError total FSUMMQUAN13(3) MENGV13
VMFSUError total for the previous period VMFSUQUAN13(3) MENGV13
GEWGRWeighting group GEWGRCHAR2Assigned to domainGEWGR
THKOFTheil coefficient THKOFDEC5(2) DEC3_2
AUSNAException message bar AUSNACHAR30TEXT30
PROABForecast flow control PROABCHAR10CHAR10
VBKEZIndicator: base forecast on consumption values VBKEZCHAR1X
STATULIS version status VSSTACHAR1CHAR01
VETXTVersion description VETXTCHAR40TEXT40
PRWUGForecast: Lower limit PRWUGQUAN13(3) MENGV13
PRWOGForecast: Upper limit PRWOGQUAN13(3) MENGV13
PRROSForecast: Sale rate PRROSQUAN13(3) MENGV13
PRKUMCumulative forecast result PRKUMQUAN13(3) MENGV13
PRZGFPointer: Forecast weighting factor PRZGFNUMC10PRZGF
AKTPECurrent period AKTPEDEC3PERI3
FAUSRIndicator: correction of outliers for forecast FAUSRCHAR1X
SIGMASigma factor SIGMXDEC3(2) GLATT
FLGEXCIndicator: automatic correction of outliers FLGEXCCHAR1CHAR01
FLGCORIndicator: use corrected historical values for forecast FLGCORCHAR1CHAR01

Key field Non-key field



How do I retrieve data from SAP table PROP using ABAP code

The following ABAP code Example will allow you to do a basic selection on PROP to SELECT all data from the table
DATA: WA_PROP TYPE PROP.

SELECT SINGLE *
FROM PROP
INTO CORRESPONDING FIELDS OF WA_PROP
WHERE...

How to access SAP table PROP

Within an ECC or HANA version of SAP you can also view further information about PROP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).