Showing results for 
Search instead for 
Did you mean: 

Intercept SQL statement

Former Member
0 Kudos

Hi to everybody,

I have one question: I'm in the Financial Reports -> Financial -> Cash Flow. I have the necessity to view or intercept the procedure/statement SQL the use SAP to retrieve the dataset. I use the SQL Profiler, but is very hard to understand all the statement. There is another way to do it?



Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi ,

SQL profiler is the only way to get the queries that sap b1 internally executes to fetch the report results.

system queries are not available to users.


Trupti Mahurkar

Former Member
0 Kudos

Hi Marco,

As far as I known, this is the simplest way to do this kind of job. No wonder it is difficult to understand. The logic behind it is indeed very complicated.