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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Adjacent Duplicates from intrenal table

Former Member

‎10-05-2007 7:49 PM

0 Kudos

Hi Friends,

what is mean by Adjacent Duplicates from intrenal table..

can anyone .. give me sample code for this .

regards,

venu

2 REPLIES 2

Former Member

‎10-05-2007 7:53 PM

0 Kudos

It's the method of getting rid of duplicate entries from an internal table. Press F1 on DELETE.

Rob

Former Member

‎10-05-2007 7:54 PM

0 Kudos

Hi

Sometimes duplicate records are get populated into internal table with same data in all fields or with most of the fields

So we don't want that similar records in the internal table which is data redundancy

so we SORT that internal table by the fey fields

and use the command

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING F1 F2 F3...

this will remove the other similar records keeping a unique record in ITAB

Regards

Anji