regarding client specified

[Former Member]

hi gurus,

i want to know will the client specified syntax in the seect statement improve the performance of program if yes how do we use it in the selct statement plz let me know......

thnx i advance...

[Former Member]

hi Ravi,

If you want to select across other clients, the FROM clause must include the addition ... CLIENT SPECIFIED .

Refer

[Removed by the moderator.]

After from statement specify CLIENT SPECIFIED statement

.]]>

[Former Member]

Hi

If you accessing the data from the current client, there is no need to use client specified clause in SELECT statement.

You can test the performance of statements side by side using the Performance Tips and Tricks transaction. From SE80 go to Environment->Examples->Performance Examples.

Type in your two select statements (one with client specified and one without) in the two windows and hit the measure runtime button. If you have a reasonable amount of data you should be able to tell any difference.

Regards,

Raj

[Former Member]

Hi,

I believe it is not related to performance...By using CLIENT SPECIFIED..you have to provide the MANDT in the where clause..otherwise automatic client handling is done in OPEN SQL..

Thanks,

Naren

[Former Member]

hi,

select * from makt CLIENT SPECIFIED into table it_makt where <Conditions>.

this client specified is used for accesing records of a table from other client to existing client. as u give mandt as a first field of a tbale then table becomes client specific so which others [users of other clients] can't access that table. to access that kind of tables we use CLIENT SPECIFIED st in select query.

if helpful reward some points.

with regards,

suresh babu aluri.