Common Errors of downloading customer material from ERP Using CRM middleware Middleware

Use the transaction code vd51 and vd52 to create and modify the customer material.
The material I created in ERP maintains a customer material AOP for it.

After downloading to CRM, The WebClient UI displays the following:

Download the main configuration of customer material:

• 1. Specify the customer ID to be downloaded through the kunnr field in the table knmt:

• 2. Download material 1427 of ERP to CRM first

Common Errors

• 1. Error message number not in interval XXX-xxx When downloading a customer from ERP
     

This error is an attempt to download the customer number 3471 from ERP.
Error message:

Why is the interval mentioned in the error message 0000300000-0000399999?
When the ERP customer is downloaded to CRM, a corresponding business partner instance is created.
In this example, we learned through debugging that the partner group used for creating a business partner in CRM is 0002:

Check that the number range of 0002 is set to 07:

The interval corresponding to 07 is the range mentioned in the error message:

Solution: change the number range of 0002 to 03.

• 2. Error message form of address 0001 not designated for Organization
     

By debugging crm_bupa_main_val, the error message is thrown in row 34th:

Although this customer instance is determined to be a organization (because the Category field is 2), the person field is set to a bit instead of the organizatn field, so this error message is displayed.

Solution:

In the ERP transaction code sm30, open view v_tsad3 and Mark 0003 as organization:

Then, change the title of customer 3471 from MS to company:

Then the download is successful.

• 3. Customer classification 06 does not exist
     
     Debugging shows that the error message is thrown from row 22nd, because the corresponding configuration item cannot be found in the crmc_classif table:

You can maintain this configuration table in define customer class:

In my system, there is no configuration item for this classification.

First, we need to figure out where the 06 in the Code comes from?

Set a breakpoint in bapi_crm_save, download the content of the variable bapistructures In the debugger to a local device, open it in Excel, search for the keyword 06, and find that 06 appears in the structure bss_s040:

Then use "where used list" for this structure to find that the data of classification comes from Kukla.

Classification is maintained in the marketing item on the ERP Customer maintenance interface:

Maintenance in define customer classification:

Solution: either maintain the classification corresponding to 06 in CRM as shown in, or set the field corresponding to ERP to null.

• 4. Tax Number category does not exist
     

Error message: Because the us5 configuration item is not found in the table tfktaxnumtype, the error message is displayed on line 32nd:

The next step is to figure out why us5 is queried. Through debugging, we found that both us5 and Jerry were transferred from ERP:

Solution: either maintain the corresponding tax category for us5 in CRM or clear the ERP tax number 5 field.

• 5. Distribution channel is not allowed for sales organization
     
     Debugging finds that the error message is thrown in crm_pr_sales_check_distr_chain because no matching item is found for CRM sales organization o 50040102 and distribution chain 01.
     

The error message is throw in row 71st:

When I checked the st_distr_chains table, I found that O 50040102 only has a combination of Channel 10, but it lacks a combination of 01.

Solution: Use the transaction code ppoma_crm to add the missing distribution channel 01 combination and all Division 00, 01, and 07:

Then run hrbci_attributes_buffer_update to update the crmd_orgman_temp table:

Make sure that the cache table shows the combination of the distribution channel and division of the expected o 50040102. The error message is resolved.

• 6. Parent not o. K.: bupa_main
     

Cause: cust_mat_info has three parent download objects.

If one of the three objects fails to be downloaded, you cannot download cust_mat_info. Technically, the dnl_status column of the three parent objects in the corresponding record of the table smofdstat must be the content D-done.
In my example, the status of the material object is a-aborted. Therefore, you must first fix the material download error.

• 7. Sales area is not assigned for the header Product

The error is thrown in CRM's com_il_prdscp_check:

Because this product is downloaded from ERP, we cannot manually maintain the distribution chain on the CRM side:

Go back to ERP and check mvke and find that sales organization 0001 and channel 01 have been correctly maintained on this product.

Go back to CRM and check whether the sales organization of ERP and channel combination 0001-01 maintain a ing relationship on the CRM end. After I use the transaction code ppoma_crm to maintain the missing ing relationship,

Re-download:

Then, you can view the successfully downloaded sales area content on the crm ui.

For more original Jerry technical articles, follow the Public Account "Wang zixi" or scan the following QR code:

Common Errors of downloading customer material from ERP Using CRM middleware Middleware