Change Queries from display to edit mode in Quality/Production Servers.
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).
Step 1: Go to RSA1 –> Transport connection. (Note: This has to be done in your target system).
Do as per the above screenshot.
Then you will get a screen.
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”
Click on “Switch changeability”.
And the status is changed to Changeable original.
Log off and log in to your Designer.
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.
thanks guys 🙂 .
Good Job... Very Informative Tip.
Thanks Prashanth 🙂 ..
Very helpful doc and nice presentation too. Thanks for making and sharing Shreya.
Thanks Ramanjaneyulu Korrapati. 🙂
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.