Skip to Content
0
Nov 25, 2011 at 05:28 AM

Context Handling problem

29 Views

Hi all,

I have a problem with a context handling requirement. I think UDF is needed in this case but I don't know where to start. Please see below for the scenario:

I have an input structure like this:

segment1

field1

segment2

field2

segment3

field3

node2

field2

node3

field3

node3

field3

the fields will corelate the segment and the node. so for this structure, segment2 and node2 are corelated. Actually, node2 is under segment2.

here's my desired output to make things clearer:

segment1

field1

segment2

field2

node2

field2

segment3

field3

node3

field3

node3

field3

field1 sample value. ex. 0000000001

all field2 have the same value. Value from both segment2 and node2 of field2 is the same. ex. 0000000002

all field3 have the same value. Value from both segment3 and the 2 node3s of field3 is the same. ex. 0000000003

In my current mapping, I'm getting this erroneous output:

segment1

field1

node2

field2

segment2

field2

node3

field3

segment3

field3

node3

field3

The nodes are not in their correct segments. node2 is one level higher because there was no node1.

Occurrence of segments are 1..unbounded. nodes are 0..unbounded.

Thanks all.

Regards,

SAPenthusiast