SAP MII Build Complex XML Structure

[former_member540482]

Hi All,

I have a requirement in which I have to fetch data from multiple queries and build a xml output.

I m able to execute queries, put repeater on them, and able to trace the results.

But now, I want to build an xml out of this and show it as transaction output. I used SAP MII XML Output Actions, but could not succeed.

Posting a sample xml as required in output.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<xmii:pos xmlns:xmii="http://www.abc.com/test">

<po>

  <ID>70001187</ID>

  <PlantCode>3100</PlantCode>

  <Code>Scheduled</Code>

  <operations>

   <operation>

    <OperationID>0010</OperationID>  

    <Code>Completed</Code>

    <PONum>70001187</PONum>

    <SegmentID>86</SegmentID>    

   </operation>

  </operations>

</po>

</xmii:pos>

Please help me as to how can I build this XML. I m using SAP MII 14.

Thanks

N G

[former_member185280]

I recommend doing this with an xsl using the XSL transformation action.

XSL Transformation - SAP Manufacturing Integration and Intelligence - SAP Library

Regards,

Christian

[former_member540482]

HI Christian,

Thanks for the reply.

I m still not sure, how will XSLT help me get the complex XML, or rather create this parent child heirarchy.

Could you provide me with some more input.

Thanks.

N G

[swaroop_anasane]

Hi NG,

You can create an XML document and then add Rowset using append xml, this way you can keep on adding the result sets and pass you xml as output.

Also, what do you mean when you say " I used SAP MII XML Output Actions, but could not succeed.". Let me know the steps.

Thanks,

Swaroop