Skip to Content
author's profile photo Former Member
Former Member

Loading Product Hierarchy from BW Info Object

Hello Experts

I am trying to load product Master data text & hierarchy from BW info object (0Material) to BPC product dimension.

As per BW standard product master data is maintained 0Material Info object and hierarchy in a text info object (0Prod) which is an attribute of 0Material info object.

I can load the master data from 0Material, then I try to load text node of hierarchy which is an attribute in 0Material infoobject, system is giving an error "ID not available". Neither I cannot load the same from 0Prod

Does anybody face similar issues?

Looking forward to hear a solution?

Kind regards

Abraham

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Mar 19, 2015 at 08:20 PM

    Hi Thomas,

    Please go thru the below document and if you still face issues , let us know step by step what you did to help you further.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c02d0b47-3e54-2d10-0eb7-d722b633b72e?overridelayout=t…

    Regards

    Ram

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ram

      Thanks for the reply, I have gone through the document before and was able to load all my master data from BW expect 0Material.

      The issue is there are two info object, 0Material which is a main master data and 0Prod where hierachy is maintained .0Prod is an attribute in 0Material. Hence the node text is not character in 0material info object.


      I tried to load the 0Material by filtering the attribute 0Prod. It is also not working.


      My BW colleagues say this is a standard config for Material Master data.


      Any Solution?


      Kind regards

      Abraham

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2015 at 12:50 AM

    Hi Thomas,

    You need to load master data 0Prod into your material dimension, they will act as hierarchy nodes.


    so the steps are

    load 0Material masterdata

    load 0Prod masterdata

    load 0Material hierarchy


    Andy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 20, 2015 at 03:59 AM

    Hi Thomas,

    You need to load hierarchy node when you load master data & text. On the selection screen tab "Hierarchy", select the hierarchy you want to load, and make sure you put in the correct member ID and level. You can check the hierarchy node ID from RSH1 tcode on BW

    Check out this discussion :

    Hope it helps.

    Regards

    Hendry

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Thomas,

      It doesn't make sense to have hierarchy maintained as attribute. Clearly, BW has separated master data and hierarchy so the maintenance can be easier. It is hard to maintain hierarchy as property.

      Please make effort to create hierarchy for 0PROD in BW system. You can create a custom transformation to 0PROD hierarchy from the datasource that contains "hierarchy attribute"

      BR

      Hendry

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.