Enterprise Integration Forum : Getting Data from a SAP RFC

Domino Version - 8.0.2
LEI SAP Connector - 1.7.2

We have a SAP RFC which will allow us to get data for Employees from SAP to a Notes DB but cannot get any data returned to us.

The connection document is setup and we can connect to the RFC and select the result table for the table to be used and the Direct Transfer Activity.

In the Direct Transfer document we have all Field Mapping setup and since we do not need to supply any parameters we are keeping the Select Statement field blank. We run the Activity and it starts and ends with no errors or data.

Here is the RFC that we are using where the Tables are parameters that we could supply if we wanted to. For example we can add EMPLY_STATUS.1.STAT2="A" to only get Active employees but that does not return anything either.

FUNCTION rfc_sap_hr_data.
*"----------------------------------------------------------------------
*"*"Local Interface:
*" IMPORTING
*" VALUE(RUN_DATE) TYPE SY-DATUM DEFAULT SY-DATUM
*" TABLES
*" PERNR STRUCTURE ZPPAMICROSPERNR
*" EMPLY_STATUS STRUCTURE ZPPAMICROSEMPSTAT
*" COMPANY_CODE STRUCTURE ZPPAMICROSCMPCODE
*" COST_CENTER STRUCTURE ZPPAMICROSCOSTCTR
*" CONTR_AREA STRUCTURE ZPPALOTUSCAREA
*" PAYROLL_AREA STRUCTURE ZPPAMICROSPAYAREA
*" PERS_AREA STRUCTURE ZPPAMICROSPERSAREA
*" PERS_SUB_AREA STRUCTURE ZPPAMICROSPERSSUBAREA
*" EMPLY_GROUP STRUCTURE ZPPAMICROSEMPLGRP
*" EMPLY_SUBGRP STRUCTURE ZPPAMICROSEMPLSUBGRP
*" JOB STRUCTURE ZPPALOTUSJOB
*" POSITION STRUCTURE ZPPALOTUSPOSIT
*" ORGUNIT STRUCTURE ZPPALOTUSORGUNT
*" ROS_RESULT STRUCTURE ZPPALOTUSRFC
*" ERROR_TABLE STRUCTURE ZPPAMICROSERROR
*"----------------------------------------------------------------------

The IMPORTING value RUN_DATE is defaulted to the current date so we are thinking we do not need to supply that.

Could there be an issues with using LEI/SAP 1.7.2 with Domino 8.0.2 or is there something else we are missing.

Thanks in advance and please let me know if more information is needed.

Enterprise Integration Forum

Resources

Lotus Support

Wikis

Lotus Forums