delete duplicate adjacent duplictes

[Former Member]

Hi,

Plz clarify my doubt

what is the diffeence between delete and delete adjacent duplicates

Regards

Haritha

[Former Member]

Hi,

Search the SCN before posting the Basic questions.

[Former Member]

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

[Former Member]

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..

[Former Member]

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

[Former Member]

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

[Former Member]

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...