Skip to Content

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.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. 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?

    Thanks,
    BenyV

    (0) 
    1. Bala Koppuravuri Post author
      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.

      Bala

      (0) 

Leave a Reply