Application Development 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: 

Internal Tables

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

former_member555112
Active Contributor
0 Kudos

Hi,

you will have to make use of LOOP.

Regards,

Ankur Parab

Former Member
0 Kudos

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.

Former Member
0 Kudos

look at syntax of

FIND IN TABLE

statement.

Former Member
0 Kudos

This message was moderated.

0 Kudos

>

> SELECT DISTINCT,

> SELECT ALL,

> SELECT ANY.

>

> Regds,

> Anil

Can you use those statements with internal tables?

Former Member
0 Kudos

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