SAP ABAP Table MDEZ (Individual lines of the MRP elements)

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	INTTAB	Structure
Structure	MDEZ	Table Relationship Diagram
Short Description	Individual lines of the MRP elements

Delivery and Maintenance

Pool/cluster
Delivery Class
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	PLAAB	☐	PLAAB	PLAAB	NUMC	2	0	Material requirements planning segment
2	PLANR	☐	PLANR	PLANR	CHAR	20	0	Planning segment number
3	SORT0	☐	NUM08	NUM08	NUMC	8	0	Numeric field length 8
4	TAG00	☐	TAG00	TAG00	NUMC	2	0	Daily shift (sort indicator 0)
5	SORT1	☐	SORT1	SORT1	CHAR	1	0	Sort indicator 01
6	SORT2	☐	SORT2	SORT2	CHAR	2	0	Sort indicator 02
7	DELKZ	☐	DELKZ	DELKZ	CHAR	2	0	MRP element
8	PLUMI	☐	PLUMI	CHAR1	CHAR	1	0	Receipt/issue indicator
9	VRFKZ	☐	VRFKZ	VRFKZ	CHAR	1	0	Availability indicator
10	DAT00	☐	DAT00	DATUM	DATS	8	0	Receipt/Requirements date
11	DAT01	☐	DAT01	DATUM	DATS	8	0	Delivery/order finish date
12	DELB0	☐	DELB0	DELB0	CHAR	6	0	Abbreviation for MRP element
13	EXTRA	☐	EXTRA	CHAR40	CHAR	40	0	MRP element data
14	AUSSL	☐	AUSSL	AUSSL	CHAR	2	0	Exception message key	*
15	AUSKT	☐	AUSKT	AUSKT	CHAR	2	0	Exception message number
16	MNG01	☐	MNG01	MENGV13	QUAN	13	3	Quantity received or quantity required
17	MNG02	☐	VRFMG	MENGV13	QUAN	13	3	Available quantity
18	MNG03	☐	VRFMG	MENGV13	QUAN	13	3	Available quantity
19	MNG04	☐	MNG04	MENGV13	QUAN	13	3	ATP quantity
20	FBYTE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
21	ALINE	☐	XLINE	XLINE	INT4	10	0	Line index for internal table processing
22	ZLINE	☐	XLINE	XLINE	INT4	10	0	Line index for internal table processing
23	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
24	ABEKZ	☐	ABEKZ	CHAR1	CHAR	1	0	Exception indicator
25	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
26	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
27	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
28	MNAUS	☐	MNG02	MENG13	QUAN	13	3	Variable scrap quantity
29	DAT02	☐	DAT02	DATUM	DATS	8	0	Start/release date
30	DAT03	☐	DAT03	DATUM	DATS	8	0	Opening date
31	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
32	ESOBS	☐	ESOBS	ESOBS	CHAR	1	0	Special procurement - external display	*
33	WRK01	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
34	WRK02	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
35	SLOC2	☐	SLOC2	LGORT	CHAR	4	0	Issuing/Receiving Storage Location	*
36	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
37	UMDAT	☐	UMDAT	DATUM	DATS	8	0	Rescheduling date
38	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
39	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
40	MD4KD	☐	MD4KD	NAME	CHAR	35	0	Customer name
41	MD4LI	☐	MD4LI	NAME	CHAR	35	0	Vendor name
42	LLMSG	☐	LLMESSAGE	AUSSL	CHAR	2	0	Exception at a lower BOM level	*
43	LLDLY	☐	MDDELAY	INT4	INT4	10	0	Delay for lower BOM levels
44	TRAMG	☐	TRAMG	MENGV13	QUAN	13	3	MRP: stock in transit
45	USEX1	☐	USEEX	CHAR30	CHAR	30	0	Field to be filled by user exit
46	USEX2	☐	USEEX	CHAR30	CHAR	30	0	Field to be filled by user exit
47	USEX3	☐	USEEX	CHAR30	CHAR	30	0	Field to be filled by user exit
48	SORT3	☐	SRTKD	NUM8	NUMC	8	0	Sort indicator for individual customer segments
49	UNIV1	☐	MNG01	MENGV13	QUAN	13	3	Quantity received or quantity required
50	UNIV2	☐	VRFMG	MENGV13	QUAN	13	3	Available quantity
51	UNIV3	☐	TEXT	FL_TEXT	CHAR	29	0	Text field
52	DETAIL_ICON	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
53	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
54	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
55	MDMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
56	MDLOC	☐	MDLOC		CHAR	20	0	Location of MRP Element
57	MDWRK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
58	MDBER	☐	BERID	BERID	CHAR	10	0	MRP Area	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDEZ	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
2	MDEZ	PRIO_URG	PURG	PRIO_URG	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in