queryviz
tables/relationship path
open in builder
TVKO
LIFNR
LFA1
SPRAS
T002
SPRAS
SKAT
KTOPL, SAKNR
SKA1

SKA1

g/l account master (chart of accounts)
fi15f · 3k · 14r

fields (15)

fieldtypelengthkeydescription
KTOPLchar4pkchart of accounts
MANDTclnt3pkclient
SAKNRchar10pkg/l account number
BILKTchar10group account number
ERDATdats8date on which the record was created
ERNAMchar12name of person who created the object
FUNC_AREAchar16functional area
GVTYPchar2p&l statement account type
KTOKSchar4g/l account group
MCOD1char25search term for using matchcode
MUTEFGchar1flag indicating account requires manual entries
SAKANchar10g/l account number, significant length
XBILKchar1indicator: account is a balance sheet account?
XLOEVchar1indicator: account marked for deletion?
XSPEBchar1indicator: account blocked for creation?

relationships (14)

configuration

reference to config tables

references
T004
KTOPLKTOPL
N:1
SKB1
SAKNRSAKNR
1:N
referenced by
T012K
SAKNRHKONT
N:1
T030
SAKNRKONTS
N:1
master lookup

reference to master data

referenced by
SKB1
SAKNRSAKNR
N:1
BSET
SAKNRHKONT
N:1
BSIS
SAKNRHKONT
N:1
FEBEP
SAKNRHKONT
N:1
BSEG
SAKNRHKONT
N:1
AFAB
SAKNRSAKTO
M:1
SKAT
SAKNRSAKNR
N:1
BSAS
SAKNRHKONT
N:1
GLPCA
SAKNRRACCT
1:N
text table

descriptions and translations

references
SKAT
KTOPLKTOPL
SAKNRSAKNR
1:N
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms