R/3 and CRM Business Partners no longer match

[paul_bakker2]

Hi,

Apologies if this is not the right forum. We have an R/3 system, and CRM system.

The R/3 system is the 'source of truth' for our business partner data. Updates are sent to CRM via BUPA_MAIN Bdocs.

We discovered recently that some Bdocs failed a couple of years ago, and now the BP data in R/3 and CRM is not properly synchronized. Also, some of the old Bdocs have been deleted.

I'm wondering what the best course of action is?

1. find all BPs that are different, and overwrite their CRM version with the (latest) R/3 version

2. simply copy all BPs from R/3 to CRM

3. Go through all unprocessed BDocs and update the CRM BPs manually.

To me, option 1. seems the best. But how do you find all differences between BPs, and how do you copy BP master data from one system to another?

I think this would be a common requirement. Is there a SAP standard program for doing this?

thanks

Paul

[former_member184701 · Accepted solution]

dear friend,

first,

to try re-process all unprocessed BDocs in CRM (SMW01)

second,

i would recommend to run PIDE in R/3 and check out the current account groups/settings

third,

from technical point of view you are able to find out the difference between BPs - extract relevant records from standard tables into Excel and do comparison there. work with techical guy/abaper if you need

and the last,

to think about how to keep CRM customer master data consistent

that might be everyday BDocs analysis and customer master data keeping (deletion of duplicates, for example)...

good luck!

[paul_bakker2 · Accepted solution]

Hi,

Thanks for the thoughtful responses. My plan of action is now this:

(1) Retry all Bdocs with errors (we already have a program that does this, so there's not much point)

(2) Extract a list of all BPs with 'stuck' BUPA_MAIN bdocs - there are about 1800 of these BPs

(3) Use R3AR2 and R3AR4 to update these BPs from R/3

(4) Delete all existing BUPA_MAIN Bdocs that are in error.

We will then monitor the BUPA_MAIN bdocs carefully and update any other BPs that appear int he error list.

My questions are:

- do I need to consider any other BDoc types (Like BUAG_MAIN), or can we look at BUPA_MAIN in isolation?

- what is the correct procedure for deleting BDocs?

thanks again!

Paul Bakker

[Former Member · Accepted solution]

Dear

Paultje,

(BUAG_MAIN) --- Contract acconts objects (Business Agreements), these are require in case of ISU implementation/Scenarios.

in your case i feel you should take BUPA_MAIN & BUPA_REL into consideration.

All the best.

Kind Regards,

Amit

[paul_bakker2]

I'm in the process of cleaning up the BP data, and it all seems to be going well. Thanks for all the answers.

The final step (deleting the old BDOCs) can be done through SMW01. The 'delete' button simply marks the BDOCs as complete, and (I'm told) they will be cleaned up by some regular housekeeping job.

[Former Member]

Hi,

I think you have to do these steps:

1. Delete old Bdocs

2. Restart initial load for Bupa_main.

Check first this on test system.

Or please use another way:

Use R3ar2, r3ar4, r3ar3 for request load of the part (10, 100, 1000... ) of the partners.

Denis

[paul_bakker2]

Denis,

Thanks for the fast reply.

I'm not sure what you mean by 'Restart initial load for BUPA_MAIN', but it sounds a bit scary (and unnecessary) to me. We have tens of thousands of BPs.

Your second option sounds better. I investigated R3AR2, as well as CRMM_BUPA_MAP. It seems you can use both of these to 'resynch' business partners between two systems.

But I'm not sure which one to use. When is CRMM_BUPA_MAP a better option, versus R3AR2?

Also, if I use this method, what do I do with the old BDocs that are in error? Is there a transaction for deleting them?

thanks!

Paul

[Former Member]

When downloading, the crmm_bupa_map will create a new request (r3ar2) to get customer data with BUPA_MAIN bdoc.

The difference, is that you can upload customers in crmm_bupa_map, and in r3ar2 you can't.

R3AR2 is only for downloading purposes ,but you are able to get more information (like relations with BUPA_REL bdoc)

this means bothe appraches are doing the same action.

So technically it makes no difference if i gather the bp from r/3 per request or per crmm_bupa_map. Everytime you gather BP information through CRMM_BUPA_MAP will create a new request for BUPA_MAIN bdoc. You'll see another entry at R3AR2.

kind regards,

Amit