1. Home
  2. Resources
  3. SAP Tables
  4. MDKE - Extract of header data for MRP document

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
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
X Yes
NULL No
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
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SOBES Special procurement type SOBES CHAR 1 0
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
E Standard in-house production
P Production in plant 2
9 IS-OIL only: Stock transfer reservation
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
NULL Not selected
* Selected and processed
X Selected but not yet processed
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
X Yes
NULL No
LAZKZ Indicator: List was already accessed (displayed) LAZKZ CHAR 1 0
X Yes
NULL No
KZSEASN Indicator: Seasonal material KZSEASN CHAR 1 0
NULL Blank
. Radio button
X Selection
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
X Yes
NULL No
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
X Yes
NULL No
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 SYST MANDT TMABC Values Table for the ABC Indicator for Materials MANDT
MDKE MAABC MDKE MAABC TMABC Values Table for the ABC Indicator for Materials MAABC
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