SAP table reference

T004

Directory of Charts of Accounts

Explore 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.

/ Fields

T004 fields.

12 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key KTOPL Chart of AccountsCHAR40 KTOPL
SAKLN Significant Length of the G/L Account NumberNUMC20 SAKLN
DSPRA Maintenance Language for the Chart of AccountsLANG10 T002 SPRAS_004
ASPRA Alternative LanguagesCHAR100 ASPRA
KKTPL Group Chart of AcctsCHAR40 T004 KKTPL
XSPER Indicator: Is the Chart of Accounts Blocked ?CHAR10 XSPER
NO_VBUND Trading partner cannot be enteredCHAR10 NO_VBUND
INTEG_CO Type of integration between G/L accounts and cost elementsCHAR10 INTEG_CO
LAYOUT_0 G/L Account Master Record: Layout for "Central Processing"CHAR40 TAMLAY0 TAB_LAYOUT_GL_0
LAYOUT_P G/L Master Data: Layout for "Chart of Accts Processsing"CHAR40 TAMLAY0 TAB_LAYOUT_GL_P
LAYOUT_S G/L Master Data: Layout for "Company Code Processing"CHAR40 TAMLAY0 TAB_LAYOUT_GL_S
/ Relationships

T004 relationships.

13 relationships
TableFieldCheck tableDescriptionCheck field
T004DSPRAT002Language Keys (Component BC-I18)SPRAS
T004KKTPLT004Directory of Charts of AccountsMANDT
T004KKTPLT004Directory of Charts of AccountsKTOPL
T004LAYOUT_0TAMLAY0Tab pages in master data: Tab layoutsMANDT
T004LAYOUT_0TAMLAY0Tab pages in master data: Tab layoutsAPPL
T004LAYOUT_0TAMLAY0Tab pages in master data: Tab layoutsLAYOUT
T004LAYOUT_PTAMLAY0Tab pages in master data: Tab layoutsMANDT
T004LAYOUT_PTAMLAY0Tab pages in master data: Tab layoutsAPPL
T004LAYOUT_PTAMLAY0Tab pages in master data: Tab layoutsLAYOUT
T004LAYOUT_STAMLAY0Tab pages in master data: Tab layoutsMANDT
T004LAYOUT_STAMLAY0Tab pages in master data: Tab layoutsAPPL
T004LAYOUT_STAMLAY0Tab pages in master data: Tab layoutsLAYOUT
T004MANDTT000ClientsMANDT