difference

[Former Member]

difference between presentation ,application and databaseserver

[RichHeilman]

presentation server is your PC with SAPgui running on it, the appliation server is teh middle teir where the appliation runs, and the database server is where the data is actually stored. In some cases, the application and database layers could be on the same machine.

Regards,

Rich Heilman

[Former Member]

SAP works on three tier architecture, DB level, application server and presentation server hence it is SAP R/3.

The application server is where all the data is fetched from DB and all the processing done.

Presentation server is your desktop which has only GUI and you will be connected to application server from here.

Presentation server is basically the maching on which SAP GUI is installed , so to put it simply the machine from which you access the SAP system i.e. your machine. To access data from presentation server you can use GUI_UPLOAD , GUI_DOWNLOAD function modules.

Application server is basically the SAP Server , to access data from this you need to user OPEN Dataset , close dataset , Read Dataset e.t.c commands,

Please refer to the help for each for more info.

Check out these sample programs to understand the same

http://www.sapdevelopment.co.uk/file/file_downloadsap.htm ( Application Server )

http://www.sapdevelopment.co.uk/file/file_updownpop.htm ( Presentation Server)

Presentaion Server- Where SAP GUI have.

Application Server - Where SAP Installed.

Database Server - Where Database installed.

In General,

Presentation server is basically the maching on which SAP GUI is installed , so to put it simply the machine from which you access the SAP system i.e. your machine. To access data from presentation server you can use GUI_UPLOAD , GUI_DOWNLOAD function modules.

Application server is basically the SAP Server , to access data from this you need to user OPEN Dataset , close dataset , Read Dataset e.t.c commands.

Check out these sample programs to understand the same

http://www.sapdevelopment.co.uk/file/file_downloadsap.htm ( Application Server )

http://www.sapdevelopment.co.uk/file/file_updownpop.htm ( Presentation Server)

[Former Member]

hi,

<b>Presentation server</b> works as user interface.

it is what u see on SAP screen.

<b>Application server</b> works as intermidiate between presentation and database server.

When user put any requirement like execute one report and ask for data, appl server bring that request from presentation server to database server, and when data comes it gives to presentation server for display.

<b>Database server</b> use for data fetching where all tables stores.

[Former Member]

Hi Srinath ji

<b>Presentation Server:-</b>

Software layer in the R/3 System that accepts input from users and returns the results.

<b>Application Server :-</b>Server that provides a range of services to run the R/3 System. An application server consists of a dispatcher and one or more work processes for each service. The dispatcher manages processing requests, and work processes execute them.

Each application server provides at least one dialog service and one gateway.

<b>Database Server:-</b>

Unlike application servers and presentation servers, there is only one database server in your system. You should therefore aim to reduce the database load as much as possible.Here

Reward Points if useful.

Regards,

Shilpi

[Former Member]

SAP R/3 is based on a three tier client/server technology. Typically, it is made up of three functionally distinct layers namely: the user interface, business logic and database.

The user interface, which is otherwise known as the presentation server displays the interface for users' communication with the SAP system. It is often referred to as the SAP GUI. As a matter of fact, it is a program called sapgui.exe. The application server is where the business logic and data manipulation takes place. Data processing, SAP administration tasks and client request/feedback management are handled within the business layer. The database layer is synonymous to the database server and it typically acts as a data repository for tables and other database objects and structures.

Ideally, an R/3 system is composed of one database server, one or more application servers and one or more presentation servers. SAP Business One on the other hand is composed of a database server and one or more presentation servers.