Convert XML data to String with comma separated in SAP MII(15.2)

[former_member698200]

I am fetching the Serial numbers from BAPI inside my transaction and i am needed to convert this XML output to String format separated by comma so that it can be passed as a single parameter in[Param.1] defined inside my MDO Update query.

<INPUT>

<IM_LGNUM>PAST</IM_LGNUM>

<IM_LGPLA>FRR01</IM_LGPLA>

</INPUT>

<OUTPUT>

<EX_BINDATA>

<item>

<HUIDENT>00000000000010041767</HUIDENT>

<SER_DATA>

<item>

<SERID>TFLMM2N0AC1</SERID>

</item>

<item>

<SERID>TFLMM2N0AC2</SERID>

</item>

<item>

<SERID>TFLMM2N0AC3</SERID>

</item>

</SER_DATA>

<MATID>CL-MM29N0</MATID>

</item> <item>

</item>

</EX_BINDATA>

<EX_ERROR/>

</OUTPUT>

[agentry_src · Accepted solution]

A very simple way would be to repeat on SER_DATA/Item and concatenate "," & SERID in a local property before mapping it to your MDO query. Probably several other means of doing so such as an xslt.

[former_member698200 · Accepted solution]

Thank you so much Mike. Let me try this.