Upload Hierarchy and Product Categories from CSV file

[Former Member]

Hi SRM Gurus,

My requirement is to upload Hierarchy and Product Categories from CSV file into SRM 5.5.

Working on Standalone Scenario.

manually we do it in Comm_hierarchy transaction.

My question now is :

how to upload Hierarchy and product categories (say some 5000 records) into SRM .

In SRM 5.5 Standalone Scenario, is there any std program available?

will BDC work in this circumstances.

i need some help in this regard. Points will be rewarded. Plz help.

[Former Member]

Hi

<b>Which SRM version are you using ?</b>

<u>Please check SAP OSS Note 1024002</u>

<u><i>Please go through this -></i></u>

Use this program to delete the product categories COM_HIERARCHY_DELETE_ALL.

After executing this program execute the transaction COMM_PROD_RECATEG to re categorize your products which were created by the deleted product catehory.

After deleting the product category run this transaction `comm_del_prwb_user; to reset the user attributes.

<b>Related Links -></b>

<u>Other useful pointers -></u>

Hope this will help. Do let me know.

Regards

- Atul

[Former Member]

Hi

<u>Use Transaction COMM_HIERARCHY in SRM system to create Product Categories.</u>

<u><b>Uploading product categories through the middleware is done using the transaction code - R3AS and object DNL_CUST_PROD1 for this. Please sell all the settings in SRM as well as R/3 as per SAP OSS Note no: 720819.</b></u>

<u><i>Please go through this -></i></u>

When replicating categories from R/3, the system creates 2 hierarchies:

- R3MATCLASS assigned to purchasing application

- R3PRODTYP assigned to product application

When creating R3PRODTYP, predefined set types (description, UOM, purchasing...) are assigned to this hierarchy.

Also, a sub node MAT_ is defined as MATERIAL and a sub node SERV_ is defined as SERVICE.

If you don't replicate categories from R/3 but create them locally, you must do the same as the sdt:

- assign a hierarchy to purchasing & product applications (can be the same one)

- in the hierarchy assigned to the product application, you must have a sub node defined with family type MATERIAL to be able to create some MATERIAL products (same for services)

- in the hierarchy assigned to the product application, you must assigned predifined set types (descriptions and so on)

<b>Related Links -></b>

Hope this will help. Do let me know.

Regards

- Atul

[Former Member]

I am working on Standalone Scenario. SRM 5.5 SP10.

how do i get the product categories say some 5000 records given in CSV file into SRM 5.5. they want a auto upload program from csv to SRM 5.5 Standalone.

Urgent plz. since no SAP Backend. how do i do it? can i use a BDC or any standard uploading is possible. i came across one badi bbp_prodcat_hier does it help me..... Help in this regard will be highly appriceated.

[Former Member]

Hi Lokesh,

Were you able to upload the prod categories thorugh the flat file??We are having the same issue.

Regards,

SRM tech