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.

[Former Member]

The two function modules are:

RSZ_I_BASIC_CHA_WHERE_USED

RSZ_I_BASIC_KEYFIG_WHERE_USED.

Thanks,

Jeff

[Former Member]

Hi Jeff,

How can I find information with these function modules? Do I have to execute them?

please let me know

thanks

Sabrina.

[former_member188975]

Hi Sabrina,

You can put the name of the function module in SE37 and hit F8 (Execute). Then give the InfoObject technical name, object version as A and put an X in the Queries_only if you would only like the information pertaining to use in queries.

Hope this helps...

[former_member188975]

Hi Sabrina,

I think you shoudl be able to look up this info in the metadata repository too.

Hope this helps...