T000 is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores Clients data. There are total 17 fields in the table. The T000 table can be found in the T000 API (STRM_T000) package and is part of the Client Copy (BC-CTS-CCO) module.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full table is passed to buffer |
T000 Table Fields
The following is the list of fields that are available in SAP T000 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type | Length |
|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | CLNT | 3 | |
| MTEXT | Client name | MTEXT_D | TEXT25 | CHAR | 25 | |
| ORT01 | City | ORT01 | TEXT25 | CHAR | 25 | |
| MWAER | Standard Currency in Client | MWAER | WAERS | TCURC | CUKY | 5 |
| ADRNR | Character Field with Length 10 | CHAR10 | CHAR10 | CHAR | 10 | |
| CCCATEGORY | Client control: Role of client (production, test,…) | CCCATEGORY | CCCATEGORY | CHAR | 1 | |
| CCCORACTIV | Changes and transports for client-specific objects | CCCORACTIV | CCCORACTIV | CHAR | 1 | |
| CCNOCLIIND | Maintenance authorization for objects in all clients | CCNOCLIIND | CCNOCLIIND | CHAR | 1 | |
| CCCOPYLOCK | Protection reg. client copy program and comparison tools | CCCOPYLOCK | COPYLOCK | CHAR | 1 | |
| CCNOCASCAD | Client control: No client cascade for upgrade import | CCNOCASCAD | X | CHAR | 1 | |
| CCSOFTLOCK | Client control: Soft Lock Required (Planned for 4.0) | CCSOFTLOCK | X | CHAR | 1 | |
| CCORIGCONT | Recording Client for Switch BC Sets | CCORIGCONT | CHAR1 | CHAR | 1 | |
| CCIMAILDIS | Client Control: CATT und eCATT Start Authorization | CCIMAILDIS | SECURECATT | CHAR | 1 | |
| CCTEMPLOCK | Client control: Indicator that client is temporarily locked | CCTEMPLOCK | X | CHAR | 1 | |
| CHANGEUSER | Last Changed By | AS4USER | AS4USER | CHAR | 12 | |
| CHANGEDATE | Last Changed On | AS4DATE | AS4DATE | DATS | 8 | |
| LOGSYS | Logical system | LOGSYS | LOGSYS | TBDLS | CHAR | 10 |
Availability
The SAP HANA table T000 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for T000 table
We’re updating the content all the time, so check back regularly.
