Important Standard Tables in SAP BW – SAP Business Information Warehouse


Process Chain Tables

Table Name 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

Queries

Table Name Description RSRREPDIR Directory of all reports (Query GENUNIID) RSZCALC Definition of a formula element RSZCEL Query Designer: Directory of Cells RSZCHANGES Change history of reporting components RSZCOMPDIR Directory of reporting components RSZCOMPIC Assignment reusable component <-> InfoCube RSZELTATTR Attribute selection per dimension element RSZELTDIR Directory of the reporting component elements RSZELTDIR Directory of the reporting component elements RSZELTPRIO Priorities with element collisions RSZELTPROP Element properties (settings) RSZELTTXT Texts of reporting component elements RSZELTXREF Directory of query element references RSZGLOBV Global Variables in Reporting RSZRANGE Selection specification for an element RSZSELECT Selection properties of an element

Infopackage

Table Name 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

Update Rules

Table Name Description RSUPDROUT Update rules List RSUPDDAT Update rules with routines RSUPDKEY Update rule key fields RSUPDINFO InfoProvider to Infosource correlation

Transfer Structure

Table Name 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

Embedded ABAP coding for Transfer / Update Rules

Table Name Description RSAABAP ABAP source code per object routine

Queries

Table Name Description RSRREPDIR Directory of all reports (Query GENUNIID) RSZCALC Definition of a formula element RSZCEL Query Designer: Directory of Cells RSZCHANGES Change history of reporting components RSZCOMPDIR Directory of reporting components RSZCOMPIC Assignment reusable component <-> InfoCube RSZELTATTR Attribute selection per dimension element RSZELTDIR Directory of the reporting component elements RSZELTDIR Directory of the reporting component elements RSZELTPRIO Priorities with element collisions RSZELTPROP Element properties (settings) RSZELTTXT Texts of reporting component elements RSZELTXREF Directory of query element references RSZGLOBV Global Variables in Reporting RSZRANGE Selection specification for an element RSZSELECT Selection properties of an element

Workbooks

Table Name 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

Table Name 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

Table Name 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 (for Characteristics,Time Characteristics, and Units) RSDCHA Characteristics Catalog RSDDPA Data Package Characteristic RSDIOBJCMP Dependencies of InfoObjects RSDKYF Key Figures RSDTIM Time Characteristics RSDUNI Units RSDICHAPRO Stores InfoCube-specific characteristic properties data

InfoCubes

Table Name Description RSDCUBE Directory of InfoCubes RSDCUBEIOBJ Objects per InfoCube (where-used list) RSDCUBEMULTI InfoCubes involved in a MultiCube RSDCUBEMULTI InfoCubes concerned with MultiCube RSDCUBET Texts on InfoCubes RSDDIME Directory of Dimensions RSDDIMEIOBJ InfoObjects for each Dimension (Where-Used List) RSDDIMET Texts on Dimensions RSDICHAPRO Characteristic Properties Specific to an InfoCube RSDICMULTIIOBJ MultiProvider: Selection/Identification of InfoObjects RSDICMULTIIOBJ MultiProvider: Selection/Identification of InfoObjects RSDICVALIOBJ InfoObjects of the Stock Validity Table for the InfoCube RSDIKYFPRO Flag Properties Specific to an InfoCube

Aggregates

Table Name Description RSDDAGGRDIR Directory of Aggregates RSDDAGGRCOMP Description of Aggregates RSDDAGGRT Text on Aggregates RSDDAGGLT Directory of the aggregates, texts

ODS Object

Table Name 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 

Table Name Description RSTSODS Directory of all PSA Tables

DataSource

Table Name 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

Table Name Description RSIS Directory of InfoSources with Flexible Update RSIST Texts on InfoSources with Flexible Update RSISFIELD InfoObjects of an InfoSource

Communications Structure

Table Name 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

Table Name Description RSTS Transfer Structure in SAP BW ROOSGEN Generated Objects for a DataSource (Transfer Structure, for example in SAP Source System)

Mapping

Table Name Description RSISOSMAP Mapping Between InfoSources and DataSources (=OLTP Sources) RSOSFIELDMAP Mapping Between DataSource Fields and InfoObjects

InfoSpoke

Table Name Description 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

Table Name 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 RSDDSTAT_OLAP View containing data from the events from the areas for the front end and calculation layer of the analytic engine (Front End/OLAP) RSDDSTATSTEPTP Stores OLAP Statistics: (Navigation) Step Types data RSDDSTATHANDLTP Stores OLAP Statistics: Handle Types (Runtime Objects) data. Combines Handle & Step type and helps to identify where the time is being spent RSDDSTAT_DM Statistics DataManager for Query execution. View containing data from the events from the area for the aggregation layer and analytic engine (Data Manager). RSDDSTATWHM Warehouse management statistics RSDDSTAT_WRITE InfoCube Writes RSDDSTATBCACT Business Content Activation Statistics RSDDSTATCOND Data on Condensing Run InfoCube RSDDSTATEXTRACT Time of last delta load

Web Item

Table Name 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

Table Name 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

Table Name 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

Composite and Transient InfoProvider

Table Name Description RSLTIP Directory Transient Providers RSLTIPT Texts for TransientProviders RSLTIPXREF TransientProvider: Cross References

BI Integrated Planning

Table Name Description RSPLF_SRV

Planning Service

SRVNM is the technical name of the planning function

SRVTYPENM is the technical name of the planning function type (see RSPLAN)

INFOPROV is the name of the infoprovider or aggregation level

TXTLG is the description of the planning function

RSPLF_SRV_COND Rule Condition in Planning Service RSPLF_SRV_CU Characteristic Usage RSPLF_SRV_P Parameter Value (Elementary Type) RSPLF_SRV_PS Parameter Value (Selection Type) RSPLF_SRV_TI Index: Associated TLOGO Objects RSPLF_SRVT Text Table for Planning Service RSPLF_SRVTYPE Definition of Planning Service RSPLF_SRVTYPE_D Dialog Information RSPLF_SRVTYPE_P Parameter Definition for Planning Service RSPLF_SRVTYPE_PT Text Table for Parameter Definition&nbsp RSPLF_SRVTYPE_PV Maintenance View for Parameter Definition RSPLF_SRVTYPET Text Table for Definition of Planning Services

Planning Sequences

RSPLS_SEQUENCE Planning Sequence RSPLS_SEQUENCE_S

Planning Steps

SEQNM is the technical name of the planning sequence

STEPID reflect the order in which the planning function are called

AGGRLEVEL is the technical name of the aggregation level

SELOBJ is the technical name of the filter

SRVNM is the technical name of the planning function

RSPLS_SEQUENCET Texts for Planning Sequences

Aggregation Levels

RSPLS_ALVL Planning: Primary Table for Aggregation Level RSPLS_ALVL_IOBJ Planning: Aggregation Levels for InfoObjects RSPLS_ALVLT Planning: Text Table for Aggregation Level

Characteristic Relationship

RSPLS_CR_HEAD Characteristic Relationships: Header Table RSPLS_CR_PROP Characteristic Relationships: Settings RSPLS_CR_RANGE Char.Relationship: Range (for example, for DataStore Object) RSPLS_CR_ROLE Characteristic Relationships: Roles of the Characteristics RSPLS_CR_STEPS Relationships Between Characteristics in Basic InfoProvider

Data Slices

RSPLS_DS Data Slices RSPLS_DS_FIELD Data Slices: InfoObjects with Restrictions RSPLS_DS_HEAD Data Slices: Header Table RSPLS_DS_RANGE Data Slices: Selection RSPLS_DST Text Table: Data Slices

BWA Tables

Table Name Description RSDDSTATTREX Statistic Data Process TREX Aggreg. RSDDSTATTREXSERV BIA internal statistics RSDDSTATBIAUSE BIA Index Maintenance Run times