XML to Internal table

[Former Member]

Hello all,

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

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

......

<QfiData xmlns="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.

[Former Member]

solved by raja.