Skip to Content
-1

How to write ABAP logic in BW Transformation for Hierarchy table

May 04 at 07:46 AM

40

avatar image
Former Member

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

Regards,

Kalesha.

10 |10000 characters needed characters left characters exceeded
Former Member


Inserting the table image as it not displayed properly in the question.

Regards,

Kalesha.

requirement.jpg (26.2 kB)
0

What have you tried? Do you have any development experience? Do you have an experienced developer on site? Are you expecting us to write your program for you?

1
Former Member

Hi,

Yes , I do have development experience. I am not expecting to write my program from anyone. I just wanted to check if any one come across such requirement and wanted to get some tips /guidance /any reference URL's from them.

Regards,

Kalesha.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers