Outbound ABAP Client Proxy

[former_member229310]

Hi,

Scenario - Client Proxy to JDBC.

I am getting Purchase order details out of Client proxy which goes and updates multiple tables at JDBC. I am doing this via single service interface to update multiple tables ( multiple statement element in JDBC target structure ).

Client Proxy

PO HEADER

PO DETAIL

PO TEXT

PO ITEM

JDBC tables

tbl_HEADER

tbl_DETAIL

tbl_TEXT

tbl_ITEM

Detail and ITEM tables from SAP has too many entries. When I tested in development for 14 PO header it had 1500 detaills, 500 text and 800 items. So i am thinking of breaking down of these PO headers in abap client proxy to trigger the abap proxy for every 50 PO header. So that it would not end up with huge PO details and text.

I am thinking of modifyin the abap code to send 50 PO header each time in client proxy.

loop on PO headers.

if lv_counter is 50.

call method to send via client proxy.

then next 50 records. so that we are sending in chunks.

PI would receive in multiple messages with consisting of 50 PO header and many item details. Does update/insert on JDBC table would affect. what precautions shd i take in PI considering update on JDBC

Kindly suggest with any inputs.

Thanks in advance.

[former_member229310]

resolved

[Former Member]

Hi,

You can use the update_insert option of the receiver jdbc canonical structure.

This would ensure that rows already existing would be updated and only the delta would be inserted into the tables.

Regards