Skip to Content
0
Former Member
Oct 09, 2005 at 07:15 PM

Designing a BPM, Help Required

22 Views

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