topic Re: xml to Internal table : Issue in Application Development and Automation Discussions

xml to Internal table : Issue

Former Member — Sat, 11 Jun 2011 11:20:29 GMT

Dear All,

I have written a program to bring the data from xml to internal table Below is the strucutre of my xml file .

- <Data>

- <MT Type="CR">

</MT>

- <OP Type="CR">

- <Activities Element="AT">

- <AT Type="CR">

</AT>

- <AT Type="CR">

</AT>

</Activities>

</OP>

</Data>

.However I am not able to handle the multiple entries which comes together . ie

- <AT Type="CR">

</AT>

- <AT Type="CR">

</AT>

Please let me know how to handle this . Thanks!

Regards,

Syed

uwe_schieferstein — Sat, 11 Jun 2011 19:37:22 GMT

Hello Syed

You may have a look at thread

Regards

Uwe

Former Member — Sun, 12 Jun 2011 12:59:04 GMT

yo can the FM alsm_excel_to_internal_table or for Example you can see in the given url:

jitendra_it — Sun, 12 Jun 2011 19:03:17 GMT

Hi ,

To convert XML data into internal table u have to use FM "SMUM_XML_PARSE", this FM takes XString as input ,so first u have to

convert ur xml string into XString using FM "SCMS_STRING_TO_XSTRING".

Thanks

jitendra

Former Member — Sun, 12 Jun 2011 19:58:22 GMT

if you are in ECC 6.0, use Transformation (Please search the forum or help.sap.com to know more)

It is easy to use with table handling (only have pain in nested structure and control break-up) and really fast with bot-way handling.

Thanks.