topic Re: SAP Database in Application Development and Automation Discussions

SAP Database

Former Member — Tue, 17 Apr 2007 04:52:57 GMT

Hi all,

I want to know whether SA has its own database?

If it has what is its name?

Thanks in advance.....

Re: SAP Database

Former Member — Tue, 17 Apr 2007 04:55:02 GMT

hi,

Sorry

Refer to this thread

Regards,

Santosh

Message was edited by:

Santosh Kumar Patha

Re: SAP Database

Former Member — Tue, 17 Apr 2007 04:55:45 GMT

Hi..

SAP is not having its own database.

it will use the databases like Oracle,SQL Server........

and SAP is designed to support different databases.

when you are purchasing the SAP software you have to specify the database system to be supported......

Regards,

Suresh..

Re: SAP Database

Former Member — Tue, 17 Apr 2007 04:56:35 GMT

No SAP dont have its own database

SAP uses Native SQL for fetching data from database server to apllication server

& then using Open SQL it manipulates the data on appln server & then again updates data using native SQL.

Depending on client it can use oracle, sybase, DB2 etc.

Thanks

Sandeep

Reward if helpful

Re: SAP Database

Former Member — Tue, 17 Apr 2007 04:56:41 GMT

hi Shah,

to know which database you are using currently do this way

goto->system-status (u will find the database name used)

Santosh

Re: SAP Database

Former Member — Tue, 17 Apr 2007 04:58:19 GMT

Hi,

The database layer consists of a central database system containing all of the data in the R/3 System. The database system has two components - the database management system (DBMS), and the databse itself. SAP does not manufacture its own database. Instead, the R/3 System supports the following database systems from other suppliers: ADABAS D, DB2/400 (on AS/400), DB2/Common Server, DB2/MVS,INFORMIX, Microsoft SQL Server, ORACLE, and ORACLE Parallel Server.

The database does not only contain the master data and transaction data from your business applications, all data for the entire R/3 System is stored there. For example, the database contains the control and Customizing data that determine how your R/3 System runs. It also contains the program code for your applications. Applications consist of program code, screen definitions, menus, function modules, and various other components. These are stored in a special section of the database called the R/3 Repository, and are accordingly called Repository objects. You work with them in the ABAP Workbench.

regards,

kiran kumar k

Re: SAP Database

Former Member — Tue, 17 Apr 2007 04:59:41 GMT

Hi,

Thnaks i want to know what is the name of SAP database?

And R u sure its having its own database?

Because i am getting different answers....

Re: SAP Database

Former Member — Tue, 17 Apr 2007 05:06:24 GMT

Sorry,

It donot have its own database ...

have a look at this thread

Regards,

Santosh