Jdbc to Idoc Scenario

[Former Member]

Hi,

Scenario is Jdbc to Idoc ,their is an control table in sender database  which contains one key field and status and Time field .My question is When ever The idoc is succesfully posted in Ecc then the time of idoc posted need to be updated in time field of control table in database.Just Suggest me any ways for the solution.

Thanks & Regards,

Anusha Penneru.

[anand_shankar10]

The best way is to let the first flow be JDBC to IDOC and then an ABAP proxy triggered from ECC will update the JDBC table with a key field tallied from the database.

Thanks

Anand

[smavachee]

I will suggest you to go ahead with JDBC > PI > ABAP Proxy

After processing the records, trigger an outbound ABAP Proxy (ABAP Proxy > PI > JDBC)

Write Joins for both tables and combine it into one Query and write in the select table. 

Regards,

Sunil

[Former Member]

Hi Anusha,

You may build proxy to jdbc interface to read idoc creation date in ecc and update in database.

You may schedule a job in ecc to trigger proxy at specific interval.

Regards,

Beena