topic Re: Remove Duplicate Record in Application Development and Automation Discussions

Remove Duplicate Record

Former Member — Tue, 06 Apr 2010 14:32:15 GMT

Can any one help me please.My error is...

I was created a ALV report for RG1.On that report A single material doc. Have so many simialr Reference doc. I have to remove that duplicate Reference doc. How can i remove that duplicate reference doc.

Table name is : J_1IRG1

Material Doc(Field name) is: MBLNR

Reference Doc.(Field name) : RDCO1

Thanks

Laxmikanta

Re: Remove Duplicate Record

former_member434229 — Tue, 06 Apr 2010 15:58:31 GMT

Hi,

Write the below statment before displaying the data display.

DELETE ADJACENT DUPLICATES FROM <itab> comparing MBLNR RDCO1.

Regards,

Ni3

Re: Remove Duplicate Record

Former Member — Tue, 06 Apr 2010 18:05:21 GMT

Hi,

Yes you can use this statement DELETE ADJACENT DUPLICATES....as mentioned in the above reply, but before writing this statement you must SORT <itab> with the specified fields (fields which you will be using for deletion)

This will definitely work.

Asha

Re: Remove Duplicate Record

Former Member — Wed, 07 Apr 2010 05:08:43 GMT

Use the command "DELETE ADJACENT DUPLICATES FROM"

Regards

Vinod

Re: Remove Duplicate Record

Former Member — Wed, 07 Apr 2010 07:50:39 GMT

hi,

try like this.


sort itab by MBLNR RDCO1.
delete adjacent duplicates from itab comparing MBLNR RDCO1.

this should help.

thanks

tanmaya