Designing a BPM, Help Required

[Former Member]

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

[MichalKrawczyk · Accepted solution]

Hi John,

>>>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.

why can't you do that?

you can combine the SAP data with the jdbc response

of the first jdbc call (2:1 mapping)

this way all of your data will become available in the second jdbc call

Regards,

michal

[Former Member · Accepted solution]

Hi Micheal,

Cud u please elaborate on that. I believe the design is correct.I am not sure how to combine the SAP data with the first JDBC response.

Regards

John