Skip to Content
Former Member
May 04, 2018 at 07:46 AM

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.

Existing Data GUID UP DOWN Required Column ROOTX 0(Zero) N1 ROOTX N1 ROOTX N2 ROOTX N2 N1 N3 ROOTX N3 N2 0 (Zero) ROOTX