client specified

[Former Member]

hi all,

In select query in where condition if we mention client specified

what is it mean

[Former Member]

Hi,

If we specify the client specified then we need to mention MANDT also as one of the where clause .

"If you use this addition, you can then address the client fields in the individual clauses of the SELECT statement."

Thanks,

Greetson

[Former Member]

Hi,

in one server itself many clients are maintained...

you will logon by entering your client code....

its picks the value from your client table

Regards,

V.Balaji

Reward if Usefull...

[Former Member]

Hi,

SELECT... FROM <tables> CLIENT SPECIFIED. ..

If you use this addition, you can then address the client fields in the individual clauses of the SELECT statement.

You know that data in tables are client dependent.So if you want to see all clents data for given where condition in select statement

you have use CLIENT SPECIFIED addition.

[Former Member]

hi,

Suppose u r login with client 800, and u wnat to select data from client 810.if the table is client independent then only we can select data from other clients.

then in SELECT query u have to specify mandt field with where condition.

*select * from <dtab> into <itab> where MANDT = '800'.*

thanks,

raji

reward if helpful