MDKP SAP (Header Data for MRP Document) Table details
Dictionary Type: Table
Description: Header Data for MRP Document
Description: Header Data for MRP Document
Table field list including key, data, relationships and ABAP select examples
MDKP is a standard SAP Table which is used to store Header Data for MRP Document data and is available within R/3 SAP systems depending on the version and release level.
The MDKP table consists of various fields, each holding specific information or linking keys about Header Data for MRP Document data available in SAP. These include DTART (Type of MRP list), MATNR (Material Number), PLWRK (Plant), PLSCN (Planning Scenario of Long-Term Planning).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MDKP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DTART | Type of MRP list | DTART | CHAR | 2 | DTART | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
PLWRK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
PLSCN | Planning Scenario of Long-Term Planning | PLSCN | NUMC | 3 | PLSC | PLSCN | PLS | ||
DTNUM | Number of material requirements planning table | DTNUM | NUMC | 10 | NUM10 | ||||
DSDAT | MRP date | DSDAT | DATS | 8 | DATUM | ||||
BDBKZ | Selection indicator for processed MRP lists | BDBKZ | CHAR | 1 | XFELD | ||||
SLKZ1 | Selection indicator for exception groups | SLKZX | CHAR | 1 | CHAR1 | ||||
SLKZ2 | Selection indicator for exception groups | SLKZX | CHAR | 1 | CHAR1 | ||||
SLKZ3 | Selection indicator for exception groups | SLKZX | CHAR | 1 | CHAR1 | ||||
SLKZ4 | Selection indicator for exception groups | SLKZX | CHAR | 1 | CHAR1 | ||||
SLKZ5 | Selection indicator for exception groups | SLKZX | CHAR | 1 | CHAR1 | ||||
SLKZ6 | Selection indicator for exception groups | SLKZX | CHAR | 1 | CHAR1 | ||||
SLKZ7 | Selection indicator for exception groups | SLKZX | CHAR | 1 | CHAR1 | ||||
SLKZ8 | Selection indicator for exception groups | SLKZX | CHAR | 1 | CHAR1 | ||||
VRKZ1 | Processing indicator 01 | VRKZ1 | CHAR | 1 | XFELD | ||||
VRKZ2 | Processing indicator 02 | VRKZ2 | CHAR | 1 | XFELD | ||||
VRKZ3 | Processing indicator - 03 | VRKZ3 | CHAR | 1 | XFELD | ||||
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
DISST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
SOBSL | Special procurement type | SOBSL | CHAR | 2 | T460A | SOBSL | |||
SOBES | Special procurement type | SOBES | CHAR | 1 | SOBES | ||||
WRK02 | Planning/production plant | WRK02 | CHAR | 4 | T001W | WERKS | |||
DISMM | MRP Type | DISMM | CHAR | 2 | T438A | DISMM | |||
DISVF | MRP procedure | DISVF | CHAR | 1 | DISVF | ||||
DISPO | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | T024D | DISPO | DGR | HS_T024D | |
PLDIS | Planning controller (no longer used) | PLDIS | CHAR | 3 | T024D | DISPO | |||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
MTWZT | Material replenishment lead time | MTWZT | DEC | 3 | DEC3 | ||||
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
BEAZT | Processing time for purchase order proposal | BEAZT | DEC | 3 | DEC3 | ||||
FIXTR | End of planning time fence (date) | FIXTR | DATS | 8 | DATUM | ||||
MFHKZ | Planning time fence set manually (MFXDT) | MFHKZ | CHAR | 1 | XFELD | ||||
DISLS | Lot size (materials planning) | DISLS | CHAR | 2 | T439A | DISLS | |||
LOSVF | Lot-sizing procedure for short-term period | LOSVF | CHAR | 1 | LOSVF | ||||
LOSKZ | Lot-size indicator for the short-term period | LOSKZ | CHAR | 1 | LOSKZ | ||||
PERAZ | Number of periods for the short-term area | PERAZ | DEC | 3 | DEC03 | ||||
EISBE | Safety Stock | EISBE | QUAN | 13(3) | MENG13 | ||||
MINBE | Reorder Point | MINBE | QUAN | 13(3) | MENG13 | ||||
HOEBE | Maximum stock level | MABST | QUAN | 13(3) | MENG13 | ||||
BSTMI | Minimum Lot Size | BSTMI | QUAN | 13(3) | MENG13 | ||||
BSTMA | Maximum Lot Size | BSTMA | QUAN | 13(3) | MENG13 | ||||
BSTFX | Fixed lot size | BSTFE | QUAN | 13(3) | MENG13 | ||||
BSTRF | Rounding value for purchase order quantity | BSTRF | QUAN | 13(3) | MENG13 | ||||
SUM01 | Plant stock / only plant segment | SUM01W | QUAN | 13(3) | MENG13 | ||||
SUM02 | No longer used/do not use!! | NOUSE | QUAN | 13(3) | MENG13 | ||||
SUM03 | No longer used/do not use!! | NOUSE | QUAN | 13(3) | MENG13 | ||||
SUM04 | No longer used/do not use!! | NOUSE | QUAN | 13(3) | MENG13 | ||||
SUM05 | No longer used/do not use!! | NOUSE | QUAN | 13(3) | MENG13 | ||||
NEGBS | Negative stock | NEGBS | QUAN | 13(3) | MENG13 | ||||
MSGID | Message identification | MSGID | CHAR | 20 | Assigned to domain | ARBGB | |||
MSGAR | Message Type | MSGTY | CHAR | 1 | MSGAR | ||||
MSGNR | Message number | MSGNR | CHAR | 3 | T100 | MSGNR | |||
MSGV1 | Message variable 01 | MSGV1 | CHAR | 50 | CHAR50 | ||||
MSGV2 | Message variable 02 | MSGV2 | CHAR | 50 | CHAR50 | ||||
MSGV3 | Message variable 03 | MSGV3 | CHAR | 50 | CHAR50 | ||||
MSGV4 | Message variable 04 | MSGV4 | CHAR | 50 | CHAR50 | ||||
DISGR | MRP Group | DISGR | CHAR | 4 | T438M | DISGR | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
MRPPP | PPC planning calendar | MRPPP | CHAR | 3 | T439G | MRPPP | |||
BDARF | Requirements quantity from material requirements planning | BDARF | QUAN | 13(3) | MENG13 | ||||
LFRHY | Planning cycle | LFRHY | CHAR | 3 | T439G | MRPPP | |||
RDPRF | Rounding Profile | RDPRF | CHAR | 4 | Assigned to domain | RDPRF | |||
BERW1 | Stock Days' Supply Without Receipts | BERW1 | DEC | 4(1) | DECV3_1 | ||||
BERW2 | First Receipt Days' Supply | BERW2 | DEC | 4(1) | DECV3_1 | ||||
KZAUS | Discontinuation indicator | KZAUS | CHAR | 1 | KZAUS | ||||
AUSDT | Effective-Out Date | AUSDT | DATS | 8 | DATUM | ||||
NFMAT | Follow-Up Material | NFMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
AUSZ1 | Exception group in the MRP list | AUSZX | CHAR | 2 | CHAR2 | ||||
AUSZ2 | Exception group in the MRP list | AUSZX | CHAR | 2 | CHAR2 | ||||
AUSZ3 | Exception group in the MRP list | AUSZX | CHAR | 2 | CHAR2 | ||||
AUSZ4 | Exception group in the MRP list | AUSZX | CHAR | 2 | CHAR2 | ||||
AUSZ5 | Exception group in the MRP list | AUSZX | CHAR | 2 | CHAR2 | ||||
AUSZ6 | Exception group in the MRP list | AUSZX | CHAR | 2 | CHAR2 | ||||
AUSZ7 | Exception group in the MRP list | AUSZX | CHAR | 2 | CHAR2 | ||||
AUSZ8 | Exception group in the MRP list | AUSZX | CHAR | 2 | CHAR2 | ||||
BEADA | MRP list processing date | BEADA | DATS | 8 | DATUM | ||||
NAUKZ | Indicator: new exception in the MRP list | NAUKZ | CHAR | 1 | CHAR1 | ||||
SAUFT | Ind.: Repetitive mfg allowed | SA_SAUFT | CHAR | 1 | XFELD | ||||
KZPROMO | Indicator: Material in promotion | KZPROMO | CHAR | 1 | CHAR1 | ||||
SHFLG | Safety time indicator (with or without safety time) | SHFLG | CHAR | 1 | SHFLG | ||||
SHZET | Safety time (in workdays) | SHZET | NUMC | 2 | NUMC2 | ||||
FABKZ | Indicator: Item Relevant to JIT Delivery Schedules | FABKZ | CHAR | 1 | FABKZ | ||||
MFXDT | Manual firming date | MFXDT | DATS | 8 | DATUM | ||||
BSKFL | Flag whether stock correction factors exist | BSKFL | CHAR | 1 | XFLAG | ||||
MAABC | ABC Indicator | MAABC | CHAR | 1 | Assigned to domain | MAABC | |||
CFLAG | Aggregated MRP list | COMPMRPL | CHAR | 1 | XFELD | ||||
GRREL | Relevant for requirements grouping for project stock | GRREL | CHAR | 1 | XFELD | ||||
RWPRO | Range of coverage profile | RWPRO | CHAR | 3 | Assigned to domain | RWPRO | |||
SHPRO | Period Profile for Safety Time | SHPRO | CHAR | 3 | Assigned to domain | SHPRO | |||
AHDIS | MRP relevancy for dependent requirements | AHDIS | CHAR | 1 | AHDIS | ||||
BERW4 | Second Receipt Days' Supply | BERW4 | DEC | 4(1) | DECV3_1 | ||||
BADON | Indicator: BAdI is Active | MD_BADI_ON | CHAR | 1 | XFELD | ||||
HANAON | HANA Optimizations Active / Inactive | PPH_HANA_ON | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table MDKP using ABAP code
The following ABAP code Example will allow you to do a basic selection on MDKP to SELECT all data from the tableDATA: WA_MDKP TYPE MDKP.
SELECT SINGLE *
FROM MDKP
INTO CORRESPONDING FIELDS OF WA_MDKP
WHERE...
How to access SAP table MDKP
Within an ECC or HANA version of SAP you can also view further information about MDKP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects