1. Home
  2. Resources
  3. SAP Tables
  4. MDKP_DATA - Data Part for MRP List Header (MDKP, MDKPDB)

SAP Table MDKP_DATA

Data Part for MRP List Header (MDKP, MDKPDB)

MDKP_DATA (Data Part for MRP List Header (MDKP, MDKPDB)) 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 MDKP_DATA to other SAP tables.

MDKP_DATA table fields

Field Data element Checktable Datatype Length Decimals
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 CHAR 4 0
MEINS Base Unit of Measure MEINS 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 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 CHAR 4 0
DISMM MRP Type DISMM 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 CHAR 3 0
PLDIS Planning controller (no longer used) PLDIS CHAR 3 0
EKGRP Purchasing Group EKGRP 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 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 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 CHAR 4 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
MRPPP PPC planning calendar MRPPP CHAR 3 0
BDARF Requirements quantity from material requirements planning BDARF QUAN 13 3
LFRHY Planning cycle LFRHY 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