SAP ABAP View WFCS_MDST_V (View via Master Data for Standard Forecasting)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ MM-CBP (Application Component) Consumption-Based Planning (See Also PP-MRP)
     ⤷ WFCS (Package) IS-R: Sales Forecasting for Stores

Basic Data

View Type	D	Database View
Database View	WFCS_MDST_V
Short Description	View via Master Data for Standard Forecasting
Root table	MAPR	Material Index for Forecast

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MAPR	MAPR
2	PROP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MAPR	MANDT	JL	EQ				0	0
2	PROP	MANDT	JR	EQ			AND	0	0
3	MAPR	PNUM1	JL	EQ				0	0
4	PROP	PNUM1	JR	EQ			AND	0	0
5	PROP	HSNUM		EQ	'00'		AND	0	0
6	PROP	VERSP		EQ	'00'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MAPR	MANDT		☐	MANDT	☐	Client
2	WERKS	MAPR	WERKS		☐	WERKS_D	☐	Plant
3	MATNR	MAPR	MATNR		☐	MATNR	☐	Material Number
4	PNUM1	PROP	PNUM1		☐	PNUM1	☐	Pointer: forecast parameters
5	HSNUM	PROP	HSNUM		☐	HSNUM	☐	Number for history
6	VERSP	PROP	VERSP		☐	VERSP	☐	Version number of forecast parameters
7	PNUM2	PROP	PNUM2		☐	PNUM2	☐	Pointer for forecast results
8	PROPR	PROP	PROPR		☐	PROPR	☐	Forecast profile
9	PERKZ	MAPR	PERKZ		☐	PERKZ	☐	Period indicator
10	PERIV	MAPR	PERIV		☐	PERIV	☐	Fiscal Year Variant
11	MODAW	PROP	MODAW		☐	MODAW	☐	Model Selection Indicator
12	MODAV	PROP	MODAV		☐	MODAV	☐	Model selection procedure
13	KZPAR	PROP	KZPAR		☐	KZPAR	☐	Indicator for parameter optimization
14	OPGRA	PROP	OPGRA		☐	OPGRA	☐	Optimization level
15	KZINI	PROP	KZINI		☐	KZINI	☐	Initialization indicator
16	PRMOD	PROP	PRMOD		☐	PRMOD	☐	Forecast model
17	ALPHA	PROP	ALPHA		☐	ALPHA	☐	Basic value smoothing using alpha factor
18	BETA1	PROP	BETA1		☐	BETA1	☐	Trend value smoothing using the beta factor
19	GAMMA	PROP	GAMMA		☐	GAMMA	☐	Seasonal index smoothing using gamma factor
20	DELTA	PROP	DELTA		☐	DELTA	☐	MAD (mean absolute deviation) smoothing using delta factor
21	EPSIL	PROP	EPSIL		☐	EPSIL	☐	Epsilon factor
22	SIGGR	PROP	SIGGR		☐	SIGGR	☐	Tracking limit
23	PRDAT	PROP	PRDAT		☐	PRDAT	☐	Date of last forecast
24	PERAN	PROP	PERAN		☐	PERAN	☐	Number of historical periods
25	PERIN	PROP	PERIN		☐	PERIN	☐	Number of periods for initialization
26	PERIO	PROP	PERIO		☐	PERIO	☐	Number of periods per seasonal cycle
27	PEREX	PROP	PEREX		☐	PEREX	☐	Number of periods for ex-post forecasting
28	ANZPR	PROP	ANZPR		☐	ANZPR	☐	Number of forecast periods
29	FIMON	PROP	FIMON		☐	FIMON	☐	Fixed periods
30	GWERT	PROP	GWERT		☐	GWERT	☐	Basic value
31	GWER1	PROP	GWER1		☐	GWER2	☐	Basic value of the 2nd order
32	GWER2	PROP	GWER2		☐	GWER2	☐	Basic value of the 2nd order
33	VMGWE	PROP	VMGWE		☐	VMGWE	☐	Basic value of previous period
34	VMGW1	PROP	VMGW1		☐	VMGW2	☐	Base value of the second order in previous period
35	VMGW2	PROP	VMGW2		☐	VMGW2	☐	Base value of the second order in previous period
36	TWERT	PROP	TWERT		☐	TWERT	☐	Trend value
37	VMTWE	PROP	VMTWE		☐	VMTWE	☐	Trend value of previous period
38	PRMAD	PROP	PRMAD		☐	PRMAD	☐	Mean absolute deviation (MAD)
39	VMMAD	PROP	VMMAD		☐	VMMAD	☐	Mean absolute devaition of previous period
40	FSUMM	PROP	FSUMM		☐	FSUMM	☐	Error total
41	VMFSU	PROP	VMFSU		☐	VMFSU	☐	Error total for the previous period
42	GEWGR	PROP	GEWGR		☐	GEWGR	☐	Weighting group
43	THKOF	PROP	THKOF		☐	THKOF	☐	Theil coefficient
44	AUSNA	PROP	AUSNA		☐	AUSNA	☐	Exception message bar
45	PROAB	PROP	PROAB		☐	PROAB	☐	Forecast flow control
46	VBKEZ	PROP	VBKEZ		☐	VBKEZ	☐	Indicator: base forecast on consumption values
47	STATU	PROP	STATU		☐	VSSTA	☐	LIS version status
48	VETXT	PROP	VETXT		☐	VETXT	☐	Version description
49	PRWUG	PROP	PRWUG		☐	PRWUG	☐	Forecast: Lower limit
50	PRWOG	PROP	PRWOG		☐	PRWOG	☐	Forecast: Upper limit
51	PRROS	PROP	PRROS		☐	PRROS	☐	Forecast: Sale rate
52	PRKUM	PROP	PRKUM		☐	PRKUM	☐	Cumulative forecast result
53	PRZGF	PROP	PRZGF		☐	PRZGF	☐	Pointer: Forecast weighting factor
54	AKTPE	PROP	AKTPE		☐	AKTPE	☐	Current period
55	FAUSR	PROP	FAUSR		☐	FAUSR	☐	Indicator: correction of outliers for forecast
56	SIGMA	PROP	SIGMA		☐	SIGMX	☐	Sigma factor
57	FLGEXC	PROP	FLGEXC		☐	FLGEXC	☐	Indicator: automatic correction of outliers
58	FLGCOR	PROP	FLGCOR		☐	FLGCOR	☐	Indicator: use corrected historical values for forecast

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C