cancel
Showing results for 
Search instead for 
Did you mean: 

How do you display the SQL that BEx uses?

Former Member
0 Kudos

All,

I would like to display the SQL that is submitted to BEx. I understand you can perform a SQL Trace (ST05), but I want to see the SQL before is submitted to BEx. Can anyone help me.

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

As Allison mentions - use RSRT, choosing Execute + Debug.

From there you will see an option, Display SQL Query, which may be what you want, it displays the SAP's Open SQL, but what you might relate better to is the Display Run Schedule, which will show the SQl as translated to the target DB environment and the Explain (execution) Plan.

Just as an FYI, ST04 is also useful for seeing the SQL and execution plans of a query that has already run. Check it out if you are not familiar with it.

Former Member
0 Kudos

Gary,

Execute the query in RSRT, you can choose the execute and debug option, here you can select to view the SQL.