Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Remove duplicats in bods4.1

Dear Experts

  I have a requirement that i want to delete duplicates in my template table

Ex:

MATNRLAST_DIRECT_COSTLINE_DISCOUNTPRICELOCATION_ORIGINAL
27394.518<Null>94.518AS
27341.61<Null>94.518INC
27341.61<Null><Null>INC
10025473304.688<Null>3304.688AS
10025471485.23<Null>3304.688INC
10025471485.23<Null>3464.74INC
10025473464.74<Null>3304.688PTE
100263916.67<Null>16.67AS
1002639829.25<Null>16.67INC
1002639829.25<Null>1141.45INC
10026391141.45<Null>16.67PTE

  Here the MATNR ( Material No) is duplicated many times. How to delete this data based on condition. I have tried in query transform distinct row. Its not working.

I am coming from ABAP background

In ABAP syntax

Delete adjacent duplicates from <TABLE NAME> comparing MATNR LOCATION_ORIGINAL


This statement simply gives correct result as

MATNRLAST_DIRECT_COSTLINE_DISCOUNTPRICELOCATION_ORIGINAL
27394.518<Null>94.518AS
10025473304.688<Null>3304.688AS
100263916.67<Null>16.67AS

How to achieve the same in BODS?

Kindly suggest in 1 or 2 steps.

Regards

Vijay Mukunthan

error.png (9929 B)
Not what you were looking for? View more on this topic or Ask a question