During years of work in the SAP world, I have noted down “couple” of useful tables from different SAP® NetWeaver modules, which I regularly use. Please see the list in the following tables:
| Type | Table Name | Description | Note | Key Words |
|---|---|---|---|---|
| System | DD02L | All SAP table names | ||
| System | DD02T | Description of table names | ||
| System | DD03L | Fields in a table | ||
| System | E070 | Transport requests | ||
| System | E071 | Object Entries of Requests/Tasks | ||
| System | MODSAPVIEW | User Exits table | ||
| System | RSBATCHPARALLEL | Control Parallel Batch Processes | Change number of parallel processes for DTP/DSO/... | |
| System | RSOTLOGOHISTORY | Table of Metadata Object Versions | To see version history for an object | |
| System | SSM_CUST | Set Values for the Session Manager / Profile Generator | Menu Role behavioar, suppresing double entries | |
| System | T002 | Language Keys (Component BC-I18) | Internal language code to external (switch off Conversion Exit in SE16) | Language |
| System | T005T | Country Names | ||
| System | T247 | Month name and short text | Month name number conversion | |
| System | TADIR | Directory of Repository Objects | ||
| System | TDEVC | Packages | ||
| System | TDEVCT | Texts for Packages | ||
| System | TFDIR | Function Module | ||
| System | TSTC | All Transactions in the system | ||
| System | TVARV | Table of variables in selection criteria | User defined variables. Corresponding TR: STVARV | |
| System | TVARVC | Table of Variant Variables (Client-Specific) | User defined variables. Corresponding TR: STVARVC | |
| System | UGMD2101 | FIN Master Data: List of Generated DDIC Elements | Generated objects for Financial | |
| System | VSEOCLASS | Class (CLASS c ... ENDCLASS) | ||
| System | WDY_COMPONENT | Web Dynpro: Component | ||
| Aggregates | RSDDAGGRDIR | Directory of Aggregates | ||
| Aggregates | RSDDAGGRCOMP | Description of Aggregates | ||
| Aggregates | RSDDAGGRT | Text on Aggregates | ||
| Aggregates | RSDDAGGLT | Directory of the aggregates, texts | ||
| APD | RSANT_PROCESS | Repository for Process Definitions | List of processes | |
| Archiving | RSARCHIPRO | BW Archiving: General Archiving Properties | ||
| Archiving | RSARCHIPROIOBJ | BW Archiving: General Archiving Properties | ||
| Archiving | RSARCHIPROLOC | BW ARchiving: General Local Properties | ||
| Archiving | RSARCHIPROLOCSEL | BW Archiving: Archived Data Area | ||
| Archiving | RSARCHIPROPID | BW Archiving: Program References of InfoProvider | ||
| Archiving | RSARCHREQ | BW Archiving: Archiving Request | ||
| Archiving | RSARCHREQFILES | BW Archiving: Verfified Archive Files | ||
| Archiving | RSARCHREQSEL | BW Archiving: Request-Selections | ||
| Authorization | AGR_1251 | Authorization data for the activity group | ||
| Authorization | AGR_USERS | Assignment of roles to users | ||
| Communications Structure | RSKS | Communications Structure for InfoSources with Flexible Update | ||
| Communications Structure | RSKS | Communications Structure (View) for Attributes for an InfoSource with Direct Update | ||
| Communications Structure | RSKSFIELD | Texts on InfoSources with Flexible Update | ||
| Communications Structure | RSISFIELD | InfoObjects of an InfoSource with Flexible Update | ||
| Currencies | RSCURTRT | Currency Translation Types | Package: RS | |
| Currencies | TCURR | Currency Conversion Table | ||
| Currencies | V_TCURR | Currency Exchange Rates | ||
| Data Flows | RSDFNODES | Nodes in the Data Models | Objects included in specific Data Flow | |
| Data Source (OLTP Source) | ROOSOURCE | Header Table for SAP BW DataSources (SAP Source System/BW System) | Delta Information as TR: RSA2 | |
| Data Source (OLTP Source) | RODELTAM | BW Delta Procedure (SAP Source System) | ||
| Data Source (OLTP Source) | RSDS | DataSource in BW | ||
| Data Source (OLTP Source) | RSDSSEGFD | Data source structure - fields | ||
| Data Source (OLTP Source) | RSISOSMAP | Mapping Between InfoSources and OLTP Sources | ||
| Data Source (OLTP Source) | RSOLTPSOURCE | Replication Table for DataSources in BW | ||
| Data Source (OLTP Source) | RSOLTPSOURCEFIE | OLTP Source Fields | Data source fields | |
| Data Source (OLTP Source) | RSOSFIELDMAP | Mapping Between OLTP Source Fields and InfoObjects | ||
| Data Transfer Process | RSBKDTP | BW: Data Transfer Process Header Data | 7.x | |
| Data Transfer Process | RSBKDTPH | DTP: Historic Versions | 7.x | |
| Data Transfer Process | RSBKDTPSTAT | Status Information on Data Transfer Process | 7.x | |
| Data Transfer Process | RSBKDTPT | Texts on Data Transfer Processes | 7.x | |
| Data Transfer Process | RSBKDTPTH | Texts on Data Transfer Processes | 7.x | |
| Data Transfer Process | RSDDSTATDTP | Table for WHM Statistics. Details DTP | 7.x | |
| Data Transfer Process | RSOACUBE_DTP | BW: OLTP Direct Access: Directory of Assigned Remote DTPs | 7.x | |
| Embedded ABAP coding for Transfer / Update Rules | RSAABAP | ABAP source code per object routine | ||
| Hierarchies | RSHIEDIR | Hierarchy catalog | ||
| Hierarchies | RSOSOHIE | Directory for Master Data Hierarchies | ||
| InfoCube | RSDCUBE | Directory of InfoCubes | ||
| InfoCube | RSDCUBET | Texts on InfoCubes | ||
| InfoCube | RSDCUBEIOBJ | Objects per InfoCube (where-used list) | ||
| InfoCube | RSDDIME | Directory of Dimensions | ||
| InfoCube | RSDDIMET | Texts on Dimensions | ||
| InfoCube | RSDDIMEIOBJ | InfoObjects for each Dimension (Where-Used List) | ||
| InfoCube | RSDCUBEMULTI | InfoCubes involved in a MultiCube | ||
| InfoCube | RSDICMULTIIOBJ | MultiProvider: Selection/Identification of InfoObjects | ||
| InfoCube | RSDICHAPRO | Characteristic Properties Specific to an InfoCube | ||
| InfoCube | RSDIKYFPRO | Flag Properties Specific to an InfoCube | ||
| InfoCube | RSDICVALIOBJ | InfoObjects of the Stock Validity Table for the InfoCube | ||
| InfoObject | RSDIOBJ | Directory of all InfoObjects | ||
| InfoObject | RSDIOBJT | Texts of InfoObjects (Texts in all languages) | ||
| InfoObject | RSDATRNAV | Navigation Attributes | ||
| InfoObject | RSDATRNAVT | Navigation Attributes texts | ||
| InfoObject | RSDBCHATR | Master Data Attributes | Position, Navigational, Time dependent | |
| InfoObject | RSDCHABAS | Basic Characteristics (for Characteristics,Time Characteristics, and Units) Texts | Infoobject details: data type, length, infoarea, MD read class, ... | |
| InfoObject | RSDCHA | Characteristics Catalog (Referenced IO) | ||
| InfoObject | RSDDPA | Data Package Characteristic | ||
| InfoObject | RSDIOBJCMP | Dependencies of InfoObjects (Compounds & KF Reference) | ||
| InfoObject | RSDKYF | Key Figures | ||
| InfoObject | RSDTIM | Time Characteristics | ||
| InfoObject | RSDUNI | Units | ||
| InfoObject | RSOSFIELDMAP | |||
| InfoObject | RSDIOBJHIE | Hierarchy Attributes for InfoObject | ||
| InfoObject | RSDIOBJFIX | Delivered Fixed System InfoObjects | ||
| InfoObject | RSDAREA | Infoarea | ||
| InfoObject | RSAPPL | ? | ||
| InfoObject | RSDIOBCT | InfoObject Category | ||
| InfoObject | RSDADAP | ??? | ||
| InfoObject catalogs | RSDIOBC | InfoObject catalogs | ||
| InfoObject catalogs | RSDIOBCIOBJ | InfoObjects in InfoObject catalogs | ||
| InfoPackage | RSLDPIO | Links datasource to infopackages | ||
| InfoPackage | RSLDPIOT | InfoPackage Text Description | ||
| InfoPackage | RSLDPRULE | ABAP source code for InfoPackages | ||
| InfoPackage | RSLDPSEL | Hardcoded selections in InfoPackages | ||
| InfoPackage | RSMONICDP | Contains the request-id number by data target | ||
| InfoPackage | RSPAKPOS | List of InfoPackage Groups / InfoPackages | ||
| InfoPackage | RSREQDONE | Monitor: Saving of the QM entries | QM Status | List of requests in PSA table |
| InfoPackage | RSSELDONE | InfoPackage selection and job program, there in field UPDMODE the update status (INIT/DELTA/FULL) | REQuest number -> InfoPackage | |
| InfoSource | RSIS | Directory of InfoSources with Flexible Update | ||
| InfoSource | RSIST | Texts on InfoSources with Flexible Update | ||
| InfoSource | RSISFIELD | InfoObjects of an InfoSource | ||
| InfoSpoke | RSBSPOKESELSET | InfoSpoke Directory and Selection Options | ||
| InfoSpoke | RSBSPOKEVSELSET | InfoSpoke Directory with Selection Options and Versioning | ||
| InfoSpoke | RSBSPOKE | List of all InfoSpokes with attributes maintained with transaction RSBO which include the name of | the Source & Target Structures | |
| InfoSpoke | RSBSPOKET | List of all InfoSpokes with the Short & Long Descriptions (only one of these can be maintained). | ||
| InfoSpoke | RSBSTEPIDMESS | Contains all the messages that have been recorded during the execution of an InfoSpoke. This table can | be added to using the ABAP Class/Method i_r_log->add_sy_message. | |
| Mapping | RSISOSMAP | Mapping Between InfoSources and DataSources (=OLTP Sources) | Transfer structure, Transfer rules, Info source | |
| Mapping | RSOSFIELDMAP | Mapping Between DataSource Fields and InfoObjects | ||
| Menu Roles | AGR_DEFINE | Role definition | ||
| Menu Roles | AGR_HIER | Table for Structure Information for Menu | ||
| Menu Roles | AGR_HIERT | Menu Roles elements texts | ||
| Menu Roles | AGR_TEXTS | Menu roles texts | ||
| Misc | RSPSADEL | PSA Table deletion | ||
| Misc | RSSTATMANREQMAP | Mapping of Higher- to Lower-Level Status Manager Request | Linking between PSA request no. and Request no. | |
| Misc | TBTCP | Job Schedule Definition | ||
| Misc | TBTCO | Job Schedule Result | ||
| Misc | RSMONMESS | Monitor Messages | ||
| Misc | RSERRORLOG | Check loading errors in table | ||
| Misc | V_RSZGLOBV | Report Variables view table | ||
| Misc | DEVACCESS | Developer Keys table | ||
| Misc | RSDDAGGRDIR | Directory of the aggregates | ||
| Misc | ROIDOCPRMS | Control parameters for data transfer from the source system | ||
| Misc | SMEN_BUFFC | Objects in User's Favorites | ||
| Misc | RSBASIDOC | Transfer structure prefix | ||
| ODS/DSO Object | RSDODSO | Directory of all ODS Objects | ||
| ODS/DSO Object | RSDODSOT | Texts of all ODS Objects | ||
| ODS/DSO Object | RSDODSOIOBJ | InfoObjects of ODS Objects | ||
| ODS/DSO Object | RSDODSOATRNAV | Navigation Attributes for ODS Object | ||
| ODS/DSO Object | RSDODSOTABL | Directory of all ODS Object Tables | ||
| ODS/DSO Object | RSREQICODS | Monitor: Saving of the updated IC and ODS per request | ||
| Open Hub Destination | RSBOHSERVICETP | Open Hub: Service Types | ||
| Open Hub Destination | RSBREQUESTDELTA | Open Hub: Cross Reference Outbound/Inbound | ||
| Open Hub Destination | RSBREQUESTMESS | Open Hub: Log for a Request | ||
| Open Hub Destination | RSBREQUID | Open Hub: Requests | ||
| Open Hub Destination | RSBREQUID3RD | Open Hub: Status of 3rd Party Requests | ||
| Open Hub Destination | RSBREQUIDRUN | Open Hub: Table with Status for a Request | ||
| Open Hub Destination | RSBSTRUCTURE | Open Hub: Generated Structures and Tables | ||
| Open Hub Destination | RSSELDONE | Administrace infokostky (nahravani), vybery etc.) | ||
| Open Hub Destination | RSICCONT | Saving of the updated IC and ODS per request | ||
| ProcessChain | RSCOMPTLOGOT | List of Component Names | ||
| ProcessChain | RSEVENTCHAIN | Event Chain Processing Event Table | ||
| ProcessChain | RSEVENTHEAD | Header for the event chain | ||
| ProcessChain | RSEVENTHEADT | Header for the event chain | ||
| ProcessChain | RSPCCHAIN | Process chain details | PC items. To find object in PC | |
| ProcessChain | RSPCCHAINATTR | Attributes for a Process Chain | APPLNM = Application component name (node name for PC) In which group PC is. | |
| ProcessChain | RSPCCHAINEVENTS | Multiple Events with Process Chains | ||
| ProcessChain | RSPCCHAINT | Texts for Chain | ||
| ProcessChain | RSPCCOMMANDLOG | System Command Execution Logs (Process Chains) | ||
| ProcessChain | RSPCLOGCHAIN | Cross-Table Log ID / Chain ID | ||
| ProcessChain | RSPCLOGS | Application Logs for the Process Chains | ||
| ProcessChain | RSPCPROCESSLOG | Logs for the Chain Runs | ||
| ProcessChain | RSPCRUNVARIABLES | Variables for Process Chains for Runtime | ||
| ProcessChain | RSPCTRIGGER | Variants for the Trigger Processes | Find if PC is scheduled and how | |
| ProcessChain | RSPCVARIANT | Generic Variant Storage | To see which object is selected in variant (field LOW, HIGH, ...) | |
| ProcessChain | RSPC_MONITOR | Monitor individual process chains | ||
| PSA | RSTSODS | Directory of all PSA Tables | ||
| PSA | RSTSODSREQUEST | Request directory ODS (PSA), which request is in which ODS (PSA) | ||
| PSA | RSTSODSREQUESTPG | Request / package directory | Number of Packages | |
| PSA | V_RSTC_PC_EMPTY | Request SID <-> Request GUID | ||
| Queries | RSBBSQUERY | Jump targets and sources for Queries | Source Query - ELTUID; Target Query tech. name - RONAM | |
| Queries | RSZELTDIR | Directory of the reporting component elements | ||
| Queries | RSZELTTXT | Texts of reporting component elements | Texts for all elements and Queries | |
| Queries | RSZELTXREF | Directory of query element references | ||
| Queries | RSRREPDIR | Directory of all reports (Query GENUNIID) | Query UID based on Query Tech. Name | |
| Queries | RSZCOMPDIR | Directory of reporting components | ||
| Queries | RSZRANGE | Selection specification for an element | ||
| Queries | RSZSELECT | Selection properties of an element | ||
| Queries | RSZCOMPIC | Assignment reuseable component <-> InfoCube | ||
| Queries | RSZELTPRIO | Priorities with element collisions | Elements in Query like local calculations and selections (not - KYF, Structures) | |
| Queries | RSZELTPROP | Element properties (settings) | ||
| Queries | RSZELTATTR | Attribute selection per dimension element | ||
| Queries | RSZCALC | Definition of a formula element | ||
| Queries | RSZCEL | Query Designer: Directory of Cells | ||
| Queries | RSZGLOBV | Global Variables in Reporting | ||
| Queries | RSZWVIEW | Header Table for BW Views | ||
| Queries | V_CMP_JOIN | Inner join for query components without texts | Query and components overview - Useful View | |
| Queries | V_REP_JOIN | Inner Join for query Components without Texts | Useful View | |
| Queries | V_VAR_JOIN | Inner join for variables without texts | Useful View | |
| Requests | RSBKREQUEST | |||
| Requests | RSBKREQUEST_V | |||
| Requests | RSSTATMANPART | Store for G_T_PART of Request Display in DTA Administration | ||
| Requests | RSSTATMANPSA | |||
| SAP BW Statistics | RSDDSTAT | Basic Table for InfoCubes/Queries | ||
| SAP BW Statistics | RSDDSTATAGGR | Detail Table for Aggregate Setup | ||
| SAP BW Statistics | RSDDSTATAGGRDEF | Detail Table of Navigation for each InfoCube/Query | ||
| SAP BW Statistics | RSDDSTATCOND | InfoCube Compression | ||
| SAP BW Statistics | RSDDSTATDELE | InfoCube Deletions | ||
| SAP BW Statistics | RSDDSTATWHM | Warehouse Management | ||
| Technical Tables | T006 | Unit master data | ||
| Technical Tables | T009 | 0FISCPER, 0FISCYEAR master data | ||
| Transfer Structure | RSTS | Transfer Structure List | ||
| Transfer Structure | RSTSFIELD | Transfer Structure fields | ||
| Transfer Structure | RSTSRULES | Transfer Structure rules | ||
| Transfer Structure | RSAROUT | ABAP routine - check table | Information about routine. Where it can be found. | Routine |
| Transfer Structure | RSAROUTT | Text name of Transfer Routine | ||
| Transfer Structure | DD03T | Text for R/3 Transfer structure Objects | ||
| Transfer Structure | ROOSGEN | Generated Objects for a DataSource (Transfer Structure, for example in SAP Source System) | ||
| Transformations | RSTRAN | Transformation | Get source, target for the transformation. | 7.x |
| Transformations | RSTRANT | Transformation Texts | ||
| Transformations | RSTRANRULE | 7.x | ||
| Transformations | RSTRANFIELD | 7.x | ||
| Transformations | RSTRANSTEPMAP | Mapping for Rule Step Within a Rule | ||
| Transformations | RSTRANSTEPROUT | Rule Type: Routine | Mapping between transformation and it's routines | |
| Update Rules | RSUPDROUT | Update rules List | ||
| Update Rules | RSUPDDAT | Update rules with routines | ||
| Update Rules | RSUPDKEY | Update rule key fields | ||
| Update Rules | RSUPDINFO | InfoProvider to Infosource correlation | ||
| User information | ADRP | Persons (Business Address Services) | ||
| User information | USR02 | Logon Data (Kernel-Side Use) | ||
| User information | USR21 | Assign user name address key | ||
| User information | V_USERNAME | View for Reading User Name | ||
| Web Item | RSZWITEM | Header Table for BW Web Items | ||
| Web Item | RSZWMDITEM | BW Web Metadata: Template Item ( Dataprovider, Item, ... ). | ||
| Web Item | RSZWITEMXREF | Cross Reference of Web Items | ||
| Web Item | RSZWMIMEIOBUFFER | Buffer for Translation MIME Rep. to IO | ||
| Web Item | RSZWOBJ | Storage of the Web Objects | ||
| Web Item | RSZWOBJTXT | Texts of Templates/Items/Views | ||
| Web Item | RSZWOBJXREF | Structure of the BW Objects in a Template | Data provider, Infocube, ... for Web Template | |
| Web Item | RSZWTEMPLATE | Header Table for BW HTML Templates | ||
| Web templates | RSZWBTMPHEAD | Header Table for BW HTML Templates | ||
| Web templates | RSZWBTMPHEADTXT | Header Table for BW HTML Templates Texts | Web Templates description | |
| Web templates | RSZWBTMPTEXT | BW Web Templates: Language Texts | ||
| Web templates | RSZWBTMPXREF | BI Template Cross references to TLOGO Objects | To see Queries assigned to Web Template (Obj. type = ELEM, Object Name = ELTUID) ELTUID can be use in table V_CMP_JOIN | Web template Query |
| Web templates | RSZWOBJ | Storage of the Web Objects | ||
| Web templates | RSZWOBJTXT | Texts for Templates/Items/Views | ||
| Web templates | RSZWOBJXREF | Structure of the BW Objects in a Template | ||
| Web templates | RSZWTEMPLATE | Header Table for BW HTML Templates | ||
| Workbooks | RSRWBINDEX | List of binary large objects (Excel workbooks) | ||
| Workbooks | RSRWBINDEXT | Titles of binary objects (Excel workbooks) | ||
| Workbooks | RSRWBSTORE | Storage for binary large objects (Excel workbooks) | ||
| Workbooks | RSRWBTEMPLATE | Assignment of Excel workbooks as personal templates | ||
| Workbooks | RSRWORKBOOK | Where-used list for reports in workbooks |