Initial load of customers from ECC to CRM when some of the customers are already existing in CRM

[Former Member]

Hi Experts,

We have a SAP CRM 7.0 landscpe integrated with ECC 6.0. We need to download the customers for a particular sales area from ECC to CRM.

In our scenario, some of the customers in the particular sales area are already present in CRM. So, when we try to do an initial load of the customers by setting appropriate filters, the queues get stuck when the already existing customer is getting downloaded to CRM.

My question is, what is the standard system behaviour while doing the initial load? Does it overwrite the existing data or it throws an error for existing data? Is there any way to by-pass the existing customers while doing the initial load?

e.g. Customers in ECC numbering from 1 to 100. Customer existing in CRM are numbered, say, 11, 18, 26, 78 and 92. So while doing the initial load for these 100 customers, the queue gets stuck at customer no. 11. Is this a standard behaviour? Is there any way to by-pass these existing customers?

Thanks and regards,

Mahesh Kakani

[Former Member]

Mahesh,

Customer already exist in CRM than if you do initial load it will only update existing customer.

and if customer is not present than initial load will create new customer

you can run request load

In Tcode R3AR3 Define Requests

Adapter Object CUSTOMER_MAIN

table KNA1 field name KUNNR  EQ  0000000XX (10 Digits)

In Tcode R3AR4 Start Requests

In Tcode R3AR3 Monitor Requests

Regards,

Vaibhav Shah

[Former Member]

Hi Vaibhav,

Thanks for your reply. But in our case, the initial load is not updating the existing customer. It's showing a mapping error that the number XXXXX is already mapped to a business partner. Am I missing something?

As an alternative i have downloaded the customers using request load as mentioned by you above. But need to know the issue with initial download as request load will not be advisable in production box.

Thanks and regards,

Mahesh Kakani

[Former Member]

Hi,

perhaps, have you created those codes manually in the CRM? If you haven't created any sales transactions you might remove those codes from CRM and then upload them again.

I also suggest you to through this thread:

http://scn.sap.com/thread/1963402

Actually compare the guid in ECC (CRMKUNNR) with the GUID in CRM (BUT000) for the customers with problems.

Regards,

Mauro

[Former Member]

Mahesh,

1) can you please run request load for problem customers and copy error and message no. from smw01

2)  request load you can do in production also we did not faced any issue with request load. initial load is one time activity but request load you can run n no of times

Note 1388057 - SAP BP: Create BP with existing GUID-wrong message displayed

Regards,

Vaibhav Shah