Skip to Content
Author's profile photo Former Member

RSRTQ – BW Query Details

This document addresses the requirement of gathering all the details of a query at one go, irrespective of the type of query element without actually navigating through different screens. In this article I am explaining how RSRTQ Transaction code helps especially in Transport issues.

Live Scenario

A Query is collected in a Transport request. Contents of the Transport request show Elements of the query Builder with system generated Technical ID’s, 25 digit ID’s.

                                                    IMG1.png

Checking the object descriptions collected in the Transport request ends up either going to the base tables or to Transport connection from RSA1 transaction both of which provide few details but not the complete details as in RSRTQ. Using Unique ID’s radio button from Technical Information panel, we can get these details.

RSRTQ – Query Definition in Detail

Details of a query can be seen in the Query designer by clicking on each element to know the properties of an element but instead transaction RSRTQ gives all the details of a Query at one shot.

Calling Transaction

RSRTQ screen can also be navigated from SE38 using SAP delivered program RSRQ_QUERYDEFINITION and Pressing F8.          

                        IMG2.png

Output Options

This pane shows the available list of query elements to select. All or required elements can be selected to see the properties.

Additional Output

All the query properties like Display Properties, Rows/column Properties, Planning Properties, Hierarchy properties can be seen with additional Output pane selections.

                        IMG3.png 

Properties include Read mode, Cache mode, Optimization mode, Statistics Detail Level and more.

                        IMG4.png

This feature especially helps to show the Variable properties at one go which is otherwise one will end up in navigating through lot of screens to see all the variable related information in query designer.

                        IMG5.png

Technical Information

Technical information pane has three buttons which show different level of details

Selecting Technical Names Radio button gives the technical names of the query elements, including the selection fields, filters.

                        IMG6.png

                        IMG7.png

Selecting Unique ID Radio button gives the Unique ID’s which system generates for elements of the query.

                        IMG8.png

                        IMG9.png

Above screen shot shows our requirement of finding the query elements from system generated Technical ID’s.

Selecting Change Log Radio button gives the details like when the elements were last changed.

                        IMG10.png        

Hierarchy Node last change details can be seen in the below screen shot.

                        IMG11.png

Related Content

http://help.sap.com/saphelp_nw04s/helpdata/en/1e/99ea3bd7896f58e10000000a11402f/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/f1/0a5673e09411d2acb90000e829fbfe/frameset.htm

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/14329

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very Useful.

      Author's profile photo CH Raman
      CH Raman

      Hi Aparna,

      Very good article and useful too. Thanks for sharing....

      Thanks

      Author's profile photo Prashanth konduru
      Prashanth konduru

      Nice n usefull info..

      Author's profile photo Former Member
      Former Member

      Very Good Document

      Author's profile photo Former Member
      Former Member

      Nice document Aparna

      Thanks 🙂

      Purushotham.

      Author's profile photo Former Member
      Former Member

      Good Stuff 🙂

      Aparna Thanks for the doc

      Author's profile photo Former Member
      Former Member

      Hi Aparna,

      Nice document, thanks for sharing.

      Regards,

      Malathi

      Author's profile photo Mohan krishna
      Mohan krishna

      Hi Aparna,

      Thanks for Sharing, Nice document.

      Regards,

      Mohana.

      Author's profile photo Former Member
      Former Member

      Good job Aparna, thank you for sharing.

      Author's profile photo venkat yerva
      venkat yerva

      Good document 🙂

      Author's profile photo Aparajit Banik
      Aparajit Banik

      Hi Aparana,
      Thank You for sharing this document  really very informative.
      Would you like to elaborate about Parameter 2

      Thanks

      Author's profile photo Former Member
      Former Member

      Useful Document.

      Jayendran

      Author's profile photo Former Member
      Former Member

      Great document