queryviz
tables/relationship path
open in builder
T002
SPRAS
LFA1
LIFNR
EKKO
EBELN
RSEG
BELNR, GJAHR
RBKP

RBKP

document header: incoming invoice
mm36f · 3k · 3r

fields (36)

fieldtypelengthkeydescription
BELNRchar10pkdocument number of an accounting document
GJAHRnumc4pkfiscal year
MANDTclnt3pkclient
BKTXTchar25document header text
BLARTchar2document type
BLDATdats8document date in document
BUDATdats8posting date in the document
BUKRSchar4company code
BVTYPchar4partner bank type
CPUDTdats8posting date of document
CPUTMtims6time of entry
DMBTRcurr13invoice amount in local currency
HWSTEcurr13tax amount in local currency
LIFNRchar10vendor account number
LOEKZchar1deletion indicator
NAVNWcurr13non-deductible input tax amount
NETDTdats8due date for net payment
RABGRcurr13total discount amount in local currency
RE_BELNRchar10accounting document number (subsequent)
RE_BUKRSchar4company code of subsequent accounting document
RE_GJAHRnumc4fiscal year of subsequent accounting document
RMWWRcurr13invoice amount (doc. currency)
SKFBTcurr13amount eligible for cash discount (doc. curr.)
SKNTOcurr13cash discount amount in document currency
STBLGchar10reversal document number
STJAHnumc4year of reversal document
TCODEchar20transaction code
USNAMchar12user name
WAERScurr5currency key
WMWSTcurr13tax amount in document currency
WRBTRcurr13invoice amount in document currency
XBLNRchar16external document number (vendor invoice #)
XZAHLchar1indicator: document is a down payment
ZLSCHchar1payment method
ZLSPRchar1payment block key
ZTERMchar4terms of payment key

relationships (3)

header / item

parent-child document structure

references
RSEG
BELNRBELNR
GJAHRGJAHR
1:N
referenced by
RSEG
BELNRBELNR
GJAHRGJAHR
N:1
master lookup

reference to master data

references
BKPF
BELNRBELNR
GJAHRGJAHR
BUKRSBUKRS
1:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms