Client Dependent and Client independent Tables

What is a Client in Sap?
In SAP, highest level of organization structure is Client.
The 'Client' is a technical, structural characteristic of the SAP system.
The client concept will be used to logically separate the data in a physical database.

Ex: Development - 100
       Quality - 200
       Production - 300

Whenever we login to SAP system, we login to a specific client. (ie we can only access that Particular Client(100) Specific Data in the R/3 system along with the Client independent  table data, we cannot access the Client specific Data belongs to the  other Clients(200, 300)  ). 
















Client Dependent and Client Independent Tables.

Data in the R/3 system is categorized as client-dependent and client-independent.

Client dependent table:

Client dependent tables are always client-specific. These cannot be accessed from any other client. 




















A client-dependent table has the field MANDT of data type CLNT, which indicates Client id.
A client-independent table does not have this field. First row of any client-dependent table always contains a client dependent field ( MANDT) and it should be primary key along with main Primary Key of the Table .This ‘MANDT’ field contains the client number.

A client-dependent table may have different dataset for different clients.

Client independent table:

Client-independent table are cross-client  i.e. independent of any client, so accessible from any other client and changes made in this table under one client, will be reflected in all the other clients. Hence, a client-independent table will always have same dataset for all clients.





Explanation :  

let us say we have three Clients( Development-100, Quality – 200, Production- 300).
All the 3 Clients  contain a Table ‘ztable’. 

What If ” Ztable” is Client Dependent .
you only able to see the perticular Client (100 or 200 or 300) Specific Data of that Table depending on the Client you have logged in

What If ” Ztable” is Client Independent.
you will be able to see  Same Data independent on  the Client you logged in.





No comments: