SAP table MDTB (MRP Table)

SAP table MDTB has 3 primary key fields being MANDT,DTNUM,DTPOS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
DTNUM Number of material requirements planning table NUMC 10 0 DTNUM
DTPOS Item number of MRP list NUMC 6 0 DTPOS
PLAKZ Indicator for planning segment CHAR 1 0 PLAKZ
PLANR Planning segment number CHAR 20 0 PLANR
DAT00 Receipt/Requirements date DATS 8 0 DAT00
SORT1 Sort indicator 01 CHAR 1 0 SORT1
SORT2 Sort indicator 02 CHAR 2 0 SORT2
DELKZ MRP element CHAR 2 0 DELKZ
AR Dependent reservation
BA Purchase requisition
BB Subcontractor requirements of material provided
BE Order item schedule line
BP Gross requirements planning
BR Process order
C1 Customer stock
C2 Subcontr. Customer Stock
C3 Subcontr. Customer Order Stock
C4 Subcontr. Project Stock
CH Batch stock
CS SegmentBatchSLoc
DD Effective-out date
E1 Subcontracting purchasing
ER End of replenishment lead time
FE Production order
FH End of planning time fence
HS SegmentBatchStock
IH Maintenance order
IM Actual goods receipt quantity
IW In Plant (Shipping Notification)
JI JIT call
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
LS SegmentSLocStock
M2 Material Transfer
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
SD Safety Demand
SF Safety requirement
SG Stock Gain
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
WS SegmentStock
VSTAT Processing Status CHAR 1 0 VSTAT_D
VRFKZ Availability indicator CHAR 1 0 VRFKZ
PLUMI Receipt/issue indicator CHAR 1 0 PLUMI
MNG01 Quantity received or quantity required QUAN 13 3 MNG01
MNG02 Variable scrap quantity QUAN 13 3 MNG02
MNG03 Shortage Quantity QUAN 13 3 MNG03
DAT01 Delivery/order finish date DATS 8 0 DAT01
DAT02 Start/release date DATS 8 0 DAT02
DAT03 Opening date DATS 8 0 DAT03
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
PRPER Forecast period NUMC 6 0 PRPER
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
FIX01 Indicator: Fixing of Lot Size in Planned Order CHAR 1 0 FIX01
FIX02 Indicator: fixing explosion in planned order CHAR 1 0 FIX02
BAART P.O./Order type CHAR 4 0 BAART
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
SOBES Special procurement type CHAR 1 0 SOBES
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
9 IS-OIL only: Stock transfer reservation
E Standard in-house production
P Production in plant 2
UMSKZ Special G/L Indicator CHAR 1 0 T074U UMSKZ
PLART Planning type CHAR 1 0 * PLART
AUSSL Exception message key CHAR 2 0 T458A AUSSL
WRK02 Planning/production plant CHAR 4 0 T001W WRK02
LGORT Storage location CHAR 4 0 * LGORT_D
DELNR MRP element number CHAR 10 0 DELNR
DELPS MRP element item NUMC 6 0 DELPS
DELET Schedule Line Number MRP Element NUMC 4 0 DELET
AUFVR Source number for order CHAR 10 0 AUFVR
POSVR Source item number NUMC 6 0 POSVR
EINVR Source schedule line number NUMC 4 0 EINVR
UKZ01 Indicator: MRP element can be brought forward CHAR 1 0 UKZ01
UMDAT Rescheduling date DATS 8 0 UMDAT
DEL12 MRP element number CHAR 12 0 DEL12
BAUGR Higher-Level Assembly Material CHAR 40 0 MARA BAUGR
DELVR MRP element CHAR 2 0 DELKZ
AR Dependent reservation
BA Purchase requisition
BB Subcontractor requirements of material provided
BE Order item schedule line
BP Gross requirements planning
BR Process order
C1 Customer stock
C2 Subcontr. Customer Stock
C3 Subcontr. Customer Order Stock
C4 Subcontr. Project Stock
CH Batch stock
CS SegmentBatchSLoc
DD Effective-out date
E1 Subcontracting purchasing
ER End of replenishment lead time
FE Production order
FH End of planning time fence
HS SegmentBatchStock
IH Maintenance order
IM Actual goods receipt quantity
IW In Plant (Shipping Notification)
JI JIT call
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
LS SegmentSLocStock
M2 Material Transfer
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
SD Safety Demand
SF Safety requirement
SG Stock Gain
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
WS SegmentStock
VERSB Version Number for Independent Requirements CHAR 2 0 VERSB
OLDSL Key of the second exception message CHAR 2 0 T458A OLDSL
RDMNG Excess stock quantity QUAN 13 3 RDMNG
PLAAB Material requirements planning segment NUMC 2 0 PLAAB
TAG00 Daily shift (sort indicator 0) NUMC 2 0 TAG00
ABEKZ Exception indicator CHAR 1 0 ABEKZ
MDFST Production order status: internal ind. for MRP CHAR 1 0 MDFST
MDMNG MRP: quantity field (stock in transit, receipt qty, ...) QUAN 13 3 MDMNG
VERID Production Version CHAR 4 0 * VERID
WRK01 Planning Plant CHAR 4 0 * PLWRK
SERNR BOM explosion number CHAR 8 0 * SERNR
REVLV Revision Level CHAR 2 0 REVLV
DBSKZ Direct procurement indicator CHAR 1 0 DBSKZ
No direct procurement or direct production
E Direct production
F Direct procurement
EXTNL Indicator for External Procurement CHAR 1 0 EXTNL
ADINF Field for Additional Information CHAR 4 0 MD_ADINF
RESLO Issuing Storage Location for Stock Transport Order CHAR 4 0 * RESLO
PRIO_URG Requirement Urgency NUMC 2 0 PURG PRIO_URG
PRIO_REQ Requirement Priority NUMC 3 0 PREQ PRIO_REQ
000 Restriction Due to APO (Format INT1); 000 Only Internal
MPNMT Material Number CHAR 40 0 * MATNR

MDTB foreign key relationships

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