topic Re: delete duplicate adjacent duplictes in Application Development and Automation Discussions

delete duplicate adjacent duplictes

Former Member — Fri, 15 May 2009 06:24:39 GMT

Hi,

Plz clarify my doubt

what is the diffeence between delete and delete adjacent duplicates

Regards

Haritha

Re: delete duplicate adjacent duplictes

Former Member — Fri, 15 May 2009 06:26:32 GMT

Hi,

Search the SCN before posting the Basic questions.

Re: delete duplicate adjacent duplictes

Former Member — Fri, 15 May 2009 06:27:04 GMT

hi ,

Delete is used to delete all records or based on the conditions specified conditions.

Delete adjacent duplicates only delete the duplicated documents .

The search is based on the duplicate entries of the prinmary key values.

Before using delete adjacent need to sort the Internal Table

Thanks,

Vamshi

Re: delete duplicate adjacent duplictes

Former Member — Fri, 15 May 2009 06:28:32 GMT

1) Delete is used to delete any record as per given where condition.

2) Delete adjacent is used to delete similar records found after sorting the internal table.

Delete adjacent can b used to delete records by comparing one or more fields too..

Re: delete duplicate adjacent duplictes

Former Member — Fri, 15 May 2009 06:50:22 GMT

Hi,

Delete is used to delete the records.

Delete adjacent duplicates come into picture when a table contains duplicate entries.

If duplicate entries are available in a table, to delete them sort the table with the field and delete them with the

Delete adjacent duplicates.

Hope this helps you.

Regards,

Rajani

Re: delete duplicate adjacent duplictes

Former Member — Fri, 15 May 2009 10:38:38 GMT

Hi,

Difference between Delete and Adjacent Duplicates:

Delete is used to delete data from the internal table based on particular condition.

Delete adjacent duplicates is used to delete duplicate entries from the internal table.

For Example:

ITAB-FIELD1 ITAB-FIELD2 ITAB-FIELD3

ABCS 10 2

EFGH 10 1

Delete ITAB WHERE FIELD3 = '1'.

After this:

ITAB-FIELD1 ITAB-FIELD2 ITAB-FIELD3

ABCS 10 2

Delete adjacent duplicates comparing FIELD2.

ITAB-FIELD1 ITAB-FIELD2 ITAB-FIELD3

ABCS 10 2

Hope this answer your question.

Regards,

Prashant Gaikwad

Re: delete duplicate adjacent duplictes

Former Member — Fri, 15 May 2009 12:20:47 GMT

hi,

let itab be fname fkey

a 1

b 2

a 1

delete itab from wa_itab .. this will delete itab line by line .

delete adjacent duplicates : a 1

b 2

now duplicates entries are deleted...