1. Home
  2. Resources
  3. SAP Tables
  4. MDTB - MRP Table

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
MANDT Client MANDT CLNT 3 0
DTNUM Number of material requirements planning table DTNUM NUMC 10 0
DTPOS Item number of MRP list DTPOS NUMC 6 0
PLAKZ Indicator for planning segment PLAKZ CHAR 1 0
PLANR Planning segment number PLANR CHAR 20 0
DAT00 Receipt/Requirements date DAT00 DATS 8 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
VSTAT Processing Status VSTAT_D CHAR 1 0
VRFKZ Availability indicator VRFKZ CHAR 1 0
PLUMI Receipt/issue indicator PLUMI CHAR 1 0
MNG01 Quantity received or quantity required MNG01 QUAN 13 3
MNG02 Variable scrap quantity MNG02 QUAN 13 3
MNG03 Shortage Quantity MNG03 QUAN 13 3
DAT01 Delivery/order finish date DAT01 DATS 8 0
DAT02 Start/release date DAT02 DATS 8 0
DAT03 Opening date DAT03 DATS 8 0
PERKZ Period Indicator PERKZ CHAR 1 0
P Period according to fiscal year variant
M Monthly
W Weekly
T Daily
NULL Initial value
PRPER Forecast period PRPER NUMC 6 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
FIX01 Indicator: fixeing lot size in planned order FIX01 CHAR 1 0
X Yes
NULL No
FIX02 Indicator: fixing explosion in planned order FIX02 CHAR 1 0
X Yes
NULL No
BAART P.O./Order type BAART CHAR 4 0
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
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
UMSKZ Special G/L Indicator UMSKZ T074U CHAR 1 0
PLART Planning type PLART CHAR 1 0
AUSSL Exception message key AUSSL T458A CHAR 2 0
WRK02 Planning/production plant WRK02 T001W CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
DELNR MRP element number DELNR CHAR 10 0
DELPS MRP element item DELPS NUMC 6 0
DELET Schedule Line Number MRP Element DELET NUMC 4 0
AUFVR Source number for order AUFVR CHAR 10 0
POSVR Source item number POSVR NUMC 6 0
EINVR Source schedule line number EINVR NUMC 4 0
UKZ01 Indicator: MRP element can be brought forward UKZ01 CHAR 1 0
X Yes
NULL No
UMDAT Rescheduling date UMDAT DATS 8 0
DEL12 MRP element number DEL12 CHAR 12 0
BAUGR Material number of higher-level assembly BAUGR MARA CHAR 18 0
DELVR 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
VERSB Version number for independent requirements VERSB CHAR 2 0
OLDSL Key of the second exception message OLDSL T458A CHAR 2 0
RDMNG Excess stock quantity RDMNG QUAN 13 3
PLAAB Material requirements planning segment PLAAB NUMC 2 0
TAG00 Daily shift (sort indicator 0) TAG00 NUMC 2 0
ABEKZ Exception indicator ABEKZ CHAR 1 0
MDFST Production order status: internal ind. for MRP MDFST CHAR 1 0
MDMNG MRP: quantity field (stock in transit, receipt qty, ...) MDMNG QUAN 13 3
VERID Production Version VERID CHAR 4 0
WRK01 Planning Plant PLWRK CHAR 4 0
SERNR BOM explosion number SERNR CHAR 8 0
REVLV Revision Level REVLV CHAR 2 0
DBSKZ Direct procurement indicator DBSKZ CHAR 1 0
NULL No direct procurement or direct production
E Direct production
F Direct procurement
EXTNL Indicator for External Procurement EXTNL CHAR 1 0
X Yes
NULL No
ADINF Field for Additional Information MD_ADINF CHAR 4 0
RESLO Issuing Storage Location for Stock Transport Order RESLO CHAR 4 0
PRIO_URG Requirement Urgency PRIO_URG PURG NUMC 2 0
PRIO_REQ Requirement Priority PRIO_REQ PREQ NUMC 3 0

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 OLDSL T458A Exception Messages in Material Requirements Planning AUSSL
MDTB OLDSL MDTB MANDT T458A Exception Messages in Material Requirements Planning MANDT
MDTB PRIO_REQ MDTB PRIO_REQ PREQ Requirement Priorities PRIO_REQ
MDTB PRIO_REQ MDTB MANDT PREQ Requirement Priorities MANDT
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