when to include mandt in a z table?

[Former Member]

When creating a Z table, when is the MANDT field mandatory and when not?

-- Ven

[Former Member]

Hi,

Mandt - It specifies wheather a table is client dependent or client independent.

If mandt is present the table is client dependent.

If mandt is not present the table is client independent.

Client Dependent :

If u declare a table as a client dependent , that table can be used with in that particular client , other clients can't access that table.

here we should specify first field is mandt.

Generally SAP Script is a cleint dependent, we can't use this Scripts directly to other clients without some conversion.

Client Independent :

If u declare a table as a client independent, We can access this table other client also.

here we need not to specify first field is mandt.

Generally Smart forms are client Independent, We can use those Smart forms into other clients also.

because when activating one Smart form, system automatically generate the one function module automatically.

.

Reward if helpful.

Regards,

[Former Member]

MANDT field is never mandatory. If you think you need to separate data between different clients in the same system, you need to have MANDT field in the table.

Typically, if the table is configuration table, you don't need MANDT field. If it is an application data table, you should have MANDT field.

Bottom line, you are better off keeping a MANDT field in all the application the tables.

I don't use a MANDT field when the table is used for data extracts (for further loading into external databases such as BW) since we have only one client in production system.

[Former Member]

hi

if u want u r ztable to be client dependent then u declare mandt feild.

and if u want it to be client independent then dont use mandt feild

[Former Member]

I split the points

[Former Member]

Mandt - It specifies wheather a table is client dependent or client independent.

If mandt is present the table is client dependent.

If mandt is not present the table is client independent.

Client Dependent :

If u declare a table as a client dependent , that table can be used with in that particular client , other clients can't access that table.

here we should specify first field is mandt.

Generally SAP Script is a cleint dependent, we can't use this Scripts directly to other clients without some conversion.

Client Independent :

If u declare a table as a client independent, We can access this table other client also.

here we need not to specify first field is mandt.

Generally Smart forms are client Independent, We can use those Smart forms into other clients also.

because when activating one Smart form, system automatically generate the one function module automatically.