topic Re: XML to internal table conversion in Application Development and Automation Discussions

XML to internal table conversion

Former Member — Thu, 22 Aug 2013 11:42:32 GMT

Hi experts ,

My requirement is to read a xml file and convert data into internal table(itab).

I already have the code but the result in itab is not in proper format .

Itab is having data like :

emp_id 112233

emp_name xyz

emp_id 223344

emp_name abc

emp_id 334455

emp_name pqr

emp_id 445566

emp_name mno

I want the emp_ id and emp_name to be header of internal table , and data to be stored row wise. like :

emp_id emp_name

112233 xyz

223344 abc

334455 pqr

445566 mno

I WANT A GENERIC PROGRAM for this that can read any xml file and return data in internal table in required format.

Regards,

Meenu

Re: XML to internal table conversion

uppu_narayan — Thu, 22 Aug 2013 17:26:35 GMT

Hi meenu,

Plz refer the following document properly

https://scn.sap.com/docs/DOC-24791

can you plz paste your xml code.

Regards,

Narayan

Re: XML to internal table conversion

former_member209120 — Fri, 23 Aug 2013 03:17:23 GMT

Hu Meenu Agrawal,

Try like this

http://wiki.sdn.sap.com/wiki/display/ABAP/Upload+XML+file+to+internal+table

Re: XML to internal table conversion

Former Member — Fri, 23 Aug 2013 03:43:31 GMT

My XML code is :

<?xml version="1.0" ?>

- <catalog>

- <book id="bk101">

<author>Gambardella, Matthew</author>

<title>XML Developer's Guide</title>

<genre>Computer</genre>

<publish_date>2000-10-01</publish_date>

<description>An in-depth look at creating applications with XML.</description>

</book>

- <book id="bk102">

<author>Ralls, Kim</author>

<title>Midnight Rain</title>

<genre>Fantasy</genre>

<publish_date>2000-12-16</publish_date>

<description>A former architect battles corporate zombies, an evil sorceress, and her own childhood to become queen of the world.</description>

</book>

- <book id="bk103">

<author>Corets, Eva</author>

<title>Maeve Ascendant</title>

<genre>Fantasy</genre>

<publish_date>2000-11-17</publish_date>

<description>After the collapse of a nanotechnology society in England, the young survivors lay the foundation for a new society.</description>

</book>

- <book id="bk104">

<author>Corets, Eva</author>

<title>Oberon's Legacy</title>

<genre>Fantasy</genre>

<publish_date>2001-03-10</publish_date>

<description>In post-apocalypse England, the mysterious agent known only as Oberon helps to create a new life for the inhabitants of London. Sequel to Maeve Ascendant.</description>

</book>

- <book id="bk105">

<author>Corets, Eva</author>

<title>The Sundered Grail</title>

<genre>Fantasy</genre>

<publish_date>2001-09-10</publish_date>

<description>The two daughters of Maeve, half-sisters, battle one another for control of England. Sequel to Oberon's Legacy.</description>

</book>

- <book id="bk106">

<author>Randall, Cynthia</author>

<title>Lover Birds</title>

<genre>Romance</genre>

<publish_date>2000-09-02</publish_date>

<description>When Carla meets Paul at an ornithology conference, tempers fly as feathers get ruffled.</description>

</book>

- <book id="bk107">

<author>Thurman, Paula</author>

<title>Splish Splash</title>

<genre>Romance</genre>

<publish_date>2000-11-02</publish_date>

<description>A deep sea diver finds true love twenty thousand leagues beneath the sea.</description>

</book>

- <book id="bk108">

<author>Knorr, Stefan</author>

<title>Creepy Crawlies</title>

<genre>Horror</genre>

<publish_date>2000-12-06</publish_date>

<description>An anthology of horror stories about roaches, centipedes, scorpions and other insects.</description>

</book>

- <book id="bk109">

<author>Kress, Peter</author>

<title>Paradox Lost</title>

<genre>Science Fiction</genre>

<publish_date>2000-11-02</publish_date>

<description>After an inadvertant trip through a Heisenberg Uncertainty Device, James Salway discovers the problems of being quantum.</description>

</book>

- <book id="bk110">

<author>O'Brien, Tim</author>

<title>Microsoft .NET: The Programming Bible</title>

<genre>Computer</genre>

<publish_date>2000-12-09</publish_date>

<description>Microsoft's .NET initiative is explored in detail in this deep programmer's reference.</description>

</book>

- <book id="bk111">

<author>O'Brien, Tim</author>

<title>MSXML3: A Comprehensive Guide</title>

<genre>Computer</genre>

<publish_date>2000-12-01</publish_date>

<description>The Microsoft MSXML3 parser is covered in detail, with attention to XML DOM interfaces, XSLT processing, SAX and more.</description>

</book>

- <book id="bk112">

<author>Galos, Mike</author>

<title>Visual Studio 7: A Comprehensive Guide</title>

<genre>Computer</genre>

<publish_date>2001-04-16</publish_date>

<description>Microsoft Visual Studio 7 is explored in depth, looking at how Visual Basic, Visual C++, C#, and ASP+ are integrated into a comprehensive development environment.</description>

</book>

</catalog>

Re: XML to internal table conversion

Former Member — Fri, 23 Aug 2013 03:48:01 GMT

Hi Ramesh ,

I have used this code which is there in this link provided by you , this is good but data fetched in itab is not in proper format as i mentioned in my original post.

please suggest me what code i should use after this code in order to convert the itab in required format.

Regards,

Meenu

Re: XML to internal table conversion

Former Member — Fri, 23 Aug 2013 03:50:07 GMT

Hi Narayan,

I have pasted my XML code.

And my xml file is not on apllication server. I need to pick it from my presentation server ( desktop) only.

Regards,

Meenu

Re: XML to internal table conversion

uppu_narayan — Fri, 23 Aug 2013 06:40:02 GMT

your output and the xml code u have pasted has no match... if you still not getting output let me know i will fill the internal table based on the xml code u have pasted.......and send u

Regards,

Narayan

Re: XML to internal table conversion

Former Member — Fri, 23 Aug 2013 06:45:24 GMT

Hi Narayan ,

The output i mention in my post is just a example for explaining the difference between formats of internal table which i am getting and which i want..

Regards,

Meenu

Re: XML to internal table conversion

uppu_narayan — Fri, 23 Aug 2013 07:22:29 GMT

ok.. happy that ur issue resolved

Regards,

narayan

Re: XML to internal table conversion

Former Member — Fri, 23 Aug 2013 07:40:48 GMT

Hi Narayan,

my issue is not resolved yet.. i need the correct format of internal table.

Regards,

Meenu

Re: XML to internal table conversion

Former Member — Wed, 18 Sep 2013 05:01:00 GMT

one you have the internal table filled up as you had shown in your original post, simple solution is to loop at it and append the values to an internal table as per your design. Second option is to use an xslt transformation but it also depends on the way ur XML has been generated.

I believe the easiest fix for you is to loop and move rather than getting into the the complications of XSLT.

Re: XML to internal table conversion

philipdavy — Wed, 18 Sep 2013 05:18:42 GMT

Hi,

Refer the below given link.

http://scn.sap.com/thread/710038

Regards,

Philip.