queryviz
tables/relationship path
open in builder
T500P
BUKRS
T001
BUKRS
VBRK
VBELN
VBRP

VBRP

billing document: item data
sd16f · 2k · 4r

fields (16)

fieldtypelengthkeydescription
POSNRnumc6pkbilling item number
VBELNchar10pkbilling document number
ARKTXchar40short text for item
AUBELchar10sales order number (origin of billing item)
AUPOSnumc6sales order item number
FKIMGquan15billed quantity
MATNRchar18material number
MWSBTcurr13tax amount for item
MWSKZchar2tax classification code
NETWRcurr15net value of billing item
PSTYVchar4billing item category
VGBELchar10preceding document (e.g., delivery number)
VGPOSnumc6preceding item number
VRKMEunit3sales unit of measure
WAERKcuky5document currency
WERKSchar4plant

relationships (4)

header / item

parent-child document structure

references
VBRK
VBELNVBELN
N:1
referenced by
VBRK
VBELNVBELN
1:N
master lookup

reference to master data

references
MARA
MATNRMATNR
N:1
LIPS
VGBELVBELN
VGPOSPOSNR
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms