Select Query

[Former Member]

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

[Former Member]

it will work

You can use for the tables which are client dependent.

Reward Points if this helps,

Satish

[Former Member]

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.

[Former Member]

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.

[former_member386202]

Hi,

Yes it will work but only for client dependent table.

Regards,

Prashant

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

Regards,

Satish

[Former Member]

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?

[Former Member]

Yes... you are right...

Regards,

Satish

[Former Member]

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

[Former Member]

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

Rob

[Former Member]

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

[Former Member]

the moment u use CLIENT SPECIFIED,

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

[Former Member]

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.