topic Re: Internal Table in Application Development and Automation Discussions

Internal Table

Former Member — Tue, 27 Nov 2007 13:08:57 GMT

Hi Experts,

My Internal table has the following structure and data's.

Name age Sex

B 20 MALE

A 22 MALE

B 20 MALE

C 28 MALE

I want to delete the duplicate entries (B) fro my internal table.

Any body help me on this issue.

Thanks,

Points Assured.

Re: Internal Table

former_member195698 — Tue, 27 Nov 2007 13:10:01 GMT

sort the table and use <b>delete adjacent duplicates comparing all fields</b>

regards

abhishek

Re: Internal Table

former_member386202 — Tue, 27 Nov 2007 13:10:38 GMT

Hi,

Do like this

sort itab by name age sex

DELETE ADJACENT DUPLICATES FROM itab COMPARING name age sex.

Regards,

Prashant

Re: Internal Table

former_member188829 — Tue, 27 Nov 2007 13:10:45 GMT

Hi,

Sort Itab By Name.

Delete adjacent duplicates From itab Comparing Name.

Re: Internal Table

Former Member — Tue, 27 Nov 2007 13:20:39 GMT

Hi,

I tried with delete adjacent duplicates comparing all fields.

But its not delete the dupplicate entries.

The think is I used this code in Class[se24].

Thanks.

Re: Internal Table

former_member195698 — Tue, 27 Nov 2007 13:31:15 GMT

Its possible in Classes also. I tried it in a method of a class.

sort INTERNALTABLE.

delete adjacent duplicates from INTERNALTABLE comparing all fields.

Check in debug whether your data is coming sorted properly before the DELETE statement and also whether there are really any duplicate entries comparing all the fields in the table.

Re: Internal Table

JozsefSzikszai — Tue, 27 Nov 2007 13:39:41 GMT

Jasmine,

the correct statement in this case is:

DELETE ADJACENT DUPLICATES FROM itab.

you don't need COMPARING...

Re: Internal Table

Former Member — Tue, 27 Nov 2007 13:41:40 GMT

delete adjacent duplicates from itab comparing names.

Or delete adjacent duplicates from itab comparing all fields.

Regs

Manas

Re: Internal Table

Former Member — Tue, 27 Nov 2007 13:42:57 GMT

Hi Experts,

Thanks for the replies.

My Internal table has the following,

Name age Sex

B 20 MALE

A 22 MALE

B 20 MALE

C 28 MALE

I need to outout as,

Name age Sex

B 20 MALE

A 22 MALE

C 28 MALE

So for this ouput I couldn't use Delete adjacent Duplicate.

My WA has,

Name age Sex

B 20 MALE

How can I do that?

Thanks.

Re: Internal Table

Former Member — Tue, 27 Nov 2007 13:45:09 GMT

use

sort itab by name age sex.

delete adjacent duplicates from itab comparing all fields.

it will work...

Regards

vasu

Re: Internal Table

Former Member — Tue, 27 Nov 2007 16:23:51 GMT

Thanks