Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 


Former Member
0 Kudos

What is the significance of client in SAP?


Former Member
0 Kudos

CLIENT is the highest heriarchial unit in any Module in SAP.

In the development business SAP landscape will be divided into 3 systems namely DEVELOPMENT, Testing or Quality and Production.

These are 3 sepearate servers(boxes). they may exist seperately (in 3 system landscape)or sometimes both the DEV and TEST systems together and PRD sepearte(2 type landscape).

This is purely a basis work.

Again coming to each System, there may be different clients in DEV system, as we need diffferent systems to work, one for customizing work, and other for sandbox work and other for Development work(transports), based on the requirements we can define any number of clients.

in PRD there won't be different clients.

Somes times in Quality may exits 2 or 3 clients.

So the requests will be created in DEV in one client and they are released and sent to other systems like QUALITY and PRD once they are perfect.

A single R/3 System can manage the application data for several separate areas of a business (for example, branches). Each of these commercially separate areas in the R/3 System is called a client, and has a number. When a user logs onto an R/3 System, they specify a client. The first column in the structure of every database table containing application data is the client field (MANDT, from the German word for client). It is also the first field of the table key. Only universal system tables are client-independent, and do not contain a client name.

By default, Open SQL statements use automatic client handling. Statements that access client-dependent application tables only use the data from the current client. You cannot specify a condition for the client field in the WHERE clause of an Open SQL statement. If you do so, the system will either return an error during the syntax check or a runtime error will occur. You cannot overwrite the MANDT field of a database using Open SQL statements. If you specify a different client in a work area, the ABAP runtime environment automatically overwrites it with the current one before processing the Open SQL statement further.

Should you need to specify the client specifically in an Open SQL statement, use the addition


directly after the name of the database table. This addition disables the automatic client handling and you can use the field MANDT both in the WHERE clause and in a table work area.

Reading data

Client Handling

As already mentioned, you can switch off the automatic client handling in Open SQL statements using a special addition. In the SELECT statement, the addition comes after the options in the FROM clause:


If you use this addition, you can then address the client fields in the individual clauses of the SELECT statement

these links helps u