Difference between Rate Table and Lookup table

[Former Member]

What is the difference between Rate Table and Lookup Table in SAP Callidus Commissions? Please anyone explain?

[sveabecker]

Welcome and Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html

The more details you provide, the more likely it is that members will be able to assist you.

Regards, Svea

SAP Community moderator

[former_member683595 · Accepted solution]

From Commissions Documentation:

A rate table is a special-purpose table that is used to calculate incentive compensation for a step commission, where a transaction is paid at different rates when it crosses rate threshold tiers. Rate tables can only be used in incentive rules.

A lookup table is a multidimensional table that you use to store a set of numeric-based values. You can then refer to the values from rules or formulas. Lookup tables are the same for each plan assignment; they aren’t customizable for each position assigned to the compensation plan. The values in lookup tables can be concurrently retrieved by any number of compensation rules or shared formulas. Lookup tables store indexed values, where each value represents the intersection of multiple criteria and each individual criterion is specified by an index value. A lookup table has the following characteristics:●Can have many dimensions.●Stores the same type of value in all table cells (for example, a lookup table can’t store both percentages and currency values in the same table).●Returns results that don’t depend on what has been already passed through the lookup table—this lookup behavior is different from the spanning behavior of rate tables.To use the data stored in a lookup table, you include a reference to the lookup table in a rule, formula, or rule element. In the reference, you specify the data to pass to the lookup table to determine the cell value to return.

[former_member36904]

to make it easier to grasp:

Lookup Table --> Straight Commissions

if you say in the table: 0-80% achievement you get 5%, above 80% achievement you get 10% then if a sales rep reaches 100% of his target, he gets 10% on his full achievement.

Rate Table --> Step Commissions

if you say in the table: 0-80% achievement you get 5%, above 80% achievement you get 10% then if a sale rep reaches 100% of his target, he gets 5% for the first 80% and another 10% for the last 20%

Hope this helps 🙂

[Former Member]

Hi Daniel, Its really very clear. Easy to understand. Thanks 🙂