I have created product hierarchy for 9 levels by modifying PRODHS structure and creating data in ECC (data in table T179). I also activated 0PROD_HIER_LPRH_HIER as well as 0MATERIAL_LPRH_HIER, as I was not sure which one I should use. When I run RSA3 for Hier name PRDHA for both these datasources, I can see the data.
Then I replicated the datasource 0PROD_HIER_LPRH in BW, built transformation for infoobject 0PROD_HIER as hierarchy. When I create a datapak for this, I am not able to see the hierarchy for selection. When I click 'Available Hierarchies from OLTP', it says that 'There are no hierarchies for this infosource in source system. I am not sure what am I missing and need help to make this work. All your help will be highly appreciated