Product Hierarchy from R/3 to BW

[Former Member]

Hi

I have a problem with product hierarchy in BW. First, i extract master data for material (0Material, infoobject), but attribute 0PROD_HIER was not update, all records has this value in blank. After that, i extracted hierarchy from R/3, with datasource 0MATERIAL_LPRH_HIER, and hierarchy was activated in BW without problems. Now my problem is how to insert the material en hiearchy, as i have it in R/3, i think that it should be when i extract the hierarchy, but it not happened. So how can i insert the whole material in their node as they are in R/3??

Thanks a lot...regards

[Former Member]

Hi,

Check tables MARA and MVKE in your R/3 system for PRODH field.

The field PRODH in data source 0material is from MARA. If you are using product hierarchy from sales data for material(MVKE) then you may have to write user exit to populate data.

Vijay.

[Former Member]

Have a look at this:

Regards