cancel
Showing results for 
Search instead for 
Did you mean: 

How to find BEx queries without prompts

Former Member
0 Kudos

Hi, I have a situation where there are lots of BEx queries mostly with prompts created at query design time. I also have a few queries without prompts. As there are several differenr queries and it is hard to navigate through all of them to find the ones without prompts.

Can you suggest if there is a quick way to find these

Thanks in advance, Kris

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kris,

It's not very easy to find the needed queries in one step. But you can try the following RSZ tables to first figure out all queries with prompt(variable screen).

1. SE16-> table RSZELTXREF:

enter LAYTP =VAR and  POSN=1, and OBJVERS=A,  then get all SELTUID which is the query UID.

2. SE16->table RSZCOMPDIR:

enter the above SELTUIDs in field COMPUID, to get all COMPIDs as query name .

In this way, you will get the technical name for all queries with prompt. Save them in Excel as result 1).

Then you may again get all queries in the system from table RSZCOMPDIR with only OBJVERS=A. Save them in Excel as result 2).

The difference between result 1) and 2) should meet your requirement.

Hope this helpful.

Regards,
Cecilia

Former Member
0 Kudos

Appreciate your response Cecilia

It is a bit challenging issue but your inputs came very handy to searching for without prompt queries

Kris

sheldon_piao
Employee
Employee
0 Kudos

Hi Kris,

Cecilia solution is perfect.
Query itself contains no property about whether the query has input-ready variable or not, so we have to request help from another tricky property: Input-variable order.
If there is input-ready variable for one query, it will have order definition which is stored at table RSZELTXREF as Cecilia mentioned.

Then we can know the list of queries which has input-ready variable. Next we can use table RSZCOMPDIR to find the queries which have no input-ready variable.

If you are familiar with Open SQL, you may get the list via a SQL statement.
Or you may use excel to find the list.

Best Regards,
Sheldon.

Answers (0)