topic Re: client specified in Application Development and Automation Discussions

client specified

Former Member — Fri, 28 Mar 2008 00:55:41 GMT

hi all,

In select query in where condition if we mention client specified

what is it mean

Re: client specified

Former Member — Fri, 28 Mar 2008 01:56:41 GMT

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

Re: client specified

Former Member — Fri, 28 Mar 2008 02:03:10 GMT

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

Re: client specified

Former Member — Fri, 28 Mar 2008 02:41:56 GMT

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.

Re: client specified

Former Member — Fri, 28 Mar 2008 04:17:00 GMT

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