topic How to select from internal table in Application Development and Automation Discussions

How to select from internal table

Former Member — Thu, 15 Feb 2007 19:13:50 GMT

How to select from internal table.

e.g I would like to do

select from single * from itab1 into itab2 where fieldx = itab1-oldnumber.

Former Member — Thu, 15 Feb 2007 19:17:45 GMT

Hi Tina,

You can not perform any kind of SELECT statement operations on Internal tables.

For your requirement, you can do using LOOP...ENDLOOP statements on internal table.

DATA WA_ITAB1 LINE OF ITAB1.

LOOP AT ITAB1 INTO WA_ITAB1.

READ TABLE ITAB1 WITH KEY FIELDX = WA_ITAB1-OLDNUMBER.

IF SY-SUBRC = 0.

APPEND WA_ITAB1 TO ITAB2.

EXIT.

ENDIF.

ENDLOOP.

READ TABLE ITAB1

Thanks,

Vinay

Former Member — Thu, 15 Feb 2007 19:20:15 GMT

Hi,

We do not write the selects on Internal tables, we can write the READ statements on it.

LOOP AT ITAB1.
Read table ITAB2 with key FIELD1 = ITAB1-FIELD1.
 If sy-subrc = 0.
    write the code
 endif.

ENDLOOP

Regards

Sudheer

Former Member — Thu, 15 Feb 2007 19:21:58 GMT

Try:


LOOP AT itab1 INTO itab2 WHERE (...)
  APPEND itab2.
ENDLOOP.

Rob

Former Member — Thu, 15 Feb 2007 19:34:08 GMT

HI,

Your select query itself is wrong. What others have suggested is nothing but

itab2[] = itab1[].

Use:

select * from tablename into itab2

for all entries in itab1

where fieldx = itab1-oldnumber.

Regards

Subramanian