T004 (Directory of Charts of Accounts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T004 to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
KTOPL
Chart of Accounts
|
KTOPL |
CHAR
|
4 | 0 | ||||||||
|
SAKLN
Significant length of the G/L account number
|
SAKLN |
NUMC
|
2 | 0 | ||||||||
|
||||||||||||
|
DSPRA
Maintenance language for the chart of accounts
|
SPRAS_004 | T002 |
LANG
|
1 | 0 | |||||||
|
ASPRA
Alternative languages
|
ASPRA |
CHAR
|
10 | 0 | ||||||||
|
KKTPL
Group Chart of Accts
|
KKTPL | T004 |
CHAR
|
4 | 0 | |||||||
|
XSPER
Indicator: is the chart of accounts blocked ?
|
XSPER |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
NO_VBUND
Trading partner cannot be entered
|
NO_VBUND |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
INTEG_CO
Type of integration between G/L accounts and cost elements
|
INTEG_CO |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
LAYOUT_0
G/L account master record: Layout for "Central Processing"
|
TAB_LAYOUT_GL_0 | TAMLAY0 |
CHAR
|
4 | 0 | |||||||
|
LAYOUT_P
G/L master data: Layout for "chart of accts processsing"
|
TAB_LAYOUT_GL_P | TAMLAY0 |
CHAR
|
4 | 0 | |||||||
|
LAYOUT_S
G/L master data: Layout for "company code processing"
|
TAB_LAYOUT_GL_S | TAMLAY0 |
CHAR
|
4 | 0 | |||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T004 | DSPRA | T004 | DSPRA |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| T004 | KKTPL | T004 | MANDT |
T004
Directory of Charts of Accounts
|
MANDT |
| T004 | KKTPL | T004 | KKTPL |
T004
Directory of Charts of Accounts
|
KTOPL |
| T004 | LAYOUT_0 | T004 | LAYOUT_0 |
TAMLAY0
Tab pages in master data: Tab layouts
|
LAYOUT |
| T004 | LAYOUT_0 | SYST | MANDT |
TAMLAY0
Tab pages in master data: Tab layouts
|
MANDT |
| T004 | LAYOUT_0 | 'GL_MASTER' |
TAMLAY0
Tab pages in master data: Tab layouts
|
APPL | |
| T004 | LAYOUT_P | SYST | MANDT |
TAMLAY0
Tab pages in master data: Tab layouts
|
MANDT |
| T004 | LAYOUT_P | 'GL_MASTER' |
TAMLAY0
Tab pages in master data: Tab layouts
|
APPL | |
| T004 | LAYOUT_P | T004 | LAYOUT_P |
TAMLAY0
Tab pages in master data: Tab layouts
|
LAYOUT |
| T004 | LAYOUT_S | 'GL_MASTER' |
TAMLAY0
Tab pages in master data: Tab layouts
|
APPL | |
| T004 | LAYOUT_S | T004 | LAYOUT_S |
TAMLAY0
Tab pages in master data: Tab layouts
|
LAYOUT |
| T004 | LAYOUT_S | SYST | MANDT |
TAMLAY0
Tab pages in master data: Tab layouts
|
MANDT |
| T004 | MANDT | T004 | MANDT |
T000
Clients
|
MANDT |