List of useful SAP standard database tables. All tables can be viewed via the SAP 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).
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
