Initial load for Object CUSTOMER_MAIN

[Former Member]

Hi,

My client has taken their initial load more than year back. During that time some 900 odd customers where not copied to CRM from ECC because of various master data issues. Now, they have entry of Business Partner in table crmm_but_custno however none of them are actually downloaded from ECC.

We have given requirement to download them again from ECC and create them in CRM. For the same I tried to download them using CRMM_BUPA_MAP but due to the fact those customers has been part of initial load the system is taking delta load for them.

Here, I am facing error Business partner with GUID xxx does not exist (this error would come because system in taking delta load with update indicator 'U' which should come as 'I' for insert as those customer are not created yet!)

The main issue here is even in synchronization or initial load if we download the customer back which were part of initial load system would take only delta values and not all data from ECC.

Does any one has any suggestion how to download data with full details in them as they would come in initial load in this case?

I have already attempted following option:

1. Used initial load again

2. Synchronization with request using Tcode R3AR2/R3AR4/CRMM_BUPA_MAP

Thanks,

Alok Mehta

[Former Member · Accepted solution]

Hi,

first try to clear absent entries in the table crmm_but_custno.

then synchronize with request using Tcode R3AR2/R3AR4

Denis

[Former Member · Accepted solution]

Hi Denis,

Thanks for the reply. However, SAP system picks delta load even if you remove table entries from crmm_but_custno. As the updat flag 'U' comes from ECC. The system must be checking for some reference table in ECC itself.

Here, I have also tried to manipulate change table entries of CDHDR but could not found any solution.

Regards,

Alok Mehta

[Former Member · Accepted solution]

Hi Alok,

you need to do the request load using R3AR2 only. request loads work like initial loads only with 'I' only difference is that there you provide the filter to get the selected data only. create the request object for adapter object CUSTOMER_MAIN and set the filter the on table KNA1 and field KUNNR. just make sure, before you start the download in R3AR4, that master data is corrected in ECC for that customer which you are entering in request in R3AR2 and CRM customizing donwload is in sync with R/3. after this just start the request load and check the bdoc in SMW01. it should get processed and your BP will be downloaded.

Thanks

Sudhir Grover

[Former Member · Accepted solution]

Hi Sudhir,

Thanks for the answer. I tried the same but I am getting following error in BDOC analysis:

Customer number xxx is already assigned to a business partner.

The above error is coming because this customer was part of initial load however the BDOCs were in error mode and no one had tried to reprocess them after clearing errors.

Now, I do not have those BDOC as they are deleted from the system. I am suspecting that I need to delete some entry in table where the reference was stored in earlier initial run.

Request you to please reply in case you have any suggestions.

Thanks,

Alok

[Former Member · Accepted solution]

Hello,

CRMM_BUT_CUSTNO is the Mapping Table between Business Partner - Customer in CRM and CRMKUNNR is the table in ECC.

Issue here might be you allready have a key in those tables.

Kindly check OSS Notes 609766 and 522676. They should help you resolving the mismatch between CRMKUNNR table of ECC and u2018CRMM_BUT_CUSTNOu2019 table of CRM and BUT* tables.

Hope this helps!

Regards,

Dinesh.

[Former Member · Accepted solution]

Hi Dinesh,

We have already implemented note 609766 and there is no mismatch of GUID between any of the tables. As I am facing this issue in CUSTOMER_MAIN upload itself I am not sure the other note would be helpful.

Thanks,

Alok

[Former Member · Accepted solution]

Hello Alok,

you have 900 customers to download. go to CRMKUNNR table in ECC and see if it has GUIDs.

If it has, then see if you have any other entries in the CRM system in table *CUST_NO.

if you have then check if its refering to the same BP.. it should not coz this BP is never there in the system..

Kindly let me know your findings..

Thanks and regards,

Dinesh.

[Former Member · Accepted solution]

Hi Dinesh,

Thanks for taking interest in my issue.

I have randomly checked the same with 15 customers and I do have there entries similar in CRM and ECC tables. As the customer were already part of initial load and due to master data or customizing issues BDOCs were not processed correctly.

Regards,

Alok

[Former Member · Accepted solution]

Hello Alok,

you should not have the entries in table for these 900 in CRM tables.

if you have it in CRM BUT000: please check GUIDs are in synch between BUT000 and CRMM_BUT_CUSTNO.

If you only have the entries in CRMM_BUT_CUSTNO not in BUT000, delete them and download again.

Hope it helps!

BR,

Dinesh.