topic Re: select in Application Development and Automation Discussions

select

Former Member — Mon, 11 Dec 2006 13:32:12 GMT

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

Re: select

RichHeilman — Mon, 11 Dec 2006 13:34:17 GMT

You can specify the client in your WHERE clause.

where   MANDT = '200'

Regards,

Rich Heilman

Re: select

Former Member — Mon, 11 Dec 2006 13:35:55 GMT

Hi ,

you need the extension

select *

from xxx

where mandt = '001'

client specified

regards

Werner

Re: select

Former Member — Mon, 11 Dec 2006 13:36:08 GMT

Hi,

It doesn't work.

rahul.

Re: select

RichHeilman — Mon, 11 Dec 2006 13:36:35 GMT

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

Re: select

Former Member — Mon, 11 Dec 2006 13:50:21 GMT

Hi,

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

REGARDS

RAHUL

Re: select

RichHeilman — Mon, 11 Dec 2006 13:52:10 GMT

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

Regards,

Rich Heilman

Re: select

Former Member — Mon, 11 Dec 2006 14:47:49 GMT

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

Re: select

Former Member — Fri, 27 Apr 2007 13:19:29 GMT

Query solved.Thanks.

Regards,

Hemant