multiple mapping programs

Hi ,

Currently we have 5 interfaces with 5 different IDOCs which are going to SQL[IDOC to JDBC].

We want to conver them to Proxy-->JDBC. Since Oracle does not need all the data in IDOCs.

I was thinking if I could define one Data type containing all the fields required by different SQL table and generate a Proxy class. Is this the right approach?

But i would have 5 different Mapping Programs and One operation mapping between the source Proxy and 5 different stored procedures which insert data in different table in SQL.

If not I was thinking creating a data type seperately for fields in each IDOC and create seperate message types and SI and MM.

Please advice.

Thanks,

Teresa