What is Client Dependent and Client Independent

[Former Member]

hi to all

some one asked me,

what is Client Dependent and Client independent in SAP

thanks

[Former Member · Accepted solution]

In SAP, highest level of organization structure is client.Whenever we login to SAP system, we login to a specific client. Data in the R/3 sytem 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. First column of any client-dependent table is always client(type MANDT) by default and itu2019s a primary key, this field contains the client no.

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.

Identifying the client dependent and independent tables:

Check table DD02L is having a field named CLIDEP which is with the short-text u2019flag-indicating client-specific entriesu2019. Execute this table. Records having CLIDEP(Client-speicific) checked as u2018Xu2019, are containing tha names of client-dependent tables, and rest records are containing the name of client-independent tables.

[Former Member]

Hi

There are two types of objects in SAP, client dependent and client independent.

Objects used in several clients are called client independent while objects used in a specific client is called client dependent. To identify if a table is client dependent, one can use tcodes SE11 or SE12. In the table field attributes, if the MANDT field is present that table is client dependent.

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.

Data which can be access by all user are client independent (no mandt field in table). Data which can be access by some specific user are client dependent (use mandt field in table) .

Mainly the MANDT coloum plays important role.

Regards

Bhaskar

[Former Member]

hello haroon

cleint dependant is , where the data is customizing like abap programs, objects in tables

cleint independant is actually sap orginal data.

warm regards

barkath

[Former Member]

Hi Haroon,

The client concept will be used to logically sepatate data in a physical database.client independent object or data can be accessed by a user in any client but client dependent object can be accessed by a user in the same client to which the object belongs to.you can not see client 100 data login in to client 200.But if the data is client independent all users in client 100 and 200.

Table T000 is a client independent object that you can see login to any client.But usr02 table you will see only the users of same client you loged in ,here the first field will be a client field that is field MANDT.

Regards

Ashok

[Former Member]

Hi,

The main difference in this

Client Dependent tables contain the column mandt as the first column where as client independnt tables don't have this column.

Regards,

Anil

[Esha1]

Hi

The client is a technical, structural characteristic of the SAP system.

In SAP terminology client independent and client dependent is used in BW terminology:

Tables which can be access by all user are client independent (no mandt field in table). This is used in OLAP environment in business information warehouse.

Tables which can be access by some specific user are client dependent (use mandt field in table). This is used in OLTP environment.

Hope it answers your query.