topic Re: converting an internal table containing XML file data into normal internal in Application Development and Automation Discussions

converting an internal table containing XML file data into normal internal

Former Member — Fri, 13 Apr 2007 13:08:36 GMT

Hi all,

i'am working with a scenario where we have to read data from an XML file into a internal table and then upload that into any transactions like MM01 r XK01 like that.

now i copied the data from the XML file using some interfaces supporting XML conversions and now the data is present in a internal table declared in the abap program. the declaration of that internal table is

TYPES: BEGIN OF t_xml_line,

data(256) TYPE x,

END OF t_xml_line.

DATA: l_xml_table TYPE TABLE OF t_xml_line,

l_xml_line TYPE t_xml_line,

l_xml_table_size TYPE i.

DATA: l_filename TYPE string.

now all the data read from the XML file has been copied into the internal table along with the tags of the XML. now i want those tags of XML to be removed and data alone to be copied into another intenal table.

CAN ANYONE HELP ME OUT FROM THIS SCENARIO.

Thanks,

anil.

Re: converting an internal table containing XML file data into normal internal

Former Member — Fri, 13 Apr 2007 13:12:07 GMT

do this way....

declare another internal table with fields....

loop at itab1.

split itab1 at <delimiter> into itab2.

append itab2.

endloop.

Re: converting an internal table containing XML file data into normal internal

RichHeilman — Fri, 13 Apr 2007 13:13:58 GMT

What SAP release are you working with?

Regards,

Rich Heilman

Re: converting an internal table containing XML file data into normal internal

RichHeilman — Fri, 13 Apr 2007 13:17:13 GMT

If you are on a fairly new release, you may be able to use transformations.

http://help.sap.com/saphelp_nw2004s/helpdata/en/e3/7d4719ca581441b6841f1054ff1326/frameset.htm

Regards,

Rich Heilman

Re: converting an internal table containing XML file data into normal internal

Former Member — Mon, 16 Apr 2007 10:42:52 GMT

thanks to ramesh babu and rich heilman.