Deleting Duplicate Customers

[Former Member]

Dear Gurus,

When uploading my master data, I have realised that I had 2/3 duplicate customers. I loaded them without a STDC number or VAT number as this will be done at a later stage.

I also want to cancel 3/4 test-dummy customers I created to have a clean data base.

Can anyone explain to me how I should cancel those customers please?

Your help is greatly appreciated.

Merci

Chris.

[Former Member · Accepted solution]

Dear Chris,

if you have to delete only some customers then you can do it manually by going to XD06 and mark them for deletion....

And if you want to delete them permanently then use OBR2.....

Thanks,

Raja

[aramsum]

Hi Chris,

You can not delete the customers physically If the Company code in which you have created this customers is productive. To delete these customers permanently you have to use se16n and delete the entry permanently from the databse. If the company code is not productive ,you can delete the customer's SALES AREA DATA using OV52 and IF you company code is not set productive, then you can delete the general data aswell. The ideal option would be to use "XD06" or If you want to delete the customer permanently , use the transaction "SE16N" and give the table "KNA1" and delete your customer. But this is not advisable.

Regards

Ram Pedarla

[former_member184555]

Hi

You can also use the Tcode OV52 to permanently delete the customers.

Thanks,

Ravi

[Former Member]

Hi ,

use the following T-codes ,

VD05 Block customer (sales)

VD06 Mark customer for deletion (sales)

XD06 Mark customer for deletion (centr.)

XD05 Block customer (centrally)

Please let me know if you still need any more help.

Thanks and regards,

Rajeshwar