1. Home
  2. Resources
  3. SAP Tables
  4. MDEZ - Individual lines of the MRP elements

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.

Source: MDEZ (Individual lines of the MRP elements)

MDEZ table fields

Field Data element Checktable Datatype Length Decimals
PLAAB Material requirements planning segment PLAAB NUMC 2 0
PLANR Planning segment number PLANR CHAR 20 0
SORT0 Numeric field length 8 NUM08 NUMC 8 0
TAG00 Daily shift (sort indicator 0) TAG00 NUMC 2 0
SORT1 Sort indicator 01 SORT1 CHAR 1 0
SORT2 Sort indicator 02 SORT2 CHAR 2 0
DELKZ MRP element DELKZ CHAR 2 0
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 1 0
VRFKZ Availability indicator VRFKZ CHAR 1 0
DAT00 Receipt/Requirements date DAT00 DATS 8 0
DAT01 Delivery/order finish date DAT01 DATS 8 0
DELB0 Abbreviation for MRP element DELB0 CHAR 6 0
EXTRA MRP element data EXTRA CHAR 40 0
AUSSL Exception message key AUSSL CHAR 2 0
AUSKT Exception message number AUSKT CHAR 2 0
MNG01 Quantity received or quantity required MNG01 QUAN 13 3
MNG02 Available quantity VRFMG QUAN 13 3
MNG03 Available quantity VRFMG QUAN 13 3
MNG04 ATP quantity MNG04 QUAN 13 3
FBYTE Single-Character Indicator CHAR1 CHAR 1 0
ALINE Line index for internal table processing XLINE INT4 10 0
ZLINE Line index for internal table processing XLINE INT4 10 0
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
ABEKZ Exception indicator ABEKZ CHAR 1 0
VERID Production Version VERID CHAR 4 0
SERNR BOM explosion number SERNR CHAR 8 0
REVLV Revision Level REVLV CHAR 2 0
MNAUS Variable scrap quantity MNG02 QUAN 13 3
DAT02 Start/release date DAT02 DATS 8 0
DAT03 Opening date DAT03 DATS 8 0
SOBES Special procurement type SOBES CHAR 1 0
0 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 1 0
WRK01 Planning Plant PLWRK CHAR 4 0
WRK02 Planning Plant PLWRK CHAR 4 0
SLOC2 Issuing/Receiving Storage Location SLOC2 CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
UMDAT Rescheduling date UMDAT DATS 8 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
MD4KD Customer name MD4KD CHAR 35 0
MD4LI Vendor name MD4LI CHAR 35 0
LLMSG Exception at a lower BOM level LLMESSAGE CHAR 2 0
LLDLY Delay for lower BOM levels MDDELAY INT4 10 0
TRAMG MRP: stock in transit TRAMG QUAN 13 3
USEX1 Field to be filled by user exit USEEX CHAR 30 0
USEX2 Field to be filled by user exit USEEX CHAR 30 0
USEX3 Field to be filled by user exit USEEX CHAR 30 0
SORT3 Sort indicator for individual customer segments SRTKD NUMC 8 0
UNIV1 Quantity received or quantity required MNG01 QUAN 13 3
UNIV2 Available quantity VRFMG QUAN 13 3
UNIV3 Text field TEXT CHAR 29 0
DETAIL_ICON Carrier field for icons ICON_TEXT CHAR 132 0
PRIO_URG Requirement Urgency PRIO_URG PURG NUMC 2 0
PRIO_REQ Requirement Priority PRIO_REQ PREQ NUMC 3 0
MDMAT Material Number MATNR CHAR 18 0
MDLOC Location of MRP Element MDLOC CHAR 20 0
MDWRK Plant WERKS_D CHAR 4 0
MDBER MRP Area BERID CHAR 10 0

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