Skip to Content
avatar image
Former Member

How to find BEx queries without prompts

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 04, 2015 at 08:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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