Added by Vikram Srivastava , last edited by Arun Varadarajan on Jan 12, 2010  (view change) div.auto_complete { width: 350px; background: none repeat scroll 0% 0% rgb(255, 255, 255); }div.auto_complete ul { border: 1px solid rgb(136, 136, 136); margin: 0pt; padding: 0pt; width: 100%; list-style-type: none; }div.auto_complete ul li { margin: 0pt; padding: 3px; }div.auto_complete ul li.selected { background-color: rgb(255, 255, 187); }div.auto_complete ul strong.highlight { color: rgb(136, 0, 0); margin: 0pt; padding: 0pt; }

Labels: 

bw, business, information, warehouse EDIT

Applies to:

SAP BW 7.0,SAP BW 3.5.

Summary

This WIKI gives a link of the SAP BW tables for BEx queries. This becomes very useful for multiple analysis.

Author(s):  Vikram Srivastava

   
Company:  Infosys Technologies Limited.   
Created on:   29-12-2009

Author(s) Bio
Vikram Srivastava is working as Technology Analyst with Infosys Technologies Limited. He has got rich experience on various BW Implementation/Support Projects in both SAP BW 3.5 and SAP BW 7.0.

BEx Tables Linking

Most of the times, we are confused while debugging any query for getting where used list, for writing codes where query relations need to be required. We always think if we know the relation between them, our work is done.

 This  linking of the SAP BW tables help to meet multiple requirements.Some of which are:

--> Find Where Used List

---> Find List of queries restricted on the particualr value.

--> Find the queries list where selection is used etc.

This can be obtained by using the relationship as shown in the diagram below:

List of Important Query Related Tables

RSZELTTXT        Texts of reporting component elements 
RSZELTXREF       Directory of query element references 
RSRREPDIR        Directory of all reports 
RSZCOMPDIR       Directory of reporting components
RSZELTDIR        Directory of the reporting component elements
RSZELTDIR        Directory of the reporting component elements
RSZRANGE         Selection specification for an element 
RSZSELECT        Selection properties of an element 
RSZCOMPIC        Assignment reuseable component <-> InfoCube
RSZCALC            Definition of a formula element 
RSZCEL              Query Designer: Directory of Cells
RSZELTPRIO       Priorities with element collisions
RSZGLOBV          Global Variables in Reporting
RSZELTATTR       Attribute selection per dimension element
RSZCHANGES       Change history of reporting components
RSZELTPROP       Element properties (settings)