Cross client data read

[Former Member]

Hi Experts

select * from zemp

into corresponding fields of table itab

where sy-mandt = 391.

Can we read data of database table from cross clients.

i used abv query, says error.

regards

Rajaram

[Former Member]

use the client specified addition.

SELECT *

FROM ZEMP CLIENT SPECIFIED

INTO TABLE ITAB

WHERE mandt = '000'.

[Former Member]

Hi

I trid as follows

SELECT * FROM zemp CLIENT SPECIFIED INTO table itab

WHERE MANDT = '392'.

But am getting the error as follows,

The work area "ITAB" is not long enough. long enough.

What could be the reason,

regards

Rajaram

[kiran_k8]

Raja,

Check the itab structure.

K.Kiran.

[Former Member]

declare itab as follows...

data itab type table of zemp.

SELECT * FROM zemp CLIENT SPECIFIED INTO table itab

WHERE MANDT = '392'.

[Former Member]

Hi,

Add the keyword CLIENT-SPECIFIED in your select query....

Best Regards.

[Former Member]

u have to use like this

select * from zemp

into corresponding fields of table itab client specified

where sy-mandt = 391.

for better clarity

SELECT * FROM SCUSTOM CLIENT SPECIFIED INTO WA_SCUSTOM

WHERE MANDT = '003'.

if any query....revert

[Former Member]

Use a function module for cross client it would be more recommandable and easy if we need any cross client data.

Declare the Cross client function module like this.

Declare like this.

DATA: LOC_REMOTE_CLIENT TYPE GSVAL.

*FOR FETCHING VENDOR NAME*

CALL FUNCTION 'ZGET_VENDOR_NAME' DESTINATION LOC_REMOTE_CLIENT

TABLES

TLFA1 = INT_LIF.

Thanks,

Sakthi