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.