on 05-26-2011 8:20 AM
Hello
I am trying to find out which table in SQL the buffer history (ST02) data is stored?
Please let me know.
Thank you
Ken
Table?
ST02 is memory, there's no table.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I do not know the tablenames, but you can run a st05 trace for st02 to find the tables.
For this start st05 and start the trace for your user. Then start st02 and enter the history screen. Then go back to st05 and stop the trace. Then you should be able to find the table, where the data is stored.
Best regards
Clas
Hi dude!
Clas Hortien's advise is simply great, as it will be useful not just to guess the tables you need right now but also in the future.
Just to help you in case you are not familiar with ST05: when you are reading the trace, you can summarize times in order to get it simpler and in a easier format to read (not just chronologic): go to the menu "Trace list" and select "Summarize Trace by SQL Statement (Shift+F8)". Under the column "Obj. name" there are the names of the tables read.
Cheers!!
--Jesú
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.