SAP System Tables

fengwhen

System Tables

ADCP	Person/Address assignment (central address administration)
ADIRACCESS	Table to store keys for TADIR objects
ADR2	Telephone numbers (central address admin.)
ADRP	Persons (central address administration)
APQD	DATA DEFINITION Queue
APQI	Queue info definition
D010SINF	ABAP- Information about ABAP program source code
E071	Change and Transport System- Object Entries of Requests/Tasks
E07T	Change and Transport System- Short Texts for Requests/Tasks
ENLFDIR	Additional Attributes for Function Modules
INDX	System table INDX
NAST	Message Status
STXH	STXD SAPscript text file header
T005	Countries
T005S	Taxes- Region (Province) Key
T005U	Taxes- Region Key- Texts
T006	Units of Measurement
T015M	Names of the months
T247	Month name and short text
T777A	Building Addresses
TADIR	Directory of Repository Objects
TBTCO	Job status overview table
TBTCP	Batch job step overview
TFDIR	Function Module
TFTIT	Function Module Short Text
TSP03L	Spool- Long device names
TSTC	SAP Transaction Codes
TSTCT	Transaction Code Texts
TUTYP	User Types in Current Price List in SAP System
TUZUS	Special versions
TVARV	Table of variables in selection criteria
TVDIR	View Directory
US930	Data Relevant to Measurement for User Master Record
USR01	User master record (runtime data)
USR02	Logon data
USR04	User master authorizations
USR06	Additional Data per User
USR14	Surchargeable Language Versions per User
USR21	Assign user name address key
ARCH_OBJ	Objects for archiving and reorganization
BTCUED	Description of user event IDs for background processing
BTXSUPB	BSI- Upgrade-Information
CCCFLOW	Client Copy Control Flow
DBSTATC	DB Optimizer Control (Statistics Creation)
DEVACCESS	Table for development users
DEVL	OBSOLETE- Do not use (See TCETRAL)
E070	Change and Transport System- Header of Requests/Tasks
E070L	CTS- Index for Assigning Numbers to Requests/Tasks
INSTVERS	Documentation for installation Status and History
PAT03	Patch Directory
SDBAC	DBA Action Table
T100	Messages
TAPLT	Program Application Long Texts
TASYS	OBSOLETE- Do not use, see TCEDELI
TDEVC	Development Classes
TEMSE	Temp Sequential table.
TLOCK	Change and Transport System- Lock Table
TNAPR	Processing programs for output. Can be very handy to find the print program for a SAPScript.
TNAST	Printed output control table
TPFET	Table of profile parameters
TPFHT	Profile header, administration data for profiles in DB
TPROT	Table contains all DD tables to be logged
TRBAT	Communication Table for Transport Control
TRDIRT	Title texts for programs in TRDIR
TRESN	Table of Naming Conventions in ABAP Workbench
TRJOB	Job ID for Coordinating Batch-ABAP/UNIX for Transports
TSP03C	Spool- Device Description Extension
TST03	TemSe data
TSYST	OBSOLETE- Do not use (see TCESYST)
TWSYS	OBSOLETE- Do not use (See TCETRAL)
USOBT	Relation transaction - authorization object
USR03	User address data
USR05	User Master Parameter ID
USR12	User master authorization values
USR40	Table for illegal passwords
USR41	User master- Additional data
UST04	User masters
VARIT	Variant texts
VARID	Variant directory
D010TAB	Table for Use Report---Tables
DD02L	SAP 所有表
DD02T	R/3 DD- SAP table texts
DD03L	表的所有字段
DD03T	DD- Texts for fields (language dependent)
EDIDC	IDOC Control Records
EDIDOT	Short description of IDoc types
EDID2	IDOC segments (version 3.1)
EDID4	IDOC segments (version 4.6)
EDSEA	EDI- Table of all segments of current release
VRSX2	Central Table for Version Management (Report Source)
TSE05	Can add parameters to the INSERT COMMAND (IC). Then, when you insert command, your info appears in the editor. Useful for comment blocks, common section of code, etc.
CDPOS	Change document items
CDHDR	Change document header
T529A	governs the foreground sequence of infotypes the system will use to prompt the user during online and batch processing. You will have to code your BDC to follow that sequence of creating infotypes.
T588Z	governs the dynamic event processing that will only take place during online user inputs. For BDC's you will have to create separate BDC's to handle any infotypes that are inserted dynamically by this table.
T588M	Infotype Screen Control