Skip to Content
0
Former Member
Dec 11, 2008 at 03:40 PM

Delete Duplicate entries in itab

16 Views

Dear Experts,

My code is Below. my requirement is all the work area fields are modify comparing matnr.

but i am use append duplicates entris allowed.only possible to modify.

loop at it_ekpo into wa_ekpo.

read table it_ekpo3 into wa_ekpo3 with key matnr = wa_ekpo-matnr.

if sy-subrc = 0.

wa_ekpo-matnr = wa_ekpo3-matnr.

wa_ekpo-menge = wa_ekpo3-menge.---->count field

modify it_ekpo from wa_ekpo.

endif.

endloop.

sort it_ekpo.

DELETE adjacent DUPLICATES FROM it_ekpo comparing matnr.

(Duplicates entry is not working) so modify is changed.

reference: -


>it_ekpo in this way

ebeln matnr menge ecp

10 lo45 1 iiii

10 l045 1 uuy

10 lo77 1 hhj

13 li12. 1 jhjh [mainly i join one itab ibn it_ekpo]

reference------>it_ekpo3.

ebeln matnr menge

10 lo45 2

10 lo77 1

13 li12 1

my final output is --->it_ekpo in this way.

ebeln matnr menge ecp

10 lo45 2 iiii

10 lo77 1 hhj

13 li12. 1 jhjh

<removed_by_moderator>

regards,

raj.

Edited by: Julius Bussche on Dec 11, 2008 5:30 PM