Transporting SAP Query Changes??

[Former Member]

Hi All,

I want to transport the changes that are made to the SAP query to my test server from the development server.

Can anybody suggest me how to create a transportation request for the same or is there any other way to transport the changes

Thanks and Regards,

Rupesh

[Former Member]

Use SE10.

[Former Member]

hi rupesh,

Go to SE10. you can release your requests from there.

it is the transport Organizer

[Former Member]

Hi,

For the changes done to the SAP query in SQ01..03 the transport request are not generated.

I want to know how such changes can be transported??

Thanks and Regards,

Rupesh

[Former Member]

you have to use the program RSAQR3TR to create TR for the query change in development server. Get it released to test server, and then copy the query from global area of test server to the standard area (in same program).

[Former Member]

Hello Rupesh,

U can use download and upload option in query also to move infosets and queries.

Goto Sq02. Press the transport button (Ctrl+F3).

Select action as Download. Untick the test run.Select radio button Transport infoset and queries. Enter the infoset and query. execute. This will prompt for a file name.

After it has saved the query and infoset. Log on to test server and folow the same procedure excpet now select UPLOAD.

[Former Member]

Hi Rupesh,

in SQ02 you have an option to transport the changes.

just use that..

click on the symbol CAR or use CTRL+F3.

regards

vijay

[Former Member]

Hi All,

Thanks For all your replies.

The situations is that the query is remaining the same,i.e,I am not distrubing the SQ02 transaction.I am just adding few more fields that needs to be displayed in the output list.

Also,the problem is that I don't have the access to the test system ( Client Restrictions).So whatever needs to be done is in DEV system and through the transport request.

So please anybody have any suggestion, do help me.

Thanks and Regards,

Rupesh.

[Private_Member_738555]

Hi,

Same situation for me also, I have added new columns to the existing info set and query. When I am trying to transport it through se09 by releasing the task and creating TOC its moving to testing system but my changes are not moved to testing system.

And also tried with sq02---> transports--> download its also not worked.

my changes having code, so it is not allowing me to upload code in testing system.

Anyone please help me to transport my changes to testing system.

Thanks,

ANJIBABU

[Former Member]

I saw your posted comment. I recommend raising your question again as a new question and follow our rules of engagement: https://community.sap.com/resources/rules-of-engagement. The author of the original question is no longer active in the community and won't receive your query. Feel free to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. With these tips you'll be able to prepare questions that draw responses from our members.

Thanks!

[Former Member]

Hello u need to log on to development server and use SQ02 and follow the same process except for Download and upload it will be export and as you have no access in test you will have to get the TR in to the test using the normal process.

[Former Member]

HI,

Please follow below steps to transport a Query.

1. In DEV system Go to SQ02 and select Environment ---> Transports.

Select Download radio button under Transport action and below you mention the different ares where you did your changes like(Functional area, Queries or User Groups)

and then click on Execute(Remove the Test Run) and it will prompt you for the file name which will be saved onto Local Directory.

2. In TEST system open the same SQ02 and select Environment --> Transports

Now you select Upload and remember to select the checkbox - Overwriting allowed

And give the details below like functional area, User groups and Querries whereever you did your changes - WITH THE SAME NAMES whatever you have given in the DEV system.

Then execute again it will prompt for local file and select the same which you have downloaded on to the local directory in DEV system.

3. Finally you open SQ01 transaction and select Query -->

More functions -

---

> Generete program.

Then run your Query.

Hope it helps. Reward points if it is helpful.

Thanks

Suresh

[Former Member]

Hi,

As told before run the program in RSAQR3TR in dev server.

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 test server.

In Test server run the same program again, now enter the transport request number in DATASET WITH IMPORTS, use import option and then ur new query will overwrite the previous query.

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

[Former Member]

Hi rupesh,

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,

amit m.