SAP tables list and database views available in the data dictionary



List of useful SAP standard database tables. All SAP tables can be viewed via the data dictionary using transaction code SE11.

DBCON
Description of database connections (including password)

DD02V
Date dictionary tables

DD03L
Date dictionary tables and fields

DD07T
Texts for Domain Fixed Values

DOKIL
SAP Object documentation link details. Required by function module DOCU_READ to retieve SAP documentation for specific repository object (FM, Prog, Tcode etc).

E070, E070A, E070AS, E071
Transport data is stored within these tables

ENHOBJCONTRACT
Table of enhancement points

RFCDES
SAP RFC destination, created Remote function call destinations on current sap system

T100
Table of message ( mesage class and message number )

TACT
Available activities on your SAP system

TADIR
Table of R/3 repository objects (programs, tcodes etc)

TBRG
Definition of authorization groups in your SAP system

TBRGT
Text table for authorization group table TBRG

TFDIR
Table of SAP function modules

TFTIT
SAP function module short text

TNRO
This table stores SAP Number ranges, which are created via SNRO transaction

NRIV
Number ranges interval table, also created via tcode SNRO

TOBJ
Authorization objects

TRDIR
Table of SAP programs

TRMAC
Table of SAP macros

TSTC
Table of SAP transaction codes

TPARA
Table of SAP PID's

DEVACCESS
Table of development users including registered Developer access key

USR02
Logon data

USR04
User master authorization (one row per user)

UST04
User profiles (multiple rows per user)

USR10
Authorisation profiles (i.e. &_SAP_ALL)

UST10C
Composit profiles (i.e. profile has sub profile)

UST10S
Authorization profiles, stores list of all objects with an authorisation profile

USR11
Text for authorisation profiles

USR12
Authorisation values



USR13
Short text for authorisation

USR40
Table for illegal passwords

OBJT
Type T Objects (Separate Transaction)

Related Articles

SAP Application specific database tables
SAP Application specific database tables
SAP HR database tables
SELECT from COOI table
SELECT from COVP table