XML to internal table conversion

[Former Member]

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

[uppu_narayan]

Hi meenu,

     Plz refer the following document properly

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

can you plz paste your xml code.

Regards,

Narayan

[Former Member]

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

[former_member209120]

Hu Meenu Agrawal,

Try like this

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

[Former Member]

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

[Former Member]

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>

<price>44.95</price>

<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>

<price>5.95</price>

<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>

<price>5.95</price>

<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>

<price>5.95</price>

<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>

<price>5.95</price>

<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>

<price>4.95</price>

<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>

<price>4.95</price>

<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>

<price>4.95</price>

<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>

<price>6.95</price>

<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>

<price>36.95</price>

<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>

<price>36.95</price>

<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>

<price>49.95</price>

<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>

[uppu_narayan]

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

[Former Member]

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

[uppu_narayan]

ok.. happy that ur issue resolved

Regards,

narayan

[Former Member]

Hi Narayan,

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

Regards,

Meenu

[Former Member]

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.

[philipdavy]

Hi,

Refer the below given link.

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

Regards,

Philip.