2007 Nov 08 3:14 PM
Hello All,
I need a function or possible way to export (later also import) my data to a structured XML file. (like in the DISPLAY_XML_STRING function)
SELECT single * FROM sflight INTO CORRESPONDING FIELDS OF ls_sflight.
CALL TRANSFORMATION id SOURCE structure = ls_sflight RESULT XML xmlstr.
CALL FUNCTION 'DISPLAY_XML_STRING' EXPORTING xml_string = xmlstr.Example: Result of DISPLAY_XML_STRING
<?xml version="1.0" encoding="utf-8" ?>
<asx:abap xmlns:asx="http://www.sap.com/abapxml" version="1.0">
<asx:values>
<TABLE>
<SFLIGHT>
<MANDT>800</MANDT>
<CARRID>AA</CARRID>
<CONNID>0017</CONNID>
<FLDATE>2007-06-06</FLDATE>
<PRICE>422.94</PRICE>
<CURRENCY>USD</CURRENCY>
<PLANETYPE>747-400</PLANETYPE>
<SEATSMAX>385</SEATSMAX>
<SEATSOCC>375</SEATSOCC>
<PAYMENTSUM>193347.3</PAYMENTSUM>
<SEATSMAX_B>31</SEATSMAX_B>
<SEATSOCC_B>31</SEATSOCC_B>
<SEATSMAX_F>21</SEATSMAX_F>
<SEATSOCC_F>19</SEATSOCC_F>
</SFLIGHT>
</TABLE>
</asx:values>
</asx:abap>
Thanks in Advance
2007 Nov 08 3:21 PM
Welcome to SDN.
Please use CALL TRANSFORMATION or use class IF_IXML_DOCUMENT.
Please check this link
/people/r.eijpe/blog/2005/11/10/xml-dom-processing-in-abap-part-i--convert-an-abap-table-into-xml-file-using-sap-dom-approach
a®