Tables

[Former Member]

Hi Folks,

How to retrieve data from a table which is in two different clients say 100 and 200 and output that data as a list output.

Cheers,

Sriram.

[vikram_maduri2]

U can retrive data If the tables r clinet indepedent & provided they or on the same database,If they r client dependent U need to use RFC.

[Former Member]

Hi,

data is Client Dependent, we can not access the data from other client,

but you can do it in way, in a Client, get the data into a Internal table, then Download it to Desktop, then come to second internal table, then Upload this to a Internal table, then get the data from this client and List all these data in the output

Regads

Sudheer

[Former Member]

HI,

u can get the data from other clients using RFC.

see the procedure to get the data using RFC from other clients.

rgds,

bharat.

[Former Member]

Hi,

Create a remote enabled function module which fetches the required data by using a SELECT statement. Create destinations in both clients.

Call this function module by specifying the destinations in your report.

Regards

Sailaja.

[Former Member]

hi,

<b>Client Handling</b>

As already mentioned, you can switch off the automatic client handling in Open SQL statements using a special addition. In the SELECT statement, the addition comes after the options in the FROM clause:

SELECT ... FROM <tables> CLIENT SPECIFIED ...

If you use this addition, you can then address the client fields in the individual clauses of the SELECT statement.

DATA WA TYPE SCARR.

DATA NAME(10) VALUE 'SCARR'.

SELECT *
INTO   WA
FROM   (NAME) CLIENT SPECIFIED
WHERE  MANDT = '000'.

  WRITE: / WA-CARRID, WA-CARRNAME.

ENDSELECT.

A condition for the MANDT field is allowed, since the example uses the CLIENT SPECIFIED option. If NAME had contained the value ‘scarr’ instead of ‘SCARR’, a runtime error would have occurred.

regards,

Ashok Reddy

[Former Member]

Using 'client specified' is quite questionable in buisness applications, why do you want to see data of different clients???