Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Deleting redundant entries from a internal table

Former Member
0 Kudos

Hi folks,

Can you guys suggest be the best way for deleting redundant entries from a sorted internal table which has more than 100 fields for a single record.

Regards,

vivek

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hello Vivek,

You can use the statement.

Delete adjacent duplicate from itab comparing fields <field1> <field2> <field3> <field4>....

Comparing fields adition will only compare the duplicate entries in fields specified before deleting entries from your internal table.

Hope it helps.

Thanks,

Jayant

5 REPLIES 5

former_member156446
Active Contributor
0 Kudos

delete adjucent duplicate comparing fields F1 f2 F3 ....

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

Use

DELETE ADJACENT DUPLICATES FROM ITAB.

Regards,

Rich Heilman

Former Member
0 Kudos

Hi,

Use this

Delete adjacent duplicates from itab comparing f1 f2...

Regards,

Rohan.

Former Member
0 Kudos

Though answered, it didnt work out as the itab structure is a bit comlicated.

Former Member
0 Kudos

Hello Vivek,

You can use the statement.

Delete adjacent duplicate from itab comparing fields <field1> <field2> <field3> <field4>....

Comparing fields adition will only compare the duplicate entries in fields specified before deleting entries from your internal table.

Hope it helps.

Thanks,

Jayant