SAP Table T004
Directory of Charts of Accounts
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.
T004 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| NO_VBUND | Trading partner cannot be entered | NO_VBUND | CHAR | 1 | 0 |
Possible values
|
||||||
| INTEG_CO | Type of integration between G/L accounts and cost elements | INTEG_CO | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 | ||||||
T004 foreign key relationships
| 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 |
