Skip to Content
1
Former Member
Apr 16, 2014 at 03:50 PM

Get a lighter hierarchy in SAP BW than in SAP ECC

145 Views

Hello,

In SAP ECC we have a material hierarchy with 8 levels.

The first four levels are the organization as division and brand.

The last four levels are material characteristics as the type and the containing.

In SAP BW we want the following :

- Split the hierarchy levels to fill 8 attributes of the material info-object. DONE

- Get only the first four levels of the hierarchy + the material linked to the 4th level.

In ECC we have :

Level 1 > Level 2 > Level 3 > Level 4 > Level 5 > Level 6 > Level 7 > Level 8 > Material

In BW we want :

Level 1 > Level 2 > Level 3 > Level 4 > Material

It seems possible in transformation from datasource 0MATERIAL_LPRH_HIER to material hierarchy with using huge development in node segment :

- Delete unwanted nodes

- Check / Change fields parent / child / next

I hope it exist an easier way. Do you know one ?

Thank you.