MDTB

MRP Table | #masterdata | Component: Master Data
Column Name Description
MANDT Client
DTNUM Number of material requirements planning table
DTPOS Item number of MRP list
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
MNG01 Quantity received or quantity required
MNG02 Variable scrap quantity
MNG03 Shortage Quantity
RDMNG Excess stock quantity
MDMNG MRP: quantity field (stock in transit, receipt qty, ...)
Column Name Description
DAT00 Receipt/Requirements date
DAT01 Delivery/order finish date
DAT02 Start/release date
DAT03 Opening date
UMDAT Rescheduling date
Column Name Description
DELKZ MRP element Show values
PERKZ Period Indicator Show values
FIX01 Indicator: Fixing of Lot Size in Planned Order Show values
FIX02 Indicator: fixing explosion in planned order Show values
BESKZ Procurement Type Show values
SOBES Special procurement type Show values
UKZ01 Indicator: MRP element can be brought forward Show values
DELVR MRP element Show values
DBSKZ Direct procurement indicator Show values
EXTNL Indicator for External Procurement Show values
Column Name Description Domain name
PLAKZ Indicator for planning segment PLAKZ
PLANR Planning segment number PLANR
SORT1 Sort indicator 01 SORT1
SORT2 Sort indicator 02 SORT2
VSTAT Processing Status VSTAT
VRFKZ Availability indicator VRFKZ
PLUMI Receipt/issue indicator CHAR1
PRPER Forecast period PRPER
WEBAZ Goods receipt processing time in days DEC3
BAART P.O./Order type BAART
PLART Planning type PLART
LGORT Storage location LGORT
DELNR MRP element number DELNR
DELPS MRP element item DELPS
DELET Schedule Line Number MRP Element DELET
AUFVR Source number for order CHAR10
POSVR Source item number NUM06
EINVR Source schedule line number NUM04
DEL12 MRP element number DEL12
VERSB Version Number for Independent Requirements VERSB
PLAAB Material requirements planning segment PLAAB
TAG00 Daily shift (sort indicator 0) TAG00
ABEKZ Exception indicator CHAR1
MDFST Production order status: internal ind. for MRP CHAR1
VERID Production Version VERID
WRK01 Planning Plant WERKS
SERNR BOM explosion number SERNR
REVLV Revision Level REVLV
ADINF Field for Additional Information MD_ADINF
RESLO Issuing Storage Location for Stock Transport Order LGORT
MPNMT Material Number MATNR
Master Data Relations Join Conditions
Exception Message
  • MDTB.MANDT == T458A.MANDT
  • MDTB.AUSSL == T458A.AUSSL
Higher-Level Assembly Material
  • Higher-Level Assembly Material
  • Client
  • MDTB.BAUGR == MARA.MATNR
  • MDTB.MANDT == MARA.MANDT
Key of the second exception message
  • MDTB.MANDT == T458A.MANDT
  • MDTB.OLDSL == T458A.AUSSL
Requirement Priority
  • Requirement Priority
  • Client
  • MDTB.PRIO_REQ == PREQ.PRIO_REQ
  • MDTB.MANDT == PREQ.MANDT
Requirement Urgency
  • Requirement Urgency
  • Client
  • MDTB.PRIO_URG == PURG.PRIO_URG
  • MDTB.MANDT == PURG.MANDT
Special G/L Indicator
  • Special G/L Indicator
  • ?
  • MDTB.MANDT == T074U.MANDT
  • MDTB.UMSKZ == T074U.UMSKZ
  • MDTB.[column in domain "KOART"] == T074U.KOART
Plant
  • MDTB.MANDT == T001W.MANDT
  • MDTB.WRK02 == T001W.WERKS