String Functions – SAP Commissions

Functions are predefined formulas provided by SAP Commissions that you can use in your compensation rules to calculate and specify values or conditions. In general, functions fall into groups based on their use.

For example, a group of functions, (called in Return type : String) is provided as shown below.

Most functions are accessible from the Expression listing in the Legal Moves pane. Let’s understand each of the functions expression and definition.

Shortcut to list all functions :  type n: (in expression)

Concatenate Two Strings

Convert Date to String

Convert String to Upper Case

Convert Value to String

If Then Else

Query for String

Substring Between

Substring From

Substring Using Pattern

Trim String

Thanks, for reading it till the end. 🙏

Note

• I recommend best practice calling functions inside the formula but not directly in a rule.
• Rule should have a formula which is referencing to the functions inside the expression. 
• If there is a business logic change request, use the existing formula; create new version through referencing.
• No Hard-coding in expressions legal moves.

For more information around SAP Commissions please take a look here: Link

Hope you find that helpful! Let me know your thoughts on this in the comments section.
Don’t forget to share this article with your friends or colleagues.
Feel free to connect with me on any of the platforms below! 🚀

Yogananda Muthaiah |Twitter | LinkedIn | GitHub