topic Convert itab containing XML format to text format in Application Development and Automation Discussions

Convert itab containing XML format to text format

Former Member — Tue, 07 Jul 2009 06:27:39 GMT

Hi,

I have a requirement in which I have to read a file from the application server. The file is in xml format. I have to display the file in ALV format. Can anyone tell me a method that can be used to do this?

Thanks

Re: Convert itab containing XML format to text format

Former Member — Tue, 07 Jul 2009 06:28:56 GMT

Hi ,

Use Transformation.

regards,

Vijay

Re: Convert itab containing XML format to text format

Former Member — Tue, 07 Jul 2009 06:42:16 GMT

Hello,

For Fetching the data from the application server . Use Open Dataset , Read Dataset and Close Dataset.After the getting the data , pass the data to the function module SMUM_XML_PARSE . This FM will convert the data from XML.

Re: Convert itab containing XML format to text format

Former Member — Tue, 07 Jul 2009 07:02:26 GMT

Hi,

I have already used the read dataset and have filled my itab with the xml data. but when I am passing the same itab to the FM SMUM_XML_PARSE then it is giving me a dump.

Thanks

Edited by: lydia jacob on Jul 7, 2009 9:02 AM

Re: Convert itab containing XML format to text format

Former Member — Tue, 07 Jul 2009 07:06:19 GMT

Hello ,

Before passing the data to SMUM_XML_PARSE . Pass the XML data to the function module 'SCMS_BINARY_TO_XSTRING' for converting the file to string Then call the SMUM_XML_PARSE .It should work.

Re: Convert itab containing XML format to text format

Former Member — Tue, 07 Jul 2009 08:36:58 GMT

Hi Lydia,

Please look at the code example given in code gallery. Link: [XML|https://wiki.sdn.sap.com/wiki/display/Snippets/SimulatortoreaddatafromaxmlfilestoredintheMIMErepositoryandconvertitintotheinternal+table.].

Regards,

Sai

Re: Convert itab containing XML format to text format

Former Member — Tue, 07 Jul 2009 08:51:03 GMT

Hi,

This is very simple.

1.First you need to bring the data from the application server by using the opendataset.

Read the data from server into an internal table

2.then transform the data from intrenal table to the data base using read dataset

3.finally close the dataset.

hope this might help you out.

Pooja

Re: Convert itab containing XML format to text format

ThomasZloch — Tue, 07 Jul 2009 08:59:14 GMT

The most performant way for XML to ABAP conversion (and vice versa) is the so-called simple transformations, available with release 7.00.

http://help.sap.com/saphelp_nw70/helpdata/EN/e3/7d4719ca581441b6841f1054ff1326/frameset.htm

Thomas