Skip to Content
author's profile photo Former Member
Former Member

How to edit or save query without disturbing Production support default query

I am new into production support , and i was assigned a task to edit query and check for the errors in report . Now that i am editing or experimenting with the errors i dont want to disturb the production system . Will it be ok if i save the query in "save as in favorites " and execute the query . Please help i am new in production team.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jun 09, 2012 at 02:45 AM

    Akshay,

    You mentioned errors in report.What kind of task is it?Is it a mismatch issue?

    Why don't you check/change in Dev or quality?If you don't have data in dev or quality then check in production.

    If the changes are major you can use 'save query as' it and do the changes in the duplicate query nothing will happen.Otherwise do the changes in the existing query.

    But these changes wont reflect in Dev and Quality systems so, people/sap wont recommend to do changes directly in Prod.

    Note: If you are edit the existing report....follow this ...Save query as----->execute----->Fill the selection screen------>save as workbook

    Regards,

    Anand.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2012 at 08:55 AM

    Hi,

    Do one simple thing, open the query in the production which needs to be tested or modified.

    Now select SAVE AS option from FILE menu.

    Provide another name to this new copy of earlier query (E.g. queryoriginalname_TEST_AKSHAY)

    Save this query.

    Now you can perform your experiments/changes on this newly created test query without any affect on the original query.

    BR,

    Arpit

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.