SAP4TECH

SAP and ABAP Free Tutorials
Menu
  • SAP Technical
    • ABAP Code Snippets
    • ABAP WebDynPro
    • SAP GW
    • SAP IDOC (ALE)
    • SAP PI (XI)
    • SAP Screen Personas
    • SAP Workflow
  • SAP Functional
    • SAP FI
    • SAP FSCM
    • SAP HR
    • SAP SD & SAP MM
    • SAP PM
    • SAP PP
    • SAP PS
    • SAP QM
    • SAP VIM
    • SAP WM
  • SAP Fiori
  • SAP HANA
  • SAP BW
  • SAP CRM
  • SAP SRM
  • SAP4TECH
    • About Us
    • Contact Us
    • Terms & Conditions
    • Privacy and Cookie Policy

SAP4TECH » The full list of important SAP BW Tables (Business Intelligence Warehouse Tables)

SAP BW

The full list of important SAP BW Tables (Business Intelligence Warehouse Tables)

March 16, 2017 John

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 …

Table of Contents

  • SAP BW Tables
    • SAP BW Tables for Transfer Structure
    • SAP BW Tables for Update Rules
    • Embedded ABAP coding for Transfer / Update Rules
    • InfoPackage Tables in SAP BW
    • SAP Process Chain Tables
    • Query Tables in SAP BW
    • Workbooks
    • Web templates
    • InfoObject
    • InfoCube Tables in SAP BW
    • Aggregate Tables in SAP BW
    • ODS Object
    • PSA Tables in SAP BW
    • DataSource (= OLTP Source)
    • InfoSource
    • Communications Structure
    • Transfer Structure
    • Mapping
    • InfoSpoke
    • SAP BW Statistics
    • Other useful SAP BW Tables
    • SAP BW Tables for Web Item
    • Archiving Tables in SAP BW
    • Open Hub Destination

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. 

Prev Article
Next Article
Tags:SAP Tables Warehouse

Related Articles

SAP BW Overview
Starting with SAP BW, here an short SAP BW Overview …

SAP BW Overview – All what you need to know to start with SAP BW

SAP BW Extractors
SAP BW Extractors are used to extract Data for Data …

Different Types of SAP BW Extractors Explained: Content Vs Generic Extractors

Search on SAP4TECH

The Most Populars

  • The Most Important SAP ISU Tables
    The Most Important SAP ISU Tables
  • SAP Users Tables
    SAP Users Tables (for Personal, Logon, and Address Data)
  • List of SAP Purchase Order Tables in SAP MM SAP PO Tables
    SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • Full list of SAP Movement Types
    SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP GL Account Tcodes SAP GL Account Tables
    The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables
    SAP BOM Tables for BOM Header, Items and components and Category

Related Posts

  • SAP BI Vs SAP BW
    What is the difference between SAP BI and SAP BW ?
  • SAP BW Overview
    SAP BW Overview – All what you need to know to start with SAP BW
  • SAP BI Tcodes
    List of Main SAP BW Tcodes (SAP Business Intelligence Transaction Codes)
  • SAP BW Extractors
    Different Types of SAP BW Extractors Explained: Content Vs Generic Extractors

SAP4TECH

SAP and ABAP Free Tutorials

Trending Posts

  • The Most Important SAP ISU Tables
  • SAP Users Tables (for Personal, Logon, and Address Data)
  • SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables for BOM Header, Items and components and Category

The Most Recents

  • The Most Important SAP ISU Tables
  • SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd Lecture
  • The Main SAP Dunning Transaction Codes
  • SAP Accounts Payable Tcodes & Accounts Receivable Tcodes ( SAP AP Tcodes & SAP AR Tcodes)
  • The Most Important SAP Payment Terms Tables (ZTERM, Text…)

Search

SAP Tutorials by Topics

  • SAP Tables
  • SAP Tcodes
  • SAP BAPI
  • ABAP Snippets
  • Top SAP Courses
  • Top SAP Books
Copyright © 2021 SAP4TECH

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh
This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy