4
Aug
2009
SAP: List of tables pertaining to Transport Requests
| TABNAME | Description | |
| E070 | Change & Transport System: Header of Requests/Tasks | |
| E070A | Change & Transport System: Attributes of a Request | |
| E070C | CTS: Source/Target Client of Requests/Tasks | |
| E070CREATE | Change & Transport System: Creation Date of Request | |
| E070CTV | Generated Table for View E070CTV | |
| E070DEP | Change & Transport System: Dependencies of Requests | |
| E070L | CTS: Index for Assigning Numbers to Requests/Tasks | |
| E070M | CTS: Target Package/Layer for Requests | |
| E070TC | Help Table for E070 for Client-Specific Imports | |
| E070USE | Use of Current Requests by Users | |
| E070V | Generated Table for View E070V | |
| E071 | Change & Transport System: Object Entries of Requests/Tasks | |
| E071C | Change & Transport System: Client-Specific Lock Flag | |
| E071E | Lang. Transport: Positive List for Generic Object Selection | |
| E071K | Change & Transport System: Key Entries of Requests/Tasks | |
| E071KC | Change & Transport System: Key Entries of Requests/Tasks | |
| E071KF | Change & Transport System: Nametab Info. on (CHAR)Key Fields | |
| E071KFINI | Change & Transport System: Nametab Info. on (CHAR)Key Fields | |
| E071K_30 | Change & Transport System: Key Entries of Requests/Tasks | |
| E071K_KEY | E071K Key Fields | |
| E071S | System-Specific Import Status of Objects | |
| E071V | Generated Table for View E071V | |
| E07T | Change & Transport System: Short Texts for Requests/Tasks | |
| E07T_OLD | E07T Before TRKORR Extension |
Useful transport tables [listed above].
29
Jun
2009
SAP: Favorites and Links
All information about user set up – like favorites and links – are stored in system tables.
So if you want to take a look how the information is layed out just hit se16 and take a look at the following tables.
SMEN_BUFFC: stores favorites informatoin
COLUMN-UNAME will display user name
COLUMN-REPORT will display transaction code
SMEN_BUFFI: stores user associated links
COLUMN-UNAME will display user name
COLUMN-URL will display the link of the address
4
Oct
2007
Usful SAP 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). 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 |
