Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Transporting SAP Query

Go to solution
Former Member

‎2006 Sep 19 6:01 PM

0 Likes
2,171

Hi Friends

This question is regarding the transportation of SAP Query.

I need to transport User groups, Infosets from Development client to Testing client.

Can any one give me the procedure to transport these stuff?

I appreciate all helpful answers.

Thanks in advance

Hari

1 ACCEPTED SOLUTION
Read only

Go to solution
ferry_lianto
Active Contributor

‎2006 Sep 19 6:07 PM

0 Likes
1,082

Hi Hari,

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'.

Hope this will help.

Regards,

Ferry Lianto

Please reward points if helpful.

4 REPLIES 4
Read only

Go to solution
ferry_lianto
Active Contributor

‎2006 Sep 19 6:07 PM

0 Likes
1,083

Hi Hari,

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'.

Hope this will help.

Regards,

Ferry Lianto

Please reward points if helpful.

Read only

Go to solution
Former Member
In response to ferry_lianto

‎2006 Sep 19 6:25 PM

0 Likes
1,082

Thank you ferry. I have one more question. Where/How to specify the transport request to import?

Hari

Read only

Go to solution
Former Member

‎2006 Sep 19 6:14 PM

0 Likes
1,082

Hi Hari,

If you would transport a query, you should create it in globle area ..

Transport the query via SQ02 or SQ03, it actually uses the standard program RSAQR3TR for transport so that you can specify the query for transport or the lot to transport

Regards

Sudheer

Read only

Go to solution
ferry_lianto
Active Contributor

‎2006 Sep 19 6:38 PM

0 Likes
1,082

Hi Hari,

Did you follow above step #3?

Before run the program in RSAQR3TR in DEV server (for example). Choose option TRANSPORT QUERY and enter the query name, uncheck the test run. You will get a transport request number. Now release this TR to QA server (for example).

In QA server (for example) run the same program again, now enter the transport request number in DATASET WITH IMPORTS, use import option and then your new query will overwrite the previous query.

But you need authorization to run this program in QA server, otherwise transport is not possible.

Hope this will help.

Regards,

Ferry Lianto