Skip to Content
                                       

Queries are part and parcel of every Bi consultant’s life, in many a case we would need to quickly look up basic information on a query but would also have to go through the hassle of opening Query designer, waiting for it to instantiate and then opening the required query.

This blog addresses some of these concerns by having a program which gives the necessary information and the same can be called through a TCode   if required and this makes it very easy and avoids switching windows while you work. The program is an SAP delivered program RSRQ_QUERYDEFINITION or Tcode RSRTQ. This is a handy program which would be very useful for BI consultant in daily job.

How to make use of this program

Type Tcode SE38 and give the program name and execute (F8)

image

If i want see what are all characteristics in the rows and Keyfigures

Then we need to select check box Rows/columns in selection screen

If some body wants to see what are all free chars and default values

Then in the input screen we can select Filter checkbox

Most Importantly – Variables are listed under the Input variables check box.

In this case we need select Input variables check box.

                       In normal practice i have to navigate through lot screens to see all the variable related info. in query designer. But it very simple in this case where we need to check additional check box i.e   Show Properties.Here is the output which will give all the related info. of variable ..

Thanks                                                                                                                                                                                                                                                 

To report this post you need to login first.

5 Comments

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

  1. Nicolas AIMAIN
    this program is very interesting (it’s also available through tcode RSRTQ) but it doesn’t seem to work with BI7 queries (it should need further investigation – so far, I tested it on a few 3.5/BI7 queries)
    –> do you encounter the same problem ?

    regards

    (0) 
    1. Shanthi Bhaskar Post author
      Nicolas,

      I did try in BI7 where i could get the details. But i was mainly intrested in Varible properties only.

      Thanks
      Shanthi Bhaskar

      (0) 

Leave a Reply