topic Re: Read Data from one client to another client/ in Application Development and Automation Discussions

Read Data from one client to another client/

murugeshkumar_ramasamy — Sat, 09 Aug 2008 03:26:53 GMT

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

Re: Read Data from one client to another client/

Former Member — Sat, 09 Aug 2008 04:13:34 GMT

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'

Re: Read Data from one client to another client/

former_member585060 — Sat, 09 Aug 2008 04:19:01 GMT

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

Re: Read Data from one client to another client/

murugeshkumar_ramasamy — Sat, 09 Aug 2008 09:06:19 GMT

Gurus..

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

Thanks & Regards,

Murugesh R