T004 Directory of Charts of Accounts

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 being MANDT,KTOPL.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.