Loading Product Hierarchy from BW Info Object

[Former Member]

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

[former_member544285]

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

[Former Member]

Hi Hendry

There is no Hierarchy node available in Master data. It is maintained as a attribute.

Abraham

[former_member182766]

Thomas, could you please show as a screenshot of your 0PROD hierarchy in SAP BW with few nodes expanded?

[former_member182766]

Or do the following:

Create hierarchy Transformation between your 0prod hierarchy Data Source and 0MATERIAL.

In Start routine after intervals method (if any) include this code:

data: wa_package like line of SOURCE_PACKAGE_3,

         RESULT_PACKAGE like SOURCE_PACKAGE_3.

LOOP AT SOURCE_PACKAGE_3 INTO wa_package.

  IF wa_package-IOBJNM <> '0HIER_NODE'.

  wa_package-IOBJNM = '0MATERIAL'.

  ENDIF.

APPEND wa_package TO RESULT_PACKAGE.

ENDLOOP.

SOURCE_PACKAGE_3 = RESULT_PACKAGE.

This way the loaded hierarchy will mimic the hierarchy of 0MATERIAL and you will be able to load it to BPC (provided you also loading 0PROD master data to 0MATERIAL).

[former_member544285]

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

[Former Member]

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

[Former Member]

Hi Andy

Thanks for the reply

0Prod master data is a text info object which is linked to 0Material info object by an atrribute maintained in 0Material.

When I try to load 0Prod, i am getting an error message " ID not available in 0Prod"

Kind regards

Abraham

[Former Member]

Hi Thomas,

You need to activate master data for info object 0PROD.

in the Master Data/Texts tab page, tick the box for master data.

Andy

[Former Member]

Hi Andy

Thanks for the reply.

It tried activating 0PROD and it is not working either

Is there any workaround.

Kind regards

Abraham

[Former Member]

Hi Thomas,

Please take a screenshot of the hierarchy in BW.

Andy

[former_member728473]

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-d722b633b...

Regards

Ram

[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