queryviz
tables/relationship path
open in builder
T052
ZTERM
BSIK
LIFNR, BUKRS
LFB1

LFB1

vendor master (company code)
fi20f · 3k · 5r

fields (20)

fieldtypelengthkeydescription
BUKRSchar4pkcompany code
LIFNRchar10pkaccount number of vendor or creditor
MANDTclnt3pkclient
AKONTchar10reconciliation account in general ledger
CERDTdats8certification date
ERDATdats8date on which the record was created
ERNAMchar12name of person who created the object
FDGRVchar10cash management group
HBKIDchar5short key for a house bank
LNRZEchar10head office account number (payer)
LOEVMchar1deletion flag for master record (company code level)
MINDKchar3minority indicators
PERNRnumc8personnel number
REPRFchar1indicator: check double invoices?
SPERRchar1indicator: payment block for company code
TOGRUchar4tolerance group for the vendor/customer
XVERRchar1indicator: clearing between customer and vendor?
ZTERMchar4terms of payment key
ZUESSIONchar3sort key
ZWELSchar10list of permitted payment methods

relationships (5)

master lookup

reference to master data

references
LFA1
LIFNRLIFNR
N:1
BSIK
LIFNRLIFNR
BUKRSBUKRS
1:N
referenced by
LFA1
LIFNRLIFNR
1:N
configuration

reference to config tables

references
T001
BUKRSBUKRS
N:1
T052
ZTERMZTERM
N:1
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms