cancel
Showing results for 
Search instead for 
Did you mean: 

Maintain same customer number twice with different GUIDs

Former Member
0 Kudos

Recently, R3 refreshed, but CRM not. After refresh R3 is having few customer & product numbers, which were same as earlier. That means those customers & products already exist in CRM. I run initial load for customizing & master data from R3 to CRM.

Now, I can see existing product number can be downloaded from R3 & result is same product number present twice in CRM with different GUIDs.

For customer, I am not able to download existing customer number via initial load. I am getting mapping error & error description - "Customer number EKC3137 is already assigned to a business partner". Delta load also failed for same customer with error - "Business partner with GUID 15ECAD322FDA074BB8B125DEDB4194DB does not exist". I checked & found existing entry in CRM is having different GUID for this customer.

Can anyone suggest how to download this customer with new GUID, keeping same customer with different GUID. This means expected result is same customer number maintained twice with two different GUIDs. Definitely old customer can not be updated from R3, but new one can be updated in future.

Regards,

Soumya

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi.

Everytime you do a not simultaneous client copy you will get this inconsistencies on middleware data.

You can correct this as described below:

CUSTOMERS:

Apply note 609766 in order to create a report that will correct the customers Guids on tables: R/3: CRMKUNNR and CRM: CRMM_BUT_CUSTNO .

MATERIAL:

R/3 table that contains CRM product guid: NDBSMATG16

CRM table: COMM_PRODUCT

SAP recomends to delete all products and replicate them again: COM_PRODUCT_DELETE_SINGLE

Possible problem if you also have price condition tables on CRM (the product Guids will be the old ones so yoiu will have to download all pricing data again).

CONTACT PERSONS:

R/3: CRMPARNR

CRM: CRMM_BUT_CONTNO

Apply note 703322 and run report Z_OSS_000400_2004 on R/3 and corrects the inconsistencies.

Regards.

Susana Messias

Former Member
0 Kudos

Hi Susana,

Many thanks for your reply.

However, our requirement is little different. We want to keep old GUID for customers. Additionally, we want to download same customers with new GUID. This is test environment & we want old data for testing purpose.

Regards,

Soumya Sen