topic Re: when to include mandt in a z table? in Application Development and Automation Discussions

when to include mandt in a z table?

Former Member — Thu, 07 Feb 2008 15:22:15 GMT

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

-- Ven

Re: when to include mandt in a z table?

Former Member — Thu, 07 Feb 2008 15:27:28 GMT

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,

Re: when to include mandt in a z table?

Former Member — Thu, 07 Feb 2008 15:42:00 GMT

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.

Re: when to include mandt in a z table?

Former Member — Thu, 07 Feb 2008 16:04:51 GMT

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

Re: when to include mandt in a z table?

Former Member — Thu, 07 Feb 2008 16:50:36 GMT

I split the points

Re: when to include mandt in a z table?

Former Member — Fri, 08 Feb 2008 06:29:42 GMT

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.