Select options with Native SQL

[Former Member]

Hi,

Is there any way that I can retrieve data from an external Oracle DB table using native SQL and 2 select-options as 'where' criteria?

select-options: s_bukrs for ekko-bukrs,

s_bsart for ekko-bsart.

*-- connection to ext db

@$#

exec sql perform write_ln

select ebeln

from zext_ekko

into :wa

where [?!?!?!?] "Should retrieve data based on sel-optins

endexec

Thanks in Advance

Somesh

[Former Member]

If the low & high are mentioned in select-option then you can use BETWEEN as log operator in condition, i suppose. But if there are multiple values entered then it wont work. You can very well mention a parameter or a field of structure as conditon in WHERE clause of Select stmt in native SQL.

Reward if its useful.

Regards,

Sail

[Former Member]

Thanks for the reply Sail.. true it fails incase of multiple values..

I came across this SELECT * FROM SCARR WHERE ... CLIENT SPECIFIED..... CONNECTION con. But SAP help says, we are not allowed to use that option.. ne idea y? This makes the current coding a lot more easy.

Thanks

Somesh

[Former Member]

restrict the selcet options to EQ and BT

[Former Member]

where condition may not work for native sql query's