Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table MDTB

MRP Table

MDTB (MRP Table) 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 MDTB to other SAP tables.

MDTB table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

MANDT

Client

MANDT

CLNT

DTNUM

Number of material requirements planning table

DTNUM

NUMC

DTPOS

Item number of MRP list

DTPOS

NUMC

PLAKZ

Indicator for planning segment

PLAKZ

CHAR

PLANR

Planning segment number

PLANR

CHAR

DAT00

Receipt/Requirements date

DAT00

DATS

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

VSTAT

Processing Status

VSTAT_D

CHAR

VRFKZ

Availability indicator

VRFKZ

CHAR

PLUMI

Receipt/issue indicator

PLUMI

CHAR

MNG01

Quantity received or quantity required

MNG01

QUAN

MNG02

Variable scrap quantity

MNG02

QUAN

MNG03

Shortage Quantity

MNG03

QUAN

DAT01

Delivery/order finish date

DAT01

DATS

DAT02

Start/release date

DAT02

DATS

DAT03

Opening date

DAT03

DATS

PERKZ

Period Indicator

PERKZ

CHAR

Value	Description
P	Period according to fiscal year variant
M	Monthly
W	Weekly
T	Daily
NULL	Initial value

PRPER

Forecast period

PRPER

NUMC

WEBAZ

Goods Receipt Processing Time in Days

WEBAZ

DEC

FIX01

Indicator: fixeing lot size in planned order

FIX01

CHAR

Value	Description
X	Yes
NULL	No

FIX02

Indicator: fixing explosion in planned order

FIX02

CHAR

Value	Description
X	Yes
NULL	No

BAART

P.O./Order type

BAART

CHAR

BESKZ

Procurement Type

BESKZ

CHAR

Value	Description
E	In-house production
F	External procurement
NULL	No procurement
X	Both procurement types

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

UMSKZ

Special G/L Indicator

UMSKZ

T074U

CHAR

PLART

Planning type

PLART

CHAR

AUSSL

Exception message key

AUSSL

T458A

CHAR

WRK02

Planning/production plant

WRK02

T001W

CHAR

LGORT

Storage Location

LGORT_D

CHAR

DELNR

MRP element number

DELNR

CHAR

DELPS

MRP element item

DELPS

NUMC

DELET

Schedule Line Number MRP Element

DELET

NUMC

AUFVR

Source number for order

AUFVR

CHAR

POSVR

Source item number

POSVR

NUMC

EINVR

Source schedule line number

EINVR

NUMC

UKZ01

Indicator: MRP element can be brought forward

UKZ01

CHAR

Value	Description
X	Yes
NULL	No

UMDAT

Rescheduling date

UMDAT

DATS

DEL12

MRP element number

DEL12

CHAR

BAUGR

Material number of higher-level assembly

BAUGR

MARA

CHAR

DELVR

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

VERSB

Version number for independent requirements

VERSB

CHAR

OLDSL

Key of the second exception message

OLDSL

T458A

CHAR

RDMNG

Excess stock quantity

RDMNG

QUAN

PLAAB

Material requirements planning segment

PLAAB

NUMC

TAG00

Daily shift (sort indicator 0)

TAG00

NUMC

ABEKZ

Exception indicator

ABEKZ

CHAR

MDFST

Production order status: internal ind. for MRP

MDFST

CHAR

MDMNG

MRP: quantity field (stock in transit, receipt qty, ...)

MDMNG

QUAN

VERID

Production Version

VERID

CHAR

WRK01

Planning Plant

PLWRK

CHAR

SERNR

BOM explosion number

SERNR

CHAR

REVLV

Revision Level

REVLV

CHAR

DBSKZ

Direct procurement indicator

DBSKZ

CHAR

Value	Description
NULL	No direct procurement or direct production
E	Direct production
F	Direct procurement

EXTNL

Indicator for External Procurement

EXTNL

CHAR

Value	Description
X	Yes
NULL	No

ADINF

Field for Additional Information

MD_ADINF

CHAR

RESLO

Issuing Storage Location for Stock Transport Order

RESLO

CHAR

PRIO_URG

Requirement Urgency

PRIO_URG

PURG

NUMC

PRIO_REQ

Requirement Priority

PRIO_REQ

PREQ

NUMC

MDTB foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
MDTB	AUSSL	MDTB	MANDT	T458A Exception Messages in Material Requirements Planning	MANDT
MDTB	AUSSL	MDTB	AUSSL	T458A Exception Messages in Material Requirements Planning	AUSSL
MDTB	BAUGR	MDTB	MANDT	MARA General Material Data	MANDT
MDTB	BAUGR	MDTB	BAUGR	MARA General Material Data	MATNR
MDTB	OLDSL	MDTB	MANDT	T458A Exception Messages in Material Requirements Planning	MANDT
MDTB	OLDSL	MDTB	OLDSL	T458A Exception Messages in Material Requirements Planning	AUSSL
MDTB	PRIO_REQ	MDTB	MANDT	PREQ Requirement Priorities	MANDT
MDTB	PRIO_REQ	MDTB	PRIO_REQ	PREQ Requirement Priorities	PRIO_REQ
MDTB	PRIO_URG	MDTB	MANDT	PURG Requirement Urgencies	MANDT
MDTB	PRIO_URG	MDTB	PRIO_URG	PURG Requirement Urgencies	PRIO_URG
MDTB	UMSKZ	SYST	MANDT	T074U Special G/L Indicator Properties	MANDT
MDTB	UMSKZ	T074U	KOART	T074U Special G/L Indicator Properties	KOART
MDTB	UMSKZ	MDTB	UMSKZ	T074U Special G/L Indicator Properties	UMSKZ
MDTB	WRK02	MDTB	MANDT	T001W Plants/Branches	MANDT
MDTB	WRK02	MDTB	WRK02	T001W Plants/Branches	WERKS