queryviz
tables/relationship path
open in builder
TSPA
SPART
MARA
MATNR
MAKT
MATNR
MSEG
MBLNR, MJAHR
MKPF

MKPF

header: material document
mm22f · 2k · 2r
Merged into MATDOC
Material document header merged into MATDOC. Header fields (posting date, user, etc.) are denormalized into each MATDOC line item.
key differences:
  • •Header fields (BUDAT, USNAM, TCODE, etc.) available on every line item
  • •No separate header query needed
  • •MKPF still physically exists for compatibility views

fields (22)

fieldtypelengthkeydescription
MBLNRchar10pknumber of material document
MJAHRnumc4pkmaterial document year
AENAMchar12name of person who changed object
BKTXTchar25document header text
BLDATdats8document date in document
BRNCHchar4branch code
BUDATdats8posting date in the document
BWARTchar3movement type
CPUDTdats8day on which the accounting document was entered
CPUTMtims6time of entry
FRBNRchar16delivery note number (vendor)
HERKLchar3country of origin of material
NBLJPnumc4year of subsequent material document
NBLNRchar10subsequent material document number
SMBJPnumc4year of original material document (cancelled)
SMBLNchar10number of original material document (cancelled)
SMBLPnumc4item of original material document (cancelled)
TCODEchar20transaction code
USNAMchar12user name
VGARTchar2transaction/event type
WERKSchar4plant
XBLNRchar16external document number

relationships (2)

header / item

parent-child document structure

references
MSEG
MBLNRMBLNR
MJAHRMJAHR
1:N
referenced by
MSEG
MBLNRMBLNR
MJAHRMJAHR
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms