on 05-22-2015 6:19 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.