Read external datbase & update the data in SAP database.

[Former Member]

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,

[Former Member]

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.

[Former Member]

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,

[Former Member]

which BAPI are you using ?

[Former Member]

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.

[Former Member]

HR_INFOTYPE_OPERATION

[Former Member]

hi,

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

[Former Member]

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

[Former Member]

use t-code BAPI for find bapi

check bapi description which will be suitable for you

[Former Member]

Hi,

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

Thanks

Nitesh