How to write ABAP logic in BW Transformation for Hierarchy table

Hi All,

Greeting for the day.

I have one requirement in BW as below.

I have one table where i have data in the form of Hierarchy as in the below table where i need to populate the root GUID against all child GUID's.

As per below Example : N3 is the last node as DOWN = 0, N3 is the child of N2 , N2 is the child of N1, N1 is the child of ROOTX (This is Parent as UP = 0) , so required one column where all childs should have the Parent Node as (ROOTX) in the final Result of the transformation.

This we need to achieve in BW in the transformation logic (Start / End Routines).

Kindly suggest how to write an ABAP code to achieve this.

Waiting for your earliest reply.

Thanking you in advance.

Regards,

Kalesha.