Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table MDEZ

Individual lines of the MRP elements

MDEZ (Individual lines of the MRP elements) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MDEZ to other SAP tables.

MDEZ table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

PLAAB

Material requirements planning segment

PLAAB

NUMC

PLANR

Planning segment number

PLANR

CHAR

SORT0

Numeric field length 8

NUM08

NUMC

TAG00

Daily shift (sort indicator 0)

TAG00

NUMC

SORT1

Sort indicator 01

SORT1

CHAR

SORT2

Sort indicator 02

SORT2

CHAR

DELKZ

MRP element

DELKZ

CHAR

Value	Description
AR	Dependent reservation
BA	Purchase requisition
BB	Subcontractor requirements of material provided
BE	Order item schedule line
BP	Gross requirements planning
BR	Process order
CH	Batch stock
ER	End of replenishment lead time
E1	Subcontracting purchasing
FE	Production order
FH	End of planning time fence
IH	Maintenance order
JI	JIT call
IM	Actual goods receipt quantity
IW	In plant (only relevant for IS Automotive)
KB	Individual customer stock
KD	Customer independent requirement (currently not used)
KK	Consignment stock for customer (availability check)
LA	Shipping notification
LB	Storage location stock
LC	Batch/storage location stock
LE	SA schedule line
LF	JIT delivery schedule
LK	Stock with subcontractor
LL	Forecast delivery schedule
MB	Goods issue
MR	Reservation
MS	Direct production
NE	Network order
PA	Planned order
PB	Project stock
PP	Planned independent requirement
PR	Forecast requirement
QM	Inspection lot for quality management
RP	Returns item
RR	MRP requirement (only relevant for IS-Automotive)
RU	Confirmation
S2	Simulated requirement from availability check
SA	Simulation order
SB	Dependent requirement
SF	Safety requirement
SH	Safety stock
SI	Simulation requirement
SM	Sim. dependent reqmts
SU	Total requirements
TB	Transfer requirements WMS
U1	Release order for a stock transfer order
U2	Release order for a stock transfer requisition
U3	Transfer requirement for simulation order
U4	Release order for stock transport scheduling agreement
UB	Unplanned requirement
UL	Reservation in another plant
UR	Stock transfer reservation
VA	Request for quotation
VB	Quotation
VC	Order
VE	SD scheduling agreement
VF	SD scheduling agreement; external service agent
VG	Contract
VH	Returns from Consignation Stock at Customer
VI	Delivery Free of Charge
VJ	Delivery
VP	Planning
VT	Returns (availability check)
VW	External sales order
VZ	Unverified delivery
WA	Goods issue
WB	Plant stock
WE	Goods receipt
WH	End replenishment period
DD	Effective-out date
C3	Subcontr. Customer Order Stock
C4	Subcontr. Project Stock

PLUMI

Receipt/issue indicator

PLUMI

CHAR

VRFKZ

Availability indicator

VRFKZ

CHAR

DAT00

Receipt/Requirements date

DAT00

DATS

DAT01

Delivery/order finish date

DAT01

DATS

DELB0

Abbreviation for MRP element

DELB0

CHAR

EXTRA

MRP element data

EXTRA

CHAR

AUSSL

Exception message key

AUSSL

CHAR

AUSKT

Exception message number

AUSKT

CHAR

MNG01

Quantity received or quantity required

MNG01

QUAN

MNG02

Available quantity

VRFMG

QUAN

MNG03

Available quantity

VRFMG

QUAN

MNG04

ATP quantity

MNG04

QUAN

FBYTE

Single-Character Indicator

CHAR1

CHAR

ALINE

Line index for internal table processing

XLINE

INT4

ZLINE

Line index for internal table processing

XLINE

INT4

SELKZ

Selection flag

SELKZ

CHAR

Value	Description
NULL	Not selected
*	Selected and processed
X	Selected but not yet processed

ABEKZ

Exception indicator

ABEKZ

CHAR

VERID

Production Version

VERID

CHAR

SERNR

BOM explosion number

SERNR

CHAR

REVLV

Revision Level

REVLV

CHAR

MNAUS

Variable scrap quantity

MNG02

QUAN

DAT02

Start/release date

DAT02

DATS

DAT03

Opening date

DAT03

DATS

SOBES

Special procurement type

SOBES

CHAR

Value	Description
NULL	Standard external procurement
2	Consignment
3	Subcontracting
7	Stock transfer
E	Standard in-house production
P	Production in plant 2
9	IS-OIL only: Stock transfer reservation

ESOBS

Special procurement - external display

ESOBS

CHAR

WRK01

Planning Plant

PLWRK

CHAR

WRK02

Planning Plant

PLWRK

CHAR

SLOC2

Issuing/Receiving Storage Location

SLOC2

CHAR

LGORT

Storage Location

LGORT_D

CHAR

UMDAT

Rescheduling date

UMDAT

DATS

LIFNR

Account Number of Vendor or Creditor

LIFNR

CHAR

KUNNR

Customer Number

KUNNR

CHAR

MD4KD

Customer name

MD4KD

CHAR

MD4LI

Vendor name

MD4LI

CHAR

LLMSG

Exception at a lower BOM level

LLMESSAGE

CHAR

LLDLY

Delay for lower BOM levels

MDDELAY

INT4

TRAMG

MRP: stock in transit

TRAMG

QUAN

USEX1

Field to be filled by user exit

USEEX

CHAR

USEX2

Field to be filled by user exit

USEEX

CHAR

USEX3

Field to be filled by user exit

USEEX

CHAR

SORT3

Sort indicator for individual customer segments

SRTKD

NUMC

UNIV1

Quantity received or quantity required

MNG01

QUAN

UNIV2

Available quantity

VRFMG

QUAN

UNIV3

Text field

TEXT

CHAR

DETAIL_ICON

Carrier field for icons

ICON_TEXT

CHAR

132

PRIO_URG

Requirement Urgency

PRIO_URG

PURG

NUMC

PRIO_REQ

Requirement Priority

PRIO_REQ

PREQ

NUMC

MDMAT

Material Number

MATNR

CHAR

MDLOC

Location of MRP Element

MDLOC

CHAR

MDWRK

Plant

WERKS_D

CHAR

MDBER

MRP Area

BERID

CHAR

MDEZ foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
MDEZ	PRIO_REQ	SYST	MANDT	PREQ Requirement Priorities	MANDT
MDEZ	PRIO_REQ	MDEZ	PRIO_REQ	PREQ Requirement Priorities	PRIO_REQ
MDEZ	PRIO_URG	SYST	MANDT	PURG Requirement Urgencies	MANDT
MDEZ	PRIO_URG	MDEZ	PRIO_URG	PURG Requirement Urgencies	PRIO_URG