1. Home
  2. Resources
  3. SAP Tables
  4. T000 - Clients

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
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
P Production
T Test
C Customizing
D Demo
E Training/Education
S SAP reference
CCCORACTIV Changes and transports for client-specific objects CCCORACTIV CHAR 1 0
NULL No automatic recording of changes for transport
1 Changes are recorded in transport request
2 Customizing in this client cannot be changed
3 Customizing: Can be changed as req., but cannot be transp.
CCNOCLIIND Maintenance authorization for objects in all clients CCNOCLIIND CHAR 1 0
NULL 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 and cross-client Customizing objs
CCCOPYLOCK Protection reg. client copy program and comparison tools CCCOPYLOCK CHAR 1 0
NULL Protection level 0: No restriction
X Protection level 1: No overwriting
L Protection level 2: No overwriting, no external availability
CCNOCASCAD Client control: No client cascade for upgrade import CCNOCASCAD CHAR 1 0
X Yes
NULL No
CCSOFTLOCK Client control: Soft Lock Required (Planned for 4.0) CCSOFTLOCK CHAR 1 0
X Yes
NULL No
CCORIGCONT Recording Client for Switch BC Sets CCORIGCONT CHAR 1 0
CCIMAILDIS Client Control: CATT und eCATT Authorization CCIMAILDIS CHAR 1 0
NULL eCATT and CATT Not Allowed
X eCATT and CATT Allowed
T eCATT and CATT Only Allowed for 'Trusted RFC'
E eCATT Allowed, but FUN/ABAP and CATT not Allowed
F eCATT allowed, but FUN/ABAP and CATT only for 'Trusted RFC'
CCTEMPLOCK Client control: Indicator that client is temporarily locked CCTEMPLOCK CHAR 1 0
X Yes
NULL No
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