Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Read Data from one client to another client/

0 Likes
3,803

Hi Gurus,

How to read a data from one client to another client both in same server ?

Let's say the program is in client A and will read the table z.... in client B. ?

Kl. Guide me .....

Thanks and Regards,

Murugesh R

Hi Gurus,

How to read a data from one client to another client both in same server ?

Let's say the program is in client A and will read the table z.... in client B. ?

Kl. Guide me .....

Thanks and Regards,

Murugesh R

3 REPLIES 3
Read only

Former Member
0 Likes
1,907

assume that you are in client 100, and you want client 800 data then...

you have to use the addition CLIENT SPECIFIED

REPORT  ztest_clien.

DATA: sflight TYPE sflight.

SELECT SINGLE *
 FROM sflight
 CLIENT SPECIFIED
INTO sflight
WHERE mandt = '800' AND
      carrid = 'AA'

.

Read only

former_member585060
Active Contributor
0 Likes
1,907

Hi,

Use CLIENT SPECIFIED WHERE MANDT = 'XXX'.

this client specified is used for accesing records of a table from other client to existing client. as u give mandt as a first field of a tbale then table becomes client specific so which others users of other clients can't access that table. to access that kind of tables we use CLIENT SPECIFIED st in select query.

Ex:-

SELECT * INTO wa FROM (name)

CLIENT SPECIFIED

WHERE mandt = '000'.

......

ENDSELECT.

Read the SAP help documentation here

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb39c4358411d1829f0000e829fbfe/content.htm

Read only

0 Likes
1,907

Gurus..

Thank u very Much... I rewarded both of yuu..

Thanks & Regards,

Murugesh R