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.
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 HR database tables
SELECT from COOI table
SELECT from COVP table
