topic Re: Select options with Native SQL in Application Development and Automation Discussions

Select options with Native SQL

Former Member — Thu, 14 Jun 2007 21:05:55 GMT

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

Re: Select options with Native SQL

Former Member — Thu, 14 Jun 2007 21:16:06 GMT

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

Re: Select options with Native SQL

Former Member — Mon, 18 Jun 2007 22:48:09 GMT

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

Re: Select options with Native SQL

Former Member — Tue, 19 Jun 2007 01:08:13 GMT

where condition may not work for native sql query's

Re: Select options with Native SQL

Former Member — Mon, 13 Oct 2008 18:09:13 GMT

restrict the selcet options to EQ and BT