Application Development 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: 

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

Former Member
0 Kudos
697

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

1 ACCEPTED SOLUTION

Rashid_Javed
Contributor
0 Kudos
137

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

RJv
1 REPLY 1

Rashid_Javed
Contributor
0 Kudos
138

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

RJv