How to integrate SAP HR(SuccessFactors) with Ariba for Synchronized Role Based Workflow Approvals
Objective – The objective of this blog is to solve a common issue that today’s customer base faces around Ariba workflow approval based on Role defined in the HR system.
Definition of Role is by Position and Ariba product is not directly integrated to Position Management of SuccessFactors or Business Suite on HANA.
We will discuss a scenario where the customer is having below landscape.
HR Data is stored in the Business Suite on HANA and Ariba is being used for Sourcing and Buying.
Sample Organization Structure
Any Re Organization is executed in the HR box and there is a strong need to synchronize this data into the Ariba system to implement successful Role Based Approval Scenarios.
This blog explains a possible approach which can help an organization run Role Based Approval between SAP ECC Business Suite on HANA and Ariba.
Ariba is divided into primarily Two Areas
- Sourcing (Upstream)
- Buying (Downstream)
Ariba has its own workflow engine which directly cannot consume the HR organization data either from Business Suite on HANA or Success Factors.
The Need is to Extract this data from either of the systems.
Ariba workflow Engine needs following file formats to interpret workflow data.
- Ariba understands Workflow approver by user so each data export is used based.
- Each user can be mapped to Ariba user group.
- Approver User Group
- Initiator User Group
- The basic design definition must start with this step where you determine how would you identify the Approver and Initiator user group.
An approach that this article recommends is very simple.
As we are implementing role based approval the focus needs to go back to the HR solution.
It is important that the Organizational Authority for Approval is clearly understood between both the domains HR and Ariba.
Simple Design Principals
a. Define Approval user group A_<Position ID of Approving employee/user>
b. Define Initiator user group I_<Position ID of Initiating employee/user>
SAP Business Suite Organization Management
Position ID stored in ECC is an 8 digit number that is associated with Each employee in the HR system.
Ariba workflow needs following files to be uploaded in the system.
- Group Export
- Group Consolidated
Above two files are common between Sourcing and Buying solution.
Group Export File
Above table needs to be designed based on example provided. This table stores the description of position and the ID of group which is A_<Position ID of Approving employee/user> or I_<Position ID of Initiating employee/user>.
This file is the master file of all Groups defined for downstream and upstream.
Group Consolidated File
Above file is mapping of all users and their Groupings. User and group mapping will be provided in this file. The file will store A_<Position ID of Approving employee/user> or I_<Position ID of Initiating employee/user> against the user. All Approvers and initiators with appropriate group will be part of this file.
Sourcing part of Ariba needs following files.
- Teams File
For sourcing the teams file carries the approver group and initiator group mapping.
A_<Position ID of Approving employee/user> and I_<Position ID of Initiating employee/user> are mapped as shown above.
The Designation field is determined based on the approval authority determined. For example if the approver is determined in two categories, Direct Manager and Vice President. Above file will have two values for I_20000346, one for A_<Direct Manager Position> and A_<Vice President>.
Designation field will carry value Direct Manager and Vice President.
Sourcing part of Ariba needs following files.
- Lookup Supervisor
- Job Function Export
- Relation Entry
Lookup Supervisor File
Lookup supervisor file is the mapping of initiator group to approver group.
Tool tip can carry any explanation that suits your solution and required field value must be “Yes”.
Job Function Export file
Job Function file need to carry the <Position ID of Initiating employee/user> and job description can be the description of the same position in the ECC system.
Relation Entry File
This file carries the Company code in the leftkey2 field.
Leftkey1 field carries the value of Costcenter and left id field will have both the company code and cost center values concatenated with “_”.
Cost center is associated with employee, it can either be stored in infotype 27 or infotype 1. Your HR consultant will be able to help you get this information easily.
The rest of the fields as shown can carry same values shown in above table as constant.
You will need an ECC ABAP resource to write a program that can download above files. Apart from Teams file for sourcing all files will exported in .csv file.
How would the entire solution work
You can develop a program that exports all the files in the either FTP location or local desk.
It is not possible to avoid manual step.
There are possibilities of automation of few of these files.
It is also important to determine how frequently this synchronization is expected to be executed.
If successfactors is the solution that is being used then there are APIs which are capable of exposing these data.