The SAP table T000 (Clients) is a core table in SAP systems that stores information about the various clients configured within the system. A "client" in SAP refers to a self-contained unit with its own master data and set of configuration settings, allowing multiple independent entities to operate within the same SAP system.
Changes to the T000 table are critical as they affect the fundamental configuration of the SAP system. Only authorized personnel with a deep understanding of SAP client architecture should make modifications to this table.
SAP table T000 has 1 primary key field being MANDT.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
MANDT
MTEXT
Client name
CHAR
25
0
MTEXT_D
ORT01
City
CHAR
25
0
ORT01
MWAER
Standard Currency in Client
CUKY
5
0
TCURC
MWAER
ADRNR
Character Field with Length 10
CHAR
10
0
CHAR10
CCCATEGORY
Client control: Role of client (production, test,...)
CHAR
1
0
CCCATEGORY
Possible values
C
Customizing
D
Demo
E
Training/Education
P
Production
S
SAP reference
T
Test
CCCORACTIV
Changes and transports for client-specific objects
CHAR
1
0
CCCORACTIV
Possible values
Changes without automatic recording
1
Automatic recording of changes
2
No changes allowed
3
Changes without automatic recording,no transport allowed
CCNOCLIIND
Maintenance authorization for objects in all clients
CHAR
1
0
CCNOCLIIND
Possible values
Changes to repository and cross-client customizing allowed
1
No changes to cross-client customizing objects
2
No changes to repository objects
3
No changes to repository/cross-client customizing objects
CCCOPYLOCK
Protection reg. client copy program and comparison tools
CHAR
1
0
CCCOPYLOCK
CCNOCASCAD
Client control: No client cascade for upgrade import
CHAR
1
0
CCNOCASCAD
CCSOFTLOCK
Client control: Soft Lock Required (Planned for 4.0)
CHAR
1
0
CCSOFTLOCK
CCORIGCONT
Recording Client for Switch BC Sets
CHAR
1
0
CCORIGCONT
CCIMAILDIS
Client Control: CATT und eCATT Start Authorization
CHAR
1
0
CCIMAILDIS
CCTEMPLOCK
Client control: Indicator that client is temporarily locked
CHAR
1
0
CCTEMPLOCK
CHANGEUSER
Last Changed By
CHAR
12
0
AS4USER
CHANGEDATE
Last Changed On
DATS
8
0
AS4DATE
LOGSYS
Logical system
CHAR
10
0
TBDLS
LOGSYS
T000 foreign key relationships
Table
Field
Check Table
Check Field
0 T000
LOGSYS
TBDLS Logical system
LOGSYS
1 T000
MWAER
TCURC Currency Codes
MANDT
1 T000
MWAER
TCURC Currency Codes
WAERS