queryviz
tables/relationship path
open in builder
TVKO
BUKRS
T001
BUKRS
BKPF
BELNR, GJAHR, BUKRS
EKBE

EKBE

history per purchasing document
mm26f · 7k · 6r

fields (26)

fieldtypelengthkeydescription
BELNRchar10pkaccounting document number
BUZEInumc3pkline item within accounting document
EBELNchar10pkpurchasing document number
EBELPnumc5pkitem number of purchasing document
GJAHRnumc4pkfiscal year
VGABEchar1pktransaction/event type (po history)
ZEKKNnumc2pksequential number of account assignment
BEWTPchar1po history category
BUDATdats8posting date in the document
BUKRSchar4company code
BWAHRcurr5local currency
DMBTRcurr13amount in local currency
LFBNRchar10document no. of a reference document
LFGJAnumc4fiscal year of a reference document
LFPOSnumc4item of a reference document
MATNRchar18material number
MEINSunit3base unit of measure
MENGEquan13quantity
MWSKZchar2tax on sales/purchases code
REMNGquan13invoiced quantity
REWRTcurr13invoice value (remittance advice quantity)
SHKZGchar1debit/credit indicator
WAERScurr5currency key
WERKSchar4plant
WRBTRcurr13amount in document currency
XBLNRchar16external document number

relationships (6)

master lookup

reference to master data

references
RSEG
EBELNEBELN
EBELPEBELP
1:N
BKPF
BELNRBELNR
GJAHRGJAHR
BUKRSBUKRS
N:1
referenced by
ESKN
EBELNEBELN
EBELPEBELP
ZEKKNZEKKN
1:N
history

historical/audit records

references
EKKO
EBELNEBELN
N:1
EKPO
EBELNEBELN
EBELPEBELP
N:1
referenced by
EKPO
EBELNEBELN
EBELPEBELP
1:N
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms