topic Re: Transporting SAP Query in Application Development and Automation Discussions

Transporting SAP Query

Former Member — Tue, 19 Sep 2006 17:01:25 GMT

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

Re: Transporting SAP Query

ferry_lianto — Tue, 19 Sep 2006 17:07:27 GMT

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.

Re: Transporting SAP Query

Former Member — Tue, 19 Sep 2006 17:14:49 GMT

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

Re: Transporting SAP Query

Former Member — Tue, 19 Sep 2006 17:25:32 GMT

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

Hari

Re: Transporting SAP Query

ferry_lianto — Tue, 19 Sep 2006 17:38:58 GMT

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