T000 SAP (Clients) Table details

Dictionary Type: Table
Description: Clients




ABAP Code to SELECT data from T000
Related tables to T000
Access table T000




Table field list including key, data, relationships and ABAP select examples

T000 is a standard SAP Table which is used to store Clients data and is available within R/3 SAP systems depending on the version and release level.

The T000 table consists of various fields, each holding specific information or linking keys about Clients data available in SAP. These include MTEXT (Client name), ORT01 (City), MWAER (Standard currency throughout client), ADRNR (Character Field Length = 10).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

Text table = /DSD/GS_CAPPL_T

Text table = /DSD/GS_CEXTV_T

Text table = /SAPSLL/TDPCMBT

Text table = /SAPSLL/TDPDAST

Text table = AD00PMCLT

Text table = AD00PMEVT

Text table = AD01C_CTT

Text table = AD01C_PRTX

Text table = AD03PHPT

Text table = BKKA7T

Text table = BORRTTSIDT

Text table = CCIHC_FALOCTXT

Text table = CKMLMV010T

Text table = DPR_ROLE_FUNC_T

Text table = EHSWAC_ROLET

Text table = FAGL_RPACKT

Text table = FAGL_RPLANT

Text table = FAGL_RSIGT

Text table = FAGL_R_PLTY0_T

Text table = FMHIVARNTT

Text table = FMHSARTT

Text table = FMPPLANT

Text table = FMVARNTT

Text table = GMSPLITRULEST

Text table = IWOT_PROF_SUBT

Text table = JBRADKET

Text table = J_1BSDNFXT

Text table = KONBBYT

Text table = KONMATGRPT

Text table = KONTOKLASSET

Text table = LISAKTTXT

Text table = MATGRP_HIERT

Text table = MATGRP_STRUCT

Text table = N1BCHT

Text table = N1BCPT

Text table = N1COMPLDEGREET

Text table = N1COMPLSTAGET

Text table = N1CYGROUPT

Text table = N1MONCONT

Text table = N1RLSTT

Text table = N1SNPT

Text table = N1VPPF4T

Text table = N1VPST

Text table = OICQCT

Text table = T0KBAT

Text table = T0KBBT

Text table = T0KBCT

Text table = T0KBET

Text table = T190HT

Text table = T190OT

Text table = T482T

Text table = T51T7

Text table = T51TB

Text table = T52CC_T

Text table = T52CE_T

Text table = T5E4B

Text table = T5F99K1T

Text table = T5F99KMT

Text table = T5NA2T

Text table = T618MET

Text table = T620T

Text table = T621T

Text table = T622T

Text table = T625T

Text table = T626T

Text table = T627T

Text table = T628T

Text table = T629T

Text table = T7BRG4T

Text table = T7INZ4

Text table = T7MX81

Text table = T7MX83

Text table = T7PIQHSHEADT

Text table = T8J02

Text table = T8J0Q

Text table = TAIC2T

Text table = TB2BVT

Text table = TBKKM5T

Text table = TBKKM9T

Text table = TCCLT

Text table = TCCMT

Text table = TCEHT

Text table = TCEIT

Text table = TCK29T

Text table = TCK31T

Text table = TCK32T

Text table = TCLOI6T

Text table = TCMC_QTTY_T

Text table = TCMS_INS_SET_T

Text table = TCMS_INS_TYP_T

Text table = TCMS_MVTY_PRTY_T

Text table = TCMS_REL_GRP_T

Text table = TCMS_RIG_TYP_T

Text table = TE13VT

Text table = TE436T

Text table = TECONTRACTCLASST

Text table = TFK056T

Text table = TFW_PRED_LIB_TXT

Text table = TINV_C_INCHCKT

Text table = TJDOCTYPET

Text table = TJKSDFCRULETXT

Text table = TJKSDSALESINDT

Text table = TJSERIEST

Text table = TLXXBEBT

Text table = TLXXBSAT

Text table = TLXXFUBT

Text table = TLXXGSAT

Text table = TLXXGZAT

Text table = TLXXKDAT

Text table = TLXXMVZT

Text table = TLXXRSAT

Text table = TLXXSDAT

Text table = TLXXVALT

Text table = TLXXVZWT

Text table = TMBGT

Text table = TMCWWT

Text table = TMFST

Text table = TMKVT

Text table = TMLFGT

Text table = TMZRT

Text table = TN1MECHTYPET

Text table = TOIA10T

Text table = TPVHT

Text table = TSPG0T

Text table = TSPP0T

Text table = TTSEGTPLHT

Text table = TVCINT

Text table = TVCLKT

Text table = TVHFT

Text table = TVTRT

Text table = TWBEXCLASSGROUPT

Text table = TWEKT

Text table = TWGAT

Text table = TWPPBT

Text table = TWPPFT

Text table = VERFT

Text table = VMETT

Text table = WRF_CMMD_CDT1T

Text table = WRF_CMMD_CDT2T

Text table = WRF_CMMD_CDT3T

Text table = WRF_CMMD_CDT4T

Text table = WRF_CMMD_CDT5T

Text table = WRF_CMMD_CDT6T

Text table = WRF_CMMD_CDT7T

Text table = WRF_MATGRP_HIERT

Text table = WRF_MATGRP_ROLET

Text table = WRF_MATGRP_STRAT

Text table = WRF_MATGRP_STRCT

Text table = WSDT_APPLT

Text table = WSDT_MAT_GROUPT

Text table = WSD_PRICE_ELEM_T


SAP T000 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3MANDT
MTEXTClient name MTEXT_DCHAR25TEXT25
ORT01City ORT01CHAR25TEXT25
MWAERStandard currency throughout client MWAERCUKY5TCURCWAERS
ADRNRCharacter Field Length = 10 CHAR10CHAR10CHAR10
CCCATEGORYClient control: Role of client (production, test,...) CCCATEGORYCHAR1CCCATEGORY
CCCORACTIVChanges and transports for client-specific objects CCCORACTIVCHAR1CCCORACTIV
CCNOCLIINDMaintenance authorization for objects in all clients CCNOCLIINDCHAR1CCNOCLIIND
CCCOPYLOCKProtection reg. client copy program and comparison tools CCCOPYLOCKCHAR1COPYLOCK
CCNOCASCADClient control: No client cascade for upgrade import CCNOCASCADCHAR1X
CCSOFTLOCKClient control: Soft Lock Required (Planned for 4.0) CCSOFTLOCKCHAR1X
CCORIGCONTRecording Client for Switch BC Sets CCORIGCONTCHAR1CHAR1
CCIMAILDISClient Control: CATT und eCATT Authorization CCIMAILDISCHAR1SECURECATT
CCTEMPLOCKClient control: Indicator that client is temporarily locked CCTEMPLOCKCHAR1X
CHANGEUSERLast Changed by AS4USERCHAR12AS4USER
CHANGEDATEDate of Last Change AS4DATEDATS8AS4DATE
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS

Key field Non-key field



How do I retrieve data from SAP table T000 using ABAP code

The following ABAP code Example will allow you to do a basic selection on T000 to SELECT all data from the table
DATA: WA_T000 TYPE T000.

SELECT SINGLE *
FROM T000
INTO CORRESPONDING FIELDS OF WA_T000
WHERE...

How to access SAP table T000

Within an ECC or HANA version of SAP you can also view further information about T000 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!