1. Home
  2. Resources
  3. SAP Tables
  4. WFCS_MDST_DB_INTERFACE - Update Structure for DB Master Data (MAPR/PROP/MARC/MARA)

SAP Table WFCS_MDST_DB_INTERFACE

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

WFCS_MDST_DB_INTERFACE (Update Structure for DB Master Data (MAPR/PROP/MARC/MARA)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WFCS_MDST_DB_INTERFACE to other SAP tables.

WFCS_MDST_DB_INTERFACE table fields

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

WFCS_MDST_DB_INTERFACE foreign key relationships

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