2007 Nov 23 12:47 PM
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??
2007 Nov 23 12:53 PM
Hi,
Yes it will work but only for client dependent table.
Regards,
Prashant
2007 Nov 23 12:49 PM
it will work
You can use for the tables which are client dependent.
Reward Points if this helps,
Satish
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
Sai Ramesh.
2007 Nov 23 12:51 PM
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.
2007 Nov 23 12:59 PM
What are the advantages and disadvantages of the clause <b>CLIENT SPECIFIED</b>?
2007 Nov 23 3:45 PM
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
2007 Nov 24 4:28 AM
Wont it make the SELECT look for the data in the specified client only,instead of all the clients??
2007 Nov 24 4:34 AM
If you specify the client, then it will fetch from the specified client. You have to specify in where clause.
2007 Nov 24 4:42 AM
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?
2007 Nov 24 4:47 AM
Yes... you are right...
2007 Nov 24 4:52 AM
thanks a lot Satish.This is what I wanted to know.
2007 Nov 24 4:59 PM
No - it won't. If you leave off the CLIENT SPECIFIED, it will only search the current client.
2007 Nov 23 1:03 PM
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
2007 Nov 23 1:04 PM
the moment u use CLIENT SPECIFIED,
u have to give value of MANDT field in statements if the table has that field
2007 Nov 23 3:58 PM
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.
Bluesky
