BW Training General -how to find in which Queries an infoobject is used

Go to  transaction“SE 37” and enter the below function module name and press F8

RSZ_I_BASIC_CHA_WHERE_USED

RSZ_I_BASIC_KEYFIG_WHERE_USED

First one for characteristics, second one for keyfigures.

Enter below details in screen

In I_IOBJNM, give ur info object name,

In I_OBJVERS, give A (for Active version)

In I_QUERIES_ONLY put X

Press F8 (will take some time if ur info object has been used in more queries)

Now E_T_COMPLIST shows the number of queries ur info object has been used. Click on

contents box next to it.

You will find the queries in the COMPID field.

You can use following table for all details.This will give you information about key figure ,characteristic formula etc that we use in a query and other details like  last changed by info ,last changed date and query for which key figure exist  :

RSZCOMPDIR

Other useful table will be :

RSRREPDIR	Number of queries available in BW system
RSZELTDIR	Directory of the reporting component elements
RSZELTTXT	Texts of reporting component elements
RSZELTXREF	Directory of query element references
RSRREPDIR	Directory of all reports (Query GENUNIID)
RSZCOMPDIR	Directory of reporting com