How to read data from function module ?

[Former Member]

Most of the standard IdM job templates make use of  below ‘FromSAP’ pass to fetch data from table or help values.

There are situations where we may not required to read all data from SAP Table. So we usually end up reading bulk volume of data from SAP Table and apply filter or custom scripts to skip through irrelevant records. It is a kind of cumbersome process as we may not have proper filter condition and sometimes reading too much volume would severely hit on performance. In such scenarios function modules come as handy.

Function modules are procedures that are defined using special ABAP programs. It plays an important role during interaction between different SAP systems through remote communication. Consider below function defined at the target system (SE37 transaction) that aggregates information from different tables and returns only the required data.

Following screenshots gives you an idea of how to execute the same from ABAP

On execute after setting import parameter say IT_DETAILS=X

On selecting ET_CUSTOMERS above

Similarly data can be retrieved at SAP NW IdM by using a ‘From Custom’ pass type called ‘FromSAPIdentity’ in a job.

The configuration of pass is as below

Parameter	Value
ENTRY TYPE	FUNCTION
FUNCTION	<FUNCTION MODULE NAME>
PARAMETERS	Syntax: <IMPORT PARAMETER WITH VALUE SET> Examples: IT_DETAILS=X DEPARTMENT=Y
NAMEFIELD	Export Parameter with column name separated by colon (:) Syntax: <EXPORT PARAMETER:RETURN FIELD1 |EXPORT PARAMETER:RETURN FIELD2> Examples: ET_CUSTOMERS:CUSTOMERID|ET_CUSTOMERS:NAME EMPLOYEE:NAME|EMPLOYEE:WORKPLACE