topic sql in Application Development and Automation Discussions

sql

Former Member — Sun, 18 Mar 2007 23:46:31 GMT

in sql select statement if i want to select a single material from the division A but i do not want to include the whole division A.

for example: division = 'EEQA'. append division. then in sql select : div in division. but i only want to pick 1 of the material from division A.

thanks

suresh_datti — Sun, 18 Mar 2007 23:51:43 GMT

You can use SELECT SINGLE if you do know the entire key else you have to use the SELECT UP to 1 ROWS option.

~Suresh

former_member194669 — Sun, 18 Mar 2007 23:53:37 GMT

Hi,


select single * from mytable into table i_itab where division like '%A'.

aRs

Former Member — Mon, 19 Mar 2007 00:01:22 GMT

hi,

you got me wrong.

i want to select 1 material where the material in the division that i want to exclude.

i cannot use single or up to 1 row as the select statement also involve other division and other requirement.

suresh_datti — Mon, 19 Mar 2007 00:08:00 GMT

Then you cannot retrieve with a SELECT statement.. you have to manipulate teh data in an itab..

~Suresh