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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WERKS Plant CHAR 4 0 T001W WERKS_D
MATNR Material Number CHAR 40 0 MARA MATNR
PNUM1 Pointer: forecast parameters NUMC 10 0 * PNUM1
HSNUM Number for history CHAR 2 0 HSNUM
VERSP Version number of forecast parameters CHAR 2 0 VERSP
PNUM2 Pointer for forecast results NUMC 10 0 PROW PNUM2
PROPR Forecast profile CHAR 4 0 MPRP PROPR
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
MODAW Model Selection Indicator CHAR 1 0 MODAW
A Examine for trend and seasonal fluctuations
S Examine for seasonal fluctuations
T Examine for trend
MODAV Model selection procedure CHAR 1 0 MODAV
1 Model selection by significance test
2 Analytical model selection procedure
KZPAR Indicator for parameter optimization CHAR 1 0 KZPAR
OPGRA Optimization level CHAR 1 0 OPGRA
F Fine (high optimization level)
G Rough (low optimization level)
M Middle (middle optimization level)
KZINI Initialization indicator CHAR 1 0 KZINI
M Manual initialization
X Initialization by system
PRMOD Forecast model CHAR 1 0 PRMOD
0 No forecast/no external model
B 2nd order trend
D Constant model
G Moving average
J Automatic model selection
K Constant with smoothing factor adjustment
N No forecast/external model
O 2nd order trend with adjustment of smoothing factor
S Seasonal model
T Trend model
W Weighted moving average
X Seasonal trend model
ALPHA Basic value smoothing using alpha factor DEC 3 2 ALPHA
BETA1 Trend value smoothing using the beta factor DEC 3 2 BETA1
GAMMA Seasonal index smoothing using gamma factor DEC 3 2 GAMMA
DELTA MAD (mean absolute deviation) smoothing using delta factor DEC 3 2 DELTA
EPSIL Epsilon factor DEC 3 2 EPSIL
SIGGR Tracking limit DEC 5 3 SIGGR
PRDAT Date of last forecast DATS 8 0 PRDAT
PERAN Number of historical periods DEC 3 0 PERAN
PERIN Number of periods for initialization DEC 3 0 PERIN
PERIO Number of periods per seasonal cycle DEC 3 0 PERIO
PEREX Number of periods for ex-post forecasting DEC 3 0 PEREX
ANZPR Number of forecast periods DEC 3 0 ANZPR
FIMON Fixed periods DEC 3 0 FIMON
GWERT Basic value QUAN 13 3 GWERT
GWER1 Basic value of the 2nd order QUAN 13 3 GWER2
GWER2 Basic value of the 2nd order QUAN 13 3 GWER2
VMGWE Basic value of previous period QUAN 13 3 VMGWE
VMGW1 Base value of the second order in previous period QUAN 13 3 VMGW2
VMGW2 Base value of the second order in previous period QUAN 13 3 VMGW2
TWERT Trend value QUAN 13 3 TWERT
VMTWE Trend value of previous period QUAN 13 3 VMTWE
PRMAD Mean absolute deviation (MAD) QUAN 13 3 PRMAD
VMMAD Mean absolute devaition of previous period QUAN 13 3 VMMAD
FSUMM Error total QUAN 13 3 FSUMM
VMFSU Error total for the previous period QUAN 13 3 VMFSU
GEWGR Weighting group CHAR 2 0 * GEWGR
THKOF Theil coefficient DEC 5 2 THKOF
AUSNA Exception message bar CHAR 30 0 AUSNA
PROAB Forecast flow control CHAR 10 0 PROAB
VBKEZ Indicator: base forecast on consumption values CHAR 1 0 VBKEZ
STATU LIS version status CHAR 1 0 VSSTA
VETXT Version description CHAR 40 0 VETXT
PRWUG Forecast: Lower limit QUAN 13 3 PRWUG
PRWOG Forecast: Upper limit QUAN 13 3 PRWOG
PRROS Forecast: Sale rate QUAN 13 3 PRROS
PRKUM Cumulative forecast result QUAN 13 3 PRKUM
PRZGF Pointer: Forecast weighting factor NUMC 10 0 PRZGF
AKTPE Current period DEC 3 0 AKTPE
FAUSR Indicator: correction of outliers for forecast CHAR 1 0 FAUSR
SIGMA Sigma factor DEC 3 2 SIGMX
FLGEXC Indicator: automatic correction of outliers CHAR 1 0 FLGEXC
FLGCOR Indicator: use corrected historical values for forecast CHAR 1 0 FLGCOR
PSTAT Maintenance status CHAR 15 0 PSTAT_D
MMSTA Plant-Specific Material Status CHAR 2 0 * MMSTA
MMSTD Date from Which the Plant-Specific Material Status Is Valid DATS 8 0 MMSTD
DISMM MRP Type CHAR 2 0 * DISMM
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
MINBE Reorder Point QUAN 13 3 MINBE
EISBE Safety Stock QUAN 13 3 EISBE
BSTMI Minimum Lot Size QUAN 13 3 BSTMI
BSTMA Maximum Lot Size QUAN 13 3 BSTMA
BSTFE Fixed lot size QUAN 13 3 BSTFE
MABST Maximum Stock Level QUAN 13 3 MABST
FHORI Scheduling Margin Key for Floats CHAR 3 0 * FHORI
BEARZ Processing time DEC 5 2 BEARZ
RUEZT Setup and teardown time DEC 5 2 RUEZT
TRANZ Interoperation time DEC 5 2 TRANZ
BASMG Base quantity QUAN 13 3 BASMG
DZEIT In-house production time DEC 3 0 DZEIT
LGRAD Service level DEC 3 1 LGRAD
VRBMT Reference material for consumption CHAR 40 0 * VRBMT
VRBWK Reference plant for consumption CHAR 4 0 * VRBWK
VRBDT To date of the material to be copied for consumption DATS 8 0 VRBDT
VRBFK Multiplier for reference material for consumption DEC 4 2 VRBFK
AUTRU Reset Forecast Model Automatically CHAR 1 0 AUTRU
KZAGL Indicator: smooth promotion consumption CHAR 1 0 KZAGL
No smoothing
1 Smoothing using average values
EISLO Minimum Safety Stock QUAN 13 3 EISLO
LVORM Deletion Indicator CHAR 1 0 LVORM
MATKL Material Group CHAR 9 0 MATKL
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MSTAE Cross-Plant Material Status CHAR 2 0 MSTAE
MSTDE Date from which the cross-plant material status is valid DATS 8 0 MSTDE

