1. Home
  2. Resources
  3. SAP Tables
  4. E2MDPSL - Master Stock Demand List (MDPS)

SAP Table E2MDPSL

Master Stock Demand List (MDPS)

E2MDPSL (Master Stock Demand List (MDPS)) 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 E2MDPSL to other SAP tables.

Source: E2MDPSL (Master Stock Demand List (MDPS))

E2MDPSL table fields

Field Data element Checktable Datatype Length Decimals
AUFVR Source number for order AUFVR CHAR 10 0
BAUGR Material number of higher-level assembly BAUGR CHAR 18 0
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
DAT00 Receipt/Requirements date DAT00 DATS 8 0
DAT01 Delivery/order finish date DAT01 DATS 8 0
DAT02 Start/release date DAT02 DATS 8 0
DEL12 MRP element number DEL12 CHAR 12 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
DELET Schedule Line Number MRP Element DELET NUMC 4 0
DELNR MRP element number DELNR CHAR 10 0
DELPS MRP element item DELPS NUMC 6 0
EINVR Source schedule line number EINVR NUMC 4 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
LGORT Storage Location LGORT_D CHAR 4 0
MNG01 Char 15 CHAR15 CHAR 15 0
MNG02 Char 15 CHAR15 CHAR 15 0
PLUMI Receipt/issue indicator PLUMI CHAR 1 0
POSVR Source item number POSVR NUMC 6 0
PSPEL Character field length 24 CHAR24 CHAR 24 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
VERID Production Version VERID CHAR 4 0
VRFKZ Availability indicator VRFKZ CHAR 1 0
WEBAZ R/2 table CHAR5 CHAR 5 0
WRK02 Production plant in planned order PWWRK CHAR 4 0
KUNNR Customer Number KUNNR CHAR 10 0
AUART Sales Document Type AUART CHAR 4 0
FIX01 Indicator: fixeing lot size in planned order FIX01 CHAR 1 0
X Yes
NULL No
BAART P.O./Order type BAART CHAR 4 0