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
Showing results for 
Search instead for 
Did you mean: 

Delete Duplicate entries in itab

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos


sort it_ekpo by matnr.

not



sort it_ekpo.

1 REPLY 1

Former Member
0 Kudos


sort it_ekpo by matnr.

not



sort it_ekpo.