Idoc to database and after the successful updation a email has to send

[balaji_pichaimuthu]

Hi i got this scenario,

when a production order is released in R/3 , it should send to a legacy system's Database which is present at the shop floor level. After updating that required information a mail should be sent to a predefined email id informing that a order has been created.

Source: SAP ERP (LOIPRO01 idoc)

target: 1. Database(SQL) 2.mail

Tcode : CO01 (Create production order)."

how to achieve this . i got some idea.. but i am clear in that .and confusion over creating the msg type ,msg interface

1. Async idoc->bpm->sync jdbc->receiver mail adapter

(but how to get the response from legacy system database.. can we use RFC or Bapi.. do we predifined

RFC and Bapis.. or tell me the Bapi code for this)

2.Client proxy->jdbc->mail

im not clear this coz i dnt much abt proxies.

plz help me

[dharamveer_gaur2 · Accepted solution]

Hi

First Search on SDN.

how to use JDBC Stored Procedures:

use thread for using stored procedure from JDBC adapter.

[balaji_pichaimuthu · Accepted solution]

hii thanks for all reply ,

u guys are very kind and professional.

now i got the other problem.. since ma input msg is idoc type i can assing in BPM.

im using BPM here coz this is a sync and asynchronous communication

i mean in BPM abstract sync msg interface to contact synchoronous inbound interface of jdbc side.. i cant assign req type as Idoc and Respond type as respond msg type..

now how to solve this prob?

With Regards,

Balaji

[balaji_pichaimuthu · Accepted solution]

hi i still expecting ur response,

please response.. in ma scenario the input is idoc and has to send to a synchronous ib jdbc adapter.. here i have specify idoc has input and stored procedure output... but i cant use idoc as a input type..

so what is the other option,plz help me

With Regards,

Balaji

[Former Member]

Balaji,

Using a stored procedure could be an option. You could develop & deploy a stored procedure in the legacy system database(this stored procedure can return an output response).

You could use the "EXECUTE" mode in Receiver JDBC adapter and call this stored prc, capture the response in BPM and then based on the response, you could send an email using email adapter. Hope this helps.

Thanks

Saravana

[balaji_pichaimuthu]

thnks saravana,

but still im not clear.. coz i never used to stored procedure.. could u give any thread which has the snapshots how to use stored procedure.

With regards,

Balaji