WFCS_MDST_DB_INTERFACE foreign key relationships

Table Field Check Table Check Field
0 WFCS_MDST_DB_INTERFACE MANDT T000 Clients MANDT
1 WFCS_MDST_DB_INTERFACE MATNR MARA General Material Data MANDT
1 WFCS_MDST_DB_INTERFACE MATNR MARA General Material Data MATNR
0 WFCS_MDST_DB_INTERFACE MEINS T006 Units of Measurement MANDT
0 WFCS_MDST_DB_INTERFACE MEINS T006 Units of Measurement MSEHI
1 WFCS_MDST_DB_INTERFACE PERIV T009 Fiscal Year Variants MANDT
1 WFCS_MDST_DB_INTERFACE PERIV T009 Fiscal Year Variants PERIV
0 WFCS_MDST_DB_INTERFACE PNUM2 PROW Forecast Values MANDT
0 WFCS_MDST_DB_INTERFACE PNUM2 PROW Forecast Values PNUM2
0 WFCS_MDST_DB_INTERFACE PNUM2 PROW Forecast Values ERTAG
1 WFCS_MDST_DB_INTERFACE PROPR MPRP Forecast Profiles MANDT
1 WFCS_MDST_DB_INTERFACE PROPR MPRP Forecast Profiles PROPR
0 WFCS_MDST_DB_INTERFACE WERKS T001W Plants/Branches WERKS