How to find the list of queries containing a Particular Infoobject

[Former Member]

Hi all,

I have requirement to find the list of queries and workbooks which contains a Particular Infoobject. Please advice is there any Database table or Programs exists to find..

Thanks in advance

GAMY..

[Former Member]

Hi ganesh,

simple... You can find in RSZELTXREF the link between the queries Id and all the elements Id. In RSZCOMPDIR you find the link between the element id and the infoobjects or the queries...

Hope it helps,

Rodolphe

[former_member199573]

Ganesh,

You can use the transport collection tool to collect the Infoobject and choose the grouping option "In Data flow afterwards". It should show all the reports in which it has been used.

Using where used list as mentioned by Bhanu is more straightforward than trying to collect.

Raj.

[former_member188975]

Hi,

You can do that by going to RSD1 > Type in the name of the InfoObject and from the menu Edit > choose Where Used list.

Hope this helps...

[Former Member]

Hi,

Thanks for your replies.

I have tried the oprion already..(RSD1 > Type in the name of the InfoObject and from the menu Edit > choose Where Used list.) but no use. It doesn't show the list of queires..It shows only the data targets.

I would like to know is there any table to achieve the requirement.

Thanks in advance

Ganesh(GAMY)

[Former Member]

Hi Ganesh,

Try this at meta data repository. Choose the infoobject eg: 0EMPLOYEE and click on the description of the object. It gives you the list of queries along with other details.

Hope this is usefull.

Regards

Saravanan.