topic XML conversion not happening correctly in Application Development and Automation Discussions

XML conversion not happening correctly

Former Member — Thu, 03 Sep 2009 12:02:16 GMT

Hi ,

I'm using method create_text in interface IF_IXML_DOCUMENT to convert the SAP data for sales orders into a XML file.

The problem i'm facing is when there are special characters in these texts like & ,<,>,lt etc... it is not converting into correct format.

For eg, if Material type is MAT&1 this method is returning MAT&amp .

similarly for other charaters .

any idea how to resolve it, would be very help full.

any OSS notes that needs to be applied .

Thanks

Raghavendra

Re: XML conversion not happening correctly

Former Member — Tue, 08 Sep 2009 07:13:40 GMT

Hello Raghavendra,

Use identical transformation if your need is to simply transform data to xml as follows:



DATA itab TYPE TABLE OF ....

DATA xml_string TYPE string.

* Select data into ITAB....

CALL TRANSFORMATION ID
             SOURCE ITAB = ITAB[]
             RESULT XML xml_string.

Hope this helps!

Thanks,

Augustin.

Re: XML conversion not happening correctly

Peter_Inotai — Wed, 09 Sep 2009 07:10:31 GMT

You could use CL_HTTP_UTILITY method ESCAPE_URL and UNESCAPE_URL.

Peter

Re: XML conversion not happening correctly

farihakazi — Wed, 09 Sep 2009 07:43:13 GMT

Hi,

In XML the value & gets converted to & amp ; < to & lt ; and > to & gt ; which is correct.

Why do you want it to be &?

When you view the file using Internet Explorer it will correctly show up as & and not & amp ;

Edited by: Progirl Progirl on Sep 9, 2009 1:13 PM