T004 table in SAP ERP or S/4HANA stores Directory of Charts of Accounts data. There are total 12 fields in T004 table. The Directory of Charts of Accounts table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of T004 table. It is in Financial Accounting General Services ‘Basis’ (FBASCORE) ABAP package and is part of the Financial Accounting (FI) module.
SAP T004 Table Fields
Following is the list of fields that are available in SAP T004 table. The primary key fields of Directory of Charts of Accounts table in SAP are MANDT (Client), KTOPL (Chart of Accounts).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| KTOPL | Chart of Accounts | KTOPL | CHAR(4) | |
| SAKLN | Significant Length of the G/L Account Number | SAKLN | NUMC(2) | |
| DSPRA | Maintenance Language for the Chart of Accounts | SPRAS_004 | T002 | LANG(1) |
| ASPRA | Alternative Languages | ASPRA | CHAR(10) | |
| KKTPL | Group Chart of Accts | KKTPL | T004 | CHAR(4) |
| XSPER | Indicator: Is the Chart of Accounts Blocked ? | XSPER | CHAR(1) | |
| NO_VBUND | Trading partner cannot be entered | NO_VBUND | CHAR(1) | |
| INTEG_CO | Type of integration between G/L accounts and cost elements | INTEG_CO | CHAR(1) | |
| LAYOUT_0 | G/L Account Master Record: Layout for “Central Processing” | TAB_LAYOUT_GL_0 | TAMLAY0 | CHAR(4) |
| LAYOUT_P | G/L Master Data: Layout for “Chart of Accts Processsing” | TAB_LAYOUT_GL_P | TAMLAY0 | CHAR(4) |
| LAYOUT_S | G/L Master Data: Layout for “Company Code Processing” | TAB_LAYOUT_GL_S | TAMLAY0 | CHAR(4) |
