SAP Knowledge Base Article - Public

2789130 - How to Create a Business Rule to Trim / display a sub-string of a field

Symptom

  • The requirement is to use a business rule and display a part of the field's value on another field.
  • For Example, Field 1 has a value 123456789 and the requirement is to omit the first three characters of the string and display the value on Field 2
  • Is there a standard function that handles this?

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  •  SAP SuccessFactors HCM Suite- All Versions
  •  SAP SuccessFactors Employee Central - All Versions

Resolution

The Substring function can be used in a business rule to accomplish this. Follow the steps below :

  1. The two fields in context here are Field 1 and Field 2, configured on jobinfo.
  2. Create a Business Rule as below and set it as an OnSave Trigger on the Job Info Element

Rule.png

For a detailed documentation on the Substring function and its parameters used, please refer to the section of the guide here

  1. Once a value is entered in Field 1, the Field 2 would display a trimmed value as per the condition defined in the rule

   Fields-Input.png     Fields-Output.png

Keywords

SF, EC, Success factors, Employee Central, Sub-String, part of a string, part of a field,Trim,rule , KBA , LOD-SF-EC-JOB-RUL , Job Info Business Rules , LOD-SF-EC-PER-PRS , Personal Info - Config, Rules, RBP, UI , How To

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions