Child pages
  • Relation between between BEX Query DefinitionTables
Skip to end of metadata
Go to start of metadata

Purpose 

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

Overview 

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)

Related Content

Related Documents

Insert SAP Help links or other WIKI content

Related Notes

Insert links to any related notes/KBA that support your topic or are related