Skip to Content
0
Feb 17, 2009 at 02:48 PM

SELECT from a remote dictionary table

576 Views

Hi all mates,

I'm trying to make a simple record that, assuming a logical system "target" is specified with a parameter, tries to retrieve all the entries in a dictionary, std table (i.e, the EKPO one, to retrieve Order Requisition numbers of that system) of a remote system.

Example: the parameter I specify is the target logical system: a select option then declared as follows:

SELECT-OPTIONS s_po_id FOR wa_po-object_id.

has a related search help that I would like to do as follows:

AT SELECTION-SCREEN ON VALUE-REQUEST FOR s_po_id-low.

DATA: it_help_item TYPE TABLE OF my_alv_type,

it_return TYPE TABLE OF ddshretval.

SELECT *

INTO CORRESPONDING FIELDS OF TABLE it_help_item

FROM remoteEKPO (that is to say, EKPO in log_sys specified)

WHERE ....

Is something like this possible in an "easy" way? Or the only way to do it is to implement a function in each backend to retrieve the local EKPO via RFC?

Thanks a lot for your help 😉