Listed below are some of the tables commonly used in SAP BI ( NW 2004) - however the same has not been tested in NW2004s and please make corrections if required. Some of this material has gone through a lot of eyeballs before making it to the final list and could contain some older references / incorrect references , however most of them have been validated.
Transfer Structure | |
---|
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 |
Update Rules | |
---|
RSUPDROUT | Update rules List
|
RSUPDDAT | Update rules with routines |
RSUPDKEY | Update rule key fields |
RSUPDINFO | InfoProvider to Infosource correlation |
Embedded ABAP coding for Transfer / Update Rules | |
---|
RSAABAP
| ABAP source code per object routine
|
InfoPackage | |
---|
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 |
ProcessChain |
|
---|
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 |
Queries
| |
---|
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 | Priorities 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
|
Workbooks | |
---|
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 | |
---|
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
| |
---|
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 (for Characteristics,Time Characteristics, and Units) |
RSDCHA
| Characteristics Catalog |
RSDDPA
| Data Package Characteristic |
RSDIOBJCMP
| Dependencies of InfoObjects |
RSKYF
| Key Figures |
RSDTIM
| Time Characteristics |
RSDUNI
| Units |
InfoCube | |
---|
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 |
Aggregates | |
---|
RSDDAGGRDIR
| Directory of Aggregates
|
RSDDAGGRCOMP
| Description of Aggregates |
RSDDAGGRT | Text on Aggregates |
RSDDAGGLT | Directory of the aggregates, texts |
ODS Object
| |
---|
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
| |
---|
RSTSODS
| Directory of all PSA Tables |
DataSource (= OLTP Source)
| |
---|
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 | |
---|
RSIS
| Directory of InfoSources with Flexible Update
|
RSIST | Texts on InfoSources with Flexible Update |
RSISFIELD
| InfoObjects of an InfoSource |
Communications Structure
| |
---|
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
| |
---|
RSTS
| Transfer Structure in SAP BW
|
ROOSGEN
| Generated Objects for a DataSource (Transfer Structure, for example in SAP Source System) |
Mapping | |
---|
RSISOSMAP | Mapping Between InfoSources and DataSources (=OLTP Sources)
|
RSOSFIELDMAP | Mapping Between DataSource Fields and InfoObjects |
InfoSpoke
| |
---|
RSBSPOKESELSET | InfoSpoke Directory and Selection Options
|
RSBSPOKEVSELSET | InfoSpoke Directory with Selection Options and Versioning |
RSBSPOKE | List of all InfoSpokes with attributes maintained with transaction RSBO which include the name of the Source & Target Structures |
RSBSPOKET | List of all InfoSpokes with the Short & Long Descriptions (only one of these can be maintained). |
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. |
SAP BW Statistics | |
---|
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 |
Misc | |
---|
RSSELDONE
| InfoPackage selection and job program, there in field UPDMODE the update status (INIT/DELTA/FULL) |
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 |
Web Item | |
---|
RSZWITEM | Header Table for BW Web Items |
RSZWMDITEM | BW Web Metadata: Template Item ( Dataprovider, Item, ... ). |
Archiving
| |
---|
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
| |
---|
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 |