topic Re: Internal Tables in Application Development and Automation Discussions

Internal Tables

Former Member — Thu, 16 Jul 2009 07:23:51 GMT

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

Re: Internal Tables

Former Member — Thu, 16 Jul 2009 07:29:41 GMT

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.

Re: Internal Tables

Former Member — Thu, 16 Jul 2009 07:31:16 GMT

Hi,

you will have to make use of LOOP.

Regards,

Ankur Parab

Re: Internal Tables

Former Member — Thu, 16 Jul 2009 07:31:21 GMT

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.

Re: Internal Tables

Former Member — Thu, 16 Jul 2009 07:32:02 GMT

look at syntax of

FIND IN TABLE

statement.

Re: Internal Tables

Former Member — Thu, 16 Jul 2009 07:32:03 GMT

This message was moderated.

Re: Internal Tables

Former Member — Thu, 16 Jul 2009 07:46:03 GMT


> SELECT DISTINCT,
> SELECT ALL,
> SELECT ANY.
> 
> Regds,
> Anil

Can you use those statements with internal tables?

Re: Internal Tables

Former Member — Thu, 16 Jul 2009 07:52:15 GMT

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