cancel
Showing results for 
Search instead for 
Did you mean: 

Uploading files in SAP removing duplicates

aayushaggarwal
Participant
0 Kudos

Hi Experts,

Please give me some advise on the methods that i can use to upload files in SAP, say i am using LSMW then how can remove duplicate entries from there ????

Regards,

Aayush

Accepted Solutions (0)

Answers (1)

Answers (1)

yakcinar
Active Contributor
0 Kudos

Hello Aayush,

Why don't you try eliminating duplicates before uploading.

Excel has removing duplicate values in DATA tab. You can use it.

And If there is unique key  constraints on the table which you import data, it prevent inserting duplicates.

Regards,

Yuksel AKCINAR

aayushaggarwal
Participant
0 Kudos

Hi Yuksel,

Can you please elaborate......

By duplicate records, i meant the records which are already stored in SAP.

So, if excel contain some of those records, then i want to filter those.

To put the data in SAP cleanly.

Regards,

Aayush

yakcinar
Active Contributor
0 Kudos

Hello Aayush,

I didnot understand that some of the records are already in SAP.

I know that when you are importing with LSMW process is stopped whenever there is an error. (Like duplicate record)

If you want to continue without stop you need to write ABAP with BASIs etc.

If number of records are not so high you can dump key fields to excel and eliminate duplicates using VLOOKUP functions, etc.

Regards,

Yuksel AKCINAR