Error in Download R3AI_DNL_CUST_PROD1

[Former Member]

Hi All,

        We have referred the best practice document to build our CRM 7.0 system and while setting up the middleware we had set up the number scheme for R3PRODHIER as per the guidelines. We had created 3 levels and with number of characters 5, 5, 8 respectively. Then we had downloaded all required customizing adapters from ERP which included product categories (DNL_CUST_PROD1).

But now as part of a bespoke development, the product hierarchy structure (PRODHS) has been changed to have 4 levels with the number of characters 2,5,5,8 respectively. So I need to download the hierarchy again. However when I try to change the number scheme in CRM, I get the error that the Number scheme is already assigned to a hierarchy and cannot be changed.

The concern here is we have few categories in the system which is as per the 5,5,8 number scheme and also we have created transactions using those products. So is there any way of updating the number scheme in CRM so that we could do a product hierarchy download? Currently it is failing when it tries to download level 4 entries from ERP.

Did anyone else has faced similar issues in past and worked out a way to fix it ? Please let me know if you have suggestions.

Regards.

[former_member189549 · Accepted solution]

Hello Harish,

This error message suggest that number scheme customizing has not been maintained in your CRM system.  Please check the following customizing in your system

> IMG
> Cross Application Components
  > SAP Product
   > Product Category
    > Define Category Numbering Schemes  (transaction COMMPR05)

1. In the R/3 system analayse the structure of the product hierarchy,  by viewing the structure PRODHS with transaction SE11. The field  lengths of the fields in the structure PRODHS define the number of hierarchy levels.  Please check this structure in your OLTP system and see if you have SAP standard number of levels.  The SAP standard is 5-5-8.

2. This scheme must also be maintained in CRM. Please call transaction  COMMPR05 and create a numbering scheme called R3PRODHIER. You need to define number of levels exactly the same as in R/3. (Level 1 = 5, Level 2 = 5 and    Level 3 = 8). Save your entries. The number of levels and the number of digits for each level must be.

3. Carry out the initial download of customizing object DNL_CUST_PROD1 again.

Please also check that there are no incosistency between the value of the SCHEME_GUID field for hierarchy R3PRODHIER in tables COMM_HIERARCHY and COMC_SCHEME (these are both CRM tbales). These values must be equal.

If they are not, you can delete the hierarchy by running report comm_hierarchy_delete_single; afterwards, it should be possible to download the object.

Thanks

Willie