topic Re: Select Query in Application Development and Automation Discussions

Select Query

Former Member — Fri, 23 Nov 2007 12:47:15 GMT

Select * from MSEG CLIENT SPECIFIED......................

Will this work??

On what all kinds of tables can we use the clause CLIENT SPECIFIED??

Will this work on the custom tables??

Re: Select Query

Former Member — Fri, 23 Nov 2007 12:49:21 GMT

it will work

You can use for the tables which are client dependent.

Reward Points if this helps,

Satish

Re: Select Query

Former Member — Fri, 23 Nov 2007 12:49:58 GMT

Hi,

yes it will ....

On any client dependent table you can use this specification, to get the data different from the logon client !!

for more details on client specified refer this link..

https://www.sdn.sap.com/irj/sdn/profile?userid=3552908

Regards,

Sai Ramesh.

Re: Select Query

Former Member — Fri, 23 Nov 2007 12:51:03 GMT

Hi..

It will works for all the tables which having the MANDT field..If ur custom table had MANDT means it will work..

Regards

Bala.

Re: Select Query

former_member386202 — Fri, 23 Nov 2007 12:53:00 GMT

Hi,

Yes it will work but only for client dependent table.

Regards,

Prashant

Re: Select Query

Former Member — Fri, 23 Nov 2007 12:59:05 GMT

What are the advantages and disadvantages of the clause <b>CLIENT SPECIFIED</b>?

Re: Select Query

Former Member — Fri, 23 Nov 2007 13:03:08 GMT

by default the system selects from the current client only if u have not specified.

if u want to switch off this feature u can use client specified and give the mandt values explicitely

Re: Select Query

Former Member — Fri, 23 Nov 2007 13:04:27 GMT

the moment u use CLIENT SPECIFIED,

u have to give value of MANDT field in statements if the table has that field

Re: Select Query

Former Member — Fri, 23 Nov 2007 15:45:58 GMT

The only advantage that I know of is that it will allow you to SELECT data from other clients. It's not something we normally use.

Rob

Re: Select Query

Former Member — Fri, 23 Nov 2007 15:58:35 GMT

Hi,

Yes, it will work only for client dependant tables.

If your customized table have MANDT field in the table, then you can use CLIENT SPECIFIED.

Thanks,

Sriram Ponna.

Re: Select Query

Former Member — Sat, 24 Nov 2007 04:28:02 GMT

Wont it make the SELECT look for the data in the specified client only,instead of all the clients??

Re: Select Query

Former Member — Sat, 24 Nov 2007 04:34:09 GMT

If you specify the client, then it will fetch from the specified client. You have to specify in where clause.

Regards,

Satish

Re: Select Query

Former Member — Sat, 24 Nov 2007 04:42:48 GMT

We specify the client in the where condition.

It will reduce the burden on the data base right???

I mean it will search the data in the specified client only?

Re: Select Query

Former Member — Sat, 24 Nov 2007 04:47:42 GMT

Yes... you are right...

Regards,

Satish

Re: Select Query

Former Member — Sat, 24 Nov 2007 04:52:33 GMT

thanks a lot Satish.This is what I wanted to know.

Re: Select Query

Former Member — Sat, 24 Nov 2007 16:59:13 GMT

No - it won't. If you leave off the CLIENT SPECIFIED, it will only search the current client.

Rob