11-23-2007 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??
11-23-2007 12:53 PM
Hi,
Yes it will work but only for client dependent table.
Regards,
Prashant
11-23-2007 12:49 PM
it will work
You can use for the tables which are client dependent.
Reward Points if this helps,
Satish
11-23-2007 12:49 PM
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.
11-23-2007 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.
11-23-2007 12:53 PM
Hi,
Yes it will work but only for client dependent table.
Regards,
Prashant
11-23-2007 12:59 PM
What are the advantages and disadvantages of the clause <b>CLIENT SPECIFIED</b>?
11-23-2007 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
11-24-2007 4:28 AM
Wont it make the SELECT look for the data in the specified client only,instead of all the clients??
11-24-2007 4:34 AM
If you specify the client, then it will fetch from the specified client. You have to specify in where clause.
Regards,
Satish
11-24-2007 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?
11-24-2007 4:47 AM
11-24-2007 4:52 AM
11-24-2007 4:59 PM
No - it won't. If you leave off the CLIENT SPECIFIED, it will only search the current client.
Rob
11-23-2007 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
11-23-2007 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
11-23-2007 3:58 PM
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.