Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Internal Tables

Former Member
0 Likes
1,015

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
923

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.

7 REPLIES 7
Read only

Former Member
0 Likes
924

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.

Read only

Former Member
0 Likes
923

Hi,

you will have to make use of LOOP.

Regards,

Ankur Parab

Read only

Former Member
0 Likes
923

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.

Read only

Former Member
0 Likes
923

look at syntax of

FIND IN TABLE

statement.

Read only

Former Member
0 Likes
923

This message was moderated.

Read only

0 Likes
923

>

> SELECT DISTINCT,

> SELECT ALL,

> SELECT ANY.

>

> Regds,

> Anil

Can you use those statements with internal tables?

Read only

Former Member
0 Likes
923

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