T004
Directory of Charts of AccountsExplore another table
Enter a table code or keyword to continue exploring.
SAP table T004 is a Directory of Charts of Accounts. It serves as a central repository that holds metadata and configuration details for the charts of accounts used within an SAP system.
A Chart of Accounts (CoA) is a structured list of all general ledger (GL) accounts used by an organization to record its financial transactions. Each account in the chart has a unique identifier (account number) and a description, categorizing it as an asset, liability, equity, revenue, or expense.
In SAP, the CoA is represented in the T004 table, which acts as a directory to manage various CoAs configured in the system. This ensures that each company code can be assigned the appropriate CoA to meet its specific financial and reporting needs. For example:
A multinational company might use an operational CoA for daily transactions while aligning it with a group CoA for consolidated reporting at the corporate level.
SAP table T004 has 2 primary key fields: MANDT,KTOPL.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
T004 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||
| Key KTOPL | Chart of Accounts | CHAR | 4 | 0 | KTOPL | ||||||
| SAKLN | Significant Length of the G/L Account Number | NUMC | 2 | 0 | SAKLN | ||||||
| |||||||||||
| DSPRA | Maintenance Language for the Chart of Accounts | LANG | 1 | 0 | T002 | SPRAS_004 | |||||
| ASPRA | Alternative Languages | CHAR | 10 | 0 | ASPRA | ||||||
| KKTPL | Group Chart of Accts | CHAR | 4 | 0 | T004 | KKTPL | |||||
| XSPER | Indicator: Is the Chart of Accounts Blocked ? | CHAR | 1 | 0 | XSPER | ||||||
| NO_VBUND | Trading partner cannot be entered | CHAR | 1 | 0 | NO_VBUND | ||||||
| INTEG_CO | Type of integration between G/L accounts and cost elements | CHAR | 1 | 0 | INTEG_CO | ||||||
| |||||||||||
| LAYOUT_0 | G/L Account Master Record: Layout for "Central Processing" | CHAR | 4 | 0 | TAMLAY0 | TAB_LAYOUT_GL_0 | |||||
| LAYOUT_P | G/L Master Data: Layout for "Chart of Accts Processsing" | CHAR | 4 | 0 | TAMLAY0 | TAB_LAYOUT_GL_P | |||||
| LAYOUT_S | G/L Master Data: Layout for "Company Code Processing" | CHAR | 4 | 0 | TAMLAY0 | TAB_LAYOUT_GL_S | |||||
T004 relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| T004 | DSPRA | T002 | Language Keys (Component BC-I18) | SPRAS |
| T004 | KKTPL | T004 | Directory of Charts of Accounts | MANDT |
| T004 | KKTPL | T004 | Directory of Charts of Accounts | KTOPL |
| T004 | LAYOUT_0 | TAMLAY0 | Tab pages in master data: Tab layouts | MANDT |
| T004 | LAYOUT_0 | TAMLAY0 | Tab pages in master data: Tab layouts | APPL |
| T004 | LAYOUT_0 | TAMLAY0 | Tab pages in master data: Tab layouts | LAYOUT |
| T004 | LAYOUT_P | TAMLAY0 | Tab pages in master data: Tab layouts | MANDT |
| T004 | LAYOUT_P | TAMLAY0 | Tab pages in master data: Tab layouts | APPL |
| T004 | LAYOUT_P | TAMLAY0 | Tab pages in master data: Tab layouts | LAYOUT |
| T004 | LAYOUT_S | TAMLAY0 | Tab pages in master data: Tab layouts | MANDT |
| T004 | LAYOUT_S | TAMLAY0 | Tab pages in master data: Tab layouts | APPL |
| T004 | LAYOUT_S | TAMLAY0 | Tab pages in master data: Tab layouts | LAYOUT |
| T004 | MANDT | T000 | Clients | MANDT |