Skip to Content
Author's profile photo Former Member

Query searching based on Object name

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.


 Step 1: Go to transaction SE16 –> Table RSZELTTXT


  • 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


ELTID values which holds the technical name of the object

 Step 2: Go to transaction SE16 –>Table RSZELTXREF


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


  • 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:  

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


  • 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.

Assigned tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix
      Hi Bala,
      Would'nt it be easier if the 25 digit Unique ID of the said object is copied from the 'Advanced' tab in query designer and used in RSZELTXREF-TELTUID field or am i making a mistake here?


      Author's profile photo Former Member
      Former Member
      Hi Beny,

      Thanks for your comments.

      Unique ID is specific to given query. If there are multiple queries exist on a given Info provider then it would be difficult to search one by one.