SAP Tables – Basis related tables & General tables

Oct 18th, 2009 | By Ole | Category: SAP Tables & Views

Tables related to the setup and monitoring of the SAP system.

If you are interested in tables from other areas of SAP, we have chosen to divide the tables into the following groups. Please click on the group description to view each groups tables.

If you can’t find a table where you expected it, please use the search function in the upper right corner.

Basis related tables & General tables
  • -
User & Role administration
  • -
EDI-ALE related
  • MM
Material Management
  • FI-CO
Financial Accounting & Controlling
  • QM
Quality Management
  • SD
Sales and Distribution
  • WM
Warehouse Management
  • HR
Human Resources
  • PP-PI
Production Planning
  • PRA
Production Revenue Accounting
  • JV
Joint Venture
  • PS
Project Systems
 

 

ADCP Person/Address assignment (central address administration) -
ADIRACCESS Table to store keys for TADIR objects -
ADR2 Telephone numbers (central address admin.) Telephone Numbers (Business Address Services)
ADRP Persons (central address administration) Persons (Business Address Services)
APQD DATA DEFINITION Queue Batch input queue
APQI Queue info definition Batch input queue
ARCH_OBJ Objects for archiving and reorganization Objects for archiving and reorganization
BTCUED Description of user event IDs for background processing -
BTXSUPB BSI- Upgrade-Information -
CCCFLOW Client Copy Control Flow -
D010SINF ABAP- Information about ABAP program source code Generated Table for View D010SINF
D010TAB Lists the tables associated with a particular SAP program Table for Use Report<->Tables
D020T Screen texts Screen Short Description
DBSTATC DB Optimizer Control (Statistics Creation) Configuration of Statistics Creation
DD02L Tables in SAP Data dictionary tables
DD02T Tables description Data dictionary tables
DD03L Field names in SAP Data dictionary tables
DD03T Table field description in SAP Data dictionary tables
DEVL OBSOLETE- Do not use (See TCETRAL) -
E070 Change & Transport System: Header of Requests/Tasks -
E070L CTS- Index for Assigning Numbers to Requests/Tasks -
E071 Change & Transport System: Object Entries of Requests/Tasks -
E07T Change & Transport System: Short Texts for Requests/Tasks -
ENLFDIR Additional Attributes for Function Modules -
INDX System table INDX -
INSTVERS Documentation for installation Status and History -
JCDS Change Documents for System/User Statuses (Table JEST) Change Documents
NACH Printer determination Message Control
NAST Message status Message Control
PAT03 Patch Directory -
SDBAC DBA Action Table -
SERPTREE Reporting: tree structure Reporting tree table
SNAP Runtime errors ABAP/4 Snapshot for Runtime Errors
SREPOVARI Reporting: tree/program Reporting: Reports and Variants
STXB SAPscript: Texts in non-SAPscript format (see also STXH and STXL) Basic data text (sap script)
STXH STXD SAPscript text file header (see also STXL and STXB) Basic data text (sap script)
STXL STXD SAPscript text file lines (see also STXH and STXB) Basic data text (sap script)
T015M Names of the months Calendar functions
T100 Message text (vb e000) Messages
T247 Month name and short text Calendar functions
T588M Infotype Screen Control -
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. Dynamic Actions
T777A Building Addresses -
TADIR Directory of Repository Objects -
TAPLT Program Application Long Texts -
TASYS OBSOLETE: Do not use, see TCEDELI -
TBTCO Job Status Overview Table Job processing
TBTCP Background Job Step Overview Job processing
TCEDELI Transport Layer Deliveries
TCETRAL Transport Layer -
TCURC Currency Codes Currency
TCURT Currency Code Names Currency
TCURX Decimal Places in Currencies Currency
TDEVC Development class Packages
TDEVCT Texts for development classes Texts for Packages
TFACD Factory calendar definition Calendar functions
TFDIR Function Modules -
TFTIT Function Module Short Text -
TLIBG Person responsible for function class -
TLIBT Function Group Short Texts -
TLOCK Change and Transport System: Lock Table -
TMC4 Global Control Elements: LIS Info Structure LIS structure/control tables
TNAPR Processing programs for output. Can be very handy to find the print program for a SAPScript. Processing programs for output
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 -
TRDIR System table TRDIR Generated Table for View TRDIR
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 -
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. ABAP/4 Editor insert commands
TSP02 Spool: Print requests Administration
TSP03C Spool- Device Description Extension -
TSP03L Spool- Long device names -
TST03 TemSe data -
TSTC SAP Transaction Codes -
TSTCT Transaction Code Texts -
TSYST OBSOLETE- Do not use (see TCESYST) -
TTZ5 Assign Time Tones to Countries Calendar functions
TTZ5S Assign time zones to regions Calendar functions
TTZD Summer time rules Calendar functions
TTZDF Summer time rules (fixed annual dates) Calendar functions
TTZDT Summer time rules texts Calendar functions
TTZDV Summer time rules (variable dates) Calendar functions
TTZZ Time zones Calendar functions
TUTYP User Types in Current Price List in SAP System SAP System User Type Texts
TUZUS Special versions Text for Special Versions
TVARV Table of variables in selection criteria -
TVDIR View Directory -
TWSYS OBSOLETE- Do not use (See TCETRAL) -
VARID Variant data Variant directory
VARIT Variant texts -
VRSX2 Central Table for Version Management (Report Source) -

 

Leave Comment

You must be logged in to post a comment.