topic Re: RFC help!!! in Application Development and Automation Discussions

RFC help!!!

Former Member — Wed, 01 Jul 2009 03:10:28 GMT

Hi Experts,

I want FBA(functional Business Area) of an employee to be captured from HR system. I am doing my development In sandbox server and want to fetch data from HR system. using SM59 I had made a connection to HR system which on connection test is successful. Now I want get FBA of an employee from HR system. Does anyone have idea which FM to use to retreive data from HR system.

Re: RFC help!!!

andreas_mann3 — Wed, 01 Jul 2009 13:53:02 GMT

use fm like

RFC_GET_TABLE_ENTRIES with table like PA01

Re: RFC help!!!

Former Member — Wed, 01 Jul 2009 17:31:17 GMT

Look this Fm TABLE_ENTRIES_GET_VIA_RFC or RFC_READ_TABLE

Regards

Gregory

Re: RFC help!!!

Former Member — Fri, 03 Jul 2009 06:38:27 GMT

how to specify where clause while fetching the data like select * from pa077 where pernr = pernrno and endda = '99991231'.

Re: RFC help!!!

Former Member — Fri, 03 Jul 2009 13:01:35 GMT

You need put the conditions in the table OPTIONS, for example:

MOVE  ' PERNR  EQ '  PERNSNO 'AND ENDDA EQ ''99991231''  '
      TO wa_options-text.
      APPEND wa_options TO ti_options.

Regards

Gregory

Re: RFC help!!!

Former Member — Mon, 06 Jul 2009 07:31:11 GMT

actually the field selection will be dynamic as it can be endda or usnam or some other fields. so in that case how to populate the option table.

Thanks.