MDKPDB

Header Data for MRP Document | #header | Component: Master Data
Column Name Description
MANDT Client
DTART Type of MRP list Show values
MATNR FK Material Number
BERID FK MRP Area
PLSCN FK Planning Scenario in Long-Term Planning
Column Name Description
Column Name Description
📏 Base Unit of Measure (MDKP.MEINS):
EISBE Safety Stock
MINBE Reorder Point
HOEBE Maximum Stock Level
BSTMI Minimum Lot Size
BSTMA Maximum Lot Size
BSTFX Fixed lot size
BSTRF Rounding value for purchase order quantity
SUM01 Plant stock / only plant segment
SUM02 No longer used/do not use!!
SUM03 No longer used/do not use!!
SUM04 No longer used/do not use!!
SUM05 No longer used/do not use!!
NEGBS Negative stock
BDARF Requirements quantity from material requirements planning
Column Name Description
DSDAT MRP date
FIXTR End of planning time fence (date)
AUSDT Effective-Out Date
BEADA MRP list processing date
MFXDT Manual firming date
Column Name Description
DTART Type of MRP list Show values
BDBKZ Selection indicator for processed MRP lists Show values
VRKZ1 Processing indicator 01 Show values
VRKZ2 Processing indicator 02 Show values
VRKZ3 Processing indicator - 03 Show values
BESKZ Procurement Type Show values
SOBES Special procurement type Show values
DISVF MRP Procedure Show values
MFHKZ Planning time fence set manually (MFXDT) Show values
LOSVF Lot-sizing procedure for short-term period Show values
LOSKZ Lot-size indicator for the short-term period Show values
MSGAR Message Type Show values
KZAUS Discontinuation indicator Show values
SAUFT Indicator: Repetitive Manufacturing Allowed Show values
SHFLG Safety time indicator (with or without safety time) Show values
FABKZ Indicator: Item Relevant to JIT Delivery Schedules Show values
BSKFL Flag whether stock correction factors exist Show values
CFLAG Aggregated MRP list Show values
GRREL Relevant for requirements grouping for project stock Show values
AHDIS MRP relevancy for dependent requirements Show values
BADON Indicator: BAdI is Active Show values
SGT_STATC Segmentation Status Show values
HANAON HANA Optimizations Active / Inactive Show values
Column Name Description Domain name
PLWRK MRP Area: Plant WERKS
DTNUM Number of material requirements planning table NUM10
SLKZ1 Selection indicator for exception groups CHAR1
SLKZ2 Selection indicator for exception groups CHAR1
SLKZ3 Selection indicator for exception groups CHAR1
SLKZ4 Selection indicator for exception groups CHAR1
SLKZ5 Selection indicator for exception groups CHAR1
SLKZ6 Selection indicator for exception groups CHAR1
SLKZ7 Selection indicator for exception groups CHAR1
SLKZ8 Selection indicator for exception groups CHAR1
DISST Low-Level Code DISST
MTWZT Material replenishment lead time DEC3
WEBAZ Goods receipt processing time in days DEC3
BEAZT Processing time for purchase order proposal DEC3
PERAZ Number of Periods for the Short-Term Area DEC03
MSGID Message identification ARBGB
MSGV1 Message variable 01 CHAR50
MSGV2 Message variable 02 CHAR50
MSGV3 Message variable 03 CHAR50
MSGV4 Message variable 04 CHAR50
RDPRF Rounding Profile RDPRF
BERW1 Stock Days' Supply Without Receipts DECV3_1
BERW2 First Receipt Days' Supply DECV3_1
NFMAT Follow-Up Material MATNR
AUSZ1 Exception group in the MRP list CHAR2
AUSZ2 Exception group in the MRP list CHAR2
AUSZ3 Exception group in the MRP list CHAR2
AUSZ4 Exception group in the MRP list CHAR2
AUSZ5 Exception group in the MRP list CHAR2
AUSZ6 Exception group in the MRP list CHAR2
AUSZ7 Exception group in the MRP list CHAR2
AUSZ8 Exception group in the MRP list CHAR2
NAUKZ Indicator: new exception in the MRP list CHAR1
KZPROMO Indicator: Material in promotion CHAR1
SHZET Safety Time (in Workdays) NUMC2
MAABC ABC Indicator MAABC
RWPRO Range of coverage profile RWPRO
SHPRO Period Profile for Safety Time SHPRO
BERW4 Second Receipt Days' Supply DECV3_1
Master Data Relations Join Conditions
MRP Area
  • MDKPDB.MANDT == MDLV.MANDT
  • MDKPDB.BERID == MDLV.BERID
MRP Group
  • MRP Group
  • Client
  • Planning/production plant
  • MDKPDB.DISGR == T438M.MTART
  • MDKPDB.MANDT == T438M.MANDT
  • MDKPDB.WRK02 == T438M.WERKS
Lot size (materials planning)
  • Lot Sizing Procedure within Materials Planning
  • Client
  • MDKPDB.DISLS == T439A.DISLS
  • MDKPDB.MANDT == T439A.MANDT
MRP type
  • MDKPDB.MANDT == T438A.MANDT
  • MDKPDB.DISMM == T438A.DISMM
MRP controller
  • Planning/production plant
  • MRP Controller
  • Client
  • MDKPDB.WRK02 == T024D.WERKS
  • MDKPDB.DISPO == T024D.DISPO
  • MDKPDB.MANDT == T024D.MANDT
Purchasing group
  • Purchasing Group
  • Client
  • MDKPDB.EKGRP == T024.EKGRP
  • MDKPDB.MANDT == T024.MANDT
Planning Cycle
  • Planning Cycle
  • Planning/production plant
  • MDKPDB.MANDT == T439G.MANDT
  • MDKPDB.LFRHY == T439G.MRPPP
  • MDKPDB.WRK02 == T439G.WERKS
Material
  • Material Number
  • Client
  • MDKPDB.MATNR == MARA.MATNR
  • MDKPDB.MANDT == MARA.MANDT
Unit of measure
  • MDKPDB.MANDT == T006.MANDT
  • MDKPDB.MEINS == T006.MSEHI
PPC Planning Calendar
  • PPC Planning Calendar
  • Planning/production plant
  • MDKPDB.MANDT == T439G.MANDT
  • MDKPDB.MRPPP == T439G.MRPPP
  • MDKPDB.WRK02 == T439G.WERKS
Material type
  • MDKPDB.MANDT == T134.MANDT
  • MDKPDB.MTART == T134.MTART
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • MDKPDB.PERIV == T009.PERIV
  • MDKPDB.MANDT == T009.MANDT
MRP controller
  • Planning/production plant
  • Planning controller (no longer used)
  • Client
  • MDKPDB.WRK02 == T024D.WERKS
  • MDKPDB.PLDIS == T024D.DISPO
  • MDKPDB.MANDT == T024D.MANDT
Planning Scenario in Long-Term Planning
  • MDKPDB.MANDT == PLSC.MANDT
  • MDKPDB.PLSCN == PLSC.PLSCN
Special procurement key
  • MRP Area: Plant
  • Special procurement type
  • MDKPDB.MANDT == T460A.MANDT
  • MDKPDB.PLWRK == T460A.WERKS
  • MDKPDB.SOBSL == T460A.SOBSL
Plant
  • MDKPDB.MANDT == T001W.MANDT
  • MDKPDB.WRK02 == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Message number
  • Message number
  • ?
  • ?
  • MDKPDB.MSGNR == T100.MSGNR
  • MDKPDB.[column in domain "SPRAS"] == T100.SPRSL
  • MDKPDB.[column in domain "ARBGB"] == T100.ARBGB