Application table should be client-specific

[Former Member]

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

[matt]

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

[tamitdassharma]

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.

[matt]

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.

[muttepawar-2009]

HI

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

Regards

Prashant

[matt]

No. It isn't.

Not if the predefinition is that it is client independent.

[tamitdassharma]

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.

[matt]

"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.