Convert Hierarchy to Flat structure

[#1]

Hi Experts,

We have a requirement where we want to convert hierarchical structure to a flat structure. e.g. we have a hierarchy master data Org Unit. in transactional data we got a Org Unit A, now i want to have a attributes for this Org Unit which will show the layer of this Org Unit A. In this case if Org Unit is at level 3, then attributes will be Level1, Level2, Level3 and from top node till we navigate it should put values in level1, level2 & level3.

So my data is like

Org Unit Level1 Level2 Level3

A            B        C        A

Is it possible to get with existing data.

Regards,

Ganesh

[MGrob]

Hi

The fastest way is you use this helper: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/0403a990-0201-0010-38b3-e1fc44284...

and then upload the flatfile back into a dso. If you add it all in a processchain you can fill the dso with one click and you don't need to abap code it.

If you are on 7.3 you can directly create a transformation from a hierarchy to a dso.

Hope it helps

Martin