queryviz
tables/relationship path
open in builder
TSPA
SPART
MARA
MATNR
EKPO
EBELN, EBELP
RSEG

RSEG

document item: incoming invoice
mm27f · 4k · 6r

fields (27)

fieldtypelengthkeydescription
BELNRchar10pkdocument number of an accounting document (invoice)
BUZEInumc3pkline item within accounting document
GJAHRnumc4pkfiscal year
MANDTclnt3pkclient
BPRMEunit3order price unit
BRTWRcurr13gross invoice amount in document currency
BSTMEunit3purchase order price unit
BSTMGquan13quantity in purchase order price unit
BUKRSchar4company code
DMBTRcurr13amount in local currency
EBELNchar10purchasing document number
EBELPnumc5item number of purchasing document
LFBNRchar10document number of reference document
LFGJAnumc4fiscal year of reference document
LFPOSnumc4item of reference document
MATNRchar18material number
MEINSunit3base unit of measure
MENGEquan13invoiced quantity
MWSKZchar2tax on sales/purchases code
NAVNWcurr13non-deductible input tax amount
SHKZGchar1debit/credit indicator
SKFBTcurr13amount eligible for cash discount
TXGRPnumc3group of tax line items
WEBREchar1indicator: gr-based invoice verification
WEPOSchar1goods receipt indicator
WERKSchar4plant
WRBTRcurr13amount in document currency

relationships (6)

master lookup

reference to master data

references
EKKO
EBELNEBELN
N:1
EKPO
EBELNEBELN
EBELPEBELP
N:1
referenced by
EKBE
EBELNEBELN
EBELPEBELP
1:N
EKPO
EBELNEBELN
EBELPEBELP
1:N
header / item

parent-child document structure

references
RBKP
BELNRBELNR
GJAHRGJAHR
N:1
referenced by
RBKP
BELNRBELNR
GJAHRGJAHR
1:N
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms