ABAP Queries can be transported to different clients by the following two ways:
1) By using the standard program RSAQR3TR
2) By using the transport option available on the application bar in Transactions SQ02 or SQ03.
On the next screen, all the options come up for transporting the queries. The transport action is performed based on the radio button selected on the screen.
The queries can either be downloaded from one client to the application server or local machine then the same file can be uploaded in the desired system for usage in that system.
Or it can be exported from one client by selecting the Export radio button by creating a transport and then imported in the desired system by using the same transport number.
The transports are to be made in the following order:
1. User Group transport
2. Infoset transport
3. Infoset and Query transport
4. Queries transport
The transports are to be made in the specified order. The User Group is to be transported first, followed by the Infoset and then the Queries.
Once the query is transported or uploaded in the destination system in the method specified above, the same can be used there for displaying the data fetched from the database.
