SAP ABAP Table WFCS_MDST_DB_INTERFACE (Update Structure for DB Master Data (MAPR/PROP/MARC/MARA))

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_DB_INTERFACE	Table Relationship Diagram
Short Description	Update Structure for DB Master Data (MAPR/PROP/MARC/MARA)

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	.INCLUDE	☐				0	0	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	PNUM1	☐	PNUM1	PNUM1	NUMC	10	0	Pointer: forecast parameters	*
6	HSNUM	☐	HSNUM	HSNUM	CHAR	2	0	Number for history
7	VERSP	☐	VERSP	VERSP	CHAR	2	0	Version number of forecast parameters
8	PNUM2	☐	PNUM2	PNUM2	NUMC	10	0	Pointer for forecast results	PROW
9	PROPR	☐	PROPR	PROPR	CHAR	4	0	Forecast profile	MPRP
10	PERKZ	☐	PERKZ	PERKZ	CHAR	1	0	Period indicator
11	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
12	MODAW	☐	MODAW	MODAW	CHAR	1	0	Model Selection Indicator
13	MODAV	☐	MODAV	MODAV	CHAR	1	0	Model selection procedure
14	KZPAR	☐	KZPAR	XFELD	CHAR	1	0	Indicator for parameter optimization
15	OPGRA	☐	OPGRA	OPGRA	CHAR	1	0	Optimization level
16	KZINI	☐	KZINI	KZINI	CHAR	1	0	Initialization indicator
17	PRMOD	☐	PRMOD	PRMOD	CHAR	1	0	Forecast model
18	ALPHA	☐	ALPHA	GLATT	DEC	3	2	Basic value smoothing using alpha factor
19	BETA1	☐	BETA1	GLATT	DEC	3	2	Trend value smoothing using the beta factor
20	GAMMA	☐	GAMMA	GLATT	DEC	3	2	Seasonal index smoothing using gamma factor
21	DELTA	☐	DELTA	GLATT	DEC	3	2	MAD (mean absolute deviation) smoothing using delta factor
22	EPSIL	☐	EPSIL	GLATT	DEC	3	2	Epsilon factor
23	SIGGR	☐	SIGGR	SIGGR	DEC	5	3	Tracking limit
24	PRDAT	☐	PRDAT	DATUM	DATS	8	0	Date of last forecast
25	PERAN	☐	PERAN	PERAN	DEC	3	0	Number of historical periods
26	PERIN	☐	PERIN	PERAN	DEC	3	0	Number of periods for initialization
27	PERIO	☐	PERIO	PERAN	DEC	3	0	Number of periods per seasonal cycle
28	PEREX	☐	PEREX	PERAN	DEC	3	0	Number of periods for ex-post forecasting
29	ANZPR	☐	ANZPR	PERAN	DEC	3	0	Number of forecast periods
30	FIMON	☐	FIMON	PERAN	DEC	3	0	Fixed periods
31	GWERT	☐	GWERT	MENGV13	QUAN	13	3	Basic value
32	GWER1	☐	GWER2	MENGV13	QUAN	13	3	Basic value of the 2nd order
33	GWER2	☐	GWER2	MENGV13	QUAN	13	3	Basic value of the 2nd order
34	VMGWE	☐	VMGWE	MENGV13	QUAN	13	3	Basic value of previous period
35	VMGW1	☐	VMGW2	MENGV13	QUAN	13	3	Base value of the second order in previous period
36	VMGW2	☐	VMGW2	MENGV13	QUAN	13	3	Base value of the second order in previous period
37	TWERT	☐	TWERT	MENGV13	QUAN	13	3	Trend value
38	VMTWE	☐	VMTWE	MENGV13	QUAN	13	3	Trend value of previous period
39	PRMAD	☐	PRMAD	MENG13	QUAN	13	3	Mean absolute deviation (MAD)
40	VMMAD	☐	VMMAD	MENG13	QUAN	13	3	Mean absolute devaition of previous period
41	FSUMM	☐	FSUMM	MENGV13	QUAN	13	3	Error total
42	VMFSU	☐	VMFSU	MENGV13	QUAN	13	3	Error total for the previous period
43	GEWGR	☐	GEWGR	GEWGR	CHAR	2	0	Weighting group	*
44	THKOF	☐	THKOF	DEC3_2	DEC	5	2	Theil coefficient
45	AUSNA	☐	AUSNA	TEXT30	CHAR	30	0	Exception message bar
46	PROAB	☐	PROAB	CHAR10	CHAR	10	0	Forecast flow control
47	VBKEZ	☐	VBKEZ	X	CHAR	1	0	Indicator: base forecast on consumption values
48	STATU	☐	VSSTA	CHAR01	CHAR	1	0	LIS version status
49	VETXT	☐	VETXT	TEXT40	CHAR	40	0	Version description
50	PRWUG	☐	PRWUG	MENGV13	QUAN	13	3	Forecast: Lower limit
51	PRWOG	☐	PRWOG	MENGV13	QUAN	13	3	Forecast: Upper limit
52	PRROS	☐	PRROS	MENGV13	QUAN	13	3	Forecast: Sale rate
53	PRKUM	☐	PRKUM	MENGV13	QUAN	13	3	Cumulative forecast result
54	PRZGF	☐	PRZGF	PRZGF	NUMC	10	0	Pointer: Forecast weighting factor
55	AKTPE	☐	AKTPE	PERI3	DEC	3	0	Current period
56	FAUSR	☐	FAUSR	X	CHAR	1	0	Indicator: correction of outliers for forecast
57	SIGMA	☐	SIGMX	GLATT	DEC	3	2	Sigma factor
58	FLGEXC	☐	FLGEXC	CHAR01	CHAR	1	0	Indicator: automatic correction of outliers
59	FLGCOR	☐	FLGCOR	CHAR01	CHAR	1	0	Indicator: use corrected historical values for forecast
60	.INCLUDE	☐				0	0	Data Part 0 for Reading MARC (Using Single Fields)
61	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
62	MMSTA	☐	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	*
63	MMSTD	☐	MMSTD	DATUM	DATS	8	0	Date from which the plant-specific material status is valid
64	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	*
65	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
66	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
67	.INCLUDE	☐				0	0	Data Part 1 for Reading MARC (Using Single Fields)
68	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
69	MINBE	☐	MINBE	MENG13	QUAN	13	3	Reorder point
70	EISBE	☐	EISBE	MENG13	QUAN	13	3	Safety stock
71	BSTMI	☐	BSTMI	MENG13	QUAN	13	3	Minimum lot size
72	BSTMA	☐	BSTMA	MENG13	QUAN	13	3	Maximum lot size
73	BSTFE	☐	BSTFE	MENG13	QUAN	13	3	Fixed lot size
74	MABST	☐	MABST	MENG13	QUAN	13	3	Maximum stock level
75	FHORI	☐	FHORI	FHORI	CHAR	3	0	Scheduling Margin Key for Floats	*
76	BEARZ	☐	BEARZ	DEC3_2	DEC	5	2	Processing time
77	RUEZT	☐	RUEZT	DEC3_2	DEC	5	2	Setup and teardown time
78	TRANZ	☐	TRANZ	DEC3_2	DEC	5	2	Interoperation time
79	BASMG	☐	BASMG	MENG13	QUAN	13	3	Base quantity
80	DZEIT	☐	DZEIT	DEC3	DEC	3	0	In-house production time
81	LGRAD	☐	LGRAD	DEC2_1	DEC	3	1	Service level
82	.INCLUDE	☐				0	0	Data Part 2 for Reading MARC (Using Single Fields)
83	VRBMT	☐	VRBMT	MATNR	CHAR	18	0	Reference material for consumption	*
84	VRBWK	☐	VRBWK	WERKS	CHAR	4	0	Reference plant for consumption	*
85	VRBDT	☐	VRBDT	DATUM	DATS	8	0	To date of the material to be copied for consumption
86	VRBFK	☐	VRBFK	DEC2_2	DEC	4	2	Multiplier for reference material for consumption
87	AUTRU	☐	AUTRU	XFELD	CHAR	1	0	Reset forecast model automatically
88	KZAGL	☐	KZAGL	KZAGL	CHAR	1	0	Indicator: smooth promotion consumption
89	EISLO	☐	EISLO	MENG13	QUAN	13	3	Minimum Safety Stock
90	.INCLUDE	☐				0	0	Data Part 0 for Reading MARA
91	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
92	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
93	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
94	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	*
95	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid

Foreign Keys

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

History

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