topic Re: SQL2STRING in Application Development and Automation Discussions

SQL2STRING

Former Member — Thu, 29 Nov 2012 09:21:50 GMT

Hi there,

i would like to create a function, that would be able to translate any SQL to string:

SQL:

"SELECT * FROM MARA INTO TABLE lt_mara WHERE matnr EQ lv_matnr"

String:

"SELECT * FROM MARA INTO TABLE lt_mara WHERE matnr EQ R0020"

Any Ideas ? Of course the SQL statement could be much more complicated.

Many Thanks

Re: SQL2STRING

basarozgur_kahraman — Thu, 29 Nov 2012 09:44:28 GMT

Hi Carmine,

Check these links

Moderator Message:

<< Link farming not allowed, in case of providing link(s), please justify it with your explanations >>

Message was edited by: Kesavadas Thekkillath

Re: SQL2STRING

Former Member — Thu, 29 Nov 2012 10:04:35 GMT

Thanks 🙂

looks like the similiar DEMO Report: ADBC_DEMO_METADATA

-> would like to have a straight function -> SQL->STRING

Re: SQL2STRING

amy_king — Thu, 29 Nov 2012 14:47:15 GMT

Hi Carmine,

How would you pass the SQL statement into your function? It seems like passing a SQL statement into a function would already have required the caller to place the SQL into either a string or table in order to be passed to the function.

Cheers,

Amy

Re: SQL2STRING

Former Member — Fri, 07 Dec 2012 09:39:22 GMT

Well I was thinking at some function like ST05 (SQL-Trace). Just to log the processed SQL-Statements as String.