MDEZ_DB - MDEZ DB Table

MDEZ DB Table information is stored in SAP table MDEZ_DB.
It is part of development package ODATA_PP_MRP in software component PP-FIO. This development package consists of objects that can be grouped under "OData Services for Material Requirements Planning".

Fields for table MDEZ_DB

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	S_MANDT	CLNT	6
MATNR	Material Number	X	MATNR	CHAR	80
PLANT	Plant	X	WERKS_D	CHAR	8
LINE	Numeric field length 8	X	NUM08	NUMC	16
PLAAB	Material requirements planning segment		PLAAB	NUMC	4
PLANR	Planning segment number		PLANR	CHAR	40
SORT0	Numeric field length 8		NUM08	NUMC	16
TAG00	Daily shift (sort indicator 0)		TAG00	NUMC	4
SORT1	Sort indicator 01		SORT1	CHAR	2
SORT2	Sort indicator 02		SORT2	CHAR	4
DELKZ	MRP element		DELKZ	CHAR	4
PLUMI	Receipt/issue indicator		PLUMI	CHAR	2
VRFKZ	Availability indicator		VRFKZ	CHAR	2
DAT00	Receipt/Requirements date		DAT00	DATS	16
DAT01	Delivery/order finish date		DAT01	DATS	16
DELB0	Abbreviation for MRP element		DELB0	CHAR	12
EXTRA	MRP element data		EXTRA	CHAR	80
AUSSL	Exception message key		AUSSL	CHAR	4
AUSKT	Exception message number		AUSKT	CHAR	4
MNG01	Quantity received or quantity required		MNG01	QUAN	7
MNG02	Available quantity		VRFMG	QUAN	7
MNG03	Available quantity		VRFMG	QUAN	7
MNG04	ATP quantity		MNG04	QUAN	7
FBYTE	Single-Character Flag		CHAR1	CHAR	2
ALINE	Line index for internal table processing		XLINE	INT4	4
SELKZ	Selection flag		SELKZ	CHAR	2
ABEKZ	Exception indicator		ABEKZ	CHAR	2
VERID	Production Version		VERID	CHAR	8
SERNR	BOM explosion number		SERNR	CHAR	16
REVLV	Revision Level		REVLV	CHAR	4
MNAUS	Variable scrap quantity		MNG02	QUAN	7
DAT02	Start/release date		DAT02	DATS	16
DAT03	Opening date		DAT03	DATS	16
SOBES	Special procurement type		SOBES	CHAR	2
ESOBS	Special procurement - external display		ESOBS	CHAR	2
WRK01	Planning Plant		PLWRK	CHAR	8
WRK02	Planning Plant		PLWRK	CHAR	8
SLOC2	Issuing/Receiving Storage Location		SLOC2	CHAR	8
LGORT	Storage location		LGORT_D	CHAR	8
UMDAT	Rescheduling date		UMDAT	DATS	16
LIFNR	Account Number of Supplier		LIFNR	CHAR	20
KUNNR	Customer Number		KUNNR	CHAR	20
MD4KD	Customer name		MD4KD	CHAR	70
MD4LI	Vendor Name		MD4LI	CHAR	70
LLMSG	Exception at a lower BOM level		LLMESSAGE	CHAR	4
LLDLY	Delay for lower BOM levels		MDDELAY	INT4	4
TRAMG	MRP: Stock in Transit		TRAMG	QUAN	7
USEX1	Field to be filled by user exit		USEEX	CHAR	60
USEX2	Field to be filled by user exit		USEEX	CHAR	60
USEX3	Field to be filled by user exit		USEEX	CHAR	60
SORT3	Sort indicator for individual customer segments		SRTKD	NUMC	16
UNIV1	Quantity received or quantity required		MNG01	QUAN	7
UNIV2	Available quantity		VRFMG	QUAN	7
UNIV3	Text field		TEXT	CHAR	58
DETAIL_ICON	Carrier field for icons		ICON_TEXT	CHAR	264
PRIO_URG	Requirement Urgency		PRIO_URG	NUMC	4	PURG
PRIO_REQ	Requirement Priority		PRIO_REQ	NUMC	6	PREQ
MDMAT	Material Number		MATNR	CHAR	80
MDLOC	Location of MRP Element		MDLOC	CHAR	40
MDWRK	Plant		WERKS_D	CHAR	8
MDBER	MRP Area		BERID	CHAR	20
SGT_RCAT	Requirement Segment		SGT_RCAT	CHAR	80
SGT_SCAT	Stock Segment		SGT_SCAT	CHAR	80
MPNMT	Material Number		MATNR	CHAR	80