queryviz
tables/relationship path
open in builder
T052
ZTERM
BSID
KUNNR, BUKRS
KNB1

KNB1

customer master (company code)
fi19f · 3k · 5r

fields (19)

fieldtypelengthkeydescription
BUKRSchar4pkcompany code
KUNNRchar10pkcustomer number
MANDTclnt3pkclient
AKONTchar10reconciliation account in general ledger
BUSABchar2accounting clerk
ERDATdats8date on which the record was created
ERNAMchar12name of person who created the object
FDGRVchar10cash management group
HBKIDchar5short key for a house bank
KNRZEchar10head office account number
LOEVMchar1deletion flag (company code level)
SPERRchar1indicator: payment block?
TOGRUchar4tolerance group for business partner
XAUSZchar1indicator: automatic correspondence?
XVERRchar1indicator: clearing between customer and vendor?
ZAMESSIONchar10previous account number
ZTERMchar4terms of payment key
ZUESSIONchar3sort key
ZWELSchar10list of permitted payment methods

relationships (5)

configuration

reference to config tables

references
T001
BUKRSBUKRS
N:1
T052
ZTERMZTERM
N:1
master lookup

reference to master data

references
BSID
KUNNRKUNNR
BUKRSBUKRS
1:N
KNA1
KUNNRKUNNR
N:1
referenced by
KNA1
KUNNRKUNNR
1:N
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms