T004 is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores Directory of Charts of Accounts data. There are total 12 fields in the table. The T004 table can be found in the Financial Accounting General Services ‘Basis’ (FBASCORE) package and is part of the Financial Accounting (FI) module.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full buffering as specified by generic key |
T004 Table Fields
The following is the list of fields that are available in SAP T004 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type | Length |
|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT | 3 |
| KTOPL | Chart of Accounts | KTOPL | KTOPL | CHAR | 4 | |
| SAKLN | Significant Length of the G/L Account Number | SAKLN | SAKLN | NUMC | 2 | |
| DSPRA | Maintenance Language for the Chart of Accounts | SPRAS_004 | SPRAS | T002 | LANG | 1 |
| ASPRA | Alternative Languages | ASPRA | CHAR10 | CHAR | 10 | |
| KKTPL | Group Chart of Accts | KKTPL | KTOPL | T004 | CHAR | 4 |
| XSPER | Indicator: Is the Chart of Accounts Blocked ? | XSPER | XFELD | CHAR | 1 | |
| NO_VBUND | Trading partner cannot be entered | NO_VBUND | XFELD | CHAR | 1 | |
| INTEG_CO | Type of integration between G/L accounts and cost elements | INTEG_CO | INTEG_CO | CHAR | 1 | |
| LAYOUT_0 | G/L Account Master Record: Layout for “Central Processing” | TAB_LAYOUT_GL_0 | TAB_LAYOUT | TAMLAY0 | CHAR | 4 |
| LAYOUT_P | G/L Master Data: Layout for “Chart of Accts Processsing” | TAB_LAYOUT_GL_P | TAB_LAYOUT | TAMLAY0 | CHAR | 4 |
| LAYOUT_S | G/L Master Data: Layout for “Company Code Processing” | TAB_LAYOUT_GL_S | TAB_LAYOUT | TAMLAY0 | CHAR | 4 |
Availability
The SAP HANA table T004 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for T004 table
We’re updating the content all the time, so check back regularly.