topic Application table should be client-specific in Application Development and Automation Discussions

Application table should be client-specific

Former Member — Fri, 25 Jan 2019 07:43:20 GMT

Is it mandatory to add a mandt field when created predefined Database Table?

Re: Application table should be client-specific

matt — Fri, 25 Jan 2019 07:47:26 GMT

Yes, if that's what is required. No, if that's not what is required.

Re: Application table should be client-specific

muttepawar-2009 — Fri, 25 Jan 2019 07:52:01 GMT

Yes : it is mandatory to add a mandt field when created predefined Database Table.

Regards

Prashant

Re: Application table should be client-specific

matt — Fri, 25 Jan 2019 08:18:32 GMT

No. It isn't.

Not if the predefinition is that it is client independent.

Re: Application table should be client-specific

tamitdassharma — Fri, 25 Jan 2019 09:18:38 GMT

Hello anand07,

It is important to add a mandt field if you are creating a client dependent table. Example: A table which holds data pertaining to users of that tenant or client.

It is not important to add a MANDT field in a cross-client table. Example: A table which contains the name of other tables or programs in a specific system.

Re: Application table should be client-specific

tamitdassharma — Fri, 25 Jan 2019 09:21:08 GMT

Please share a better clear answer as the person who has posted this question might be new to the world of ABAP. Or please refrain from providing such trivial answers and demotivating the person.

Re: Application table should be client-specific

matt — Fri, 25 Jan 2019 09:59:11 GMT

"A table which contains the name of other tables or programs in a specific system."

Not really. You might well want different tables or programs in that table, in different clients of the same instance.

Re: Application table should be client-specific

matt — Fri, 25 Jan 2019 09:59:45 GMT

If a general question is asked,I'll answer generally.

If the OP wants to understand the difference between client dependent and client-independent, then I'd suggest he or she do some research. There's plenty of blogs with this information, and other documentation.