topic Re: client dependent tables in Application Development and Automation Discussions

client dependent tables

Former Member — Wed, 24 May 2006 10:00:10 GMT

hai all,

in client dependent tables ,if we make changes in a table will it reflect in other client, suppose the same table is available in other client with same field which we changed?

gopan

Re: client dependent tables

andreas_mann3 — Wed, 24 May 2006 10:04:20 GMT

if you make a change with se11 - it have consquences for all clients - because the structure of the table is not client-dependent - only the content of the table

Re: client dependent tables

Former Member — Wed, 24 May 2006 10:04:21 GMT

Hi,

Did you mean you altered the table structure? then yes the change will be affected at all other clients. Because tables are not really client depedent ever, its just that the records at the table whose first field is MANDT with type MANDT, are client depemdents.

Rgds,

Deb.

Re: client dependent tables

Former Member — Wed, 24 May 2006 10:04:48 GMT

Hi gopan,

1. the same table is available in other client w

I think there is some confusion in this statement.

2. When we say different client,

it means,

a) There is only ONE BOX (Server)

b) In that there is ONLY One database

c) The database contains tables

d) The tables contain ONE EXTRA COLUMN

e) This EXTRA COLUMN is called Client (MANDT)

3. So if a table is client dependent,

it means, it has one extra column for client (MANDT)

4. All RECORDS,

of all clients (on this server)

will be contained in this table only.

(and not any other table / server)

5. So if we make one record change ,

It won't appear in another client

6. BCOS CLIENT FILTERATION while selecting records

from table, is AUTOMATICALLY DONE BY R/3.

regards,

amit m.

Re: client dependent tables

suresh_datti — Wed, 24 May 2006 10:05:55 GMT

if you are talking about data it will not be reflected.. you have to use Tcode SCC1 to copy the data over to different clients..

Regards,

Suresh Datti

Re: client dependent tables

Former Member — Wed, 24 May 2006 10:07:50 GMT

only the data in the table is client-dependent...the structure will definitely be reflected to other clients if u change in one....

Re: client dependent tables

nishanthbhandar — Wed, 24 May 2006 10:10:43 GMT

Changes will not be reflected if the table is client dependent.You need to transport the changes to the other clients.

Cheers

Nishanth

Re: client dependent tables

Former Member — Wed, 24 May 2006 10:29:02 GMT

GOOD

THESE ARE SOME CHARACTERISTICS OF CLIENT DEPENDENT AND CROSS CLIENT TABLES.

Client-Dependent Tables

Class A and C: Data is only imported into client 000. Existing data records are overwritten.

Class E, S and W: Data is imported into all clients. Existing data records are overwritten.

Class G: Existing data records are overwritten in client 000. In all other clients, new data records are inserted, but existing data records are not overwritten.

Class L: No data is imported.

Cross-Client Tables

Classes A, L and C: No data is imported.

Classes E, S, and W: Data is imported. Existing data records with the same key are overwritten.

Class G: Non-existent data records are inserted, but no existing data records are overwritten.

THE ANSWER OR YOUR QUESTION IS YES,CHANGES WILL REFLECT IN ALL THE CLIENT.

THANKS

MRUTYUN