topic Re: explain sql format vs. open sql format in Application Development and Automation Discussions

explain sql format vs. open sql format

Former Member — Thu, 28 Dec 2006 14:43:04 GMT

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

Re: explain sql format vs. open sql format

Former Member — Thu, 28 Dec 2006 17:14:48 GMT

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

Rob

Re: explain sql format vs. open sql format

Former Member — Fri, 29 Dec 2006 17:20:50 GMT

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

Re: explain sql format vs. open sql format

Former Member — Fri, 29 Dec 2006 17:38:58 GMT

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