SE11 ABAP Dictionary SE11 T000

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

T000

Clients
SAP SAP Transparent Table 17 Fields
Primary Key:
MANDT

Dictionary Fields Fields

(17 dari 17 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
MTEXT
- Name CHAR 25 - - Client name
3
ORT01
- City CHAR 25 - - City
4
MWAER
- Currency CUKY 5 - - Standard currency throughout client
5
ADRNR
- Character Field Length = 10 CHAR 10 - - Character Field Length = 10
6
CCCATEGORY
- Role CHAR 1 - - Client control: Role of client (production, test,...)
7
CCCORACTIV
- Corr. sys. CHAR 1 - - Changes and transports for client-specific objects
8
CCNOCLIIND
- NoCrsCli CHAR 1 - - Maintenance authorization for objects in all clients
9
CCCOPYLOCK
- Copy lock CHAR 1 - - Protection reg. client copy program and comparison tools
10
CCNOCASCAD
- No cascade CHAR 1 - - Client control: No client cascade for upgrade import
11
CCSOFTLOCK
- Lock Meth. CHAR 1 - - Client control: Soft Lock Required (Planned for 4.0)
12
CCORIGCONT
- Recording Client for Switch BC Sets CHAR 1 - - Recording Client for Switch BC Sets
13
CCIMAILDIS
- CATT CHAR 1 - - Client Control: CATT und eCATT Authorization
14
CCTEMPLOCK
- Temp. lock CHAR 1 - - Client control: Indicator that client is temporarily locked
15
CHANGEUSER
- Last Changed by CHAR 12 - - Last Changed by
16
CHANGEDATE
- Date of Last Change DATS 8 - - Date of Last Change
17
LOGSYS
- LogSystem CHAR 10 - - Logical system

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk T000.

Interactive ERD Diagrams

Belum terpasang pada pin diagram ERD.

Standard T-Codes
SCC4 SE11 SE16
Related Tables

Tidak ada relasi langsung terdeteksi.

ANSI SQL Query 
SELECT a.MTEXT,
       a.ORT01,
       a.MWAER,
       a.ADRNR,
       a.CCCATEGORY
FROM T000 AS a
WHERE a.MANDT = '800';
ABAP OpenSQL (7.40+) 
SELECT a~mtext,
       a~ort01,
       a~mwaer,
       a~adrnr,
       a~cccategory
  FROM t000 AS a
  WHERE a~mandt = '800'
  INTO TABLE @DATA(lt_t000)
  UP TO 100 ROWS.