Can a SQL Server stored procedure call an SAP function module?

[Former Member]

Can a SQL Server stored procedure call an SAP function module.? The stored procedure will be called via a trigger when data records are added to a Z table.

[Former Member · Accepted solution]

I agree with Markus - You should always go through the SAP application layer instead of access the DB from back-end directly. There are load balancing, high availability, and as Markus said security concerns if you do DB back-end access.

SAP certified 3rd party software should support SAP application layer access.

[markus_doehr2]

If it´s a modified program or an own program I would call the function module there instead of "out of the SAP system".

Markus

[Former Member]

Thanks for your reply. This issue came up because it involves a 3rd party software which need to access the Z tables in SAP. Your suggestion would not help in this case. Any other suggestions?

[markus_doehr2]

You have two options:

- the other software can use the RFC SDK and call directly in the system

- the other software can use a database connect

Markus

[Former Member]

Thanks for your prompt reply. I will pass your suggestions to our developers.

[markus_doehr2]

The database connect is "easier" to implement but if you use the RFC, you can keep the control in the backend ERP about permissions etc.

Markus