In this post, I will try and describe everything you need to know about the SAP t000 table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for T000 what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from T000....Right lets get started!
Object Name: T000
Dictionary Type: Transparent table
Description: Clients
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
MANDT | MANDT | CLNT | 3(0) | Client | MANDT | TEST | ||||||
MTEXT | MTEXT_D | CHAR | 25(0) | Client name | TEXT25 | SYST | ||||||
ORT01 | ORT01 | CHAR | 25(0) | City | TEXT25 | FB | ||||||
MWAER | MWAER | CUKY | 5(0) | TCURC | Standard currency throughout client | WAERS | SYST | |||||
ADRNR | CHAR10 | CHAR | 10(0) | Character Field Length = 10 | CHAR10 | SAP | ||||||
CCCATEGORY | CCCATEGORY | CHAR | 1(0) | Client control: Role of client (production, test,...) | CCCATEGORY | |||||||
CCCORACTIV | CCCORACTIV | CHAR | 1(0) | Changes and transports for client-specific objects | CCCORACTIV | |||||||
CCNOCLIIND | CCNOCLIIND | CHAR | 1(0) | Maintenance authorization for objects in all clients | CCNOCLIIND | |||||||
CCCOPYLOCK | CCCOPYLOCK | CHAR | 1(0) | Protection reg. client copy program and comparison tools | COPYLOCK | |||||||
CCNOCASCAD | CCNOCASCAD | CHAR | 1(0) | Client control: No client cascade for upgrade import | X | |||||||
CCSOFTLOCK | CCSOFTLOCK | CHAR | 1(0) | Client control: Soft Lock Required (Planned for 4.0) | X | |||||||
CCORIGCONT | CCORIGCONT | CHAR | 1(0) | Recording Client for Switch BC Sets | CHAR1 | |||||||
CCIMAILDIS | CCIMAILDIS | CHAR | 1(0) | Client Control: CATT und eCATT Authorization | SECURECATT | |||||||
CCTEMPLOCK | CCTEMPLOCK | CHAR | 1(0) | Client control: Indicator that client is temporarily locked | X | |||||||
CHANGEUSER | AS4USER | CHAR | 12(0) | Last Changed by | AS4USER | SDIC | ||||||
CHANGEDATE | AS4DATE | DATS | 8(0) | Date of Last Change | AS4DATE | SDIC | ||||||
LOGSYS | LOGSYS | CHAR | 10(0) | TBDLS | Logical system | LOGSYS |