Accessing data from db table on another client on a separate server

[Former Member]

Hi

We are trying to access data from a db table on client 400 NSQ with a program running on client 200 NSD. We are also trying to find the name of the table in which the connection configuration should be maintained. The two clients are on separate servers.

Regards

B.Garlipp

Edited by: B.Garlipp on May 31, 2010 9:22 AM

[Former Member]

Hi

We are trying to access data from a db table on client 400 NSQ with a program running on client 200 NSD. We are also trying to find the name of the table in which the connection configuration should be maintained. The two clients are on separate servers.

Regards

B.Garlipp

Edited by: B.Garlipp on May 31, 2010 9:22 AM

[Rashid_Javed]

Create an RFC destination for NSQ system client 400 into your system where program is running (in this case NSD Client 200)

Now in your program you can call function module RFC_READ_TABLE (with reference to this destination) to read entries from the other system.

If you know ABAP, In fact you can create a Z RFC FM specific for this tables, so that you get the data in exact structure. This is because RFC_READ_TABLE returns data in text format with a delimiter.

Cheers.

Edited by: Rashid Javed on May 31, 2010 10:36 AM