VERY VERY VERY URGENT

[Former Member]

Hi All,

I wrote some code to modify one of the query tables - RSZELTXREF in our developemnt system. It screwed all the queries in our development.

How can i rollback the table to restore it?

Please help.

This is very very very urgent.

[former_member188975 · Accepted solution]

Hi George,

What exactly do you mean by "screwed"...you giveincorrect results, or do not execute at all? What changes did you make to the table?

[Former Member · Accepted solution]

Hi,

I used this code:

loop at IOBJ. (selection-screen variable)

loop at it_RSZSELECT.

it_result-iobj = iobj.

it_result-iobjnm = it_RSZSELECT-iobjnm.

select * from rszeltxref

where teltuid = it_RSZSELECT-eltuid

and objvers = 'A'.

IF rszeltxref-laytp = 'FIX'.

UPDATE rszeltxref SET laytp = 'AGG'.

ENDIF.

endselect.

endloop.

endloop.

When i executed this, all the characteristics and key figures from rows, filter and columns are appearing in free characteristics section.

Regards

[former_member188975 · Accepted solution]

Any possibility of restoring from the back up? How many queries are we talking about?

[Former Member · Accepted solution]

Hi,

They may be anywhere from 400-500 queries. Is it possible to do a rollback of that particular table?

Regards

[Former Member · Accepted solution]

Hi,

Please Help. This is very urgent.

I modified the above program in this manner:

loop at IOBJ. (selection-screen variable)

loop at it_RSZSELECT.

it_result-iobj = iobj.

it_result-iobjnm = it_RSZSELECT-iobjnm.

select * from rszeltxref

where teltuid = it_RSZSELECT-eltuid

and objvers = 'A'.

IF rszeltxref-laytp = 'FIX'.

UPDATE rszeltxref SET laytp = 'AGG'.

ENDIF.

endselect.

endloop.

endloop.

Rollback Work.

Inclusion of this statement did not help in any way.

Regards

[Former Member · Accepted solution]

Hi Guys,

Need Help.

Thanks

[Former Member · Accepted solution]

Hi George,

you have to execute the opposite:

IF rszeltxref-laytp = 'AGG'.

UPDATE rszeltxref SET laytp = 'FIX'.

ENDIF.

endselect.

for the same object list !!!

Hope it helps!

Bye,

Roberto

...anyway, NEVER DO this kind of activity without a real safe test phase !!!

[Former Member · Accepted solution]

Hi Roberto,

when i executed the opposite, now all the characteristics and key figures appear in the 'Filters' section.

Regards

[Former Member · Accepted solution]

Try to regenerate your query from RSRT and try again...

[Former Member · Accepted solution]

It doesn't help.

George

[Former Member · Accepted solution]

George,

try yo take a look to your test or prd environment and check what is different (not due to development activity, clear...) in query tables (not only on the REF one...I'm afraid that there is something other not correct on the other tables...

Bye,

Roberto

[Former Member]

Hi,

Better Raise note/issue to SAP and you will get solution.

regs,

MBA

[Former Member]

If you need a quick workaround..copy the table entries from the ur producionsystem and put it in a excel and and create a program in ur dev to upload the excel to the same table....you can do it selectively for the object which u screwed.... i.e "obje = AGG"

If there are some queries in dev not production or Quality you need to work on these....

Hope this work..

kamal

Message was edited by: kamal Raman

[Former Member]

Hi,

Finally, the database had to be restored to before the changes.

Thanks to all