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

select from T000

Former Member
0 Likes
3,044

why when selecting from T000 the client is ignored ?

i.e. following select

select * from t000.

will select entries from all clients

You can check also in SE16 that entries for all clients are shown in case of T000.

why when selecting from T000 the client is ignored ?

i.e. following select

select * from t000.

will select entries from all clients

You can check also in SE16 that entries for all clients are shown in case of T000.

7 REPLIES 7
Read only

Former Member
0 Likes
2,676

bcoz of field MANDT

Read only

0 Likes
2,676

Very "helpful" answer.

So why e.g. T001 and all other tables with MANDT behave in another way and with standard select (without CLIENT SPECIFIED) only entries from current client are returned.

First I thougth that's because MANDT is the only key field in the table but there are another tables with MANDT as whole key and they behave 'normally'. I couldn't neither fid any technical settings indicating this unusual behaviour.

Read only

0 Likes
2,676

T000 is table to maintain sap clients itself so it displays all the clients data. T000 is a cross client table.

When MANDT field is present in other tables it indicates that the table is client dependant but in T000 MANDT doesnot signify client dependance but instead it holds all client data.

go SE16N and check the table DD02L there u'll find the characteristics of every table where u can see T000 is not client specific whereas T001 is.

check the screen shot in theis link.

http://www.mariewagener.de/Note.September.2007

кu03B1ятu03B9к

Read only

0 Likes
2,676

Thanks, that explains a lot.

Do you know maybe how to set this flag for tables with MANDT field?

It seems that by default when table with MANDT field is created then the "client dependent " flag is set. Can it be somewhere changed like it is in case T000?

Read only

2,676

the entry is maintained in DD02L table and the field is CLIDEP, but how u can set set values to this i dont know, may be some config through SPRO but i dont have any idea abt it.

кu03B1ятu03B9к

Read only

Former Member
0 Likes
2,676

Bcoz this values are passing ti table d020s and from there fetching values for oyher clients also

Read only

Former Member
0 Likes
2,676

hi

T000 is the Client table ie table to hold all the Clients

while other tables have only one client in which they are created.

Regards