Skip to Content
0
Former Member
Jan 18, 2011 at 04:33 PM

Structure of a simple transformation

535 Views

Hi,

I cannot find relevant information to my question, so perhaps someone can help: I have to read data from a web service and the structure of the resulting file is this:

<NewDataSet>
  <Table>
    <Country> </Country>
    <City> </City>
  </Table>
  <Table>
    <Country> </Country>
    <City> </City>
  </Table>
</NewDataSet>

I just can´t find in SDN the rules of conversion for creating the simple transformation in SAP. So far this is what I have been able to do in XSLT_TOOL:

<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">

<tt:root name="TABLE_IN"></tt:root>

<tt:template name="COUNTRIES">
<NewDataSet>
    <tt:loop ref=".TABLE_IN.table">
        <country><tt:value ref="$ref.TABLE.COUNTRY"></tt:value></country>
        <city><tt:value ref="$ref.table.CITY"></tt:value></city>
    </tt:loop>
</NewDataSet>
</tt:template>

</tt:transform>

The above code is wrong because ABAP programme triggers an error message at CALL TRANSFORMATION.

Questions:

1) where and how are the conversion rules ?? or how can I write the code for the transformation ??

2) check this link, then method GetCitiesByCountry and tell me where the structure of the file is. I just can´t understand it.