topic Re: delete duplicate entries in Application Development and Automation Discussions

delete duplicate entries

Former Member — Wed, 05 Sep 2007 10:12:13 GMT

Please go to the following website:-

http://help.sap.com/saphelp_nw04/helpdata/en/06/aafd54fc4011d195280000e8353423/content.htm

and please scroll down to find:-

Deleting Adjacent Duplicate Entries

To delete adjacent duplicate entries use the following statement:

DELETE ADJACENT DUPLICATE ENTRIES FROM <itab>

[COMPARING <f1> <f 2> ...

|ALL FIELDS].

Then please go to the last example where the code is written as :-

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS.

IS THIS CORRECT ?

Regards

abaper.learner

Re: delete duplicate entries

seshatalpasai_madala — Wed, 05 Sep 2007 10:15:34 GMT

Hi,

YES, there is no problem with the statement

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS

ENTRIES is wrongly mentioned in the syntax, its not part of the DELETE syntax.

Regards,

Sesh

Re: delete duplicate entries

varma_narayana — Wed, 05 Sep 2007 10:16:05 GMT

The Correct version is:

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS.

OR....

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING COL1.

the Otherone may be Mistake in SAP DOCu...

reward if Helpful

Re: delete duplicate entries

former_member404244 — Wed, 05 Sep 2007 10:16:08 GMT

Hi,

The statement DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS.

it is correct.

Regards,

Nagaraj

Re: delete duplicate entries

Former Member — Wed, 05 Sep 2007 10:20:09 GMT

Hi learner,

Deleting a sequence of lines

DO 101 TIMES.

DELETE TAB_DEST INDEX 450.

ENDDO.

DELETE TAB_DEST FROM 450 TO 550.

Deleting a set of lines

LOOP AT TAB_DEST

WHERE K = KVAL.

DELETE TAB_DEST.

ENDLOOP

DELETE TAB_DEST WHERE K = KVAL.

DELETE ADJACENT DUPLICATES

As with the ORDER BY clause it could be better to avoid using SELECT DISTINCT, if some of the fields are not part of an index. Instead use ABAP SORT + DELETE ADJACENT DUPLICATES on an internal table, to delete duplicate rows.

LOOP AT TAB1.

READ TABLE TAB2 INDEX SY-TABIX.

IF TAB1 <> TAB2.

TAB_DIFFERENT = 'X'. EXIT.

ENDIF.

ENDLOOP.

ENDIF.

IF TAB_DIFFERENT = SPACE. " ...

ENDIF.

IF TAB1[] = TAB2[]. " ...

ENDIF.

Regards,

Kumar.