Date 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: Date) is provided as shown below.

Reference for Formula

References for Date Functions

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

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

Add Time to Date

Calculation Run Date

Calendar End Date

Calendar Start Date

Convert Number to Date

Convert String to Date

Credit Position Credit End Date

Credit Position Credit Start Date

Credit Position Processing End Date

Credit Position Processing Start Date

Fiscal Date

Fiscal Period End Date

Fiscal Period Start Date

If Then Else

Query for Date

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 a 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! 🚀