SAP ABAP Table WFCS_MDST_V (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	WFCS_MDST_V	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WFCS_MDST_V	MANDT	T000	MANDT	KEY	1	CN
2	WFCS_MDST_V	MATNR	MARA	MATNR	KEY	1	CN
3	WFCS_MDST_V	PERIV	T009	PERIV	REF	C	CN
4	WFCS_MDST_V	PNUM2	PROW	PNUM2	REF	1	1
5	WFCS_MDST_V	PROPR	MPRP	PROPR	REF	1	CN
6	WFCS_MDST_V	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in