SAP Table MDKE
Extract of header data for MRP document
MDKE (Extract of header data for MRP document) 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 MDKE to other SAP tables.
MDKE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
DISST
Low-Level Code
|
DISST |
CHAR
|
3 | 0 | ||||||||||||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||||||||
|
PLWRK
Planning Plant
|
PLWRK | T001W |
CHAR
|
4 | 0 | |||||||||||||||||
|
PLSCN
Planning Scenario of Long-Term Planning
|
PLSCN | PLSC |
NUMC
|
3 | 0 | |||||||||||||||||
|
MAKTX
Material Description (Short Text)
|
MAKTX |
CHAR
|
40 | 0 | ||||||||||||||||||
|
DISPO
MRP Controller (Materials Planner)
|
DISPO | T024D |
CHAR
|
3 | 0 | |||||||||||||||||
|
BDBKZ
Selection indicator for processed MRP lists
|
BDBKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
MTART
Material Type
|
MTART | T134 |
CHAR
|
4 | 0 | |||||||||||||||||
|
DISMM
MRP Type
|
DISMM | T438A |
CHAR
|
2 | 0 | |||||||||||||||||
|
MEINS
Base Unit of Measure
|
MEINS | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
BESKZ
Procurement Type
|
BESKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
SOBES
Special procurement type
|
SOBES |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
ESOBS
Special procurement - external display
|
ESOBS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
AUSNM
Group of exception messages
|
AUSNG |
CHAR
|
8 | 0 | ||||||||||||||||||
|
DTNUM
Number of material requirements planning table
|
DTNUM |
NUMC
|
10 | 0 | ||||||||||||||||||
|
BERW1
Stock Days' Supply Without Receipts
|
BERW1 |
DEC
|
4 | 1 | ||||||||||||||||||
|
BERW2
First Receipt Days' Supply
|
BERW2 |
DEC
|
4 | 1 | ||||||||||||||||||
|
BERW4
Second Receipt Days' Supply
|
BERW4 |
DEC
|
4 | 1 | ||||||||||||||||||
|
NAUKZ
Indicator: new exception in the MRP list
|
NAUKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
AUSZ1
Exception group MRP list no. 1
|
AUSZ1_D |
CHAR
|
2 | 0 | ||||||||||||||||||
|
AUSZ2
Exception group MRP list no. 2
|
AUSZ2_D |
CHAR
|
2 | 0 | ||||||||||||||||||
|
AUSZ3
Exception group MRP list no. 3
|
AUSZ3 |
CHAR
|
2 | 0 | ||||||||||||||||||
|
AUSZ4
Exception group MRP list no. 4
|
AUSZ4 |
CHAR
|
2 | 0 | ||||||||||||||||||
|
AUSZ5
Exception group MRP list no. 5
|
AUSZ5 |
CHAR
|
2 | 0 | ||||||||||||||||||
|
AUSZ6
Exception group MRP list no. 6
|
AUSZ6 |
CHAR
|
2 | 0 | ||||||||||||||||||
|
AUSZ7
Exception group MRP list no. 7
|
AUSZ7 |
CHAR
|
2 | 0 | ||||||||||||||||||
|
AUSZ8
Exception group MRP list no. 8
|
AUSZ8 |
CHAR
|
2 | 0 | ||||||||||||||||||
|
DSDAT
MRP date
|
DSDAT |
DATS
|
8 | 0 | ||||||||||||||||||
|
KZPROMO
Indicator: Material in promotion
|
KZPROMO |
CHAR
|
1 | 0 | ||||||||||||||||||
|
MAKZG
Selection flag
|
SELKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
SUM01
Plant stock / only plant segment
|
SUM01W |
QUAN
|
13 | 3 | ||||||||||||||||||
|
EISBE
Safety Stock
|
EISBE |
QUAN
|
13 | 3 | ||||||||||||||||||
|
MINBE
Reorder Point
|
MINBE |
QUAN
|
13 | 3 | ||||||||||||||||||
|
BERX1
Stock Days' Supply Without Receipts
|
BERW1 |
DEC
|
4 | 1 | ||||||||||||||||||
|
BERX2
First Receipt Days' Supply
|
BERW2 |
DEC
|
4 | 1 | ||||||||||||||||||
|
BERX3
Second Receipt Days' Supply
|
BERW4 |
DEC
|
4 | 1 | ||||||||||||||||||
|
ALINE
Line index for internal table processing
|
XLINE |
INT4
|
10 | 0 | ||||||||||||||||||
|
ABLKZ
Current stock/requirements list was created
|
ABLKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
LAZKZ
Indicator: List was already accessed (displayed)
|
LAZKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
KZSEASN
Indicator: Seasonal material
|
KZSEASN |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
MAABC
ABC Indicator
|
MAABC | TMABC |
CHAR
|
1 | 0 | |||||||||||||||||
|
DISGR
MRP Group
|
DISGR |
CHAR
|
4 | 0 | ||||||||||||||||||
|
EVAPR
Evaluation Profile for Range-of-Coverage Data
|
MD_EVAPR |
CHAR
|
3 | 0 | ||||||||||||||||||
|
MODBAD
Indicator: Modified By BAdI
|
MD_BADI_MOD |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
BERTX
MRP area text
|
BERTX |
CHAR
|
40 | 0 | ||||||||||||||||||
|
BERID
MRP Area
|
BERID |
CHAR
|
10 | 0 | ||||||||||||||||||
|
FIXTR
End of planning time fence (date)
|
FIXTR |
DATS
|
8 | 0 | ||||||||||||||||||
|
MFHKZ
Planning time fence set manually (MFXDT)
|
MFHKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
RTIME
MRP run: Total duration for each material
|
MDRTIME |
INT4
|
10 | 0 | ||||||||||||||||||
|
READT
MRP run: Time required for reading the initial situation
|
READT |
INT4
|
10 | 0 | ||||||||||||||||||
|
LOTST
MRP run: Time for calculating net requirements and lot-size
|
LOTST |
INT4
|
10 | 0 | ||||||||||||||||||
|
EXPLT
MRP run: Time for BOM explosion
|
EXPLT |
INT4
|
10 | 0 | ||||||||||||||||||
|
SCHET
MRP run: Time required for lead time scheduling
|
SCHET |
INT4
|
10 | 0 | ||||||||||||||||||
|
POSTT
MRP run: Time for posting
|
POSTT |
INT4
|
10 | 0 | ||||||||||||||||||
|
MDTBT
MRP run: Time for deleting/saving MRP list
|
MDTBT |
INT4
|
10 | 0 | ||||||||||||||||||
|
RESBT
MRP run: Time required for saving dependent requirements
|
RESBT |
INT4
|
10 | 0 | ||||||||||||||||||
|
ARBPT
MRP run: Time to read routing
|
ARBPT |
INT4
|
10 | 0 | ||||||||||||||||||
|
EINZT
MRP run: Time for evaluating the operating time
|
EINZT |
INT4
|
10 | 0 | ||||||||||||||||||
|
RQITT
MRP run: Time required for saving total requirements
|
RQITT |
INT4
|
10 | 0 | ||||||||||||||||||
|
ICON_BDBKZ
Carrier field for icons
|
ICON_TEXT |
CHAR
|
132 | 0 | ||||||||||||||||||
|
ICON_AMPEL
Icon for Traffic Light Status of Ranges of Coverage
|
MD_ICON_AMPEL |
CHAR
|
132 | 0 | ||||||||||||||||||
|
AMPEL
Traffic light icon
|
AMPEL_I |
CHAR
|
4 | 0 | ||||||||||||||||||
|
COL_CHAR1_CONT
BAdI MRP: Column Content (Type CHAR)
|
MD_COL_CONT_CHAR |
CHAR
|
30 | 0 | ||||||||||||||||||
|
COL_CHAR2_CONT
BAdI MRP: Column Content (Type CHAR)
|
MD_COL_CONT_CHAR |
CHAR
|
30 | 0 | ||||||||||||||||||
|
COL_CHAR3_CONT
BAdI MRP: Column Content (Type CHAR)
|
MD_COL_CONT_CHAR |
CHAR
|
30 | 0 | ||||||||||||||||||
|
COL_DEC1_CONT
BAdI MRP: Column Content (Type DEC)
|
MD_COL_CONT_DEC |
DEC
|
13 | 3 | ||||||||||||||||||
|
COL_DEC2_CONT
BAdI MRP: Column Content (Type DEC)
|
MD_COL_CONT_DEC |
DEC
|
13 | 3 | ||||||||||||||||||
|
COL_DATS1_CONT
BAdI MRP: Column Content (Type DATS)
|
MD_COL_CONT_DATS |
DATS
|
8 | 0 | ||||||||||||||||||
|
COL_DATS2_CONT
BAdI MRP: Column Content (Type DATS)
|
MD_COL_CONT_DATS |
DATS
|
8 | 0 | ||||||||||||||||||
|
MMSTA
Plant-Specific Material Status
|
MMSTA |
CHAR
|
2 | 0 | ||||||||||||||||||
|
DSTMP
Timestamp for Setup Date of Planning Situation
|
MD_CREASTMP |
DEC
|
15 | 0 | ||||||||||||||||||
MDKE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MDKE | DISMM | SYST | MANDT |
T438A
MRP Type
|
MANDT |
| MDKE | DISMM | MDKE | DISMM |
T438A
MRP Type
|
DISMM |
| MDKE | DISPO | SYST | MANDT |
T024D
MRP controllers
|
MANDT |
| MDKE | DISPO | MDKE | PLWRK |
T024D
MRP controllers
|
WERKS |
| MDKE | DISPO | MDKE | DISPO |
T024D
MRP controllers
|
DISPO |
| MDKE | MAABC | MDKE | MAABC |
TMABC
Values Table for the ABC Indicator for Materials
|
MAABC |
| MDKE | MAABC | SYST | MANDT |
TMABC
Values Table for the ABC Indicator for Materials
|
MANDT |
| MDKE | MATNR | SYST | MANDT |
MARA
General Material Data
|
MANDT |
| MDKE | MATNR | MDKE | MATNR |
MARA
General Material Data
|
MATNR |
| MDKE | MEINS | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| MDKE | MEINS | MDKE | MEINS |
T006
Units of Measurement
|
MSEHI |
| MDKE | MTART | SYST | MANDT |
T134
Material Types
|
MANDT |
| MDKE | MTART | MDKE | MTART |
T134
Material Types
|
MTART |
| MDKE | PLSCN | SYST | MANDT |
PLSC
Planning scenarios in long-term planning
|
MANDT |
| MDKE | PLSCN | MDKE | PLSCN |
PLSC
Planning scenarios in long-term planning
|
PLSCN |
| MDKE | PLWRK | SYST | MANDT |
T001W
Plants/Branches
|
MANDT |
| MDKE | PLWRK | MDKE | PLWRK |
T001W
Plants/Branches
|
WERKS |