SAP Database

[Former Member]

Hi all,

I want to know whether SA has its own database?

If it has what is its name?

Thanks in advance.....

[Former Member]

hi,

Sorry

Refer to this thread

Regards,

Santosh

Message was edited by:

Santosh Kumar Patha

[Former Member]

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..

[Former Member]

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

[Former Member]

hi Shah,

to know which database you are using currently do this way

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

Santosh

[Former Member]

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....

[Former Member]

Sorry,

It donot have its own database ...

have a look at this thread

Regards,

Santosh

[Former Member]

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