explain sql format vs. open sql format

[Former Member]

Hi!

My problem is that if I want to use the "Enter SQL statement" functionality of st05, I have to enter my sql commands in a different format, than in my abap code.

The format in the abap code:

select * from sbook as a inner join scarr as b on a_{carrid = b}carrid

The format of st05:

SELECT T_00 . *

FROM "SBOOK" T_00 ,

"SCARR" T_01

WHERE ( T_01 . "MANDT" = '000' AND T_00 . "CARRID" = T_01 . "CARRID" ) AND

T_00 . "MANDT" = '000'

1, Is there a converion FM for this? How could I know the "explain format", without running st05 and executing my command?

2, Where can I find a log of SQL commands, that were actually sent to the database engine?

thanks,

Tamas

[Former Member]

The open SQL that you enter in your ABAP program is converted to native SQL depending on your database platform.

Rob

[Former Member]

Hi Rob!

You've answered a different question. I know how it works. I need to get the DB dependent native SQL, which my opensql command was converted to.

Tamas

[Former Member]

At some point, I looked for such a FM myself, but without success; however, if I recall correctly, this question has been asked before and a positive answer given. So if you search the forum, you should find it.

Rob