queryviz
tables/relationship path
open in builder
T512T
SPRSL → SPRAS
T002
SPRAS
MAKT
MATNR
MSEG

MSEG

document segment: material
mm43f · 3k · 10r
Replaced by MATDOC
Material document line items moved to MATDOC. MATDOC merges header (MKPF) and item (MSEG) data into a single table — same pattern as ACDOCA for finance.
key differences:
  • •MATDOC combines MKPF header fields and MSEG item fields into one table
  • •No more separate header/item join needed for material documents
  • •New key structure: MBLNR + MJAHR + ZEILE + LINE_ID
  • •MSEG still exists in compatibility mode but MATDOC is the primary table
  • •Movement type (BWART) logic unchanged — same values apply

fields (43)

fieldtypelengthkeydescription
MBLNRchar10pknumber of material document
MJAHRnumc4pkmaterial document year
ZEILEnumc4pkitem in material document
AUFNRchar12order number
BELNRchar10accounting document number
BELNR_FIchar10fi document number
BUKRSchar4company code
BUSTMchar4update control / value string (wm)
BUZEInumc3line item within accounting document
BUZEI_FInumc3fi document line item
BWARTchar3movement type (inventory management)
BWTARchar10valuation type
CHARGchar10batch number
DMBTRcurr13amount in local currency
EBELNchar10purchasing document number
EBELPnumc5item number of purchasing document
EXBWRcurr13external amount in local currency
GJAHRnumc4fiscal year
GJAHR_FInumc4fi fiscal year
HSDATdats8shelf life expiration date
KOSTLchar10cost center
KZBEWchar1stock category indicator
KZEARchar1final issue for this reservation
KZVBRchar1consumption indicator
KZZUGchar1receipt indicator
LFBNRchar10document number for reference document
LFGJAnumc4fiscal year of reference document
LFPOSnumc4item of a reference document
LGORTchar4storage location
MATNRchar18material number
MEINSunit3base unit of measure
MENGEquan13quantity
RSNUMnumc10number of reservation / dependent requirements
RSPOSnumc4item number of reservation / dep. requirements
SHKZGchar1debit/credit indicator
SMBJPnumc4year of original material document
SMBLNchar10number of original material document
SMBLPnumc4item in original material document
VBELNchar10delivery note number
VBELPnumc6delivery item
WAERScurr5currency key
WERKSchar4plant
WRBTRcurr13amount in document currency

relationships (10)

master lookup

reference to master data

references
MARA
MATNRMATNR
N:1
MARD
MATNRMATNR
WERKSWERKS
LGORTLGORT
N:1
EKPO
EBELNEBELN
EBELPEBELP
N:1
BSEG
BELNR_FIBELNR
BUZEI_FIBUZEI
GJAHR_FIGJAHR
BUKRSBUKRS
1:1
MARC
MATNRMATNR
WERKSWERKS
N:1
referenced by
RESB
RSNUMRSNUM
RSPOSRSPOS
1:N
configuration

reference to config tables

referenced by
T156
BWARTBWART
1:N
text table

descriptions and translations

references
MAKT
MATNRMATNR
N:1
header / item

parent-child document structure

references
MKPF
MBLNRMBLNR
MJAHRMJAHR
N:1
referenced by
MKPF
MBLNRMBLNR
MJAHRMJAHR
1:N
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms