topic Re: client in Application Development and Automation Discussions

client

Former Member — Wed, 17 Mar 2010 13:58:18 GMT

Hi Gurus

Is that all standard tables are client dependent becoz all ahving MANDT as part of .

again is MANDT a primary key or a somewhat like a primary key?

Thanx

Re: client

GauthamV — Wed, 17 Mar 2010 14:11:27 GMT

Use proper subject line in future.

No,not all standard tables are client dependant.

You have tables like TADIR,STXFADM..which are client independent as well.

Re: client

Sm1tje — Wed, 17 Mar 2010 14:12:36 GMT

Well not all SAP standard tables are client dependent, but most of them are. And indeed, this is because of the MANDT / CLIENT field.

True, this field is part of the primary key, but it does not need to be added in the WHERE-clause when selecting data from a table in ABAP SELECT statement.

Re: client

Former Member — Wed, 17 Mar 2010 14:15:03 GMT

hi sushree,

If any table is having MANDT ie client as a key then that table is a client dependent table and if it doesnot contain mandt then it is client independent.

almost all standard table have mandt key so they are client dependent means their data will differ from client to client.

also client is a primary key but you need not to enter the client while updating the records.

so if you want any table to be client dependent then you have to include mandt key.and it is recommended

hope this will help you.

thanks,

Tanmaya

Re: client

ThomasZloch — Wed, 17 Mar 2010 14:27:49 GMT

Client concept of SAP is well explained in several places, please search before posting, also use meaningful subject lines in the future.

Thread locked

Thomas