queryviz
tables/relationship path
open in builder
TSPA
SPART
MARA
MATNR
ACDOCA
RBUKRS → BUKRS, RACCT → SAKNR
SKB1

SKB1

g/l account master (company code)
fi18f · 3k · 5r

fields (18)

fieldtypelengthkeydescription
BUKRSchar4pkcompany code
MANDTclnt3pkclient
SAKNRchar10pkg/l account number
ALTKTchar10group account number (country alternative chart of accounts)
BEGRUchar4authorization group
ERDATdats8date on which the record was created
ERNAMchar12name of person who created the object
FDLEVchar2planning level
FSTAGchar4field status group
MITKZchar1reconciliation account in g/l
MWSKZchar2tax category
WAERScuky5account currency
XINTBchar1indicator: post automatically only?
XKRESchar1indicator: line item display?
XLOEVchar1indicator: account marked for deletion in company code?
XOPVWchar1indicator: open item management?
XSPEBchar1indicator: account blocked for posting in company code?
ZUESSIONchar3sort key

relationships (5)

master lookup

reference to master data

references
SKA1
SAKNRSAKNR
N:1
referenced by
ACDOCA
BUKRSRBUKRS
SAKNRRACCT
N:1
configuration

reference to config tables

references
TCURC
WAERSWAERS
N:1
T001
BUKRSBUKRS
N:1
referenced by
SKA1
SAKNRSAKNR
1:N
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms