queryviz
tables/relationship path
open in builder
TSPA
SPART
MARA
MATNR
MARD
WERKS
T001W
WERKS
MDTB

MDTB

mrp table (mrp elements / planning situation)
pp16f · 5k · 9r
Unchanged in S/4
MDTB exists in S/4HANA but may not be fully populated when MRP Live is active. In S/4HANA MRP Live, the stock/requirements list (MD04) reads from in-memory structures. For classic MRP, MDTB remains the persistent table.

fields (16)

fieldtypelengthkeydescription
MANDTclnt3pkclient
MATNRchar18pkmaterial number
MDNUMchar8pkmrp document number
WERKSchar4pkplant
ZEILEnumc5pkmrp element line number
AUFNRchar12production order number
BANFNchar10purchase requisition number
BDMNGquan13requirement quantity
BDTERdats8requirements date
DELKZchar2mrp element indicator (subtype)
DZEIGchar1mrp element type
EBELNchar10purchase order number
EBELPnumc5purchase order item
LFDATdats8delivery/receipt date
PLNUMchar10planned order number
ZMENGquan13available/atp quantity

relationships (9)

master lookup

reference to master data

references
PLAF
PLNUMPLNUM
M:1
EBAN
BANFNBANFN
N:1
AUFK
AUFNRAUFNR
M:1
MARA
MATNRMATNR
N:1
EKKO
EBELNEBELN
N:1
referenced by
PLAF
PLNUMPLNUM
1:N
header / item

parent-child document structure

references
MDKP
MATNRMATNR
WERKSWERKS
MDNUMMDNUM
M:1
referenced by
MDKP
MATNRMATNR
WERKSWERKS
MDNUMMDNUM
1:N
configuration

reference to config tables

references
T001W
WERKSWERKS
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms