SAP BLOG Important Standard Tables in SAP BW – SAP Business Information Warehouse

SAP Blog · 1 Eyl 2022

Below a list of some of the important standard SAP tables in a SAP Business Warehouse (BW) system with their description. Also there are some recommendations with reference SAP note on how to perform housekeeping and cleaning up of these BW tables.

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

DTP Tables
Table Name	Description
RSBKDTP	BW: Data Transfer Process Header Data
RSBKDTPH	DTP: Historic Versions
RSBKDTPSTAT	Status Information on Data Transfer Process
RSBKDTPT	Texts on Data Transfer Processes
RSBKDTPTH	Texts on Data Transfer Processes
RSDDSTATDTP	Table for WHM Statistics. Details DTP
RSOACUBE_DTP	BW: OLTP Direct Access: Directory of Assigned Remote DTPs
RSBKDATAPAKSEL	DTP: Data Package Selections
RSBKSELECT	Selections for DTP Request (Summary)
RSBKREQUEST	DTP Request
RSBKREQUEST_V	View of DTP Request
RSBKBP	Breakpoints
RSBKDATAINFO	Information on DTP Runtime Buffers
RSBKDATAPAKID	DTP: Status Table for Data Packages
RSBKSUBSTEP	Properties of Substeps in a DTP

For more information you can see SAP note 2388483 – How-To: Data Management for Technical Tables.

This SAP Note covers data management for tables with a mainly technical background, e.g. used for:

Communication
Logging, tracing
Administration
Analysis
Metadata
Staging
Auditing

It doesn’t deal with application tables.

Furthemore there is also another SAP note which provides information about the processes to clean up and remove data from various tables of the various infoprovider types. For more information see SAP note 3232938 – How-To: Data Management for BW Infoprovider tables

Hope this helps.

Okumaya devam et...

Dil Seçicisi

Ara

Theme colors

SAP BLOG Important Standard Tables in SAP BW – SAP Business Information Warehouse

SAP Blog

Process Chain Tables

Queries

Infopackage

Update Rules

Transfer Structure

Embedded ABAP coding for Transfer / Update Rules

Queries

Workbooks

Web Templates

InfoObject

InfoCubes

Aggregates

ODS Object

PSA

DataSource

InfoSource

Communications Structure

Transfer Structure

Mapping

InfoSpoke

SAP BW Statistics

Web Item

Archiving

Open Hub Destination

Composite and Transient InfoProvider

BI Integrated Planning

Planning Sequences

Aggregation Levels

Characteristic Relationship

Data Slices

BWA Tables

DTP Tables

SAP BLOG Important Standard Tables in SAP BW – SAP Business Information Warehouse

SAP Blog

Process Chain Tables​

Queries​

Infopackage​

Update Rules​

Transfer Structure​

Embedded ABAP coding for Transfer / Update Rules​

Queries​

Workbooks​

Web Templates​

InfoObject​

InfoCubes​

Aggregates​

ODS Object​

PSA ​

DataSource​

InfoSource​

Communications Structure​

Transfer Structure​

Mapping​

InfoSpoke​

SAP BW Statistics​

Web Item​

Archiving​

Open Hub Destination​

Composite and Transient InfoProvider​

BI Integrated Planning​

Planning Sequences​

Aggregation Levels​

Characteristic Relationship​

Data Slices​

BWA Tables​

DTP Tables​

Process Chain Tables

Queries

Infopackage

Update Rules

Transfer Structure

Embedded ABAP coding for Transfer / Update Rules

Queries

Workbooks

Web Templates

InfoObject

InfoCubes

Aggregates

ODS Object

PSA

DataSource

InfoSource

Communications Structure

Transfer Structure

Mapping

InfoSpoke

SAP BW Statistics

Web Item

Archiving

Open Hub Destination

Composite and Transient InfoProvider

BI Integrated Planning

Planning Sequences

Aggregation Levels

Characteristic Relationship

Data Slices

BWA Tables

DTP Tables