cancel
Showing results for 
Search instead for 
Did you mean: 

Error while deleting Hierarchies through TCode - comm_hierarchy

0 Kudos

Hi there,

We are trying to import the Product Mater data from SAp R/3 4.7 to mySAPCRM 4.0.

The CRM system already has product master data (hierarchies, categories and products) from old logical R/3 system. So We have directly deleted all the categories in the master table COMM_CATEGORY using TCOde SE14 (have not deleted the products prior to that).

Now if we try to delete a Hierarchy thru the TCODE COMM_HIERARCHY, it thows an error message "Hierarchy still conatins categories".

Any idea, how we could correct this.

Thanks,

Ramya.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Ramya, I do think we have a little problem here. First of all never delete any from the database, period. This causes in many (if not all) cases inconsistencies. First question I have, do you have a back-up from before you initiated this deletion? If so, please restore.

Second question in order to be able to upload this hierarchy information you must ensure the corresponding number ranges in the old R/3 system and the new R/3 system do not overlap. Only in this situation you can load the new hierarchy in the CRM environment.

If there is an overlap, create a separate number range in CRM starting where the number range in the old R/3 system ends. In the replicating object add a filter to only load the hierarchies that do match this newly created number range. This will at least enable you to partially load hierarchy info from the new SAP system.

Hope this helps, Tiest

0 Kudos

Hi Tiest,

Thanks for the helpful reply. Will you please tell us where we could find and change the Number ranges of Hierarchy Infromation in CRM.

We do know about the numbering schemes that are present in the strcuture PRODHS in R/3 which correspond to CRM--> masterData --> Products --> Product Category --> Define Category Numbering scheme.But i think this is not what you are mentioning.

Thanks and regards,

Ramya.

Former Member
0 Kudos

Ramya, key number range is the material number range. The product hierarchies consist for several combined products and you want to ensure any material numbers coming over from R/3 do not already exist in CRM. The following IMG in CRM should be compared to the R/3 range: Customer Relationship Management ->ƒnMaster Data -> Product -> Settings for Product Type -> Number Assignment -> Define Number Ranges for Materials.

Create a range that is currently available within the R/3 range and only replicate materials within this range. Next is the item category definitions, etc. Hope this solves your problem, Tiest.