SAP ABAP Table /SAPAPO/DP440P (Univariate Forecast Profile (APO0326))
Hierarchy
☛
SAP_BW (Software Component) SAP Business Warehouse
⤷
SCM-BAS (Application Component) SCM Basis
⤷
/SAPAPO/SCMB_FORECAST (Package) Forecast
SAP_BW (Software Component) SAP Business Warehouse⤷
SCM-BAS (Application Component) SCM Basis⤷
/SAPAPO/SCMB_FORECAST (Package) Forecast
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | /SAPAPO/DP440P |
Table Relationship Diagram 
|
| Short Description | Univariate Forecast Profile (APO0326) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
/SAPAPO/MANDT | /SAPAPO/MANDT | CLNT | 3 | 0 | Client | * | |
| 2 | STATPF |
/SAPAPO/PRPFL | /SAPAPO/PRPFL | CHAR | 22 | 0 | Master Forecast Profile | * | |
| 3 | PAREAID |
/SAPAPO/SCMB_PAREAID | /SAPAPO/SCMB_PAREAID | CHAR | 40 | 0 | Name of DP and SNP Planning Area | ||
| 4 | GUID |
/SAPAPO/FLG_GUID | /SAPAPO/FLG_GUID | CHAR | 1 | 0 | Indicator for Whether a GUID Exists | ||
| 5 | PFITX |
/SAPAPO/PFITX | /SAPAPO/TEXT60 | CHAR | 60 | 0 | Profile Description | ||
| 6 | KENNZ |
/SAPAPO/KRIT3 | /SAPAPO/KRIT1 | CHAR | 20 | 0 | Key Figure | ||
| 7 | VRSIO |
/SAPAPO/VRSIA | /SAPAPO/CHAR10 | CHAR | 10 | 0 | Planning Version Number | ||
| 8 | VRSIOID |
/SAPAPO/SCMB_VRSIOID | /SAPAPO/SCMB_VRSIOID | CHAR | 22 | 0 | Name of Planning Version | ||
| 9 | PRSTR |
/SAPAPO/PRSTR | /SAPAPO/PRSTR | CHAR | 2 | 0 | Forecast Strategy | ||
| 10 | ALPHX |
/SAPAPO/ALPHX | /SAPAPO/GLATT | DEC | 3 | 2 | Alpha Factor | ||
| 11 | ALPH2 |
/SAPAPO/ALPH2 | /SAPAPO/GLATT | DEC | 3 | 2 | Alpha Factor for Second-Order Exponential Smoothing | ||
| 12 | BETAX |
/SAPAPO/BETAX | /SAPAPO/GLATT | DEC | 3 | 2 | Beta Factor | ||
| 13 | GAMMX |
/SAPAPO/GAMMX | /SAPAPO/GLATT | DEC | 3 | 2 | Gamma Factor | ||
| 14 | SIGMA |
/SAPAPO/SIGMX | /SAPAPO/GLATT | DEC | 3 | 2 | Sigma Factor | ||
| 15 | PERIO |
/SAPAPO/PERIO | /SAPAPO/PERAN | DEC | 5 | 0 | Number of Periods per Seasonal Cycle | ||
| 16 | PERSMO |
/SAPAPO/PERSMO | /SAPAPO/PERMO | DEC | 3 | 0 | Number of Periods for Calculation of Average | ||
| 17 | FNULL |
/SAPAPO/FNULL | /SAPAPO/X | CHAR | 1 | 0 | Indicator: Do Not Include Zero Consumptions in Forecast | ||
| 18 | GEWGR_TSID |
/SAPAPO/TSID | /SAPAPO/TSID | CHAR | 22 | 0 | Time Series ID | /SAPAPO/GEWICHT | |
| 19 | AVGPER |
/SAPAPO/AVGPER | /SAPAPO/INT4 | INT4 | 10 | 0 | Average Number of Days in Forecast Period | ||
| 20 | FLGEXC |
/SAPAPO/FLGEXC | /SAPAPO/FLGEXC | CHAR | 1 | 0 | Indicator: Automatic Outlier Correction | ||
| 21 | FLGCOR |
/SAPAPO/FLGCOR | /SAPAPO/CHAR01 | CHAR | 1 | 0 | Indicator: Use Corrected History | ||
| 22 | FLGCORAUTO |
/SAPAPO/FLGCORAUTO | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | Automatic Adjustment of Corrected History | ||
| 23 | FLGIGNORE |
/SAPAPO/FLGIGNORE | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | Indicator: Forecast Ignores Selected Values | ||
| 24 | FMAD |
/SAPAPO/FMAD | /SAPAPO/XFELD | CHAR | 1 | 0 | MAD (Mean Absolute Deviation) Indicator | ||
| 25 | FFSUMM |
/SAPAPO/FFSUM | /SAPAPO/XFELD | CHAR | 1 | 0 | Error Total Indicator | ||
| 26 | FMPE |
/SAPAPO/FMPE | /SAPAPO/XFELD | CHAR | 1 | 0 | MPE (Mean Percentage Error) Indicator | ||
| 27 | FMAPE |
/SAPAPO/FMAPE | /SAPAPO/XFELD | CHAR | 1 | 0 | MAPE (Mean Absolute Percentage Error) Indicator | ||
| 28 | FMSE |
/SAPAPO/FMSE | /SAPAPO/XFELD | CHAR | 1 | 0 | MSE (Mean Square Error) Indicator | ||
| 29 | FRMSE |
/SAPAPO/FRMSE | /SAPAPO/XFELD | CHAR | 1 | 0 | RMSE (Root of the Mean Square Error) Indicator | ||
| 30 | TD_TSID |
/SAPAPO/TSID | /SAPAPO/TSID | CHAR | 22 | 0 | Time Series ID | /SAPAPO/TRENDAM | |
| 31 | MARK_TSID |
/SAPAPO/TSID | /SAPAPO/TSID | CHAR | 22 | 0 | Time Series ID | * | |
| 32 | BOUNDPF |
/SAPAPO/BNAME | /SAPAPO/BNAME | CHAR | 22 | 0 | Diagnosis Group | /SAPAPO/T_UNIBDS | |
| 33 | KORRHIST_KENNZ |
/SAPAPO/KRIT3 | /SAPAPO/KRIT1 | CHAR | 20 | 0 | Key Figure | ||
| 34 | PROMOTION_KENNZ |
/SAPAPO/KRIT3 | /SAPAPO/KRIT1 | CHAR | 20 | 0 | Key Figure | ||
| 35 | FLG_PROMO_MARK |
/SAPAPO/FLG_PROMO_MARK | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | Promotion Selects Historical Values | ||
| 36 | FLG_PROMO_CHANGE |
/SAPAPO/FLG_PROMO_CHANGE | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | Promotion Changes Historical Values | ||
| 37 | FLG_SPORADIC |
/SAPAPO/FLG_SPORADIC | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | Generate Sporadic Forecast | ||
| 38 | FLG_NK |
/SAPAPO/FLG_NK2 | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | Add Up Decimal Places | ||
| 39 | FLG_56 |
/SAPAPO/FLG_56 | /SAPAPO/FLG_56 | CHAR | 1 | 0 | Error Measure for Automatic Model Selection 2 | ||
| 40 | PERIO_VARIATION |
/SAPAPO/PERIO_VARIATION | /SAPAPO/PERAN | DEC | 5 | 0 | Variation of Time Period Length | ||
| 41 | ALPHA_START |
/SAPAPO/ALPHA | /SAPAPO/GLATT | DEC | 3 | 2 | Basic value smoothing using alpha factor | ||
| 42 | ALPHA_ENDE |
/SAPAPO/ALPHA | /SAPAPO/GLATT | DEC | 3 | 2 | Basic value smoothing using alpha factor | ||
| 43 | ALPHA_WEITE |
/SAPAPO/WEITE | /SAPAPO/GLATT | DEC | 3 | 2 | Increment | ||
| 44 | BETA_START |
/SAPAPO/BETA1 | /SAPAPO/GLATT | DEC | 3 | 2 | Beta Factor (Trend Value Smoothing) | ||
| 45 | BETA_ENDE |
/SAPAPO/BETA1 | /SAPAPO/GLATT | DEC | 3 | 2 | Beta Factor (Trend Value Smoothing) | ||
| 46 | BETA_WEITE |
/SAPAPO/WEITE | /SAPAPO/GLATT | DEC | 3 | 2 | Increment | ||
| 47 | GAMMA_START |
/SAPAPO/GAMMA | /SAPAPO/GLATT | DEC | 3 | 2 | Seasonal index smoothing using gamma factor | ||
| 48 | GAMMA_ENDE |
/SAPAPO/GAMMA | /SAPAPO/GLATT | DEC | 3 | 2 | Seasonal index smoothing using gamma factor | ||
| 49 | GAMMA_WEITE |
/SAPAPO/WEITE | /SAPAPO/GLATT | DEC | 3 | 2 | Increment | ||
| 50 | PRF_EXTENSION |
/SAPAPO/PRPFL | /SAPAPO/PRPFL | CHAR | 22 | 0 | Master Forecast Profile | * | |
| 51 | .INCLUDE |
0 | 0 | Reinitialization Settings | |||||
| 52 | FLG_REINIT |
/SAPAPO/FCSTFLAG | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | General Indicator in Forecasting | ||
| 53 | REINIT_NE_HIST |
/SAPAPO/REINIT_NE_HIST | /SAPAPO/REINIT_NE_HIST | CHAR | 1 | 0 | Action When Not Enough History is Available to Reinitialize | ||
| 54 | REINIT_STABLE |
/SAPAPO/REINIT_STABLE | /SAPAPO/REINIT_STABLE | INT4 | 10 | 0 | Number of Stable Periods After Reinitialization | ||
| 55 | FLG_TREND_DAMP |
/SAPAPO/FCSTFLAG | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | General Indicator in Forecasting | ||
| 56 | PHI |
/SAPAPO/PHI | /SAPAPO/GLATT | DEC | 3 | 2 | Factor Dampening the Trend Value | ||
| 57 | FLG_PHI_AUTO |
/SAPAPO/FCSTFLAG | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | General Indicator in Forecasting | ||
| 58 | PHI_START |
/SAPAPO/PHI | /SAPAPO/GLATT | DEC | 3 | 2 | Factor Dampening the Trend Value | ||
| 59 | PHI_END |
/SAPAPO/PHI | /SAPAPO/GLATT | DEC | 3 | 2 | Factor Dampening the Trend Value | ||
| 60 | PHI_STEP |
/SAPAPO/PHI | /SAPAPO/GLATT | DEC | 3 | 2 | Factor Dampening the Trend Value | ||
| 61 | MAX_TREND |
/SAPAPO/MAXVAL | DEC | 16 | 3 | Maximum Value | |||
| 62 | MAX_FORECAST |
/SAPAPO/MAXVAL | DEC | 16 | 3 | Maximum Value | |||
| 63 | .INCLUDE |
0 | 0 | Event Forecast Checkboxes | |||||
| 64 | CLEAN |
/SAPAPO/DP_EV_FLG_CLEAN | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | Clean History from Impact of Historical Events | ||
| 65 | EST_RECUR |
/SAPAPO/DP_EV_FLG_EST_RECUR | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | Estimate Future Recurring Events Automatically | ||
| 66 | EVCAT |
/SAPAPO/DP_EVCATID | CHAR | 22 | 0 | Event Catalog ID | |||
| 67 | MLRPF_FOR_UNIV |
/SAPAPO/MLRPF_FOR_UNIV | /SAPAPO/PRPFL | CHAR | 22 | 0 | MLR Profile for Univariate Forecasting | * | |
| 68 | FLG_SEAGRP |
/SAPAPO/FLAG_SEAGRP | /SAPAPO/FCSTFLAG | CHAR | 1 | 0 | Consider Group Seasonality | ||
| 69 | PRICE_CHG_THR |
/SAPAPO/PRICE_CHANGE_THRESHOLD | DEC | 6 | 2 | Price Change Threshold |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /SAPAPO/DP440P | BOUNDPF |  /SAPAPO/T_UNIBDS |
NAME |
|||
| 2 | /SAPAPO/DP440P | GEWGR_TSID | /SAPAPO/GEWICHT |
TSID |
|||
| 3 | /SAPAPO/DP440P | TD_TSID | /SAPAPO/TRENDAM |
TSID |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
