Kontakt

Ansicht
Dokumentation

RP_HRSFEC_UPLOAD_EEKEY_MAPPING - Program RP_HRSFEC_UPLOAD_EEKEY_MAPPING

RP_HRSFEC_UPLOAD_EEKEY_MAPPING - Program RP_HRSFEC_UPLOAD_EEKEY_MAPPING

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

Important note before executing the report
This report has been developed only for Product Support and is not generally available for customers. Note that this report can cause damage to the key mapping if used incorrectly. However, if you want to use it, please read the instructions carefully or contact SAP Product Support. Make sure you test with a small number of employees before proceeding with bulk changes.

You use this report to to upload Employee Key Mapping entries from a CSV file into the table HRSFEC_D_EEKEYMP.

Integration

You need to upload employee key mapping when employee master data already exists in the system and the replication of employee master data from an external system into the SAP ERP system is planned.

If you start the replication web service without employee key mapping, it may happen that employee master data is duplicated in the system.

Prerequisites

The user needs the authorization to change tables of authorization group PA.

This report uploads a CSV file (comma delimited) with records representing employee key mapping entries.

The report parameter Field Separator (delimiter) determines the delimiter between the values of a line.

The report parameter Includes Header Line determines that the first line is a header line and whether it can be ignored during upload or not.

A record consists of the following values separated by a field separator. The sequence of values corresponds to the following column list of table HRSFEC_D_EEKEYMP:

  1. EMPLOYEE_ID Person ID from source system
  2. EMPLOYMENT_ID Employment ID (source system)
  3. WORK_AGR_ITEM_ID Work Agreement Item ID (source system)
  4. PERNR Personnel number (SAP ERP)
  5. BUKRS Company Code (SAP ERP)
  6. EMPLOYEE_ID_EXT External Person ID (source system)
  7. USER_ID User ID (source system)
  8. PERSON_UUID (source system) It is generated when person data is created in the system. UUID is used for integrating person data in Employee Central with SAP ERP.

Example

EMPLOYEE_ID EMPLOYMENT ID WORK_ARG_ITEM_ID PERNR BURKRS EMPLOYEE_ ID_TEXT USER_ID PERSON_UUID
123456 12345 30023210 32100000 DE01 30023210 30023210 000097FCE66143D184EA523E329D6FAC

The following consistency checks are implemented:

  • Field EMPLOYEE_ID must not be SPACE
  • Field EMPLOYEE_ID has length <= 38
  • Field EMPLOYMENT_ID must not be SPACE
  • Field EMPLOYMENT_ID has length <= 38
  • Field WORK_AGR_ITEM_ID must not be SPACE
  • Field WORK_AGR_ITEM_ID has length <= 38
  • Field PERNR must not be SPACE
  • Field PERNR has length <= 8
  • Field PERNR is numeric
  • Field PERNR has at least 1 corresponding entry in table PA0003
  • Field BUKRS must not be SPACE
  • Field BUKRS has length <= 4
  • Field BUKRS has a corresponding entry in table T001
  • Field EMPLOYEE_ID_EXT must not be SPACE
  • Field EMPLOYEE_ID_EXT has length <= 100
  • Field USER_ID must not be SPACE
  • Field USER_ID has length <= 100
  • Key combined from EMPLOYEE_ID, EMPLOYMENT_ID and WORK_AGR_ITEM_ID is new for table HRSFEC_D_EEKEYMP.
  • Field PERNR can only be assigned to one employment from Employee Central. There might be several entries in table HRSFEC_D_EEKEYMP with same PERNR, but those entries must have the same EMPLOYEE_ID and EMPLOYMENT_ID.

Features

Selection

Deselect the parameter Test Mode for productive run. Only the checks are executed in a test run.

Standard Variants

Output

Activities

Example






Addresses (Business Address Services)   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 5062 Date: 20240520 Time: 131726     sap01-206 ( 58 ms )