Skip to Content
0
Former Member
Jun 14, 2007 at 09:05 PM

Select options with Native SQL

341 Views

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