cancel
Showing results for 
Search instead for 
Did you mean: 

ST02 buffer history SQL table

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

Table?

ST02 is memory, there's no table.

Markus

Former Member
0 Kudos

ST02 is memory, and the "memory history" must be stored in a table somewhere.....

Regards

Ken

clas_hortien
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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ú