IDOC to JDBC - Multiple Inserts

Hi ,

I have an idoc to JDBC scenario.

Here is idoc structure.

E1MASTL 1...1

|--> E1STOKL 0....9999

|--->E1STOPL 0....9999

my table struture expects data from 2 segments in the E1MASTL and 4 segments from E1STOKL and 3 segments from E1STOPL.

when i trigger the idoc which has 5 line items in E1STOPL and 5 line items in E1STOKL but only one from E1MASTL.

Now, when this idoc is triggered, the table is updated with all the first line items from each segment, instead i want all the 10 lines to be updated in the table.

I have tried mapping the Statemetn and access tags to the all the possible nodes on the Idoc side but could not succed in inserting multiple lines in the table though i had multiple line items in the idoc.

Please help me how do i do it.

Thanks in advance.

Regards,

Kalpana.

Edited by: Kalpana Timmapuram on Nov 27, 2009 9:58 PM