Update the Oracle Table using BAPI

[Former Member]

Hi All,

I would like to update Oracle Data Base with my custom BAPI using the Business Logic Transaction.

Could any one please give me some logic how to do it?.

Thanks

R M

[agentry_src · Accepted solution]

RM,

Let me try to understand what you are trying to do.

Execute a transaction which runs a BAPI to retrieve information from SAP which you will then use to update fields/tables in an external (to SAP/NetWeaver) database. Is this correct?

Regards,

Mike

[Former Member · Accepted solution]

Hi Mike,

You are right.

But the thing is I need to update the Oracle Table using the BAPI in BLT.

Now i am able to get the BAPI in to my BLT using the JCO Action ,then I need to use the BAPI data and update the Oracle table.

Thanks

Raghav

[Former Member · Accepted solution]

RM,

Please follow the steps below:

1) Create and Configure the Data Server for the database you want to access/update (basically

you are creating a database connection here).

2) Save and test the connection by clicking the 'Status' button

3) Create new query template with template type as 'SQL Query' and select the server you have

configured in step#1

4) Select the mode as 'Command' and type-in your Insert/Update statements in the 'Fixed Query'

tab. For example: insert into yourtable values ('[Param.1]','[Param.2]')

5) Test the query by passing parameters from the 'Parameters' tab. You are supposed to get a

'Command Execution Successful' message if the data is successfully posted to the database.

6) Create a 'SQL Query' action block in your Business logic transaction to access the above query

and map your Param.1, Param.2 etc. to your BAPI result (on the Link Editor).

Hope this helps.

John

[former_member192939 · Accepted solution]

RM,

To update a Oracle DB,

Add the DB to the "Data Servers"

Develop a "query template" to insert data to this DB

Use the query template in the BLT action blocks

Good luck,

Ajay.

[agentry_src · Accepted solution]

John,

For clarity sake, please wrap the code mark up around your example so he can see it as you meant it to be. The automatic formatting is making a hash of what you are trying to present. Look to the right of your Message editing box for the syntax

Thanks,

Mike

[former_member192939]

RM,

I guess you are trying to use a BAPI to update the ERP transactions / DB.

First you must configure the SAP ERP Connection.

In the BLS use SAP JCo action block.

Refer MII help.

Good luck,

Ajay.

[Former Member]

Hi Ajay,

I did the SAP connection using the JCO Action block. I want to use BAPI and using that I need to update the third pary database Oracle.

I need some Logic in BLS.

Thanks

RM