Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP query

Former Member
0 Kudos

How to export ABAP query from one landscape to another landscape?

Let me know if there is any way out.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi

Take a look at OSS note 672784.

You can transport queries between systems in SQ02 (hit the lorry button) or run program RSAQR3TR.

You download the infosets, queries etc into a file and load them into whichever system you wish.

Just wanted to share my experience of transporting queries:

I needed to move a user group, 2 infosets and 3 queries from a 4.6 system to a 4.7 system.

When I tried doing this via the SQ* transactions I did not get the import/export option, so instead ran RSAQR3TR.

Step 1. Run RSAQR3TR in 'old' system. Select EXPORT and specify the objects to be transported.

(System includes these in an automatically created transport request)

Step 2. Release this transport and request it be transported to 'new' system.

(This results in the entries being populated in transport table AQTDB in 'new' system).

Step 3. Run RSAQR3TR in 'new' system. Select IMPORT and tick the Overwrite checkbox. Specify the transport number in the field labelled 'dataset with imports'.

(RSAQR3TR gives the message that stuff has been imported OK).

Step 4. In my example I still couldn't find the queries, so ran RSAQR3TR one more time, this time specifying 'Copy Standard Area -> Global Area'.

Regards

Pavan

3 REPLIES 3

Former Member
0 Kudos

If it is a local query, you can download Query and all related objects and upload in another landscape.

If it is a global query, you can assign Transport Request and release the same to your test / another environment.

Hope this helps.

ashish

PS: check this link for more details

Message was edited by:

Ashish Gundawar

Former Member
0 Kudos

Hi Murthy....

We face one issue long back... I feel it is not possible, you have to re-create all work done... in one location....

If in the same landscape then YES....

If the hint is useful… Say thanks by reward….

Regards,

Prabhu Rajesh

Former Member
0 Kudos

Hi

Take a look at OSS note 672784.

You can transport queries between systems in SQ02 (hit the lorry button) or run program RSAQR3TR.

You download the infosets, queries etc into a file and load them into whichever system you wish.

Just wanted to share my experience of transporting queries:

I needed to move a user group, 2 infosets and 3 queries from a 4.6 system to a 4.7 system.

When I tried doing this via the SQ* transactions I did not get the import/export option, so instead ran RSAQR3TR.

Step 1. Run RSAQR3TR in 'old' system. Select EXPORT and specify the objects to be transported.

(System includes these in an automatically created transport request)

Step 2. Release this transport and request it be transported to 'new' system.

(This results in the entries being populated in transport table AQTDB in 'new' system).

Step 3. Run RSAQR3TR in 'new' system. Select IMPORT and tick the Overwrite checkbox. Specify the transport number in the field labelled 'dataset with imports'.

(RSAQR3TR gives the message that stuff has been imported OK).

Step 4. In my example I still couldn't find the queries, so ran RSAQR3TR one more time, this time specifying 'Copy Standard Area -> Global Area'.

Regards

Pavan