SAP MDKE Table in S/4 HANA - Extract of header data for MRP document
MDKE is a standard SAP Table which is used to store Extract of header data for MRP document data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MDKE table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MDKE
MDKE table structure field list
Below is the full MDKE field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| DISST | Low-Level Code | DISST | CHAR | 3(0) | DISST | |||||
| MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
| PLWRK | Planning Plant | PLWRK | CHAR | 4(0) | T001W | WERKS | WRK | |||
| PLSCN | Planning Scenario in Long-Term Planning | PLSCN | NUMC | 3(0) | PLSC | PLSCN | PLS | |||
| MAKTX | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
| DISPO | MRP Controller | DISPO | CHAR | 3(0) | T024D | DISPO | DGR | HS_T024D | DISPO | |
| BDBKZ | Selection indicator for processed MRP lists | BDBKZ | CHAR | 1(0) | XFELD | |||||
| MTART | Material type | MTART | CHAR | 4(0) | T134 | MTART | MTA | |||
| DISMM | MRP Type | DISMM | CHAR | 2(0) | T438A | DISMM | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
| BESKZ | Procurement Type | BESKZ | CHAR | 1(0) | BESKZ | MBS | ||||
| SOBES | Special procurement type | SOBES | CHAR | 1(0) | SOBES | |||||
| ESOBS | Special procurement - external display | ESOBS | CHAR | 1(0) | Assigned to domain | ESOBS | ||||
| AUSNM | Group of exception messages | AUSNG | CHAR | 8(0) | CHAR8 | |||||
| DTNUM | Number of material requirements planning table | DTNUM | NUMC | 10(0) | NUM10 | |||||
| BERW1 | Stock Days' Supply Without Receipts | BERW1 | DEC | 4(1) | DECV3_1 | |||||
| BERW2 | First Receipt Days' Supply | BERW2 | DEC | 4(1) | DECV3_1 | |||||
| BERW4 | Second Receipt Days' Supply | BERW4 | DEC | 4(1) | DECV3_1 | |||||
| NAUKZ | Indicator: new exception in the MRP list | NAUKZ | CHAR | 1(0) | CHAR1 | |||||
| AUSZ1 | Exception group MRP list no. 1 | AUSZ1_D | CHAR | 2(0) | CHAR2 | |||||
| AUSZ2 | Exception group MRP list no. 2 | AUSZ2_D | CHAR | 2(0) | CHAR2 | |||||
| AUSZ3 | Exception group MRP list no. 3 | AUSZ3 | CHAR | 2(0) | CHAR2 | |||||
| AUSZ4 | Exception group MRP list no. 4 | AUSZ4 | CHAR | 2(0) | CHAR2 | |||||
| AUSZ5 | Exception group MRP list no. 5 | AUSZ5 | CHAR | 2(0) | CHAR2 | |||||
| AUSZ6 | Exception group MRP list no. 6 | AUSZ6 | CHAR | 2(0) | CHAR2 | |||||
| AUSZ7 | Exception group MRP list no. 7 | AUSZ7 | CHAR | 2(0) | CHAR2 | |||||
| AUSZ8 | Exception group MRP list no. 8 | AUSZ8 | CHAR | 2(0) | CHAR2 | |||||
| DSDAT | MRP date | DSDAT | DATS | 8(0) | DATUM | |||||
| KZPROMO | Indicator: Material in promotion | KZPROMO | CHAR | 1(0) | CHAR1 | |||||
| MAKZG | Selection flag | SELKZ | CHAR | 1(0) | SELKZ | |||||
| SUM01 | Plant stock / only plant segment | SUM01W | QUAN | 13(3) | MENG13 | |||||
| EISBE | Safety stock | EISBE | QUAN | 13(3) | MENG13 | |||||
| MINBE | Reorder Point | MINBE | QUAN | 13(3) | MENG13 | |||||
| BERX1 | Stock Days' Supply Without Receipts | BERW1 | DEC | 4(1) | DECV3_1 | |||||
| BERX2 | First Receipt Days' Supply | BERW2 | DEC | 4(1) | DECV3_1 | |||||
| BERX3 | Second Receipt Days' Supply | BERW4 | DEC | 4(1) | DECV3_1 | |||||
| ALINE | Line index for internal table processing | XLINE | INT4 | 10(0) | XLINE | |||||
| ABLKZ | Current stock/requirements list was created | ABLKZ | CHAR | 1(0) | XFELD | |||||
| LAZKZ | Indicator: List was already accessed (displayed) | LAZKZ | CHAR | 1(0) | XFELD | |||||
| KZSEASN | Indicator: Seasonal material | KZSEASN | CHAR | 1(0) | XFLAG | |||||
| MAABC | ABC Indicator | MAABC | CHAR | 1(0) | TMABC | MAABC | ||||
| DISGR | MRP Group | DISGR | CHAR | 4(0) | Assigned to domain | DISGR | ||||
| EVAPR | Evaluation Profile for Range-of-Coverage Data | MD_EVAPR | CHAR | 3(0) | MD_EVAPR | |||||
| MODBAD | Indicator: Modified By BAdI | MD_BADI_MOD | CHAR | 1(0) | XFELD | |||||
| BERTX | MRP Area Text | BERTX | CHAR | 40(0) | BERTX | |||||
| BERID | MRP Area | BERID | CHAR | 10(0) | Assigned to domain | BERID | BERID | |||
| FIXTR | End of planning time fence (date) | FIXTR | DATS | 8(0) | DATUM | |||||
| MFHKZ | Planning time fence set manually (MFXDT) | MFHKZ | CHAR | 1(0) | XFELD | |||||
| RTIME | MRP run: Total duration for each material | MDRTIME | INT4 | 10(0) | INT4 | |||||
| READT | MRP run: Time required for reading the initial situation | READT | INT4 | 10(0) | INT4 | |||||
| LOTST | MRP run: Time for calculating net requirements and lot-size | LOTST | INT4 | 10(0) | INT4 | |||||
| EXPLT | MRP run: Time for BOM explosion | EXPLT | INT4 | 10(0) | INT4 | |||||
| SCHET | MRP run: Time required for lead time scheduling | SCHET | INT4 | 10(0) | INT4 | |||||
| POSTT | MRP run: Time for posting | POSTT | INT4 | 10(0) | INT4 | |||||
| MDTBT | MRP run: Time for deleting/saving MRP list | MDTBT | INT4 | 10(0) | INT4 | |||||
| RESBT | MRP run: Time required for saving dependent requirements | RESBT | INT4 | 10(0) | INT4 | |||||
| ARBPT | MRP run: Time to read routing | ARBPT | INT4 | 10(0) | INT4 | |||||
| EINZT | MRP run: Time for evaluating the operating time | EINZT | INT4 | 10(0) | INT4 | |||||
| RQITT | MRP run: Time required for saving total requirements | RQITT | INT4 | 10(0) | INT4 | |||||
| ICON_BDBKZ | Carrier field for icons | ICON_TEXT | CHAR | 132(0) | SYCHAR132 | |||||
| ICON_AMPEL | Icon for Traffic Light Status of Ranges of Coverage | MD_ICON_AMPEL | CHAR | 132(0) | SYCHAR132 | |||||
| AMPEL | Traffic light icon | AMPEL_I | CHAR | 4(0) | Assigned to domain | ICON | ||||
| COL_CHAR1_CONT | BAdI MRP: Column Content (Type CHAR) | MD_COL_CONT_CHAR | CHAR | 30(0) | MD_COL_CONT_CHAR | |||||
| COL_CHAR2_CONT | BAdI MRP: Column Content (Type CHAR) | MD_COL_CONT_CHAR | CHAR | 30(0) | MD_COL_CONT_CHAR | |||||
| COL_CHAR3_CONT | BAdI MRP: Column Content (Type CHAR) | MD_COL_CONT_CHAR | CHAR | 30(0) | MD_COL_CONT_CHAR | |||||
| COL_DEC1_CONT | BAdI MRP: Column Content (Type DEC) | MD_COL_CONT_DEC | DEC | 13(3) | MD_COL_CONT_DEC | |||||
| COL_DEC2_CONT | BAdI MRP: Column Content (Type DEC) | MD_COL_CONT_DEC | DEC | 13(3) | MD_COL_CONT_DEC | |||||
| COL_DATS1_CONT | BAdI MRP: Column Content (Type DATS) | MD_COL_CONT_DATS | DATS | 8(0) | MD_COL_CONT_DATS | |||||
| COL_DATS2_CONT | BAdI MRP: Column Content (Type DATS) | MD_COL_CONT_DATS | DATS | 8(0) | MD_COL_CONT_DATS | |||||
| MMSTA | Plant-Specific Material Status | MMSTA | CHAR | 2(0) | Assigned to domain | MMSTA | ||||
| DSTMP | Timestamp for Setup Date of Planning Situation | MD_CREASTMP | DEC | 15(0) | TZNTSTMPS | |||||
| SGT_STATC | Segmentation Status | SGT_STATC | CHAR | 1(0) | SGT_STAT | |||||
| .INCLU--AP | 0(0) | |||||||||
| MPNSORT | A&D: For Sorting MATNR by Output Format | MAT_SORT | CHAR | 40(0) | CHAR40 | |||||
| .INCLU--AP | 0(0) | |||||||||
| PIC_DATFR | Valid from date of an interchangeable part | PIC_DATFR | DATS | 8(0) | DATUM |
Search for further information about these or an SAP related objects