sql

[Former Member]

hi

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]

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]

Hi,

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

aRs

[Former Member]

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]

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

~Suresh