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. 

Read also

Get help for your Basis problems
Do you have a SAP Basis Question?

SAP Basis Admin Books
SAP System Administration, Security, Authorization, ALE, Performance Tuning Reference Books

SAP Basis Tips
SAP BC Tips and Basis Components Discussion Forum

Administration In SAP - Sapgui, Unix, SAP ITS, Router, Client Copy and IDES 

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity. Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.