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