client dependent tables

[Former Member]

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

[andreas_mann3]

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

A.

[Former Member]

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.

[suresh_datti]

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

[Former Member]

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.

[Former Member]

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

[nishanthbhandar]

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

Cheers

Nishanth

[Former Member]

HI

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