Skip to Content
0
Former Member
Dec 04, 2006 at 08:35 AM

XML to Internal table

22 Views

Hello all,

I have an xml stored in a string. Its format is as below:

<?xml version="1.0" encoding="utf-8"?>

......

http://www2.siemens.nl/qfiservice/QfiData.xsd">

<Material diffgr:id="Material1" msdata:rowOrder="0">

<Material>463581</Material>

<ConditionRate> 2.44</ConditionRate>

<ValidFrom>20060208</ValidFrom>

<ValidTo>99991231</ValidTo>

<RegionID>48</RegionID>

<MaterialID>36294</MaterialID>

</Material>

<Material diffgr:id="Material2" msdata:rowOrder="1">

<Material>463582</Material>

<ConditionRate> 2.44</ConditionRate>

<ValidFrom>20060208</ValidFrom>

<ValidTo>99991231</ValidTo>

<RegionID>48</RegionID>

<MaterialID>36295</MaterialID>

</Material>

.....

Now the question is, i want to read only the child nodes of Material i.e., material, condition rate, validfrom, valid to, regionid, materilid and store these in an internal table.

Can anyone help me.

Thankyou.