topic Re: convert the data from database table to xml file. in Application Development and Automation Discussions

convert the data from database table to xml file.

Former Member — Fri, 14 Aug 2009 11:56:24 GMT

CALL TRANSFORMATION ('ID')

SOURCE output = itab[]

rESULT XML xml_out.

write:/ xml_out.

i used this code to transfer the data from database table into xml file.. the output is stored in xml_out.. but i wonder how to put the output in the xml file..

i mean, i need the output in this format in a file that has to be stored in a folder.

<?xml version="1.0" encoding="iso-8859-1" ?>

<customer_id>1</customer_id>

<first_name>Jan</first_name>

<last_name>Krohn</last_name>

</PERSON>

<customer_id>2</customer_id>

<first_name>James</first_name>

<last_name>Kirk</last_name>

</PERSON>

</CUSTOMERS>

Re: convert the data from database table to xml file.

Former Member — Fri, 14 Aug 2009 12:13:42 GMT

refer this link

Re: convert the data from database table to xml file.

Former Member — Fri, 14 Aug 2009 12:29:37 GMT

thank u very much sir.. i would definitely work on it.

Re: convert the data from database table to xml file.

Former Member — Mon, 17 Aug 2009 12:02:55 GMT

Use xml browser that is available with the ABAP workbench to read the xml string displayed with proper indentation.

can u please help me with this one..