MDTB - MRP Table

MRP Table information is stored in SAP table MDTB.
It is part of development package MD in software component PP-MRP-BD. This development package consists of objects that can be grouped under "Application Development R/3 Material Requirements Planning".

Fields for table MDTB

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
DTNUM	Number of material requirements planning table	X	DTNUM	NUMC	20
DTPOS	Item number of MRP list	X	DTPOS	NUMC	12
PLAKZ	Indicator for planning segment		PLAKZ	CHAR	2
PLANR	Planning segment number		PLANR	CHAR	40
DAT00	Receipt/Requirements date		DAT00	DATS	16
SORT1	Sort indicator 01		SORT1	CHAR	2
SORT2	Sort indicator 02		SORT2	CHAR	4
DELKZ	MRP element		DELKZ	CHAR	4
VSTAT	Processing Status		VSTAT_D	CHAR	2
VRFKZ	Availability indicator		VRFKZ	CHAR	2
PLUMI	Receipt/issue indicator		PLUMI	CHAR	2
MNG01	Quantity received or quantity required		MNG01	QUAN	7
MNG02	Variable scrap quantity		MNG02	QUAN	7
MNG03	Shortage Quantity		MNG03	QUAN	7
DAT01	Delivery/order finish date		DAT01	DATS	16
DAT02	Start/release date		DAT02	DATS	16
DAT03	Opening date		DAT03	DATS	16
PERKZ	Period Indicator		PERKZ	CHAR	2
PRPER	Forecast period		PRPER	NUMC	12
WEBAZ	Goods receipt processing time in days		WEBAZ	DEC	2
FIX01	Indicator: Fixing of Lot Size in Planned Order		FIX01	CHAR	2
FIX02	Indicator: fixing explosion in planned order		FIX02	CHAR	2
BAART	P.O./Order type		BAART	CHAR	8
BESKZ	Procurement Type		BESKZ	CHAR	2
SOBES	Special procurement type		SOBES	CHAR	2
UMSKZ	Special G/L Indicator		UMSKZ	CHAR	2	T074U
PLART	Planning type		PLART	CHAR	2	*
AUSSL	Exception message key		AUSSL	CHAR	4	T458A
WRK02	Planning/production plant		WRK02	CHAR	8	T001W
LGORT	Storage location		LGORT_D	CHAR	8	*
DELNR	MRP element number		DELNR	CHAR	20
DELPS	MRP element item		DELPS	NUMC	12
DELET	Schedule Line Number MRP Element		DELET	NUMC	8
AUFVR	Source number for order		AUFVR	CHAR	20
POSVR	Source item number		POSVR	NUMC	12
EINVR	Source schedule line number		EINVR	NUMC	8
UKZ01	Indicator: MRP element can be brought forward		UKZ01	CHAR	2
UMDAT	Rescheduling date		UMDAT	DATS	16
DEL12	MRP element number		DEL12	CHAR	24
BAUGR	Higher-Level Assembly Material		BAUGR	CHAR	80	MARA
DELVR	MRP element		DELKZ	CHAR	4
VERSB	Version Number for Independent Requirements		VERSB	CHAR	4
OLDSL	Key of the second exception message		OLDSL	CHAR	4	T458A
RDMNG	Excess stock quantity		RDMNG	QUAN	7
PLAAB	Material requirements planning segment		PLAAB	NUMC	4
TAG00	Daily shift (sort indicator 0)		TAG00	NUMC	4
ABEKZ	Exception indicator		ABEKZ	CHAR	2
MDFST	Production order status: internal ind. for MRP		MDFST	CHAR	2
MDMNG	MRP: quantity field (stock in transit, receipt qty, ...)		MDMNG	QUAN	7
VERID	Production Version		VERID	CHAR	8	*
WRK01	Planning Plant		PLWRK	CHAR	8	*
SERNR	BOM explosion number		SERNR	CHAR	16	*
REVLV	Revision Level		REVLV	CHAR	4
DBSKZ	Direct procurement indicator		DBSKZ	CHAR	2
EXTNL	Indicator for External Procurement		EXTNL	CHAR	2
ADINF	Field for Additional Information		MD_ADINF	CHAR	8
RESLO	Issuing Storage Location for Stock Transport Order		RESLO	CHAR	8	*
PRIO_URG	Requirement Urgency		PRIO_URG	NUMC	4	PURG
PRIO_REQ	Requirement Priority		PRIO_REQ	NUMC	6	PREQ
.INCLU--AP				MPN_MDTB	0
MPNMT	Material Number		MATNR	CHAR	80	*