Skip to Content
0
Former Member
Nov 29, 2011 at 12:23 PM

Header data with multiple items and each item have multiple sub items.

37 Views

Hi Pi experts,

SOURCE STRUCTURE: TARGET STRUCTURE

JDBC Receiver

HEADERRECORD STATEMENT

FIELD1 dbTableName

FIELD2 action

FIELD3 access(0--unbound)

FIELD4

FIELD5

ITEMRECORD( 0 TO UNBOUND)

ITEM1

ITEM2

-


-


SUBITEMRECORD(0 TO UNBOUND)

SUBITEM1

SUBITEM2

I NEED OUTPUT TO BE DISPLAY

ACCESS NODE

<FIELD1>

<FIELD2>

<FIELD3>

<FIELD4>

<FIELD5>

<ITEM1>

<SUBITEM1>

ACCESSNODE

<FIELD1>

<FIELD2>

<FIELD3>

<FIELD4>

<FIELD5>

<ITEM2>

<SUBITEM2>

I have the input structure from sap side the header data with multiple items and each item have multiple sub items.based on the number of sub items the access node of target jdbc document standard structure should be generated with same number of times.

for example if the number of subitems on the itemlevel are two then I need the access node to be populated two times.

Has any one of our SAP PI friends come across this type of requirement please help ?

Best Regards,

Ram.