Friday, October 12, 2007




Transport of ABAP Query


I am involved in this upgrade project to 4.7

The users are not able to find any reports (in QA System) which were there before the upgrade in SQ01. But they can see them in production which is not yet upgraded. They want me to copy all the reports to the QA system now....I dont have any idea how to do that.


I remember a similar problem upgrading to 4.6C from 4.5B ......
Take a look at OOS 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'.


(Now my queries etc were available in new system).


Perhaps there are better ways, but after 1.5 days of struggling I was glad to get this far.

No comments: