07-16-2009 8:23 AM
Hi Gurus,
What statement can I use to select multiple rows of data in an internal table. i.e. a statement that can work the same way as a select statement
07-16-2009 8:29 AM
Hello
loop at itab1 where field1 = " condition 1 here
and field2 = " condition 2 here
and field3 = " condition 3 here
move-corresponding itab1 to itab2.
append itab2.
endloop.
07-16-2009 8:29 AM
Hello
loop at itab1 where field1 = " condition 1 here
and field2 = " condition 2 here
and field3 = " condition 3 here
move-corresponding itab1 to itab2.
append itab2.
endloop.
07-16-2009 8:31 AM
07-16-2009 8:31 AM
Use LOOP at itab into wa_tab WHERE <logical expression>
<Logical expression> is similar to the one you give in your WHERE clause while executing a SELECT statement.
Provide feedback if this helps!!
Cheers,
Shailesh.
07-16-2009 8:32 AM
07-16-2009 8:32 AM
07-16-2009 8:46 AM
>
> SELECT DISTINCT,
> SELECT ALL,
> SELECT ANY.
>
> Regds,
> Anil
Can you use those statements with internal tables?
07-16-2009 8:52 AM
Hi :
There are no selection stmt on Int Table as ur request..You need to process your data by Loop.
Try below it can be useful :
DELETE itab WHERE cond .
eg :
DELETE itab WHERE Filed1 NE 'A' .
Resultant table will have records only with field1 = A .
Thanks
Praveen