Show TOC

Data Retrieval Using a QueryLocate this document in the navigation structure

Use

With this function, you can use a query to retrieve data within the personnel administration of your SAP ERP HCM system that you want to transfer to SAP NetWeaver Identity Management 7.1.

Features

To retrieve data with the help of a query, create an InfoSet and a query based on the InfoSet. We deliver the following example query:

  • Example query: LDAPEXTRACT604

  • User group: SAPQUERY/L1

  • Work area: global

So that the attributes that you define using your customer-specific query are connected to the delta procedure for the transfer of changed data to SAP NetWeaver Identity Management, the corresponding attributes in BAdI implementations HR_LDP_EXTRACT_PA, HR_LDAP_EXTRACT_PA_ITF and HR_LDAP_EXTRACT_PD must be represented.

Note

Note that the example query contains communication data of the two infotypes Communication (0105) and Internal Data (0032). If you distribute employee-related communication data to SAP ERP HCM using SAP NetWeaver Identity Management, you are advised not to use these attributes in the query and BAdI implementations.

Caution

To ensure the full range of functons, your query must contain the fields personnel number (P0000-PERNR), start date (P0000-BEGDA) and end date (P0000-ENDDA), and the query output list must contain the personnel number field (P0000-PERNR) as ID.

You have to map the query fields to Logical SAP Data Fields, before you transfer the data to SAP NetWeaver Identity Management using the extraction report.

The system calls the function module RSAQ_QUERY_CALL from report RPLDAP_EXTRACT_IDM. This executes the query and returns the results in a table. The system then transfers the query results to the function module LDA_PROCESS_QUERY_RESULT. This formats the data according to the mapping definitions you made in transaction HRLDAP_MAP and transfers the data to the function module SPLDAP_RECEIVE_ATTRIBUTES in the SAP Web Application Server. This exports the data by means of the LDAP Connector to the SAP Identity Management system connected. The data is initially transferred to the staging area you have configured for employee-related data.