SAP table 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're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.