Skip to Content
0
Mar 09, 2017 at 12:25 PM

SAP PI 7.40 issue of mapping with table elements

49 Views

Hi,

we are in SAP PI 7.40. Scenario XML file with multiple embedded tables to RFC fct

xml file example

<root>
<table_prem>
<id>1</id>
<table_second>
<VIN>abcde</VIN>
<table_third>
<del>2017</del>
<Make>GB</Make>
</table_third>
<table_third>
<del>2016</del>
<Make>FR</Make>
</table_third>
</table_second>
<table_second>
<VIN>defg</VIN>
<table_third>
<del>2018</del>
<Make>BR</Make>
</table_third>
<table_third>
<del>2019</del>
<Make>KV</Make>
<table_third>
</table_second>
</table_prem>
<table_prem>
<id>2</id>
<table_second>
<VIN>ghk</VIN>
<table_third>
<del>2019</del>
<Make>RR</Make>
</table_third>
<table_third>
<del>2018</del>
<Make>BR</Make>
</table_third>
</table_second>
<table_second>
<VIN>RRRRRR</VIN>
<table_third>
<del>2020</del>
<Make>AL</Make>
</table_third>
<table_third>
<del>2040</del>
<Make>ZZ</Make>
<table_third>
</table_second>
</table_prem>

</root>

when I do the mapping to the RFC fct , in the table_third, only the first item is transfered.

<Z_FCT.Response>
<TABLE_PREM>
<item>
<ID>1</ID>
<TABLE_SECOND>
<item>
<VIN>abcde</VIN>
<TABLE_THIRD>
<item>
<DEL>2017</DEL>
<MAKE>GB</MAKE>
</item>
</TABLE_THIRD>
</item>
<item>
<VIN>defg</VIN>
<TABLE_THIRD>
<item>
<DEL>2018</DEL>
<MAKE>BR</MAKE>
</item>
<TABLE_THIRD>
</item>
</TABLE_SECOND>
</item>
<item>
<ID>2</ID>
<TABLE_SECOND>
<item>
<VIN>ghk</VIN>
<TABLE_THIRD>
<item>
<DEL>2019</DEL>
<MAKE>RR</MAKE>
</item>
<TABLE_THIRD>
</item>
<item>
<VIN>RRRRRR</VIN>
<TABLE_THIRD>
<item>
<DEL>2020</DEL>
<MAKE>AL</MAKE>
</item>
<TABLE_THIRD>
</item>
</TABLE_SECOND>
</item>
</TABLE_PREM>
</Z_FCT.Response>

The first and the Second levels of table are transfered correctly.

But for the third table, only the first row is transferred.

Can somebody help me?

Another solution is the mapping with a XSLT but that's not the best solution.

Kind Regards

Eric Koralewski