topic Re: Read external datbase & update the data in SAP database. in Application Development and Automation Discussions

Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:09:40 GMT

My requirement is the user will be entering HR master data in a new software called PHR.Now my requirement is to read the PHR data base directly & update the same data in SAP database.

How this can be done please guide.

Regards,

Re: Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:11:54 GMT

Hi Abhut,

Directly updating the SAP standard tables is not recommended and it is highly dangerous.

For your requirement, either you can use BDC / LSMW or standard FMs / BAPIs to put the data into HR database. This will ensure checks are carried out and consistent data only gets updated.

regards,

amit m.

Re: Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:14:09 GMT

We'll be using BAPI's to update database in SAP.But how to read the data i.e. in other software via SAP.

Regards,

Re: Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:21:30 GMT

which BAPI are you using ?

Re: Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:23:10 GMT

Hi again,

There are a couple of options, for the approach:

1. DBCON - Secondary database connection

Using this you can setup (with help of basis team) SAP to secondary database connection

and fetch data from those tables.

2. Files :

If the data can be downloaded from the 3rd party software to files, then sap program can read those files (either manually using gui_upload or using ftp concept) and run the bapis.

regards,

amit m.

Re: Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:23:47 GMT

HR_INFOTYPE_OPERATION

Re: Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:25:00 GMT

Hi,

For this you need to connect your SAP database with external database. The same can be done by using DBCO transaction.

Thanks

Nitesh

Re: Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:29:01 GMT

hi,

HR_INFOTYPE_OPERATION is not an actual BAPI, rather a FM opened to customer use, its not even RFC enabled...

Re: Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:34:20 GMT

I suppose we can create a Z function module RFC enabled to read data & use the same FM to update the data.

Re: Read external datbase & update the data in SAP database.

Former Member — Mon, 18 Jan 2010 07:43:24 GMT

use t-code BAPI for find bapi

check bapi description which will be suitable for you