| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | CALCPARAMS_CODE | Forecasting Technique | nvarchar | 20 | 0 | CHAR | (N' ') | No | | WFA_FC_CALCPARAMS_CODE | Allow NULL? |
| 3 | PRMOD | Forecast model | char | 1 | 0 | CHAR | (N' ') | Yes | | PRMOD | Allow NULL? |
| 4 | MODAW | Model Selection Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | MODAW | Allow NULL? |
| 5 | MODAV | Model selection procedure | char | 1 | 0 | CHAR | (N' ') | Yes | | MODAV | Allow NULL? |
| 6 | KZPAR | Indicator for parameter optimization | char | 1 | 0 | CHAR | (N' ') | Yes | | KZPAR | Allow NULL? |
| 7 | OPGRA | Optimization level | char | 1 | 0 | CHAR | (N' ') | Yes | | OPGRA | Allow NULL? |
| 8 | KZINI | Initialization indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZINI | Allow NULL? |
| 9 | ALPHA | Basic value smoothing using alpha factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | ALPHA | |
| 10 | BETA1 | Trend value smoothing using the beta factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | BETA1 | |
| 11 | GAMMA | Seasonal index smoothing using gamma factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | GAMMA | |
| 12 | DELTA | MAD (mean absolute deviation) smoothing using delta factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | DELTA | |
| 13 | EPSIL | Epsilon factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | EPSIL | |
| 14 | SIGGR | Tracking limit | decimal | 5 | 3 | DEC | ((0)) | Yes | | SIGGR | |
| 15 | PERAN | Number of historical periods | decimal | 3 | 0 | DEC | ((0)) | Yes | | PERAN | |
| 16 | PERIN | Number of periods for initialization | decimal | 3 | 0 | DEC | ((0)) | Yes | | PERIN | |
| 17 | PEREX | Number of periods for ex-post forecasting | decimal | 3 | 0 | DEC | ((0)) | Yes | | PEREX | |
| 18 | PERIO | Number of periods per seasonal cycle | decimal | 3 | 0 | DEC | ((0)) | Yes | | PERIO | |
| 19 | ANZPR | Number of forecast periods | decimal | 3 | 0 | DEC | ((0)) | Yes | | ANZPR | |
| 20 | FIMON | Fixed periods | decimal | 3 | 0 | DEC | ((0)) | Yes | | FIMON | |
| 21 | LGRAD | Service level | decimal | 3 | 1 | DEC | ((0)) | Yes | | LGRAD | |
| 22 | GWERT | Basic value | decimal | 13 | 3 | QUAN | ((0)) | Yes | | GWERT | |
| 23 | VMGWE | Basic value of previous period | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VMGWE | |
| 24 | GWER1 | Basic value of the 2nd order | decimal | 13 | 3 | QUAN | ((0)) | Yes | | GWER2 | |
| 25 | VMGW1 | Base value of the second order in previous period | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VMGW2 | |
| 26 | GWER2 | Basic value of the 2nd order | decimal | 13 | 3 | QUAN | ((0)) | Yes | | GWER2 | |
| 27 | VMGW2 | Base value of the second order in previous period | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VMGW2 | |
| 28 | TWERT | Trend value | decimal | 13 | 3 | QUAN | ((0)) | Yes | | TWERT | |
| 29 | VMTWE | Trend value of previous period | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VMTWE | |
| 30 | PRMAD | Mean absolute deviation (MAD) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | PRMAD | |
| 31 | VMMAD | Mean absolute devaition of previous period | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VMMAD | |
| 32 | FSUMM | Error total | decimal | 13 | 3 | QUAN | ((0)) | Yes | | FSUMM | |
| 33 | VMFSU | Error total for the previous period | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VMFSU | |
| 34 | AUSNA | Exception message bar | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AUSNA | Allow NULL? |
| 35 | PROAB | Forecast flow control | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PROAB | Allow NULL? |
| 36 | KZOKO | Indicator: suppress places after decimal point | char | 1 | 0 | CHAR | (N' ') | Yes | | KZOKO | Allow NULL? |
| 37 | GEWGR | Weighting group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | GEWGR | Allow NULL? |
| 38 | THKOF | Theil coefficient | decimal | 5 | 2 | DEC | ((0)) | Yes | | THKOF | |
| 39 | NULLV | Zero distribution | char | 1 | 0 | CHAR | (N' ') | Yes | | NULLV | Allow NULL? |
| 40 | PRWUG | Forecast: Lower limit | decimal | 13 | 3 | QUAN | ((0)) | Yes | | PRWUG | |
| 41 | PRWOG | Forecast: Upper limit | decimal | 13 | 3 | QUAN | ((0)) | Yes | | PRWOG | |
| 42 | PRROS | Forecast: Sale rate | decimal | 13 | 3 | QUAN | ((0)) | Yes | | PRROS | |
| 43 | PRKUM | Cumulative forecast result | decimal | 13 | 3 | QUAN | ((0)) | Yes | | PRKUM | |
| 44 | PRZGF | Pointer: Forecast weighting factor | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PRZGF | Allow NULL? |
| 45 | AKTPE | Current period | decimal | 3 | 0 | DEC | ((0)) | Yes | | AKTPE | |
