SAP NetWeaver Business Warehouse
Page tree
Skip to end of metadata
Go to start of metadata

The following are the tables in SAP BW which store information related to queries in the Back End. Go to SE16 and just enter the table name:

Table Name

Use of the table

RSZELTDIR

Directory of the reporting component elements

RSZELTTXT

Texts of reporting component elements

RSZELTXREF

Directory of query element references .
To get a list of query elements built on that cube.filter by: OBJVERS = 'A', INFOCUBE= [stage:cubename]

RSRREPDIR

Directory of all reports (Query GENUNIID) .
To get all queries of a cube.filter by: OBJVERS = 'A', INFOCUBE= [stage:cubename]

RSZCOMPDIR

Directory of reporting components.
To get query change status (version, last changed by, owner) of a cube.

RSZRANGE

Selection specification for an element

RSZSELECT

Selection properties of an element

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

RSZCHANGES

Change history of reporting components

 

 


The following are the tables in SAP BW which store information related to workbooks in the back End. Go to SE16 and just enter the table name:

Table Name

Use of table

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


The following are the tables in SAP BW which store information related to web Templates in the back End. Go to SE16 and just enter the table name:

Table Name

Use of Table

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

7 Comments

  1. Unknown User (98z3kt6f)

    Thanks Buddy , its very usefull

  2. Unknown User (sbcpcnv)

    I came across one more table that list the Views that are created.

    RSZWVIEW  - Header Table for BW Views

    Request the moderator to add this to the above list

  3. Unknown User (sbcpcnv)

    I came across one more table that list the Views that are created.

    RSZWVIEW  - Header Table for BW Views

    Request the moderator to add this to the above list

    1. Former Member

      Thanks

  4. Güneş Büyüktanır

    Good job!Thanks for this.However, I need to see "by whom the workbook is changed" during lifetime of workbook.Not last update person.I need all of them.Is there such a table?

    1. Harald Schwenger

      Hi G.B., you could think of creating that information by an internal datasource on the RSRWBINDEX table, then feeding data into a subsequent DSO. In the TRFN updating the DSO you would have to implement a simple CDC (changed data capture) routine to create the required change history and update it to the DSO.

       

  5. Sunil Kr. Sinha

    Hi everyone,

    I need a help. I want to know table name which can help me to find out Workbook size.