SQL2STRING

[Former Member]

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

[basarozgur_kahraman]

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

[Former Member]

Thanks 🙂

looks like the similiar DEMO Report: ADBC_DEMO_METADATA

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

[amy_king]

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

[Former Member]

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