select

[Former Member]

Hi,

how can we fetch data from another client(002)as we r currently working on client001.i.e what select query I have 2 write to fetch data which exists in the server of client002.

Regards

rahul

[RichHeilman]

You can specify the client in your WHERE clause.

where   MANDT = '200'

Regards,

Rich Heilman

[Former Member]

Hi,

It doesn't work.

rahul.

[RichHeilman]

You must use the extenstion CLIENT SPECIFIED also.

report zrich_0001.


data: it001 type table of t001.


select * into table it001 from t001 client specified
                where mandt = '200'.

Regards,

Rich Heilman

[Former Member]

Hi,

I HAVE DONE THIS. STILL I M NOT GETTING OUTPUT.

REGARDS

RAHUL

[RichHeilman]

Are you sure that client 200 is apart of this instance? Or is it a separate instance?

Regards,

Rich Heilman

[Former Member]

Hi ,

you need the extension

select *

from xxx

where mandt = '001'

client specified

regards

Werner

[Former Member]

Try:

SELECT *
  FROM table
  CLIENT SPECIFIED
  WHERE mandt = '002'.
ENDSELECT.

Rob

I had CLIENT SPECIFIED in the wrong place.

Message was edited by:

Rob Burbank

[Former Member]

Query solved.Thanks.

Regards,

Hemant