topic Re: internal table process in Application Development and Automation Discussions

internal table process

Former Member — Thu, 10 May 2007 10:03:28 GMT

Hi Experts,

Please give me the logic for the given below scenario

I-Table

A B

1 a

1 b

1 c

2 d

3 a

3 e

3 f

4 g

In the above itab , itab have lot of records (1000000). i want to display what are all having multiple values only in column A.i want to delete single records (like 2 d(4th row)this row will be delete ) if column A and column B having same value i want to delete that rows.

Thanks & Regards,

Rajan

Message was edited by:

raja rajan

Re: internal table process

Former Member — Thu, 10 May 2007 10:05:45 GMT

hi Raja,

use ...

delete table <internal table> where sno = ...

Regards,

Jayant

Re: internal table process

suresh_datti — Thu, 10 May 2007 10:05:58 GMT

sort itab by Sno.

delete itab index 4.

delete itab index 8.

delete itab index 9.

~Suresh

Re: internal table process

Former Member — Thu, 10 May 2007 10:07:42 GMT

Hi Raja,

Looks to be a pretty strange one.

In the records 4,8 & 9 the key is the no. field of value 2. They are all multiples of 2.

4th record - 2

8th record - 4

9th record - 4

so you can delete based on this logic, multiples of 2.

Tushar

Re: internal table process

Former Member — Thu, 10 May 2007 10:08:24 GMT

Hi Raja....

if you are taking about the particular tab then you can hard code the value for

sy-tabix...

delete <internal table name> where sy-tabix = '<hard code the tab>'.

in this case no matter what the record is ..always that particular row will be deleted...

Regards,

Jayant

Re: internal table process

Former Member — Thu, 10 May 2007 10:09:37 GMT

hi,

delete itab where sno = '4' and sno = '8' and sno =' 9'.

Re: internal table process

Former Member — Thu, 10 May 2007 10:10:14 GMT

Hi Raja,

Refer this code :

loop at itab.

delete itab where sy-tabix = 4.

delete itab where sy-tabix = 8.

delete itab where sy-tabix = 9.

endloop.

Reward points if helpful.

Regards,

Hemant

Re: internal table process

Former Member — Thu, 10 May 2007 10:13:31 GMT

Hi,

If you want to directly delete the records corresponding Sr no

delete itab where num eq 4 or num eq 8 or num eq 9.

Thanks

Sandeep

Re: internal table process

Former Member — Thu, 10 May 2007 12:38:14 GMT

hi try this.

loop at itab.

do sy-tfill times.

if itab-a = itab-b.

delete itab index sy-tabix.

endif.

enddo.

endloop.

the above deletes the fiels of equal values.

take 2 fields m and n.

m = 1.

loop at itab.

do sy-tfill times.

if m <> itab-a.

m = itab-a.

skip.

read table itab index sy-index.

if itab-a <> m.

delete itab index sy-index.

endif.

enddo.

endloop.

this should remove the single values.

check it n let me kno if this works.

regards,

ramesh.