7 Functions
7.4 Function Groups
To help you find the functions you need to create your rules, we have divided them thematically into groups:
These are the function groups:
● Mathematical functions
In this group, you can find functions that help you perform mathematical operations.
● Module-specific or feature-specific functions
In this group, you can find functions that are specific to a module or feature, for example, for the Employee Central module or the Time Off feature.
Caution
Please refer to the module-specific or feature-specific handbooks before using these functions. Especially the features have to be set up in a specific way so you can use these functions.
● String functions
In this group, you can find functions that create specific texts or strings.
● Time-related and date-related functions
In this group, you can find functions that help you calculate or determine dates or periods.
● Other functions
In this group, you can find those functions that do not fit in any of the other groups.
In the following, you can find the available functions sorted by group, and from A-Z within the group. The field type defines for which fields you can select the function.
7.4.1 Mathematical Functions
For fields of type... ...you can use this function: Choose this function to:
Decimal Number
Add/Minus/Divide/Multiply Add, subtract, divide, or multiply values
Decimal Number
Math Expression Define your custom formula
38 © 2014 SAP SE or an SAP affiliate company. All rights reserved.
Configuring Business Rules in SuccessFactors Functions
For fields of type... ...you can use this function: Choose this function to:
Decimal Minimum Find the smallest value in a list of values
Decimal Opposite Sign Get a value with the opposite sign
Decimal Number
Round Define how values are rounded
7.4.2 Module-Specific or Feature-Specific Functions
Note
For some of these functions, you have to enable the corresponding feature in Provisioning before you can use them on the Configure Business Rules page.
For fields of type... ...you can use this function: Choose this function to:
Decimal Amount from Pay Scale Struc
ture
Note: Use only when you have defined pay scale structures in Employee Central
Get the amount from the pay scale structure
Decimal Avg FTE for Accruable Period Note: Use only with Time Off
Calculate the average FTE for the accruable period based on calendar days
Decimal Avg FTE for Accruable Period based on Month
Note: Use only with Time Off
Calculate the average FTE for the accruable period based on calendar months
Decimal Avg FTE for Accrual Period Note: Use only with Time Off
Calculate the average FTE for the accrual period of the time account based on calendar days
Decimal Avg FTE for Accrual Period based on Month
Note: Use only with Time Off
Calculate the average FTE for the accrual period based on calendar months
Decimal Calculate Balance
Note: Use only with Time Off
Calculate the balance for a time account on a specific date
Decimal Calculate FTE based on Stand
ard Hours
Note: Use only with Position Management
Include positions in standard hours calculation
Configuring Business Rules in SuccessFactors
Functions © 2014 SAP SE or an SAP affiliate company. All rights reserved. 39
For fields of type... ...you can use this function: Choose this function to:
Decimal Cap Accrual
Note: Use only with Time Off
Determine the accrual value within the accrual balance limit
Text Currency from Pay Scale Struc
ture
Note: Use only when you have defined pay scale structures in Employee Central
Get the currency from the pay scale structure
Value Frequency from Pay Scale
Structure
Note: Use only when you have defined pay scale structures in Employee Central
Get the frequency from the pay scale structure
Text Generate External Code Time Off Note: Use only with Time Off
Generate external code for Accruals in Time Off
Decimal Get Absence Days
Note: Use only with Time Off
Calculate how long an employee has been absent within one year
Decimal Number
Get Completed Calendar Weeks Between ISO
Note: Use only with Time Off
Calculate the number of weeks the employee works in the accrual period
Decimal Number
Get Completed Remaining Cal
endar Weeks ISO
Note: Use only with Time Off
Calculate the number of weeks the employee works in the hire period
Text Get Incumbent By Position Note: Use only with Position Management
Get the user ID of the incumbent of the position
Text Get Matrix Position Code By Type
Note: Use only with Position Management
Get the matrix position code
Decimal Number
Get Months From Hire Date Tak
ing Account Of Threshold Note: Use only with Time Off
Calculate the number of months the employee is work
ing in the hire period
Decimal Number
Get Months Taking Account Of Threshold
Note: Use only with Time Off
Calculate the number of months the employee is work
ing in the accrual period
40 © 2014 SAP SE or an SAP affiliate company. All rights reserved.
Configuring Business Rules in SuccessFactors Functions
For fields of type... ...you can use this function: Choose this function to:
Text Get Next Available Manager By Position
Note: Use only with Position Management
Get the user ID of the next available manager in the po
sition hierarchy
Decimal Number
Get Number Of Child Positions Note: Use only with Position Management
Get the number of child positions
Decimal Get Number Of Eligible Days Note: Use only with Time Off
Calculate the number of eligible days
Decimal Number
Get Number Of Months From Hire Date
Note: Use only with Time Off
Calculate the number of months the employee is work
ing as of the hire date
Decimal Get Pensionable Salary Note: Use only with Employee Central
Calculate the pensionable salary on a certain effective date
Decimal Get Pensionable Salary with Global Assignment
Note: Use only with Employee Central and Global Assignment
Calculate the pensionable salary on a certain effective date, considering global assignments
Decimal Number
Get Work History Days ADD ALL Note: Use only with Employee Central
Sum up days of all employments (current and previ
ous)
Decimal Number
Get Work History Days CONTIN
UOUS
Note: Use only with Employee Central
Sum up days of all employments back until a specified event reason
Decimal Number
Get Work History Days CUR
RENT
Note: Use only with Employee Central
Sum up days of the current employment
Decimal Number
Get Work History Days PREVI
OUS
Note: Use only with Employee Central
Sum up days of previous employments
Configuring Business Rules in SuccessFactors
Functions © 2014 SAP SE or an SAP affiliate company. All rights reserved. 41
For fields of type... ...you can use this function: Choose this function to:
Boolean Is Employee Full Time
Note: Use only with Employee Central
Determine whether the employee is full-time on a spe
cific date
Boolean Is Position Below User's Position Note: Use only with Position Management
Determine whether a position is below user's position in user's hierarchy
7.4.3 String Functions
For fields of type... ...you can use this function: Choose this function to:
Text Concatenate Combine strings to one string
Text Format Combine different objects to a meaningful text
Text Format Number Format numbers following a custom template and se
quence
7.4.4 Time-Related and Date-Related Functions
For fields of type... ...you can use this function: Choose this function to:
Text Convert Days To YY/MM/DD Convert a number of days into the format of years/
months/days Decimal
Number
Date Determine the number of the week for a date (US-de
fined)
Date Date Plus Add/subtract days or months to/from a given date
Number Day Of Month Determine the number of the month for a specific date
Number Day Of Week Determine the number of the weekday for a specific
date Date
Decimal Number
Difference in Calendar Years Calculate the time difference between 2 dates in calen
dar years
42 © 2014 SAP SE or an SAP affiliate company. All rights reserved.
Configuring Business Rules in SuccessFactors Functions
For fields of type... ...you can use this function: Choose this function to:
Date Decimal Number
Difference In Years Round Down Calculate the time difference between 2 dates in calen
dar years, rounding down the result
Date Decimal Number
Difference In Years Round Up Calculate the time difference between 2 dates in calen
dar years, rounding up the result
Decimal Number
Get Completed Weeks Between Calculate the number of completed weeks within a pe
riod
Date Get First Day Of Month Get the first day of the same month of a specified date
Date Latest Date Get the latest date of two dates
Text Timestamp Current Time UTC plus Offset Minutes
Create a current or future timestamp in UTC time standard
Date Today Get the date of today
Decimal Number
Week Of Year ISO Determine the number of the week for a date (ISO-de
fined)
7.4.5 Other Functions
For fields of type... ...you can use this function: Choose this function to:
Number Get Next Value Get next value from a Sequence MDF object
Boolean Is Empty Check if an input field is empty
Text Login User Get the currently logged-in user
All field types Lookup
Note: Use only for MDF objects
Get values from a lookup table (that is stored as MDF object)
Decimal Treat Null As Give a default value for an empty field