Remove Duplicate Record

[Former Member]

Hi

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

[former_member434229]

Hi,

Write the below statment before displaying the data display.

DELETE ADJACENT DUPLICATES FROM <itab> comparing MBLNR RDCO1.

Regards,

Ni3

[Former Member]

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

[Former Member]

Use the command "DELETE ADJACENT DUPLICATES FROM"

Regards

Vinod

[Former Member]

hi,

try like this.

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

this should help.

thanks

tanmaya