Read XML Message

[Former Member]

Hello All,

I get an XML Message from a legacy system. I need to read the data from the XML Message leaving unnecessary tags. What is the best way to do this. Are there any standard funciton modules available to do this? Plz Help.

My message is of format:

<tag1>

<tag2>data1</tag2>

<tag3>

<tag4>data2</tag4>

<tag4>data3</tag4>

<tag4>data4</tag4>

<tag4>data5</tag4>

..

..

</tag3>

</tag1>

Please tell me how to get data1, data2, data3, data4..... Appreciate any answer in this direction. This is really time critical.

Thanks,

[Former Member]

Hi,

Please check the blog in the below link explaining how to convert data from XML file to ABAP format.

/people/r.eijpe/blog/2005/11/21/xml-dom-processing-in-abap-part-ii--convert-an-xml-file-into-an-abap-table-using-sap-dom-approach

Also, you can watch this: (explained with example)

http://www.heidoc.net/joomla/index.php?option=com_content&view=article&id=15:sapxslt&catid=22:sap-xs...

Hope this will be of help.

Regards,

Susanta

[Former Member]

Hi Susanta,

Thanks very much for the reply. The second link doesn't work.

Any Ideas on how or why to use transformations ? Thanks in Advance ?

Thanks,

[Former Member]

transformation is used to convert the data from source format to target format.

its like cleansing the data.

Go through the below link to learn more about Transformation:

http://help.sap.com/erp2005_ehp_04/helpdata/EN/ae/101640a991c742e10000000a1550b0/frameset.htm

regards,

susanta