queryviz
tables/relationship path
open in builder
TSPA
SPART
MARA
MATNR
MARD
MATNR, WERKS, LGORT
ISEG

ISEG

physical inventory document items
mm18f · 3k · 3r
Unchanged in S/4
Retained in S/4HANA.

fields (18)

fieldtypelengthkeydescription
GJAHRnumc4pkfiscal year
IBLNRchar10pkphysical inventory document number
ZEILInumc5pkitem number in physical inventory document
ABWMEunit3unit of measure for difference quantity
ABWMGquan13difference quantity
BUCHMquan13book quantity at time of physical inventory
BWARTchar3movement type for physical inventory posting
CHARGchar10batch number
INSMKchar1stock type
KZINBchar1indicator: recount
KZLGPchar1indicator: counted at storage location
KZPERchar1indicator: count has been entered
LGORTchar4storage location
MATNRchar18material number
MEINSunit3base unit of measure
MENGEquan13counted quantity
SOBKZchar1special stock indicator
WERKSchar4plant

relationships (3)

header / item

parent-child document structure

references
IKPF
IBLNRIBLNR
GJAHRGJAHR
1:N
referenced by
IKPF
IBLNRIBLNR
GJAHRGJAHR
1:N
master lookup

reference to master data

references
MARD
MATNRMATNR
WERKSWERKS
LGORTLGORT
1:N
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms