SAP Table T000 stores Clientsdata

  

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!


SAP T000 dictionary attributes

Object Name: T000
Dictionary Type: Transparent table
Description: Clients


T000 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) ClientMANDTTEST
MTEXTMTEXT_DCHAR25(0) Client nameTEXT25SYST
ORT01ORT01CHAR25(0) CityTEXT25FB
MWAERMWAERCUKY5(0) TCURCStandard currency throughout clientWAERSSYST
ADRNRCHAR10CHAR10(0) Character Field Length = 10CHAR10SAP
CCCATEGORYCCCATEGORYCHAR1(0) Client control: Role of client (production, test,...)CCCATEGORY
CCCORACTIVCCCORACTIVCHAR1(0) Changes and transports for client-specific objectsCCCORACTIV
CCNOCLIINDCCNOCLIINDCHAR1(0) Maintenance authorization for objects in all clientsCCNOCLIIND
CCCOPYLOCKCCCOPYLOCKCHAR1(0) Protection reg. client copy program and comparison toolsCOPYLOCK
CCNOCASCADCCNOCASCADCHAR1(0) Client control: No client cascade for upgrade importX
CCSOFTLOCKCCSOFTLOCKCHAR1(0) Client control: Soft Lock Required (Planned for 4.0)X
CCORIGCONTCCORIGCONTCHAR1(0) Recording Client for Switch BC SetsCHAR1
CCIMAILDISCCIMAILDISCHAR1(0) Client Control: CATT und eCATT AuthorizationSECURECATT
CCTEMPLOCKCCTEMPLOCKCHAR1(0) Client control: Indicator that client is temporarily lockedX
CHANGEUSERAS4USERCHAR12(0) Last Changed byAS4USERSDIC
CHANGEDATEAS4DATEDATS8(0) Date of Last ChangeAS4DATESDIC
LOGSYSLOGSYSCHAR10(0) TBDLSLogical systemLOGSYS


View list of all tables