SAP Query

Author: Baljit Malhotra, Team Lead, Accenture

Transporting SAP Query (for STANDARD AREA from Source to Target system)

When working with Standard Area of sap query, they can not be transported using transport request. It requires use of database table AQLDB.

The transport must follow the following sequence: User Group transport, Infoset transport, Infoset and Query transport, Queries transport (basically in the same sequence as it appears on the selection-screen of program RSAQR3TR discussed below).

Standard Area Query objects are stored in the client-specific table AQLDB. They are not connected to the Transport Organizer.

In the first step, the query objects to be transported must be exported to the transport table AQTDB. In a second step, they are transported using the standard resources of the transport system.

Run Tcode SQ01 and from its menu select: Environment->Query areas. In the pop-up, choose Standard Area as follows below:

Again from the above menu of tcode SQ01, this time select: Environment->Transports. Alternatively, use the program RSAQR3TR.

The SAP query has to be exported first from the source system and then, imported into the target system.

SOURCE SYSTEM

The following activity is to be carried out in the source system, that is the system in which Infoset and SAP Query/ies have been created. In the below screen, select the Export radio-button, Transport Infosets and Queries radio button. Enter the respective infoset/s and query/ies to be transported. Select the check-box Test, if you want to test before transporting queries.

And Execute(F8)...

A new transport request will get created.

As can be seen in the transport request below, table AQTDB can be found as an object:

Click on the below Function (Key) to see the contents of the table:

You will find the transport request created in the table contents:

After successful transport from the source system, it is to be imported (the objects - infoset, sap query) in the target system.

Release the request from source system and once request is available in the target system it can be imported.

TARGET SYSTEM

Check the contents of table AQTDB in target system through the transport request created from the source system. In the SRTFD column, there is request number, name of the infoset and query (exported from the source system):

Now, Run the program RSAQR3TR as mentioned below.

Select radio-button Import and select check-box OVERWRITING allowed (IF you do not select this and if query already exits then new changes exported by you will not be overwritten). It can be run in test mode by selecting check-box Test-run.

In the Data sets with Import field, enter the transport request which was exported from the source system (same as in the table contents of table AQTDB), else the request will not import.

After successful execution of this report program, infoset/s and SAP query/ies will be available in target system. Do the same process for exporting user groups etc by making the appropriate selections in the program screen.