RFC help!!!

[Former Member]

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.

[andreas_mann3]

use fm like

RFC_GET_TABLE_ENTRIES with table like PA01

A.

[Former Member]

Hi

Look this Fm TABLE_ENTRIES_GET_VIA_RFC or RFC_READ_TABLE

Regards

Gregory

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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.