Mapping Parent A as a child of Parent B SAP CPI

[aayushaggarwal]

Hi Experts,

I have this source structure and I am trying to create below target structure.

Both A and B are on same level in source, but in target I am trying to put A as a child of B and the field a1 under a complex structure.

Could you please suggest, how I can achieve this please?

Source:

Source:

<root>
	<A>
	 <a1>1</a1>
	 <a2>EN</a2>
	 <a3>Yes<a3>
	</A>
	<A>
	 <a1>2</a1>
	 <a2>ZH</a2>
	 <a3>Yes<a3>
	</A>
	<B>
	 <b1>abc<b1>
	</B>
	<B>
	 <b1>abc</b1>
	</B>
	<B>
	 <b1>abc</b1>
	</B>
	<B>
	 <b1>abc</b1>
	</B>
</root>

Target:
      <root>
	<B>
	 <b1>abc</b1>
	 <A>
	   <row>
	    <a1>1</a1>
	    <a2>EN</a2>
	   </row>
	 </A>
	 <A>
	   <row>
	    <a1>1</a1>
	    <a2>EN</a2>
	   </row>
	 </A>
	</B>
	<B>
	 <b1>abc</b1>
	 <A>
	  <row>
	   <a1>1</a1>
	   <a2>EN</a2>
	  </row>
	 </A>
	 <A>
	  <row>
	   <a1>1</a1>
	   <a2>EN</a2>
	  </row>
	 </A>
	</B>
       </root>

[jayesh2203]

Have you tried using Groovy script for this? I think instead of Message mapping if you use groovy it will be easier to map.

[MortenWittrock]

Hi

It's not really clear at all how the A and B elements are related. Also, you have 4 B elements in the source document but only 2 in the target document. Is that intended?

Regards,

Morten

[daviddasilva]

Hello,

If you have a correct xsd on the source and target side, then you would be able to do this in message mapping but you will need to manage the contexts and use node functions.

Before we can advise further you need to clarify what the intedned output is, as Morten highlighted.

[aayushaggarwal]

Hi Morten and David,

A and B are on same level in source message

<root>

</A>

</B>

</root>

and in Target A is child of B

<root>

<B>

</A>

</B>

</root>

Also, you have 4 B elements in the source document but only 2 in the target document. Is that intended?

No, number of B's will be same in Target as Source.