topic Re: CLIENT SPECIFIED word in Select statement..? in Application Development and Automation Discussions

CLIENT SPECIFIED word in Select statement..?

Former Member — Fri, 29 Feb 2008 09:10:38 GMT

Hi All,

Could you pls let me know what is the purpose of the below FM:

CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'

What will happen when we include CLIENT SPECIFIED for select statement like below?

SELECT * FROM GLPCT CLIENT SPECIFIED

INTO CORRESPONDING FIELDS OF TABLE temp_GLPCT

WHERE rclnt = syst-mandt and

RLDNR IN RLDNR and

RRCTY IN RRCTY and

RVERS IN RVERS and

kokrs = kokrs.

Is there any relationship for FM and select query above pls let me know.

Akshitha.

Re: CLIENT SPECIFIED word in Select statement..?

Former Member — Fri, 29 Feb 2008 09:17:44 GMT

Hi,

To get data from another client in the program executed in present client, we use client specified.

<REMOVED BY MODERATOR>

regards,

Ramya

Edited by: Alvaro Tejada Galindo on Feb 29, 2008 5:29 PM

Re: CLIENT SPECIFIED word in Select statement..?

JozsefSzikszai — Fri, 29 Feb 2008 09:17:51 GMT

hi,

with CLIENT SPECIFIED addition you can select data from other client(s) (other(s) than you are currently logged on). The code you inserted does not make much sense, as it is selecting from the same client, so without the CLIENT SPECIFIED addition and the WHERE condition on the client, it would be the same.

hope this helps

Re: CLIENT SPECIFIED word in Select statement..?

Former Member — Fri, 29 Feb 2008 09:17:58 GMT

CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' is an absolete FM in 4.6b.

use the below

Class - CL_FMCY_COPY_HANDLER with Method - CALL_PROGRESS_INDICATOR

Re: CLIENT SPECIFIED word in Select statement..?

Former Member — Fri, 29 Feb 2008 09:20:07 GMT

Hello Akshitha,

It displays the progress indicator in the current window. CLIENT SPECIFIED means it fetches values form the CLIENT which is specified.

For eg. if the client is 100 it fetches values from the table where mandt (client) is 100.

Regards,

Sai

Re: CLIENT SPECIFIED word in Select statement..?

dhruv_shah3 — Fri, 29 Feb 2008 09:20:23 GMT

Hi,

First of all the FM SAPGUI_PROGRESS_INDICATOR will just show you the status of the Program execution i.e where it is currently executing

Second Client Specified is used in select query when you want the data from the specific client in R/3. for e.g

I have to client 100 200

Now i want the data from the Client 100 only then I can mention client specified in my select query for fetching the data.

Also You can use the FM in any Query.......

HTH

Regards,

Dhruv Shah

Re: CLIENT SPECIFIED word in Select statement..?

Former Member — Fri, 29 Feb 2008 09:22:05 GMT

Hi,

'SAPGUI_PROGRESS_INDICATOR' - Just to show what is currently under progress in the program being run.

An add-on functionality.

<REMOVED BY MODERATOR>

Regards,

Ramya

Edited by: Alvaro Tejada Galindo on Feb 29, 2008 5:30 PM

Re: CLIENT SPECIFIED word in Select statement..?

Former Member — Fri, 29 Feb 2008 09:27:13 GMT

Hi,

CLIENT SPECIFIED will pertain to the database tables from where you are querying.

Different clients may have database tables with the same name.

When you specify the client as 800, the database table from where data is to be fetched will be table A of client 800 (suppose) instead of tabale A of client 600 if both these clients have a database table each by the same name.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 29, 2008 5:30 PM

Re: CLIENT SPECIFIED word in Select statement..?

Former Member — Fri, 29 Feb 2008 11:52:42 GMT

Hi,

Probably the 'CLIENT SPECIFIED' key is used only when retrieving the data from the 'Change' tables (esp. CDHDR & CDPOS...etc), besides this, query on the regular tables will be done without this key.

Rgds,