Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

client

Former Member
0 Likes
669

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

1 ACCEPTED SOLUTION
Read only

GauthamV
Active Contributor
0 Likes
631

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.

4 REPLIES 4
Read only

GauthamV
Active Contributor
0 Likes
632

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.

Read only

Sm1tje
Active Contributor
0 Likes
631

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.

Read only

Former Member
0 Likes
631

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

Read only

ThomasZloch
Active Contributor
0 Likes
631

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