[JDBC to RFC] select 2 tables(header, item) and interface to 1 rfc.

[JohnPark]

Oracle database table has 2 tables which is header and item.

the data enter to 2 tables. and SAP XI select from the tables. and create sales order in SAP ERP.

A SAP RFC funcation has 2 TABLE parameters which is HEADER and ITEM.

I think use ccBPM. but I don't know how to design.

could you answer for me?

[Former Member · Accepted solution]

Hi,

you do not need BPM.

You could read the database at once if the oracle developers provide you a stored procedure.

Also if the RFC is able to receive header and items at once, BPM is not neccesary.

Regards Mario

[Former Member · Accepted solution]

oracle database programmer not worked right now.

and they don't want to any change in DBMS.