In this article, we will list the most Important SAP BW Tables (Business Intelligence Warehouse Tables).
In order to simplify this list, we will divide the list into SAP BW Tables by topics such us: Transfer Structure Tables, Update Rules, InfoPackage, Queries, Workbooks, InfoObject, InfoCube Tables, DataSource, InfoSource tables …
SAP BW Tables
SAP BW Tables for Transfer Structure
The most important SAP BW Tables for Transfer Structure are
| SAP Tables | Description |
|---|
| RSTS | Transfer Structure List |
| RSTSFIELD | Transfer Structure fields |
| RSTSRULES | Transfer Structure rules |
| RSAROUTT | Text name of Transfer Routine |
| DD03T | Text for R/3 Transfer structure Objects |
SAP BW Tables for Update Rules
The most important SAP BW Tables for Update Rules are
| SAP Tables | Description |
|---|
| RSUPDROUT | Update rules List |
| RSUPDDAT | Update rules with routines |
| RSUPDKEY | Update rule key fields |
| RSUPDINFO | InfoProvider to Infosource correlation |
Read also SAP Info Record Table, Info Record Tcodes and SAP Info Record Report.
Embedded ABAP coding for Transfer / Update Rules
The most important Embedded ABAP coding for Transfer / Update Rules are
| SAP Tables | Description |
|---|
| RSAABAP | ABAP source code per object routine |
InfoPackage Tables in SAP BW
The most important InfoPackage Tables in SAP BW are
| SAP Tables | Description |
|---|
| RSLDPIO | Links datasource to infopackages |
| RSLDPIOT | InfoPackage Text Description |
| RSLDPRULE | ABAP source code for InfoPackages |
| RSLDPSEL | Hardcoded selections in InfoPackages |
| RSMONICDP | Contains the request-id number by data target |
| RSPAKPOS | List of InfoPackage Groups / InfoPackages |
SAP Process Chain Tables
The most important Process Chain Tables in SAP BW are
| SAP Tables | Description |
|---|
| RSEVENTCHAIN | Event Chain Processing Event Table |
| RSEVENTHEAD | Header for the event chain |
| RSEVENTHEADT | Header for the event chain |
| RSPCCHAIN | Process chain details |
| RSPCCHAINATTR | Attributes for a Process Chain |
| RSPCCHAINEVENTS | Multiple Events with Process Chains |
| RSPCCHAINT | Texts for Chain |
| RSPCCOMMANDLOG | System Command Execution Logs (Process Chains) |
| RSPCLOGCHAIN | Cross-Table Log ID / Chain ID |
| RSPCLOGS | Application Logs for the Process Chains |
| RSPCPROCESSLOG | Logs for the Chain Runs |
| RSPCRUNVARIABLES | Variables for Process Chains for Runtime |
| RSPC_MONITOR | Monitor individual process chains |
Query Tables in SAP BW
The most important Queries Tables in SAP BW are
| SAP Tables | Description |
|---|
| RSZELTDIR | Directory of the reporting component elements |
| RSZELTTXT | Texts of reporting component elements |
| RSZELTXREF | Directory of query element references |
| RSRREPDIR | Directory of all reports (Query GENUNIID) |
| RSZCOMPDIR | Directory of reporting components |
| RSZRANGE | Selection specification for an element |
| RSZSELECT | Selection properties of an element |
| RSZELTDIR | Directory of the reporting component elements |
| RSZCOMPIC | Assignment reuseable component < -> InfoCube |
| RSZELTPRIO | Prioritifes with element collisions |
| RSZELTPROP | Element properties (settings) |
| RSZELTATTR | Attribute selection per dimension element |
| RSZCALC | Definition of a formula element |
| RSZCEL | Query Designer: Directory of Cells |
| RSZGLOBV | Global Variables in Reporting |
| RSZCHANGES | Change history of reporting components |
Workbooks
| SAP Tables | Description |
|---|
| RSRWBINDEX | List of binary large objects (Excel workbooks) |
| RSRWBINDEXT | Titles of binary objects (Excel workbooks) |
| RSRWBSTORE | Storage for binary large objects (Excel workbooks) |
| RSRWBTEMPLATE | Assignment of Excel workbooks as personal templates |
| RSRWORKBOOK | Where-used list for reports in workbooks |
Web templates
| SAP Tables | Description |
|---|
| RSZWOBJ | Storage of the Web Objects |
| RSZWOBJTXT | Texts for Templates/Items/Views |
| RSZWOBJXREF | Structure of the BW Objects in a Template |
| RSZWTEMPLATE | Header Table for BW HTML Templates |
InfoObject
| SAP Tables | Description |
|---|
| RSDIOBJ | Directory of all InfoObjects |
| RSDIOBJT | Texts of InfoObjects |
| RSDIOBJ | Directory of all InfoObjects |
| RSDIOBJT | Texts of InfoObjects |
| RSDATRNAV | Navigation Attributes |
| RSDATRNAVT | Navigation Attributes |
| RSDBCHATR | Master Data Attributes |
| RSDCHABAS | Basic Characteristics |
| RSDCHA | Characteristics Catalog |
| RSDDPA | Data Package Characteristic |
| RSDIOBJCMP | Dependencies of InfoObjects |
| RSKYF | Key Figures |
| RSDTIM | Time Characteristics |
| RSDUNI | Units |
InfoCube Tables in SAP BW
| SAP Tables | Description |
|---|
| RSDCUBE | Directory of InfoCubes |
| RSDCUBET | Texts on InfoCubes |
| RSDCUBEIOBJ | Objects per InfoCube (where-used list) |
| RSDDIME | Directory of Dimensions |
| RSDDIMET | Texts on Dimensions |
| RSDDIMEIOBJ | InfoObjects for each Dimension (Where-Used List) |
| RSDCUBEMULTI | InfoCubes involved in a MultiCube |
| RSDICMULTIIOBJ | MultiProvider: Selection/Identification of InfoObjects |
| RSDICHAPRO | Characteristic Properties Specific to an InfoCube |
| RSDIKYFPRO | Flag Properties Specific to an InfoCube |
| RSDICVALIOBJ | InfoObjects of the Stock Validity Table for the InfoCube |
Aggregate Tables in SAP BW
| SAP Tables | Description |
|---|
| RSDDAGGRDIR | Directory of Aggregates |
| RSDDAGGRCOMP | Description of Aggregates |
| RSDDAGGRT | Text on Aggregates |
| RSDDAGGLT | Directory of the aggregates and texts |
ODS Object
| SAP Tables | Description |
|---|
| RSDODSO | Directory of all ODS Objects |
| RSDODSOT | Texts of all ODS Objects |
| RSDODSOIOBJ | InfoObjects of ODS Objects |
| RSDODSOATRNAV | Navigation Attributes for ODS Object |
| RSDODSOTABL | Directory of all ODS Object Tables |
PSA Tables in SAP BW
| SAP Tables | Description |
|---|
| RSTSODS | Directory of all PSA Tables |
DataSource (= OLTP Source)
| SAP Tables | Description |
|---|
| ROOSOURCE | Header Table for SAP BW DataSources (SAP Source System/BW System) |
| RODELTAM | BW Delta Procedure (SAP Source System) |
| RSOLTPSOURCE | Replication Table for DataSources in BW |
InfoSource
| SAP Tables | Description |
|---|
| RSIS | Directory of InfoSources with Flexible Update |
| RSIST | Texts on InfoSources with Flexible Update |
| RSISFIELD | InfoObjects of an InfoSource |
Communications Structure
| SAP Tables | Description |
|---|
| RSKS | Communications Structure for InfoSources with Flexible Update |
| RSKS | Communications Structure (View) for Attributes for an InfoSource with Direct Update |
| RSKSFIELD | Texts on InfoSources with Flexible Update |
| RSISFIELD | InfoObjects of an InfoSource with Flexible Update |
Transfer Structure
The main Transfer Structure Tables in SAP Business Warehouse are
| SAP Tables | Description |
|---|
| RSTS | Transfer Structure in SAP BW |
| ROOSGEN | Generated Objects for a DataSource |
Mapping
The main Mapping Tables in SAP Business Warehouse are
| SAP Tables | Description |
|---|
| RSISOSMAP | Mapping Between InfoSources and DataSources (=OLTP Sources) |
| RSOSFIELDMAP | Mapping Between DataSource Fields and InfoObjects |
InfoSpoke
The main InfoSpoke Tables in SAP Business Warehouse are
| SAP Tables | Description |
|---|
| RSBSPOKESELSET | InfoSpoke Directory and Selection Options |
| RSBSPOKEVSELSET | InfoSpoke Directory with Selection Options and Versioning |
| RSBSPOKE | List of all InfoSpokes with attributes maintained |
| RSBSPOKET | List of all InfoSpokes with the Short |
| RSBSTEPIDMESS | Contains all the messages that have been recorded during the execution of an InfoSpoke |
SAP BW Statistics
| SAP Tables | Description |
|---|
| RSDDSTAT | Basic Table for InfoCubes/Queries |
| RSDDSTATAGGR | Detail Table for Aggregate Setup |
| RSDDSTATAGGRDEF | Detail Table of Navigation for each InfoCube/Query |
| RSDDSTATCOND | InfoCube Compression |
| RSDDSTATDELE | InfoCube Deletions |
| RSDDSTATWHM | Warehouse Management |
Other useful SAP BW Tables
In this part, you will find a list of interesting and useful SAP Tables in BW.
| SAP Tables | Description |
|---|
| RSFEC | BW Frontend Check. Useful for checking the installed SAP GUI versions on user machines. |
| RSSELDONE | InfoPackage selection and job program |
| RSPSADEL | PSA Table deletion |
| TBTCP | Job Schedule Definition |
| TBTCO | Job Schedule Result |
| RSMONMESS | Monitor Messages |
| RSERRORLOG | Check loading errors in table |
| V_RSZGLOBV | Report Variables view table |
| DEVACCESS | Developer Keys table |
| TSTC | All Transactions in the system |
| RSDDAGGRDIR | Directory of the aggregates |
| ROIDOCPRMS | Control parameters for data transfer from the source system |
| SMEN_BUFFC | Objects in User's Favorites |
| TSTCT | Transaction Codes with Text |
| DD03L | field names and corresponding data element names |
| DD03LT | Description of each data element |
| DD02L | All SAP Defined Table Names |
| DD02LT | Description of All SAP Defined Table Names |
SAP BW Tables for Web Item
| SAP Tables | Description |
|---|
| RSZWITEM | Header Table for BW Web Items |
| RSZWMDITEM | BW Web Metadata: Template Item Dataprovider& Item |
| RSZWITEMXREF | Cross Reference of Web Items |
| RSZWMIMEIOBUFFER | Buffer for Translation MIME Rep. to IO |
| RSZWOBJ | Storage of the Web Objects |
| RSZWOBJTXT | Texts of Templates/Items/Views |
| RSZWOBJXREF | Structure of the BW Objects in a Template |
| RSZWTEMPLATE | Header Table for BW HTML Templates |
Archiving Tables in SAP BW
The main Archiving Tables in SAP Business Warehouse are
| SAP Tables | Description |
|---|
| RSARCHIPRO | BW Archiving: General Archiving Properties |
| RSARCHIPROIOBJ | BW Archiving: General Archiving Properties |
| RSARCHIPROLOC | BW ARchiving: General Local Properties |
| RSARCHIPROLOCSEL | BW Archiving: Archived Data Area |
| RSARCHIPROPID | BW Archiving: Program References of InfoProvider |
| RSARCHREQ | BW Archiving: Archiving Request |
| RSARCHREQFILES | BW Archiving: Verfified Archive Files |
| RSARCHREQSEL | BW Archiving: Request-Selections |
Open Hub Destination
| SAP Tables | Description |
|---|
| RSBOHSERVICETP | Open Hub: Service Types |
| RSBREQUESTDELTA | Open Hub: Cross Reference Outbound/Inbound |
| RSBREQUESTMESS | Open Hub: Log for a Request |
| RSBREQUID | Open Hub: Requests |
| RSBREQUID3RD | Open Hub: Status of 3rd Party Requests |
| RSBREQUIDRUN | Open Hub: Table with Status for a Request |
| RSBSTRUCTURE | Open Hub: Generated Structures and Tables |
All the credit go the writer of this article on scn.
