client dependency

[Former Member]

Hi all,

Could anybody tell me about client Dependent and client independent ?

ABAP programs , Tables are client Dependent or client independent ?

[Former Member]

Hi Subodh,

You can make any table as CLIENT DEPENDENT by adding field MANDT as First field in your table.

If you table is CLIENT DEPENDENT then when you will use select on that table only those records will be fetched for which MANDT will be current CLIENT ID.

For example in your table 6 records are there. For 2 records MANDT is 100, for another 2 its 200 for rest 2 it is 300.Now you are login in client 100 then you will get only 2 records out of 6 if your table is CLIENT DEPENDENT and you will get 6 records if your table is CLIENT INDEPENDENT

Mukesh Kumar

[Former Member]

hi subodh,

table become client dependent if you include mandt field as first field in DB table.

it will then take data from that client only.

all other tables are client independent.

Regards,

Talwinder

[Former Member]

Hi, it help u

client dependent means only one particular client can access the things rather than all.In this case all the users corresponding to that client are responsible for that.ex:local objects.

client independent means all the clients can access any thing without any problem.this comes under repository objects.Ex: global objects.

regarding the tables as mukesh said is correct .

regard,

vasavi.

[Former Member]

Hi,

If MANDT field is used in the table & it's a primary key. then the table is client dependent.

Programs r not client dependent.

Thanks

ANUPAM

[i048168]

Hi,

The following thread will be useful.

Regards

Vadi

[Former Member]

Client Dependent - the tables which are having MANDT field (client field), these tables cannot be accessible by different clients, eventhough in the same system. The data in these tables will differ in clients.

Client Independent - the tables which are not having MANDT field, for example, some sap standard tables like country tables, language tables, currency settings and all cross-client tables. If you change any data it will get affected in all the clients.

[Former Member]

Hi

Client independent and client dependent tables does not exit only Client independent and client dependent data exists that means the structres of the tables and programs are always client independent that from any client u can see the any clients prgs and structres of the tables but data is client dependent

i.e. by adding a field mandt in u r atble u can make the table data as dependent on tht particular client

still if u have any quiries u can contact me on mutyalasunilkumar@gmail.com

plzz reward if i am helpfulll

[Former Member]

hi,

Client dependent means suppose if you have 2 clients in Development server like 025 and 125 .

Normally all the tables are client dependent tables means first field is MANDT (char 3 type ).

the data available in 025 client is different from client 125 data.

While using selection from these tables also we can restrict data fetch in the program as shown below.

select * into table it_mara

from mara

client specified

where mandt = '025'.

So it fetches data from 025 client only.

By default,only data from the current client is selected (without you having tospecify the client field specifically in the WHERE clause). If you want to select data from several clients, you must use the ...CLIENT SPECIFIED addition in the FROM clause as shown in the above example.

Regds

Sivaparvathi

Please reward points if helpful...

[Former Member]

Hi,

I will just give you an example.

Let say both of us are working on same report.

I am making a change in a table which is being accessed by the report. let say I am updating some data.

You are also working on the same report and now as the data is updated by me in the table, you will get the wrong data for your testing.

This situation is avoided if we both are working on same program under different client.

deserve reward.

regards.

[Former Member]

This message was moderated.