Internal Table

[Former Member]

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.

[former_member195698]

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

regards

abhishek

[Former Member]

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.

[former_member195698]

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.

[JozsefSzikszai]

Jasmine,

the correct statement in this case is:

DELETE ADJACENT DUPLICATES FROM itab.

you don't need COMPARING...

ec

[former_member386202]

Hi,

Do like this

sort itab by name age sex

DELETE ADJACENT DUPLICATES FROM itab COMPARING name age sex.

Regards,

Prashant

[former_member188829]

Hi,

Sort Itab By Name.

Delete adjacent duplicates From itab Comparing Name.

[Former Member]

Hi

delete adjacent duplicates from itab comparing names.

Or delete adjacent duplicates from itab comparing all fields.

Regs

Manas

[Former Member]

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.

[Former Member]

use

sort itab by name age sex.

delete adjacent duplicates from itab comparing all fields.

it will work...

Regards

vasu

[Former Member]

Thanks