Monday, December 24, 2012

How to find in which Queries an infoobject is used

Is there a table which I can use to find in which queries a particular info-object is used ?


U can use two function modules
RSZ_I_BASIC_CHA_WHERE_USED

RSZ_I_BASIC_KEYFIG_WHERE_USED
First one for characteristics, second one for keyfigures.
For ur case (navigational attribute) use the first function module.
Goto se37, give the function module name, press F8,
In I_IOBJNM, give ur infoobject name,
In I_OBJVERS, give A (for Active version)
In I_QUERIES_ONLY put X
Press F8 (will take some time if ur infoobject has been used in more queries)
Now E_T_COMPLIST shows the number of queries ur infoobject has been used. Click on contents box next to it.
You ll find the queries in the COMPID field.