SAP ABAP Table MDTB (MRP Table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD (Package) Application development R/3 requirements planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MDTB	Table Relationship Diagram
Short Description	MRP Table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DTNUM	☑	DTNUM	NUM10	NUMC	10	0	Number of material requirements planning table
3	DTPOS	☑	DTPOS	NUM06	NUMC	6	0	Item number of MRP list
4	PLAKZ	☐	PLAKZ	PLAKZ	CHAR	1	0	Indicator for planning segment
5	PLANR	☐	PLANR	PLANR	CHAR	20	0	Planning segment number
6	DAT00	☐	DAT00	DATUM	DATS	8	0	Receipt/Requirements date
7	SORT1	☐	SORT1	SORT1	CHAR	1	0	Sort indicator 01
8	SORT2	☐	SORT2	SORT2	CHAR	2	0	Sort indicator 02
9	DELKZ	☐	DELKZ	DELKZ	CHAR	2	0	MRP element
10	VSTAT	☐	VSTAT_D	VSTAT	CHAR	1	0	Processing Status
11	VRFKZ	☐	VRFKZ	VRFKZ	CHAR	1	0	Availability indicator
12	PLUMI	☐	PLUMI	CHAR1	CHAR	1	0	Receipt/issue indicator
13	MNG01	☐	MNG01	MENGV13	QUAN	13	3	Quantity received or quantity required
14	MNG02	☐	MNG02	MENG13	QUAN	13	3	Variable scrap quantity
15	MNG03	☐	MNG03	MENG13	QUAN	13	3	Shortage Quantity
16	DAT01	☐	DAT01	DATUM	DATS	8	0	Delivery/order finish date
17	DAT02	☐	DAT02	DATUM	DATS	8	0	Start/release date
18	DAT03	☐	DAT03	DATUM	DATS	8	0	Opening date
19	PERKZ	☐	PERKZ	PERKZ	CHAR	1	0	Period indicator
20	PRPER	☐	PRPER	PRPER	NUMC	6	0	Forecast period
21	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
22	FIX01	☐	FIX01	XFELD	CHAR	1	0	Indicator: Fixing of Lot Size in Planned Order
23	FIX02	☐	FIX02	XFELD	CHAR	1	0	Indicator: fixing explosion in planned order
24	BAART	☐	BAART	BAART	CHAR	4	0	P.O./Order type
25	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
26	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
27	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
28	PLART	☐	PLART	PLART	CHAR	1	0	Planning type	*
29	AUSSL	☐	AUSSL	AUSSL	CHAR	2	0	Exception message key	T458A
30	WRK02	☐	WRK02	WERKS	CHAR	4	0	Planning/production plant	T001W
31	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
32	DELNR	☐	DELNR	DELNR	CHAR	10	0	MRP element number
33	DELPS	☐	DELPS	DELPS	NUMC	6	0	MRP element item
34	DELET	☐	DELET	DELET	NUMC	4	0	Scheduling number planning element
35	AUFVR	☐	AUFVR	CHAR10	CHAR	10	0	Source number for order
36	POSVR	☐	POSVR	NUM06	NUMC	6	0	Source item number
37	EINVR	☐	EINVR	NUM04	NUMC	4	0	Source schedule line number
38	UKZ01	☐	UKZ01	XFELD	CHAR	1	0	Indicator: MRP element can be brought forward
39	UMDAT	☐	UMDAT	DATUM	DATS	8	0	Rescheduling date
40	DEL12	☐	DEL12	DEL12	CHAR	12	0	MRP element number
41	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	MARA
42	DELVR	☐	DELKZ	DELKZ	CHAR	2	0	MRP element
43	VERSB	☐	VERSB	VERSB	CHAR	2	0	Version number for independent requirements	*
44	OLDSL	☐	OLDSL	AUSSL	CHAR	2	0	Key of the second exception message	T458A
45	RDMNG	☐	RDMNG	MENG13	QUAN	13	3	Excess stock quantity
46	PLAAB	☐	PLAAB	PLAAB	NUMC	2	0	Material requirements planning segment
47	TAG00	☐	TAG00	TAG00	NUMC	2	0	Daily shift (sort indicator 0)
48	ABEKZ	☐	ABEKZ	CHAR1	CHAR	1	0	Exception indicator
49	MDFST	☐	MDFST	CHAR1	CHAR	1	0	Production order status: internal ind. for MRP
50	MDMNG	☐	MDMNG	MENGV13	QUAN	13	3	MRP: quantity field (stock in transit, receipt qty, ...)
51	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
52	WRK01	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
53	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
54	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
55	DBSKZ	☐	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
56	EXTNL	☐	EXTNL	XFELD	CHAR	1	0	Indicator for External Procurement
57	ADINF	☐	MD_ADINF	MD_ADINF	CHAR	4	0	Field for Additional Information
58	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
59	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
60	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDTB	AUSSL	T458A	AUSSL
2	MDTB	BAUGR	MARA	MATNR	KEY	1	CN
3	MDTB	OLDSL	T458A	AUSSL	REF	C	CN
4	MDTB	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
5	MDTB	PRIO_URG	PURG	PRIO_URG	REF	1	CN
6	MDTB	UMSKZ	T074U	UMSKZ	REF	C	CN
7	MDTB	WRK02	T001W	WERKS

History

Last changed by/on	SAP	20140121
SAP Release Created in