Skip to Content
0
Former Member
Sep 20, 2005 at 07:42 AM

Buffer trace lists only parameters of executed SQL stmts

29 Views

Hello,

I use SAP 4.6c.

When I switch on the buffer trace and list the results, I can see a column called 'statement'. In this column, only the parameters of the SQL Query are listed. I can not see to which key fields or attributes of the table the parameters match to.

It is possible to save the trace as a file and extract all OPEN stmts and READ SINGLE stmts (with Excel for example). Thus I get all parameters of executed stmts on buffered tables. But I do not know to which attributes or key fields of the WHERE clause targeted with the parameters...

What I would like to have is one list with all executed SQL stmts on buffered tables. I would like to reuse the stmts for simulation purposes.

Does anybody know how to get this?

Thanks,

Holger