Internal table

[Former Member]

Dear friends,

My requirement is to fetch data only names, not numbers.

SELECT ernam FROM VBAK

INTO CORRESPONDING FIELDS OF

TABLE ITAB.

LOOP AT itab.

IF itab-ernam CA '0123456789'.

DELETE itab.

ENDIF.

ENDLOOP.

this code is working fine to fetch names only.

But my problem is i have data more than 4,00,000 records.

Above loop is going to Dump.

So i have decided to fetch data only names in SELECT query itself.

Is there any possible way to fetch only names in select query itself ? instead of using the loop.

Thanks in advance

Regards,

Ajay

[Former Member]

HI,

to do it without loop, u just write the select query as:

SELECT ernam FROM VBAK

INTO CORRESPONDING FIELDS OF

TABLE ITAB where ernam ne '0123456789'.

then it validates while fetching the data it self.

then u'll get the other records only.

reward if helps u.

[Former Member]

Dear Mytri,

this is not working. I have tried it. but still fetching numbers.

Kindly suggest me

Thanks,

Ajay

[peter_ruiz2]

hi,

use this code

SELECT ernam FROM VBAK
INTO CORRESPONDING FIELDS OF TABLE ITAB
where ernam na '0123456789'.

regards,

Peter

[Former Member]

Dear Peter,

That is showing error message as " NA is not a valid comparison operator".

Kindly suggest

Thanks,

Ajay

[Former Member]

Hi,

Processing 4,00,000 records, this should not go for dump. Please check the code where exactly it is for dump.

And try this code as well.

LOOP AT itab.
   IF itab-ernam CA '0123456789'.
      DELETE itab.
      clear itab.
      continue.
   ENDIF.
ENDLOOP.

Thanks,

Sriram Ponna.

[Former Member]

Hi,

After the select statement you write delete statement as shown below.

SELECT ernam FROM VBAK

INTO CORRESPONDING FIELDS OF

TABLE ITAB.

DELETE ITAB WHERE NOT ernam CA SY-ABCDE.

Edited by: Velangini Showry Maria Kumar Bandanadham on Apr 15, 2008 9:13 AM

[Former Member]

Hi Velangini,

thanks it is working

Regards,

Ajay