Shong you can pick any example where you have one parent element tag with 1 to many child elements, some thing like the one I posted previously. Ok let me create an example and try to explain it to you. Let’s say we have a department named “Sales” with lot of employees and we want to store element department in parent table and all the sub employees in the child table.  See the xml below

<root>
<department id=1 name=”Sales”>
<employee> John </ employee >
<employee> Alex </ employee >
<employee> Sharon </ employee >
</department>
</root>

Now let’s say I have two tables Department and Employees and I want to store department "sales" on Department table and all the employees in employee table with department id 1 as the foreign key.

Hi,

I've exact the same problem, I need to import a multi level xml with nested loops?

Example:

<ZPM_EQUIPMENT_EXPORT>
  <EQUI>
    <EQUNR>000000000010032036</EQUNR>
    <AEDAT>2009-07-07</AEDAT>
  </EQUI>
  <CLOBJDAT>
    <CLOBJDAT>
      <TABIX>1</TABIX>
      <ATFLV>9.9E1</ATFLV>
      <ATNAM>ZZ_IT_KOSTENGRUPPE</ATNAM>
    </CLOBJDAT>
    <CLOBJDAT>
      <TABIX>2</TABIX>
      <ATFLV>0</ATFLV>
      <ATNAM>ZZ_ANLAGENHAUPTNUMMER</ATNAM>
    </CLOBJDAT>
  <CLOBJDAT>
</ZPM_EQUIPMENT_EXPORT>

regards
Meex

but this doesn't work for my case!