T000 table in SAP ERP or S/4HANA stores Clients data. There are total 17 fields in T000 table. The Clients table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of T000 table. It is in T000 API (STRM_T000) ABAP package and is part of the Client Copy (BC-CTS-CCO) module.
SAP T000 Table Fields
Following is the list of fields that are available in SAP T000 table. The primary key fields of Clients table in SAP are MANDT (Client).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT(3) | |
| MTEXT | Client name | MTEXT_D | CHAR(25) | |
| ORT01 | City | ORT01 | CHAR(25) | |
| MWAER | Standard Currency in Client | MWAER | TCURC | CUKY(5) |
| ADRNR | Character Field with Length 10 | CHAR10 | CHAR(10) | |
| CCCATEGORY | Client control: Role of client (production, test,…) | CCCATEGORY | CHAR(1) | |
| CCCORACTIV | Changes and transports for client-specific objects | CCCORACTIV | CHAR(1) | |
| CCNOCLIIND | Maintenance authorization for objects in all clients | CCNOCLIIND | CHAR(1) | |
| CCCOPYLOCK | Protection reg. client copy program and comparison tools | CCCOPYLOCK | CHAR(1) | |
| CCNOCASCAD | Client control: No client cascade for upgrade import | CCNOCASCAD | CHAR(1) | |
| CCSOFTLOCK | Client control: Soft Lock Required (Planned for 4.0) | CCSOFTLOCK | CHAR(1) | |
| CCORIGCONT | Recording Client for Switch BC Sets | CCORIGCONT | CHAR(1) | |
| CCIMAILDIS | Client Control: CATT und eCATT Start Authorization | CCIMAILDIS | CHAR(1) | |
| CCTEMPLOCK | Client control: Indicator that client is temporarily locked | CCTEMPLOCK | CHAR(1) | |
| CHANGEUSER | Last Changed By | AS4USER | CHAR(12) | |
| CHANGEDATE | Last Changed On | AS4DATE | DATS(8) | |
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR(10) |
