SAP table MDKP (Header Data for MRP Document)

SAP table MDKP has 5 primary key fields being MANDT,DTART,MATNR,PLWRK,PLSCN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
DTART Type of MRP list CHAR 2 0 DTART
LP Long-Term Planning
MD Material requirements planning
MATNR Material Number CHAR 40 0 MARA MATNR
PLWRK Plant CHAR 4 0 T001W WERKS_D
PLSCN Planning Scenario in Long-Term Planning NUMC 3 0 PLSC PLSCN
DTNUM Number of material requirements planning table NUMC 10 0 DTNUM
DSDAT MRP date DATS 8 0 DSDAT
BDBKZ Selection indicator for processed MRP lists CHAR 1 0 BDBKZ
SLKZ1 Selection indicator for exception groups CHAR 1 0 SLKZX
SLKZ2 Selection indicator for exception groups CHAR 1 0 SLKZX
SLKZ3 Selection indicator for exception groups CHAR 1 0 SLKZX
SLKZ4 Selection indicator for exception groups CHAR 1 0 SLKZX
SLKZ5 Selection indicator for exception groups CHAR 1 0 SLKZX
SLKZ6 Selection indicator for exception groups CHAR 1 0 SLKZX
SLKZ7 Selection indicator for exception groups CHAR 1 0 SLKZX
SLKZ8 Selection indicator for exception groups CHAR 1 0 SLKZX
VRKZ1 Processing indicator 01 CHAR 1 0 VRKZ1
VRKZ2 Processing indicator 02 CHAR 1 0 VRKZ2
VRKZ3 Processing indicator - 03 CHAR 1 0 VRKZ3
MTART Material type CHAR 4 0 T134 MTART
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
DISST Low-Level Code CHAR 3 0 DISST
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
SOBSL Special procurement type CHAR 2 0 T460A SOBSL
SOBES Special procurement type CHAR 1 0 SOBES
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
9 IS-OIL only: Stock transfer reservation
E Standard in-house production
P Production in plant 2
WRK02 Planning/production plant CHAR 4 0 T001W WRK02
DISMM MRP Type CHAR 2 0 T438A DISMM
DISVF MRP Procedure CHAR 1 0 DISVF
B Reorder Point Planning
C Demand-Driven Replenishment
D Material Requirements Planning
M Master Production Scheduling
N No MRP
R Time-Phased Materials Planning
S Forecast-Based Planning
W Replenishment (IS Retail)
X Without MRP, with BOM Explosion
DISPO MRP Controller CHAR 3 0 T024D DISPO
PLDIS Planning controller (no longer used) CHAR 3 0 T024D PLDIS
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
MTWZT Material replenishment lead time DEC 3 0 MTWZT
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
BEAZT Processing time for purchase order proposal DEC 3 0 BEAZT
FIXTR End of planning time fence (date) DATS 8 0 FIXTR
MFHKZ Planning time fence set manually (MFXDT) CHAR 1 0 MFHKZ
DISLS Lot Sizing Procedure within Materials Planning CHAR 2 0 T439A DISLS
LOSVF Lot-sizing procedure for short-term period CHAR 1 0 LOSVF
O Optimum lot-sizing procedure
P Period lot-sizing procedure
S Static lot-sizing procedure
LOSKZ Lot-size indicator for the short-term period CHAR 1 0 LOSKZ
D Dynamic lot size creation
E Lot-for-lot order quantity
F Fixed lot size
G Groff reorder procedure
H Replenish to maximum stock level
K Period lot size as in PPC planning calendar
M Monthly lot size
P Period lot sizes according to posting periods
S Stat.lot size: fixed w. splitting/dyn.lot size: part pd bal.
T Daily lot size
W Period lot size: weekly lot/dyn. lot-sizing: least unit cost
PERAZ Number of Periods for the Short-Term Area DEC 3 0 PERAZ
EISBE Safety Stock QUAN 13 3 EISBE
MINBE Reorder Point QUAN 13 3 MINBE
HOEBE Maximum Stock Level QUAN 13 3 MABST
BSTMI Minimum Lot Size QUAN 13 3 BSTMI
BSTMA Maximum Lot Size QUAN 13 3 BSTMA
BSTFX Fixed lot size QUAN 13 3 BSTFE
BSTRF Rounding value for purchase order quantity QUAN 13 3 BSTRF
SUM01 Plant stock / only plant segment QUAN 13 3 SUM01W
SUM02 No longer used/do not use!! QUAN 13 3 NOUSE
SUM03 No longer used/do not use!! QUAN 13 3 NOUSE
SUM04 No longer used/do not use!! QUAN 13 3 NOUSE
SUM05 No longer used/do not use!! QUAN 13 3 NOUSE
NEGBS Negative stock QUAN 13 3 NEGBS
MSGID Message identification CHAR 20 0 * MSGID
MSGAR Message Type CHAR 1 0 MSGTY
MSGNR Message number CHAR 3 0 T100 MSGNR
MSGV1 Message variable 01 CHAR 50 0 MSGV1
MSGV2 Message variable 02 CHAR 50 0 MSGV2
MSGV3 Message variable 03 CHAR 50 0 MSGV3
MSGV4 Message variable 04 CHAR 50 0 MSGV4
DISGR MRP Group CHAR 4 0 T438M DISGR
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
MRPPP PPC Planning Calendar CHAR 3 0 T439G MRPPP
BDARF Requirements quantity from material requirements planning QUAN 13 3 BDARF
LFRHY Planning Cycle CHAR 3 0 T439G LFRHY
RDPRF Rounding Profile CHAR 4 0 * RDPRF
BERW1 Stock Days' Supply Without Receipts DEC 4 1 BERW1
BERW2 First Receipt Days' Supply DEC 4 1 BERW2
KZAUS Discontinuation indicator CHAR 1 0 KZAUS
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
AUSDT Effective-Out Date DATS 8 0 AUSDT
NFMAT Follow-Up Material CHAR 40 0 * NFMAT
AUSZ1 Exception group in the MRP list CHAR 2 0 AUSZX
AUSZ2 Exception group in the MRP list CHAR 2 0 AUSZX
AUSZ3 Exception group in the MRP list CHAR 2 0 AUSZX
AUSZ4 Exception group in the MRP list CHAR 2 0 AUSZX
AUSZ5 Exception group in the MRP list CHAR 2 0 AUSZX
AUSZ6 Exception group in the MRP list CHAR 2 0 AUSZX
AUSZ7 Exception group in the MRP list CHAR 2 0 AUSZX
AUSZ8 Exception group in the MRP list CHAR 2 0 AUSZX
BEADA MRP list processing date DATS 8 0 BEADA
NAUKZ Indicator: new exception in the MRP list CHAR 1 0 NAUKZ
SAUFT Indicator: Repetitive Manufacturing Allowed CHAR 1 0 SA_SAUFT
KZPROMO Indicator: Material in promotion CHAR 1 0 KZPROMO
SHFLG Safety time indicator (with or without safety time) CHAR 1 0 SHFLG
Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
SHZET Safety Time (in Workdays) NUMC 2 0 SHZET
FABKZ Indicator: Item Relevant to JIT Delivery Schedules CHAR 1 0 FABKZ
No JIT
1 Automatically
MFXDT Manual firming date DATS 8 0 MFXDT
BSKFL Flag whether stock correction factors exist CHAR 1 0 BSKFL
MAABC ABC Indicator CHAR 1 0 * MAABC
CFLAG Aggregated MRP list CHAR 1 0 COMPMRPL
GRREL Relevant for requirements grouping for project stock CHAR 1 0 GRREL
RWPRO Range of coverage profile CHAR 3 0 * RWPRO
SHPRO Period Profile for Safety Time CHAR 3 0 * SHPRO
AHDIS MRP relevancy for dependent requirements CHAR 1 0 AHDIS
Materials for dependent requirements are planned
1 Materials for dependent requirements are not planned
BERW4 Second Receipt Days' Supply DEC 4 1 BERW4
BADON Indicator: BAdI is Active CHAR 1 0 MD_BADI_ON
SGT_STATC Segmentation Status CHAR 1 0 SGT_STATC
HANAON HANA Optimizations Active / Inactive CHAR 1 0 PPH_HANA_ON

