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

  1. Guest

    Thanks Buddy , its very usefull

  2. Guest

    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. Guest

    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

  4. 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?