If you are looking at getting a list of queries based on object name (used in the query) then this blog would help in compiling such list. This will be useful in cases when you are looking at re-modeling an Info provider and would like to know how many queries were using a particular object to take decisions like retaining or dropping objects from Info provider.

Tables involved: RSZELTXREF, RSZELTTXT

 Step 1: Go to transaction SE16 --> Table RSZELTTXT

 Selections:         

  • OBJVERS = A
  • LANGU = E                
  • TXTSH or TXTLG = Enter the name of object name been used in the query. Keep in mind input entered here is case sensitive and suggest using wild characters if you are not really sure about description

 Output:            

ELTID values which holds the technical name of the object

 Step 2: Go to transaction SE16 -->Table RSZELTXREF

 Selections:         

  • OBJVERS    = A
  • INFOCUBE = Name of the Info Provider
  • TELTUID = Values collected in step 1 (RSZELTTXT-ELTID)

 Output:

  • SELTUID  values which provide the Query technical name

 Step 3: Go back to Table RSZELTTXT to get the query description

           Go to transaction SE16 --> Table RSZELTTXT Selections:  

  • OBJVERS = A
  • LANGU = E                
  • ELTID = Values collected in step 2 (RSZELTXREF-SELTUID)

 Output:

  • TXTSH = Short description of the query
  • TXTLG – Provides the long description of the query

Other tables related to this topic are: RSZELTDIR, RSZELTPROP

By following these steps, you would be able to get a list of queries where the given object are used. Developing a simple ABAP program might also help in automating the search process.