| 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 | * | /SAPAPO/MANDT | Allow NULL? |
| 2 | STATPF | Master Forecast Profile | nvarchar | 22 | 0 | CHAR | (N' ') | No | * | /SAPAPO/PRPFL | Allow NULL? |
| 3 | PAREAID | Name of DP and SNP Planning Area | nvarchar | 40 | 0 | CHAR | (N' ') | No | | /SAPAPO/SCMB_PAREAID | Allow NULL? |
| 4 | GUID | Indicator for Whether a GUID Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLG_GUID | Allow NULL? |
| 5 | PFITX | Profile Description | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/PFITX | Allow NULL? |
| 6 | KENNZ | Key Figure | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/KRIT3 | Allow NULL? |
| 7 | VRSIO | Planning Version Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/VRSIA | Allow NULL? |
| 8 | VRSIOID | Name of Planning Version | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/SCMB_VRSIOID | Allow NULL? |
| 9 | PRSTR | Forecast Strategy | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/PRSTR | Allow NULL? |
| 10 | ALPHX | Alpha Factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/ALPHX | |
| 11 | ALPH2 | Alpha Factor for Second-Order Exponential Smoothing | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/ALPH2 | |
| 12 | BETAX | Beta Factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/BETAX | |
| 13 | GAMMX | Gamma Factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/GAMMX | |
| 14 | SIGMA | Sigma Factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/SIGMX | |
| 15 | PERIO | Number of Periods per Seasonal Cycle | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPAPO/PERIO | |
| 16 | PERSMO | Number of Periods for Calculation of Average | decimal | 3 | 0 | DEC | ((0)) | Yes | | /SAPAPO/PERSMO | |
| 17 | FNULL | Indicator: Do Not Include Zero Consumptions in Forecast | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FNULL | Allow NULL? |
| 18 | GEWGR_TSID | Time Series ID | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | /SAPAPO/GEWICHT | /SAPAPO/TSID | Allow NULL? |
| 19 | AVGPER | Average Number of Days in Forecast Period | int | 10 | 0 | INT4 | ((0)) | Yes | | /SAPAPO/AVGPER | Allow NULL? |
| 20 | FLGEXC | Indicator: Automatic Outlier Correction | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLGEXC | Allow NULL? |
| 21 | FLGCOR | Indicator: Use Corrected History | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLGCOR | Allow NULL? |
| 22 | FLGCORAUTO | Automatic Adjustment of Corrected History | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLGCORAUTO | Allow NULL? |
| 23 | FLGIGNORE | Indicator: Forecast Ignores Selected Values | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLGIGNORE | Allow NULL? |
| 24 | FMAD | MAD (Mean Absolute Deviation) Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FMAD | Allow NULL? |
| 25 | FFSUMM | Error Total Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FFSUM | Allow NULL? |
| 26 | FMPE | MPE (Mean Percentage Error) Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FMPE | Allow NULL? |
| 27 | FMAPE | MAPE (Mean Absolute Percentage Error) Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FMAPE | Allow NULL? |
| 28 | FMSE | MSE (Mean Square Error) Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FMSE | Allow NULL? |
| 29 | FRMSE | RMSE (Root of the Mean Square Error) Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FRMSE | Allow NULL? |
| 30 | TD_TSID | Time Series ID | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | /SAPAPO/TRENDAM | /SAPAPO/TSID | Allow NULL? |
| 31 | MARK_TSID | Time Series ID | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | /SAPAPO/TSID | Allow NULL? |
| 32 | BOUNDPF | Diagnosis Group | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | /SAPAPO/T_UNIBDS | /SAPAPO/BNAME | Allow NULL? |
| 33 | KORRHIST_KENNZ | Key Figure | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/KRIT3 | Allow NULL? |
| 34 | PROMOTION_KENNZ | Key Figure | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/KRIT3 | Allow NULL? |
| 35 | FLG_PROMO_MARK | Promotion Selects Historical Values | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLG_PROMO_MARK | Allow NULL? |
| 36 | FLG_PROMO_CHANGE | Promotion Changes Historical Values | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLG_PROMO_CHANGE | Allow NULL? |
| 37 | FLG_SPORADIC | Generate Sporadic Forecast | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLG_SPORADIC | Allow NULL? |
| 38 | FLG_NK | Add Up Decimal Places | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLG_NK2 | Allow NULL? |
| 39 | FLG_56 | Error Measure for Automatic Model Selection 2 | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLG_56 | Allow NULL? |
| 40 | PERIO_VARIATION | Variation of Time Period Length | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPAPO/PERIO_VARIATION | |
| 41 | ALPHA_START | Basic value smoothing using alpha factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/ALPHA | |
| 42 | ALPHA_ENDE | Basic value smoothing using alpha factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/ALPHA | |
| 43 | ALPHA_WEITE | Increment | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/WEITE | |
| 44 | BETA_START | Beta Factor (Trend Value Smoothing) | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/BETA1 | |
| 45 | BETA_ENDE | Beta Factor (Trend Value Smoothing) | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/BETA1 | |
| 46 | BETA_WEITE | Increment | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/WEITE | |
| 47 | GAMMA_START | Seasonal index smoothing using gamma factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/GAMMA | |
| 48 | GAMMA_ENDE | Seasonal index smoothing using gamma factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/GAMMA | |
| 49 | GAMMA_WEITE | Increment | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/WEITE | |
| 50 | PRF_EXTENSION | Master Forecast Profile | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | /SAPAPO/PRPFL | Allow NULL? |
| 51 | FLG_REINIT | General Indicator in Forecasting | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FCSTFLAG | Allow NULL? |
| 52 | REINIT_NE_HIST | Action When Not Enough History is Available to Reinitialize | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/REINIT_NE_HIST | Allow NULL? |
| 53 | REINIT_STABLE | Number of Stable Periods After Reinitialization | int | 10 | 0 | INT4 | ((0)) | Yes | | /SAPAPO/REINIT_STABLE | Allow NULL? |
| 54 | FLG_TREND_DAMP | General Indicator in Forecasting | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FCSTFLAG | Allow NULL? |
| 55 | PHI | Factor Dampening the Trend Value | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/PHI | |
| 56 | FLG_PHI_AUTO | General Indicator in Forecasting | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FCSTFLAG | Allow NULL? |
| 57 | PHI_START | Factor Dampening the Trend Value | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/PHI | |
| 58 | PHI_END | Factor Dampening the Trend Value | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/PHI | |
| 59 | PHI_STEP | Factor Dampening the Trend Value | decimal | 3 | 2 | DEC | ((0)) | Yes | | /SAPAPO/PHI | |
| 60 | MAX_TREND | Maximum Value | decimal | 16 | 3 | DEC | ((0)) | Yes | | /SAPAPO/MAXVAL | |
| 61 | MAX_FORECAST | Maximum Value | decimal | 16 | 3 | DEC | ((0)) | Yes | | /SAPAPO/MAXVAL | |
| 62 | CLEAN | Clean History from Impact of Historical Events | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/DP_EV_FLG_CLEAN | Allow NULL? |
| 63 | EST_RECUR | Estimate Future Recurring Events Automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/DP_EV_FLG_EST_RECUR | Allow NULL? |
| 64 | EVCAT | Event Catalog ID | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/DP_EVCATID | Allow NULL? |
| 65 | MLRPF_FOR_UNIV | MLR Profile for Univariate Forecasting | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | /SAPAPO/MLRPF_FOR_UNIV | Allow NULL? |
| 66 | FLG_SEAGRP | Consider Group Seasonality | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/FLAG_SEAGRP | Allow NULL? |
| 67 | PRICE_CHG_THR | Price Change Threshold | decimal | 6 | 2 | DEC | ((0)) | Yes | | /SAPAPO/PRICE_CHANGE_THRESHOLD | |
