SAP ABAP Table WFCS_MDST_KEY (Combined Structure: Keys for Movement Data & Master Data)

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

Table Category	INTTAB	Structure
Structure	WFCS_MDST_KEY	Table Relationship Diagram
Short Description	Combined Structure: Keys for Movement Data & Master Data

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
2	.INCLUDE				0	0	Key Structure for Access Table WRFT
3	.INCLUDE				0	0	Key WRPL
4	KUNNR	WRKUNNR	KUNNR	CHAR	10	0	Recipient	*
5	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
6	DAT_FROM_H	WFCS_DAT_FROM	DATUM	DATS	8	0	From Date
7	DAT_TO_H	WFCS_DAT_TO	DATUM	DATS	8	0	To Date
8	DAT_FROM_F	WFCS_DAT_FROM	DATUM	DATS	8	0	From Date
9	DAT_TO_F	WFCS_DAT_TO	DATUM	DATS	8	0	To Date
10	.INCLUDE				0	0	PROP Pointer for Master and Movement Data for Forecasting
11	PNUM1	PNUM1	PNUM1	NUMC	10	0	Pointer: forecast parameters	*
12	PNUM2	PNUM2	PNUM2	NUMC	10	0	Pointer for forecast results	*
13	PROPR	PROPR	PROPR	CHAR	4	0	Forecast profile	*
14	.INCLUDE				0	0	Parameter Structure for Time Series
15	PERKZ	WFCS_PERKZ	PERKZ	CHAR	1	0	Period Indicator
16	PERIV	WFCS_PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
17	FABKL	WFCS_FABKL	WFCID	CHAR	2	0	Factory calendar key	*
18	PRDAT	PRDAT	DATUM	DATS	8	0	Date of last forecast
19	.INCLUDE				0	0	WFCS Copy: Transfer Structure PCOM for Module "Forecast"
20	PRMOD	WFCS_PRMOD	WFCS_PRMOD	CHAR	1	0	WFCS Copy: PRMOD/Forecast Model
21	MODAW	MODAW	MODAW	CHAR	1	0	Model Selection Indicator
22	MODAV	MODAV	MODAV	CHAR	1	0	Model selection procedure
23	KZPAR	KZPAR	XFELD	CHAR	1	0	Indicator for parameter optimization
24	OPGRA	OPGRA	OPGRA	CHAR	1	0	Optimization level
25	KZINI	KZINI	KZINI	CHAR	1	0	Initialization indicator
26	ALPHA	ALPHA	GLATT	DEC	3	2	Basic value smoothing using alpha factor
27	BETA1	BETA1	GLATT	DEC	3	2	Trend value smoothing using the beta factor
28	GAMMA	GAMMA	GLATT	DEC	3	2	Seasonal index smoothing using gamma factor
29	DELTA	DELTA	GLATT	DEC	3	2	MAD (mean absolute deviation) smoothing using delta factor
30	EPSIL	EPSIL	GLATT	DEC	3	2	Epsilon factor
31	SIGGR	SIGGR	SIGGR	DEC	5	3	Tracking limit
32	PERAN	PERAN	PERAN	DEC	3	0	Number of historical periods
33	PERIN	PERIN	PERAN	DEC	3	0	Number of periods for initialization
34	PEREX	WFCS_PEREX	PERAN	DEC	3	0	Number of periods for ex-post forecasting
35	PERIO	PERIO	PERAN	DEC	3	0	Number of periods per seasonal cycle
36	ANZPR	ANZPR	PERAN	DEC	3	0	Number of forecast periods
37	FIMON	FIMON	PERAN	DEC	3	0	Fixed periods
38	LGRAD	LGRAD	DEC2_1	DEC	3	1	Service level
39	GWERT	GWERT	MENGV13	QUAN	13	3	Basic value
40	VMGWE	VMGWE	MENGV13	QUAN	13	3	Basic value of previous period
41	GWER1	GWER2	MENGV13	QUAN	13	3	Basic value of the 2nd order
42	VMGW1	VMGW2	MENGV13	QUAN	13	3	Base value of the second order in previous period
43	GWER2	GWER2	MENGV13	QUAN	13	3	Basic value of the 2nd order
44	VMGW2	VMGW2	MENGV13	QUAN	13	3	Base value of the second order in previous period
45	TWERT	TWERT	MENGV13	QUAN	13	3	Trend value
46	VMTWE	VMTWE	MENGV13	QUAN	13	3	Trend value of previous period
47	PRMAD	PRMAD	MENG13	QUAN	13	3	Mean absolute deviation (MAD)
48	VMMAD	VMMAD	MENG13	QUAN	13	3	Mean absolute devaition of previous period
49	FSUMM	FSUMM	MENGV13	QUAN	13	3	Error total
50	VMFSU	VMFSU	MENGV13	QUAN	13	3	Error total for the previous period
51	AUSNA	AUSNA	TEXT30	CHAR	30	0	Exception message bar
52	PROAB	PROAB	CHAR10	CHAR	10	0	Forecast flow control
53	KZOKO	KZOKO	XFELD	CHAR	1	0	Indicator: suppress places after decimal point
54	GEWGR	GEWGR	GEWGR	CHAR	2	0	Weighting group	*
55	THKOF	THKOF	DEC3_2	DEC	5	2	Theil coefficient
56	NULLV	NULLV	XFELD	CHAR	1	0	Zero distribution
57	PRWUG	PRWUG	MENGV13	QUAN	13	3	Forecast: Lower limit
58	PRWOG	PRWOG	MENGV13	QUAN	13	3	Forecast: Upper limit
59	PRROS	PRROS	MENGV13	QUAN	13	3	Forecast: Sale rate
60	PRKUM	PRKUM	MENGV13	QUAN	13	3	Cumulative forecast result
61	PRZGF	PRZGF	PRZGF	NUMC	10	0	Pointer: Forecast weighting factor
62	AKTPE	AKTPE	PERI3	DEC	3	0	Current period
63	.INCLUDE				0	0	Data Part for Viewing MARC (w/o LGRAD/PERKZ/PERIV)
64	.INCLUDE				0	0	Data Part 0 for Reading MARC (Using Single Fields)
65	PSTAT	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
66	MMSTA	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	*
67	MMSTD	MMSTD	DATUM	DATS	8	0	Date from which the plant-specific material status is valid
68	DISMM	DISMM	DISMM	CHAR	2	0	MRP Type	*
69	PLIFZ	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
70	WEBAZ	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
71	.INCLUDE				0	0	Data Part 1 for Reading MARC (Using Single Fields)
72	BESKZ	BESKZ	BESKZ	CHAR	1	0	Procurement Type
73	MINBE	MINBE	MENG13	QUAN	13	3	Reorder point
74	EISBE	EISBE	MENG13	QUAN	13	3	Safety stock
75	BSTMI	BSTMI	MENG13	QUAN	13	3	Minimum lot size
76	BSTMA	BSTMA	MENG13	QUAN	13	3	Maximum lot size
77	BSTFE	BSTFE	MENG13	QUAN	13	3	Fixed lot size
78	MABST	MABST	MENG13	QUAN	13	3	Maximum stock level
79	FHORI	FHORI	FHORI	CHAR	3	0	Scheduling Margin Key for Floats	*
80	BEARZ	BEARZ	DEC3_2	DEC	5	2	Processing time
81	RUEZT	RUEZT	DEC3_2	DEC	5	2	Setup and teardown time
82	TRANZ	TRANZ	DEC3_2	DEC	5	2	Interoperation time
83	BASMG	BASMG	MENG13	QUAN	13	3	Base quantity
84	DZEIT	DZEIT	DEC3	DEC	3	0	In-house production time
85	.INCLUDE				0	0	Data Part 2 for Reading MARC (Using Single Fields)
86	VRBMT	VRBMT	MATNR	CHAR	18	0	Reference material for consumption	*
87	VRBWK	VRBWK	WERKS	CHAR	4	0	Reference plant for consumption	*
88	VRBDT	VRBDT	DATUM	DATS	8	0	To date of the material to be copied for consumption
89	VRBFK	VRBFK	DEC2_2	DEC	4	2	Multiplier for reference material for consumption
90	AUTRU	AUTRU	XFELD	CHAR	1	0	Reset forecast model automatically
91	KZAGL	KZAGL	KZAGL	CHAR	1	0	Indicator: smooth promotion consumption
92	EISLO	EISLO	MENG13	QUAN	13	3	Minimum Safety Stock
93	.INCLUDE				0	0	Flags: Calculate Safety Stock and Reorder Point
94	KZSIB	KZSIB	XFELD	CHAR	1	0	Indicator: calculate safety stock
95	KZMEB	KZMEB	XFELD	CHAR	1	0	Indicator: calculate reorder level
96	.INCLUDE				0	0	Data Part for Reading MARA
97	.INCLUDE				0	0	Data Part 0 for Reading MARA
98	LVORM	LVORM	XFELD	CHAR	1	0	Deletion Indicator
99	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
100	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
101	MSTAE	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	*
102	MSTDE	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
103	ANDEC	ANDEC	ANDEC	INT2	5	0	No. of decimal places to which rounding should be performed