SAP HCM Data Provider

Introduction

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. Please follow the following instructions:

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 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 `9999999`position.

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 `StandardHcmFields`for all SAP default fields.
`TableType`	✅	Either `Simple`, `Sub` or `Xml`

SubTypeColumnName

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 regular table are for example:

ORG_ASSIGNMENT
PERSONAL DATA

Other data is stored in a table that has a specific record for said data indicated by a SubTypeColumnName and a SubTypeColumnValue. For the example if you would like to read the street address of an employee his would be “SUBTYPE” as the SubTypeColumnName and “1” as the SubTypeColumnValue and “STREETANDHOUSENO” as the FieldName as shown below.

Those tables with subtypes are for example:

ADDRESS
COMMUNICATION