JDBC to IDOC Scenario

[Former Member]

Hi All,

I am doing JDBC->IDOC scenario.

The requirement is,the fields from a table needs to be updated in SAP System.Once IDOC is generated successfully in SAP,then all the field values need to be deleted in the database.

Example:If there are 10 records ,then out of which only 6 records are processed successfully and IDOCs are generated,then only those values of 6 records should be deleted from the database and not the remaining 4 record values.

How to go about it?Is there any option available without using BPM?

Please advise.

Regards

B.Dheepa

[Former Member · Accepted solution]

Hi Dheepa,

Since doesnot support synchronous call the best thing would be to come up with Function module (let the idoc call from this fm) and let it create the idoc and let the fm sends the response back to pi and from there you update accordingly.

Regards,

---Satish

[Former Member · Accepted solution]

Hi Satish,

Thanks for your reply.

In case if we are going to use BPM,then what are the steps required to delete the entries in the database?

How will I know the successful IDOc contains the value which is there in the database?

Thanks.

[Former Member]

Hi Dheepa,

Following sdn-weblog may be useful for the case as you described,

Link: [PostingMultipleIdocs|http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=%28J2EE3417500%29ID1932444450DB21171106485548711300End?blog=/pub/wlg/2776]

Though I feel the suggestion by is much better, that avoids BPM's in your scenario.

Regards,

Nipun

[Shabarish_Nair]

somethign similar was designed as below;

JDBC -> PI -> ABAP proxy

After processing of the records, trigger an outbound ABAP proxy which will have the details of the successful records that you can now delete in the JDBC (ABAP proxy -> PI -> JDBC)

these will be two independent aync processes and no need for BPM