Abap proxy to JDBC call

[Former Member]

The scenario is Sender is ABAP proxy and receiver side is JDBC adapter.

While creating Purchase order(PO) in SAP, interface should be triggered and it should go and fetch the tax amount from a external Database(DB) and return the tax amount to SAP.

PO can have mulitple line items so for each item it should get the tax amount from DB.

I know we can change the occurence of Statement tag of JDBC structure to unbounded and accomplish multiple stored procedure calls.

But how to handle multiple response from DB for each line item and send it as a single message to SAP.

Is this possible without BPM ?

[Former Member]

Answer is BPM is needed to implement this scenario.

Use u a BPM where first use a splitting logic for PO line items and loop at individual items and do a sync send.

All response of syn send should be appended using a multiline container and use a SA bridge.

[baskar_gopalakrishnan2]

For every purchase order there are mulitple line items and for each line item we need to extract tax amount.

Question: Are these line items are in single db table or different? If it is one table, Why dont you use jdbc lookup during mapping time to fetch item amounts (Just using Select queries.. if the requirement is feasible) ?

If there are multiple tables, receiving response from many tables might not be possible. If response fails from first table then further query to the tables will not proceed. Jdbc treats entire query as one transaction.

[Former Member]

This is the normal behavior of JDBC adapter it execute individual stored procedure call and can not accept array as an import parameter and can not send array as output....

why u wanted all tax code in one go is there any performance issue?