MDKP foreign key relationships

Table Field Check Table Check Field
0 MDKP DISGR T438M Control Parameter for MRP -Material Level- MANDT
0 MDKP DISGR T438M Control Parameter for MRP -Material Level- WERKS
0 MDKP DISGR T438M Control Parameter for MRP -Material Level- MTART
1 MDKP DISLS T439A MRP Lot Sizes MANDT
1 MDKP DISLS T439A MRP Lot Sizes DISLS
0 MDKP DISMM T438A MRP Type MANDT
0 MDKP DISMM T438A MRP Type DISMM
1 MDKP DISPO T024D MRP Controllers MANDT
1 MDKP DISPO T024D MRP Controllers WERKS
1 MDKP DISPO T024D MRP Controllers DISPO
0 MDKP EKGRP T024 Purchasing Groups EKGRP
1 MDKP LFRHY T439G PP Planning periods: header table MANDT
1 MDKP LFRHY T439G PP Planning periods: header table WERKS
0 MDKP MATNR MARA General Material Data MANDT
0 MDKP MATNR MARA General Material Data MATNR
1 MDKP MEINS T006 Units of Measurement MANDT
1 MDKP MEINS T006 Units of Measurement MSEHI
0 MDKP MRPPP T439G PP Planning periods: header table MANDT
0 MDKP MRPPP T439G PP Planning periods: header table WERKS
1 MDKP MSGNR T100 Messages SPRSL
1 MDKP MSGNR T100 Messages ARBGB
1 MDKP MSGNR T100 Messages MSGNR
0 MDKP MTART T134 Material Types MANDT
0 MDKP MTART T134 Material Types MTART
1 MDKP PERIV T009 Fiscal Year Variants MANDT
1 MDKP PERIV T009 Fiscal Year Variants PERIV
0 MDKP PLDIS T024D MRP Controllers MANDT
0 MDKP PLDIS T024D MRP Controllers WERKS
0 MDKP PLDIS T024D MRP Controllers DISPO
1 MDKP PLSCN PLSC Planning scenarios in long-term planning MANDT
0 MDKP PLWRK T001W Plants/Branches WERKS
1 MDKP SOBSL T460A Special procurement key MANDT
1 MDKP SOBSL T460A Special procurement key WERKS
1 MDKP SOBSL T460A Special procurement key SOBSL
0 MDKP WRK02 T001W Plants/Branches WERKS