1. Home
  2. Resources
  3. SAP Tables
  4. MDKPDB - Header Data for MRP Document

SAP Table MDKPDB

Header Data for MRP Document

MDKPDB (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 MDKPDB to other SAP tables.

MDKPDB table fields

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

MDKPDB foreign key relationships

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