queryviz
tables/relationship path
open in builder
TSPA
SPART
MARA
MATNR
VBRP
VBELN
VBRK

VBRK

billing document: header data
sd20f · 1k · 5r

fields (20)

fieldtypelengthkeydescription
VBELNchar10pkbilling document number
BELNRchar10fi document number (populated after transfer to accounting)
BUKRSchar4company code (for fi posting)
FKARTchar4billing type (f2=invoice, g2=credit memo, l2=debit memo, re=returns invoice)
FKDATdats8billing date
FKSTOchar1billing document cancellation flag (x=cancelled)
FKTYPchar1billing category (l=delivery-based, b=order-based, etc.)
GJAHRnumc4fiscal year
KNUMVchar10condition record number (links to konv for billing document pricing)
KUNAGchar10sold-to party
KUNRGchar10payer (customer who pays the invoice)
MWSBKcurr13tax amount in document currency
NETWRcurr15net value of billing document in document currency
RFBSKchar1posting status of billing document (a=not transferred, b=fully transferred to fi, c=exception)
SFAKNchar10cancelled billing document number (reference to original if this is a cancellation)
SPARTchar2division
VKORGchar4sales organization
VTWEGchar2distribution channel
WAERKcuky5document currency
ZTERMchar4payment terms

relationships (5)

header / item

parent-child document structure

references
VBRP
VBELNVBELN
1:N
referenced by
VBRP
VBELNVBELN
N:1
configuration

reference to config tables

references
T001
BUKRSBUKRS
N:1
master lookup

reference to master data

references
KNA1
KUNAGKUNNR
N:1
BKPF
BUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
1:1
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms