Saturday, December 24, 2011

SYSTEM Tables

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       tables
DD02T R/3 DD- SAP table texts
DD03L             Table Fields
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).
CDPOS             Change document items
CDHDR            Change document header
T529A               governs the foreground sequence of infotypes
T588Z               governs the dynamic event processing
T588M              Infotype Screen Control

1 comment: