Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table MDPT

Path to Order (Pegged Requirement)

MDPT (Path to Order (Pegged Requirement)) 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 MDPT to other SAP tables.

MDPT table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

DELNR

MRP element number

DEL12

CHAR

DELPS

MRP element item

DELPS

NUMC

DELET

Schedule Line Number MRP Element

DELET

NUMC

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

MATNR

Material Number

MATNR

CHAR

WERKS

Plant

WERKS_D

CHAR

BERID

MRP Area

BERID

CHAR

PLAAB

Material requirements planning segment

PLAAB

NUMC

PLANR

Planning segment number

PLANR

CHAR

DAT00

Receipt/Requirements date

DAT00

DATS

BAART

P.O./Order type

BAART

CHAR

VERSB

Version number for independent requirements

VERSB

CHAR

MNG01

Quantity received or quantity required

MNG01

QUAN

MNG02

Quantity received or quantity required

MNG01

QUAN

INDEX

Field defined as in SY-TABIX

TABIX_D

INT4

ALLOC

Pegging: flag: receipt is allocated to requirement

ALLOC

CHAR

Value	Description
X	Yes
NULL	No

EXTRA

MRP element data

EXTRA

CHAR

LEVEL

Field defined as in SY-TABIX

TABIX_D

INT4

DELB1

Description of MRP element - up to 10 characters

DELB1

CHAR

MAKTX

Material Description (Short Text)

MAKTX

CHAR

MEINS

Base Unit of Measure

MEINS

UNIT

ICON_NOTE

Carrier field for icons

ICON_TEXT

CHAR

132