topic Problem converting from XML to ABAP in Application Development and Automation Discussions

Problem converting from XML to ABAP

former_member325971 — Tue, 10 Oct 2006 06:08:23 GMT

Hi experts,

i am currently experiencing difficulty trying to convert this xml into abap internal table.

I am trying to use XSLT to convert this XML but unsuccessful so far.

<I_DATA>

<NAME2>smith</NAME2>

<CONT>

<CONTENT1>STREAM ROAD</CONTENT1>

<CONTENT2>ENGLAND</CONTENT2>

<CONTENT1>CROSS STREET</CONTENT1>

<CONTENT2>MALAYSIA</CONTENT2>

</CONT>

<NAME1>MICHAEL</NAME1>

<CONT>

<CONTENT1>HABOUR STREET</CONTENT1>

<CONTENT2>SINGAPORE</CONTENT2>

<CONTENT1>RANCH ROAD</CONTENT1>

<CONTENT2>AMERICA</CONTENT2>

</CONT>

</I_DATA>

This is the internal table:

TYPES: BEGIN OF CONTENT,

CONTENT1(20),

CONTENT2(20),

END OF CONTENT.

TYPES: T_CONTENT TYPE TABLE OF CONTENT.

DATA: BEGIN OF I_DATA_table,

KEY1(10),

KEY2(10),

CONT TYPE T_CONTENT,

END OF I_DATA_table.

DATA: I_DATA type table of I_DATA_TABLE.

Can anyone please shine some light on this?

Many thanks in advance~!

Re: Problem converting from XML to ABAP

Former Member — Tue, 10 Oct 2006 06:10:54 GMT

Hi,

See the below link for program which is uploading the XML file in to SAP, this will work in 4.6C

http://www.geocities.com/rmtiwari/main.html?http://www.geocities.com/rmtiwari/Resources/MySolutions/Dev/Codes/Report/Z_RMTIWARI_XML_TO_ABAP_46C.html

use this XML file for the above program:

http://www.geocities.com/rmtiwari/main.html?http://www.geocities.com/rmtiwari/Resources/MySolutions/Dev/UtilityCode.html

See the below link for one more program

http://wiki.ittoolbox.com/index.php/Code:Download_and_upload_OO_ABAP_class_in_XML_format

Regards

Sudheer

Re: Problem converting from XML to ABAP

former_member325971 — Tue, 10 Oct 2006 06:18:22 GMT

Thanks Sudheer~! but i would like to use XSLT to solve this problem.

Thanks again so much for the information! Points have been awarded.

Re: Problem converting from XML to ABAP

athavanraja — Sun, 15 Oct 2006 10:40:46 GMT

answered in this thread

Regards

Raja