Tables in SAP BW which give information related to Queries, Work Books and Web Templates

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