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

Maintain same customer number twice with different GUIDs

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.



Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2010 at 06:44 PM


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

    You can correct this as described below:


    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 .


    R/3 table that contains CRM product guid: NDBSMATG16


    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).




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


    Susana Messias

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.


      Soumya Sen