Skip to Content
Author's profile photo Former Member

Change Queries from display to edit mode in Quality/Production Servers.

Scenario –

Mr.Black has transported query previous night. Next day morning, he ran his query. Mishap…!!…he found that data is improper. Now he has planned to check sales order line item wise to make the job easier. But last night he forgot to put corresponding info object in the drill-down. What to do now? Placing that object in the development server then transporting it takes lots of time right and he has to test and deliver the object by EOD.. So how about editing the query in Quality server??

Here’s the simple procedure for that.

After transporting in Quality server. (Uneditable Query).

/wp-content/uploads/2013/07/10_253105.png

/wp-content/uploads/2013/07/11_253205.png

Step 1: Go to RSA1 –> Transport connection. (Note: This has to be done in your target system).

Step 2:

/wp-content/uploads/2013/07/12_253206.png

Do as per the above screenshot.

Then you will get a screen.

Step 3:

/wp-content/uploads/2013/07/13_253229.png

For query elements choose ELEM. And at the extreme end, we can able to see “Not changeable” status.

Step 4: Now right click on the “Not changeable”

/wp-content/uploads/2013/07/14_253230.png

Click on “Switch changeability”.

Step 5:

/wp-content/uploads/2013/07/15_253232.png

And the status is changed to Changeable original.

Step 6:

Log off and log in to your Designer.

/wp-content/uploads/2013/07/16_253233.png

In the above screenshot, it is evident that the query is now changeable and sales document is added to the query.

P.S: – It is not advisable to use above method in Production Server but even if it requires changing, proper authorization is required.

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Abhimanyu Sharma
      Abhimanyu Sharma

      Nice document

      Author's profile photo abilash n
      abilash n

      Nice one....

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      thanks guys 🙂 .

      Author's profile photo Prashanth Konduru
      Prashanth Konduru

      Good Job... Very Informative Tip.

      🙂

      Regards

      KP

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Prashanth 🙂 ..

      Author's profile photo Raman Korrapati
      Raman Korrapati

      Very helpful doc and nice presentation too. Thanks for making and sharing Shreya.

      Thanks

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Ramanjaneyulu Korrapati. 🙂

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Nice tip .

      But i guess one needs to take into account the settings in SCC4 for the Target systems.

      Would this work irrespective of whatever settings we have in SCC4.

      Thanks