Follow us on LinkedIn for your next SAP project

SAP Table T000

Clients

T000 (Clients) 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 T000 to other SAP tables.

T000 table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT
CLNT
3 0
MTEXT
Client name
MTEXT_D
CHAR
25 0
ORT01
City
ORT01
CHAR
25 0
MWAER
Standard currency throughout client
MWAER TCURC
CUKY
5 0
ADRNR
Character Field Length = 10
CHAR10
CHAR
10 0
CCCATEGORY
Client control: Role of client (production, test,...)
CCCATEGORY
CHAR
1 0
CCCORACTIV
Changes and transports for client-specific objects
CCCORACTIV
CHAR
1 0
CCNOCLIIND
Maintenance authorization for objects in all clients
CCNOCLIIND
CHAR
1 0
CCCOPYLOCK
Protection reg. client copy program and comparison tools
CCCOPYLOCK
CHAR
1 0
CCNOCASCAD
Client control: No client cascade for upgrade import
CCNOCASCAD
CHAR
1 0
CCSOFTLOCK
Client control: Soft Lock Required (Planned for 4.0)
CCSOFTLOCK
CHAR
1 0
CCORIGCONT
Recording Client for Switch BC Sets
CCORIGCONT
CHAR
1 0
CCIMAILDIS
Client Control: CATT und eCATT Authorization
CCIMAILDIS
CHAR
1 0
CCTEMPLOCK
Client control: Indicator that client is temporarily locked
CCTEMPLOCK
CHAR
1 0
CHANGEUSER
Last Changed by
AS4USER
CHAR
12 0
CHANGEDATE
Date of Last Change
AS4DATE
DATS
8 0
LOGSYS
Logical system
LOGSYS TBDLS
CHAR
10 0

T000 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T000 LOGSYS T000 LOGSYS TBDLS
Logical system
LOGSYS
T000 MWAER T000 MANDT TCURC
Currency Codes
MANDT
T000 MWAER T000 MWAER TCURC
Currency Codes
WAERS