SQL-Info Button missing from Detail-View in SM50

[former_member669881]

Dear Experts,

I implemented SAP Note 1926911 SM50: Display of SQL statements fails in two of our systems.

In both systems I can go to transaction SM50 and double-click on a process to see its details.

The problem is that only one system shows the button "SQL-Info" and the last executed SQL statement.

The other system doesn't show this information and I don't know why. An authorization trace is all green. Maybe there is some customizing involved?

Can you help me?

Thanks!

Calin

[stuart_paull · Accepted solution]

After finding this post, I did a bit more digging in the program and found that actually this can be  controlled through a parameter ID SM50_CONFIGURATION which you can set. Setting it to 'X     X' will enabling display of the executing SQL statement. This may explain why it differs according to the system you were on.

[former_member669881 · Accepted solution]

It's been a long time since I posted this and I gave up on it...

Thanks for finding the solution!!!

I marked your answer as the correct one.

[former_member669881]

SM50 calls report rsmon000_alv_new.

This report has in the BI system (newer SP level) an empty selection screen parameter sqldisp.

If this parameter is checked to value 'X', then the SQL statement is shown.

But SM50 calls the report with default empty value for this parameter and so the SQL statement is not shown in newer SAP systems.

[divyanshu_srivastava3]

What were those two system ?

[former_member669881]

One system is SAP BI 7.40, the other is SAP APO 7.40.

APO has "SQL-Info", BI not.