Skip to Content
author's profile photo Former Member
Former Member

Deleting Customers

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2013 at 01:10 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • Posted on Jun 28, 2013 at 11:02 AM

    Dear,

    Please can someone explain the best way to do this or if it's better just to leave them as flagged for deletion?

    My opinion is SARA is best thing to do this .

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2013 at 11:16 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2013 at 11:35 AM

    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$

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2013 at 06:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2013 at 11:03 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2013 at 05:35 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.