CLIENT SPECIFIED word in Select statement..?

[Former Member]

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.

[Former Member]

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

[JozsefSzikszai]

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

ec

[Former Member]

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

[Former Member]

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

[dhruv_shah3]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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,

CK