go through the SAP application layer instead of access the DB from back-end

[Former Member]

May we access the DB standard SAP tables directly from a third party software?

Why we must to go through the SAP application layer instead of access the DB from back-end directly.?

Do you know if SAP AG don't recommend access the DB from back-end directly ?

is there any sap note about it ?

Thank' s in advance

[Former Member · Accepted solution]

hi,

I guess SAP doesn't recommend their customer to access your SAP database directly. We don't know what is going happened when we access it because of SAP database was so complex.

So I privately says don't. Use SAP application to maintain your SAP database.

ardhian

http://sapbasis.wordpress.com

[former_member204746]

if using Oracle (which is not your case), you bought your Oracle licensing through SAP. Oracle only allows SAP application to reach their database.

if using SQL-server, yif you bought your own MS-SQL licenses, you are allowed to conenct directly to DB... but this is not recommended as you may delete/modify important information from your SAP/MSSQL database. Auditors may not like this.

[Former Member]

Hi Enric

Thank' s for your answer.

it is for read only data of tables KNA1, KNB1 etc.

Only for to do selects with inner joins, left joins and oder SQL statement for read data, not insert or update data.

do you think it is wrong or a bad thing ?

is it more easy and quickly than rfc, web service ?

thanks

[Former Member]

On general principles it's a bad idea to let anything other than SAP access the SAP database. For one thing you're bypassing all the authorization checks you have in SAP. Create a BAPI or service to provide the needed access and keep your DB secure.

Edited by: Michael Evershed on Sep 19, 2008 10:32 PM

[former_member204746]

it is still not a good idea.

Auditors usually are against this, it may be against SOX.

you are risking the integrity of your SAP database. follow Michael's recommendation.