Versions Compared

Old Version 1

changes.mady.by.user Silvan Grüter

Saved on

compared with

New Version Current

changes.mady.by.user Marc Probst

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The SAP Data Providers let’s you import data from SAP HCM. It follows the sample principal as any other data provider.

The following entities are supported.

Entity

Supported

Core Identity

✅

Employment

✅

Employment Types

Functions

✅

Organization Units

✅

Resource

Resource Assignment

Role Assignment

Machine

Unlike other data provider, for the SAP HCM data provider to be working, you need to actually install something on the SAP System which exposes RFC Functions to be used. Please follow the following instructions:

How-to Install the CoreOne SAP Module on a SAP system

Connection Info

For all entity parts you need to specify the connection information which contains the following parameters.

Parameter

Mandatory

Example

Description

Host

✅

SAPHOST01

The SAP host

System Number

✅

00

The system number

System ID

✅

ERP

The system ID

User

✅

cos_sap_service

The user to connect with

Password

✅

🔑 * * * * * * * *

The users password

Client

✅

800

The client to be used

Language

✅

DE

The language to connect with

Info

Some of the return values of some of the data will depend on the language that you choose here.

HcmFilter

The HcmFilter object let’s you filter the data within SAP so that you only synchronise the objects that meet the filters configuration.

Filter

Description

PersonalAreaCode

Selects only employees that match any of the specified personal area codes

OrganizationalUnitRoots

Selects only employee or employment that have an active employment below the the specified root items.

ExcludePositionIds

This let’s you exclude employees, employments or functions that have an employment on any of the specified positions. You can use this for example to exclude all the employees that are parked on the sap 9999999position.

ExcludeOrganizationalUnitIds

This let’s you exclude employments that contain a specified organizational unit.

ExcludePositionsIdRanges

This let’s you exclude employees, employments on any of the specified positions.

You can define a range of PostionIds that you want to exclued with in de format Low to High.

PropertiesToLoad

The list of HcmFieldDefinitions that need to be loaded whereas each HcmFieldDefinitions has the following parameters:

Parameter

Mandatory

Description

InfoType

The info type where the property is stored on if it’s not a standard info type

TableName

✅

The table the data is stored on i.e. PERSONAL_DATA.

SubTypeColumnName

SubTypeColumnValue

The colum name on the subtype i.e. STREETANDHOUSENO

FieldName

✅

The field on the table i.e. PERNO see also the StandardHcmFieldsfor all SAP default fields.

TableType

✅

Either Simple, Sub or Xml

SubTypeColumnName

Info

All the default SAP values are available in the StandardHcmFields definition so you do not need to be bothered with the specifics below. This documentation is more for real advanced and complex configurations.

Some data within SAP is stored on a dedicated table with a specific column like the perno on the PERSONAL_DATA table shown below:

...

Those tables with subtypes are for example:

  • ADDRESS

  • COMMUNICATION

SAP Info Types

With the CoreOne SAP Connector you can read all InfoTypes by using the /ITSENSE/EMPLOYEE_GETINFOTYPE function. This function is only called when a non-standard InfoType is used. In most cases all needed information can be loaded with the standard functions. Those functions only access the following InfoTypes:

What

Info Type

Organizational Assignment

Infotype 0001

Personal Data

Infotype 0002

Addresses

Infotype 0006

Communication

Infotype 0105