Hi,
I am Required to Select Data From R/3(6.2) and based on this data some data should be picked from another application (APP1) Database table1. Now based on this table1 records (APP1 application) Table2 should be inserted/updated. When updating this table2, 2 of the fields that orginally came from SAP table should also be used to update the fields. Not sure how to pass this 2 fields to the final Update JDBC receiver.
My initial design looks like this.
Use Proxy to send data from R/3 to IP.
IP sends this data via JDBC Receiver to select data (action=SELECT" <access> and <key> nodes are used in the Data Type) and the syncronous response should be received by the IP and the IP should update/insert the table2 using JDBC Receiver( action= UPDATE_INSERT <access> and <key> nodes are used in the Data Type).
I am not able to come in terms with this design as i cannot pass the 2 fields orginally selected from SAP table to the final Update Scenario using JDBC receiver.
Request help. Any thoughts of a Revised Design?
Regards
John