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).
RFCDES RFC destination,
created Remote function call destinations on current sap system
T100 Table of message ( mesage class and message number )
TADIR Table of R/3 repository objects (programs, tcodes etc)
TFDIR Table of SAP function modules
TFTIT SAP function module short text
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)