Skip to Content

Are there standard options to identify obsolete customer master records?

Hi All!

In order to clean up master data, customers which don't have any documents and which are no longer required need to be identified so that the relevant deletion flags can be set. Does a standard program exist which can actually help with this identification?

I already tried various search terms here and elsewhere but depending on what I look for, I either get no hits at all or way too many.

While searching, I happened upon reports SAPV019 (SD) and SAPF019 (FI) but these are not an option as the very first sentence in the documentation makes quite clear:

The program deletes Financial Accounting master data and is defined as 
preparation for the productive start.

What I'd like to do, is to identify the obsolete customers, set the deletion flag(s) and then set up corresponding archiving jobs to physically remove the customer master data via standard processing.

I'm aware that my question is a bit fuzzy but that's because I'm not quite sure myself what all needs to be taken into consideration before a customer can actually be called "obsolete" (sales orders and financial documents being fairly obvious, but I'm certain that there are others I'm not yet aware of). So any pointers regarding this are also appreciated.

We are on Release 740, SP11

Thanks much for any feedback you have!

Cheers

Baerbel

P.S.: The tags most likely don't fit but I couldn't find any which were closer to my question

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 27, 2017 at 10:43 AM

    I would execute the write step from transaction SARA for object FI_ACCRECV in test mode with the option of complete log.

    this way you get the customer numbers that can be archived directly in the log, along with the reason for customers which cannot be archived.

    For performance reasons you might pre-select some customer numbers based on simple queries like customers which are used in sales documents, easiest via partner table VBPA. Download those customer numbers to Excel, and also download all customer numbers to Excel. Then do a VLOOKUP (in German: SVERWEIS) to determine those that are not found in the documents.

    Similar approach for the finance postings

    And finally take all those that are not found in either analysis to your SARA test run.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2017 at 11:13 AM

    There is transaction S_ALR_87012186 where a check box "Accounts w/o sales" which you can make use of it and execute.

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks, G Lakshmipathi! I just ran the transaction and from the looks of it, we'd need to run it with specifying several years separately and then only consider those customers for "deletion" / archiving which show up with a sales-amount of zero in all of them. Might be a bit cumbersome but doable and certainly another option to explore.

      Cheers

      Baerbel

  • Feb 27, 2017 at 02:39 PM

    Hi,

    I'd say that the programs you mentioned are the most effective way, amongst standard tools, to check the usage of master data.

    Regards,

    Eli

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2017 at 03:24 PM

    You can copy the program RFDUML00, build the required logic and schedule it in background

    Add comment
    10|10000 characters needed characters exceeded

    • Direct messages currently are given only for moderators. But, in any case, feel free to ask a question on the forum; the more participants we'd have, the better our community would be.