topic Re: Cross client data read in Application Development and Automation Discussions

Cross client data read

Former Member — Wed, 27 Aug 2008 10:23:39 GMT

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

Re: Cross client data read

Former Member — Wed, 27 Aug 2008 10:26:10 GMT

use the client specified addition.

SELECT *

FROM ZEMP CLIENT SPECIFIED

INTO TABLE ITAB

WHERE mandt = '000'.

Re: Cross client data read

Former Member — Wed, 27 Aug 2008 10:26:33 GMT

Hi,

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

Best Regards.

Re: Cross client data read

Former Member — Wed, 27 Aug 2008 10:26:48 GMT

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

Re: Cross client data read

Former Member — Wed, 27 Aug 2008 10:28:22 GMT

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

Re: Cross client data read

Former Member — Thu, 28 Aug 2008 05:13:44 GMT

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

Re: Cross client data read

kiran_k8 — Thu, 28 Aug 2008 05:17:28 GMT

Raja,

Check the itab structure.

K.Kiran.

Re: Cross client data read

Former Member — Thu, 28 Aug 2008 05:22:35 GMT

declare itab as follows...

data itab type table of zemp.

SELECT * FROM zemp CLIENT SPECIFIED INTO table itab

WHERE MANDT = '392'.