topic Re: Internal table in Application Development and Automation Discussions

Internal table

Former Member — Tue, 15 Apr 2008 06:29:28 GMT

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

Re: Internal table

Former Member — Tue, 15 Apr 2008 06:42:15 GMT

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.

Re: Internal table

Former Member — Tue, 15 Apr 2008 07:04:28 GMT

Dear Mytri,

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

Kindly suggest me

Thanks,

Ajay

Re: Internal table

peter_ruiz2 — Tue, 15 Apr 2008 07:08:05 GMT

hi,

use this code


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

regards,

Peter

Re: Internal table

Former Member — Tue, 15 Apr 2008 07:11:06 GMT

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.

Re: Internal table

Former Member — Tue, 15 Apr 2008 07:11:13 GMT

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

Re: Internal table

Former Member — Tue, 15 Apr 2008 07:12:06 GMT

Dear Peter,

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

Kindly suggest

Thanks,

Ajay

Re: Internal table

Former Member — Tue, 15 Apr 2008 07:37:42 GMT

Hi Velangini,

thanks it is working

Regards,

Ajay