topic Re: select data in an other database in Application Development and Automation Discussions

select data in an other database

Former Member — Tue, 22 Aug 2006 08:12:59 GMT

Hello

My program is in a system, and i want to select data from EKKO table in an other database system like that :

select SINGLE ebeln

g_ebeln

FROM ekko

WHERE ebeln = gs_poheaderc-po_number.

How can I do?

thank you in advance.

Peggy.

dani_mn — Tue, 22 Aug 2006 08:15:47 GMT

HI,

from selection of data from other R/3 systems, you need RFC enabled function module.

create a function module and make it remote enabled. then give the server name in destination parameter.

Regards,

HRA

Former Member — Tue, 22 Aug 2006 08:17:57 GMT

Hello,

For this u have to create a RFC Enabled Func. Module.

Try like this

CALL FUNCTION <b>'Z08V_RA_D_P38ORD_FM'</b> DESTINATION 'D38_011'

EXPORTING

I_VBELN = P_VBELN

TABLES

IT_VBAK = G_T_HEADER

EXCEPTIONS

TEST1 = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE 'E' NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF

The FM which is mentioned here should be created in the destination sytem. ie) the system from where u are getting the DATA from EKKO.

If useful reward.

Vasanth

andreas_mann3 — Tue, 22 Aug 2006 08:31:49 GMT

hi,

1) get the table ekko with fm TABLE_ENTRIES_GET_VIA_RFC

2) get your item with read table from the imported itab

Message was edited by: Andreas Mann