Infoobject where-used list in Queries

[Former Member]

Hi all,

Is there a way to find a list of all queries in which a specific infoobject is used?

thanks

Sabrina.

[Former Member · Accepted solution]

Don't know if there is a easy way around this, but try the following:

1) In table RSZRANGE give the InfoObject and active version.

2) Take the ELTUID and give them in the RSRREPDIR-COMPUID to get the queries which have the characteristic as free, rows or columns.

3) The only problem is that for things like key figures or structures, the RSZRANGE would refer to the structure (key figure or other) and not the query. In this case step 2 would fail. Table RSZELTXREF can then be used to get the linking. Give the ELTUID in TELTUID and then repeat step 2 for SELTUID.

Repeat step 3 with the SELTUID this time. Keep on repeating until the output list does not grow.

[Former Member · Accepted solution]

thanks Aneesh for your answer. Actually we can find this information in Metadata Repository too. We just figured it out.

thanks again

Sabrina.