cancel
Showing results for 
Search instead for 
Did you mean: 

Query of Database to proxy scenario

Former Member
0 Kudos

Hi All,

I have to extract data from two tables in a database and need to update the details in SAP.

What all objects do we need to create in IR and ID.

Does this scenario involve BPM in it.

Thanks in Advance,

Younus

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Younus !

Are tables related or independent? if related, maybe you can extract the data as one unique query, using a JDBC-XI-RFC/IDOC/Proxy scenario. If tables are not related, you will need to have two different scenarios.

To read data from database, use the JDBC adapter, to put data in SAP, you can use the RFC adapter, IDOC adapter or ABAP Proxy, depending on the SAP version and kind of data..e.g. there could be a standard IDOC type that is already used to manipulate that type of data.

IR:

- if target is IDOC or RFC, you can import those definitions directly from R/3.

- if target is ABAP Proxy, you should create the proxy in R/3 using SPROXY transaction

- for source message, create data type and message type

- create message mapping and interface mapping if needed

ID

- create comm channels

- receiver determination

- sender agreement for the jdbc comm channel

- receiver agreement for the rfc/idoc comm channel

As far as I understand, with the info you posted, you don't need BPM.

Regards,

Matias.