topic Re: How to get xml data into internal table? in Application Development and Automation Discussions

How to get xml data into internal table?

Former Member — Sat, 25 Apr 2009 15:55:55 GMT

Hi,

Experts,

As i want to read xml data into internal table.In that xml file there is repeated tags are present with different value i want all that data into internal table

For ex:

<ControllerUsage.ContextMappings>

<ContextElementMapping.MappedElement>

<Core.Reference package="com" name="FMCA_ECMD" type="Controller"

path="Context/Attribute:controlatt"/>

</ContextElementMapping.MappedElement>

</ContextElementMapping>

<ContextElementMapping.MappedElement>

<Core.Reference package="com" name="FMCA_ECMD" type="Controller"

path="Context/ChildNode:controlnode/Attribute:controlatt"/>

</ContextElementMapping.MappedElement>

</ContextElementMapping>

<ContextElementMapping.MappedElement>

<Core.Reference package="com" name="FMCA_ECMD" type="Controller"

path="Context/ChildNode:controlnode"/>

</ContextElementMapping.MappedElement>

</ContextElementMapping>

<ContextElementMapping.MappedElement>

<Core.Reference package="com" name="FMCA_ECMD" type="Controller"

path="Context/ChildNode:controlnode/Attribute:controlatt"/>

</ContextElementMapping.MappedElement>

</ContextElementMapping>

</ControllerUsage.ContextMappings>

Please suggest on this as soon as possible

Thanks in advance

Shabeer Ahmed

Re: How to get xml data into internal table?

Former Member — Sat, 25 Apr 2009 16:51:45 GMT

Try the function module 'TEXT_CONVERT_XML_TO_SAP'.

Re: How to get xml data into internal table?

Former Member — Sat, 25 Apr 2009 16:57:23 GMT

Also check the Unit 10 Exercises from the following delta training material

[https://sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/a7455fd8-0301-0010-d7b5-c2103a49c255|https://sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/a7455fd8-0301-0010-d7b5-c2103a49c255]

Re: How to get xml data into internal table?

GrahamRobbo — Sun, 26 Apr 2009 21:44:16 GMT

I would use a [Simple Transformation|http://help.sap.com/saphelp_nw04/helpdata/en/e3/7d4719ca581441b6841f1054ff1326/frameset.htm] .

Cheers

Graham Robbo

Re: How to get xml data into internal table?

Former Member — Mon, 27 Apr 2009 10:43:07 GMT

thank u