Client Field in the Table

[Former Member]

Why do we provide the Client Field while creating a Table?

[Former Member]

Why do we provide the Client Field while creating a Table?

[Former Member]

hi sai

it will have client details

so for having client details we can include MANDT

Suppose we are creating a z-table i.e employee table, if we include the field MANDT or client field in the table than after activating the table, it becomes a Client Dependent table. However if a table doesn't have MANDT field in it, it's independent of a client in SAP.

If a table is client dependent than the data for that table can be different for different clients.

if you dont use MANDT as key of the table, table will become client independent

regards

navjot

reward if helpfull

Message was edited by:

navjot sharma

[Former Member]

Type a name for the client say MANDT.

TYpe should be MANDT. Mark it as a key field.

Regards,

Ravi

[Former Member]

We provide client field(mandt) to make the table client dependent. See table mara.

The table which dont have that field (like: E070 or E071) become client independent.

[Former Member]

hi,

In SAP, all objects are finally stored as tables.

"Mandt" is key field which determines whether the object is client dependant or not.

Client Independant transport requests will make the transported objects available across the clients.

and Client dependent transport request make the objects available only for the client mentioned by field "Mandt"

Regards

Reshma

[Former Member]

Hi,

There are two types of tables 1. client dependant and 2. client independent

1. client dependant : This tables have first field name as MANDT and data elemetn MANDT. whenever data is inserted this field is automatically filed with current client no, (sy-mandt). Data from this tble can be accessed in same client.

2. client independant : This is client independant table means all entreis in that table will be avaliable in all clients. some general setting tables are client independant.

Award if it helps.

Jogdand M B

[Former Member]

hi,

if we want to make that particular table as CLIENT DEPENDENT then we make

Client Field for that table so that the data entered by one client wil not be able to acess by other cleint...this give some sort of security for the data so that it wont be seen by unauthorized users.

reward if helpful

ravi

Message was edited by:

ravi r

[Former Member]

By doing that..u are going to decide whether it is a

<b>Client dependent</b> or <b>Client Independent</b>.

If u specify <b>MANDT</b> as a first field,

the table will be<b> client dependent</b>. So the data in that table will not be shown or accessed to thhe other client, but the same table structure is used by both the clients.

[former_member196299]

HI Sai ,

Below are the significance of having a client field.

MANDT field is the client field . It helps in identification of a table whether it is client dependent or client independent.If a table is client dependent than the data for that table can be different for different clients.MANDT is always one of the primary keys of a table .

Hope this info makes you clear about the client field.

Reward if helpful !

Thanks

Ranjita