on 06-28-2013 11:13 AM
Hi experts,
We have several thousand customers that were imported from our old system that we'd like to delete. Obviously we'll only try and delete customers that have never had any transactions.
This can be done via OV52/OBR2 and the business partners in BUPA_DEL. It it safe to do this? A few of the customers have customer contacts (table UDM_CCT_ATTR) so presumably it's worth not trying to delete those?
The other option seems to be backing them up in SARA and then deleting them in SARA.
Please can someone explain the best way to do this or if it's better just to leave them as flagged for deletion?
Kind regards
Dave
If a customer has not been included in a transaction, you can safely delete it from OV52. SARA takes more time, OV52 takes just seconds. It is completely safe, I used it on Live projects as well. No harm done.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What do you mean by customer contacts? Do you mean contact persons?
If that is so, using OB52 is surely safe. You do not have to use SARA for a customer which has not been used in a transaction. By a transaction, I mean a sales order or a sales activity or a material document. Invoices, deliveries are transactions too.
If you mean 'sales activities' by customer contact, well that changes everything. A sales activity is a transaction as well, so you cannot use OB52, you will have to use SARA.
I just tried to delete some customers, but as the company code is productive deletions are not possible. This has put a big spanner in the works as it's not feasible making the company code unproductive, i work for a very large company. Hope this helps someone else if they're thinking about doing it.
Dear Thomas,
Its recommended by SAP to block these customers and put mark for deletion or you can also use them for future use if arises.
Thanks,
Sumeet Sah
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dave,
Customer archiving is always best thing to do , as you can retrieve it whenever you require it. So i feel like you should go with SARA.
Thanks,
samba
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
If you are sure you dont need these customers anymore then go with SARA but I would reccomend you to block these customers and put mark for deletion or you can also use them for future use. When new customer needs to be open just change the details of this customer but for this make sure there should not be a single transactional data for this customer. Is depends on frequency and volume of your customers.
Thank$
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I suggest to go with SARA, as SARA will allow you to set deletion indicator for all the customer master tables including Address data which cannot be done using OV52
regards,
santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dave,
Please make sure that you have cleared all the open items for those customers before you do the operation of deletion.
Also the other way is to Block those customers for any transactions.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
My opinion is SARA is best thing to do this .
Thanks,
Naren
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.