topic Re: XML Processing (XML file data to ABAP internal table). in Application Development and Automation Discussions

XML Processing (XML file data to ABAP internal table).

Former Member — Tue, 09 Mar 2010 03:46:18 GMT

Hi,

I have a an XML file and i need to send the data to internal table. I suppose i have written the program correctly.

But the transformation program may not be correct.

So can one please tell me the transformation program c o d e or guide me to write the transformation code. Below are details of XML file and my program.

XML File

<?xml version="1.0" encoding="UTF-8" ?>

- <aeRequestOutputType>

+ <trackingInfo>

+ <JMSHeaders>

- <ns:__caret_reply_caret_ZBAPI xmlns:ae="http://www.tibco.com/" xsi:type="ns:__caret_reply_caret_ZBAPI_">

+ <RETURN>

- <T__TRADE__DATA>

- <item>

</item>

- <item>

</item>

</T__TRADE__DATA>

</ns:__caret_reply_caret_ZBAPI__TRADE__ACC__DOC__POST_caret_ZBAPI__TRADE__ACC__DOC__POST>

</aeRequestOutputType>

My Program

REPORT ZTEST13.

DATA : BEGIN OF itab OCCURS 0,

f(255) TYPE c,

END OF itab.

DATA : t001 TYPE TABLE OF ZTEST_ST_UB. "(structure has few variables like hkont,bukrs)

DATA: xmlupl TYPE string .

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'c:\sap_output_xml.txt'

FILETYPE = 'ASC'

tables

data_tab = itab .

LOOP AT itab.

CONCATENATE xmlupl itab-f INTO xmlupl.

ENDLOOP.

CALL TRANSFORMATION ZTEST_ST_UB2

SOURCE XML xmlupl

RESULT root = t001.

Re: XML Processing (XML file data to ABAP internal table).

Former Member — Tue, 09 Mar 2010 05:20:04 GMT

Hi,

use class cl_xml_document and method import_from_file inorder to read the xml file to internal table.

go trough this [LINK|http://wiki.sdn.sap.com/wiki/display/ABAP/UploadXMLfiletointernal+table] for detial code.

Regards,

Shanmugavel chandrasekaran

Re: XML Processing (XML file data to ABAP internal table).

Former Member — Tue, 09 Mar 2010 06:19:54 GMT

Hi,

Use ixml classes

Regards,

sravan.

Re: XML Processing (XML file data to ABAP internal table).

Former Member — Wed, 07 Apr 2010 22:56:15 GMT

|Hi Everybody.

I have a same issue.

I need to read a XML file and map all the element attributes to a internal tables.

Do you have a sample to read elements from XML string and insert into the internal tables.

I found samples about the class IXML, but these aren't so clear.

Thanks in advance.

Regards.