SAP Table T004

Directory of Charts of Accounts

T004 (Directory of Charts of Accounts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T004 to other SAP tables.

T004 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KTOPL Chart of Accounts KTOPL CHAR 4 0
SAKLN Significant length of the G/L account number SAKLN NUMC 2 0
0 Number of significant digits in the G/L account number
DSPRA Maintenance language for the chart of accounts SPRAS_004 T002 LANG 1 0
ASPRA Alternative languages ASPRA CHAR 10 0
KKTPL Group Chart of Accts KKTPL T004 CHAR 4 0
XSPER Indicator: is the chart of accounts blocked ? XSPER CHAR 1 0
X Yes
NULL No
NO_VBUND Trading partner cannot be entered NO_VBUND CHAR 1 0
X Yes
NULL No
INTEG_CO Type of integration between G/L accounts and cost elements INTEG_CO CHAR 1 0
NULL Manual creation of cost elements
2 Automatic creation of cost elements
LAYOUT_0 G/L account master record: Layout for "Central Processing" TAB_LAYOUT_GL_0 TAMLAY0 CHAR 4 0
LAYOUT_P G/L master data: Layout for "chart of accts processsing" TAB_LAYOUT_GL_P TAMLAY0 CHAR 4 0
LAYOUT_S G/L master data: Layout for "company code processing" TAB_LAYOUT_GL_S TAMLAY0 CHAR 4 0

T004 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T004 DSPRA T004 DSPRA T002 Language Keys (Component BC-I18) SPRAS
T004 KKTPL T004 MANDT T004 Directory of Charts of Accounts MANDT
T004 KKTPL T004 KKTPL T004 Directory of Charts of Accounts KTOPL
T004 LAYOUT_0 T004 LAYOUT_0 TAMLAY0 Tab pages in master data: Tab layouts LAYOUT
T004 LAYOUT_0 SYST MANDT TAMLAY0 Tab pages in master data: Tab layouts MANDT
T004 LAYOUT_0 'GL_MASTER' TAMLAY0 Tab pages in master data: Tab layouts APPL
T004 LAYOUT_P SYST MANDT TAMLAY0 Tab pages in master data: Tab layouts MANDT
T004 LAYOUT_P 'GL_MASTER' TAMLAY0 Tab pages in master data: Tab layouts APPL
T004 LAYOUT_P T004 LAYOUT_P TAMLAY0 Tab pages in master data: Tab layouts LAYOUT
T004 LAYOUT_S 'GL_MASTER' TAMLAY0 Tab pages in master data: Tab layouts APPL
T004 LAYOUT_S T004 LAYOUT_S TAMLAY0 Tab pages in master data: Tab layouts LAYOUT
T004 LAYOUT_S SYST MANDT TAMLAY0 Tab pages in master data: Tab layouts MANDT
T004 MANDT T004 MANDT T000 Clients MANDT