Consultant-Level SAP ICM Interview Questions — Intermediate

Credit Rules — Deep Dive

1

What are the 4 types of Credit Rules in SAP Commissions?

Two dimensions: source (Transaction vs Order) × direction (Direct vs Indirect). Direct = who made the sale. Indirect = who rolls up.

2

What is the difference between Direct and Indirect Credit Rules?

Direct credits the person who made the sale. Indirect credits managers up the reporting chain. What input does an indirect rule take?

3

Which rule do you NOT need a Primary Measurement Rule for, and why?

Detailed Deposit Rule can bypass the Incentive Rule entirely. Think about which CMID combination this creates.

4

How does a roll relationship flow credits to a manager?

When position is created, the system auto-creates a Reporting roll type. A roll relationship defines the path — and type of roll matters (full, split, etc.).

Measurement & Incentive Rules

5

What is the difference between Primary and Secondary Measurement Rules?

Primary aggregates credits. Secondary aggregates primary measurements — typically used for attainment calculations like dividing sum by quota.

6

What are the types of Incentive Rules?

Three types. Bonus uses non-measurement values. Basic awards based on credited transactions. Per-Credit evaluates each credit individually against a rate table.

7

What is the difference between Per-Credit and Aggregate (Basic) Commission?

Per-Credit evaluates each sale individually — useful for stepped rates. Aggregate applies one rate to the total. Big difference in how stepped commissions work.

8

What is the difference between Incentive and Commission?

Commission is variable pay triggered by individual sales (percentage of revenue). Bonus is fixed or threshold-triggered. Both are variable pay but calculated differently.

9

When does the Commission workspace get populated?

It's not after Reward stage. Think about which pipeline stage makes payments "visible."

Deposit Rules

10

What are the two types of Deposit Rules?

Basic uses the Incentive Rule output. Detailed uses the Primary Measurement Rule output directly — bypassing Incentive Rule entirely.

11

What is a Deposit Hold and why would you use one?

You can place deposits above a threshold on hold for manual review before they're processed. Two related features — Credit Hold and Deposit Hold — serve different purposes.

12

What is the difference between Credit Hold and Deposit Hold?

One stops the allocation of credit, one holds the final payment. They operate at different pipeline stages.

Compensation Elements

13

What is the difference between a Rate Table and a Lookup Table?

Rate Table = attainment-based, only in Incentive Rules, two-dimensional. Lookup Table = multi-dimensional, used in rules/formulas. One has versions, the other doesn't.

14

Can a Rate Table be used in a Secondary Measurement Rule?

No — this is a frequent interview trap. Rate Tables are restricted to one rule type only.

15

Can MDLT have versions?

MDLT (Multi-Dimensional Lookup Table) is created via XML import. Version behavior is a common question in Accenture/Deloitte interviews.

16

What is MDLT and how is it created?

Multi-Dimensional Lookup Table handles intersections of multiple dimensions. XML import is the primary creation method. What errors can occur during creation?

17

What is the Query to Value function and what are its limitations?

Useful for pulling data from back-end tables. But there are real-world performance and scope limitations that get flagged in senior interviews.

18

What are the best practices when working with Variables?

Always set a default assignment. Use Variables whenever your plan object could vary by position or title. Avoiding Variables increases maintenance burden — not performance.

Pipeline — Intermediate

19

What happens when you run Reset from Validate vs Reset from Classify?

Reset from Validate deletes the VnT'd transactions. Reset from Classify removes classification data. Know exactly which tables get cleared by each reset.

20

What is the significance of Credit Start/End Date and Processing Start/End Date on a Position?

Two date pairs with different purposes. Credit dates control when credits are generated. Processing dates control when pipeline includes the position.

21

How do you run the pipeline for only specific positions without running it for everyone?

Two approaches — one uses Position Groups, one uses Specific Position mode. Which is more scalable?

22

What is the Simulation Model in SAP Commissions?

It lets you model "what-if" scenarios without affecting live data. Common interview topic for consultant-level candidates.

23

How do you use multiple calendars in a single plan?

Think about how a monthly commission + quarterly bonus would be structured. Each rule can reference a different period type.

Organization & Data

24

What is the difference between Unpost and Unfinalize?

They undo different pipeline stages. One removes trial payments, the other reopens a finalized period. Order matters — you must unfinalize before you can unpost in that period.

25

What makes a transaction unique in the SalesTransaction table?

It's not just one column. Combination of comp date, line, subline, order ID, and sequence number. Why does subline number matter?

26

What are the unique columns and primary key in the SalesTransaction table?

The system uses a composite key. Salestransactionseq plus subline number are key. How does this impact how you identify and correct specific transactions?

27

When does the cs_transactionadjustment table get populated?

Not from normal transactions — only when a specific type of modification is applied to existing transactions.

28

What is Global Values workspace and what does it contain?

Calendars, Credit Types, Event Types, Earning Codes, Earning Groups, Fixed Value Types, Reason Codes, and Base Unit Types. Know the complete list.

PL/SQL — Consultant Level

29

What is the difference between a Function and a Procedure in PL/SQL?

Functions must return a value; procedures don't have to. Preferred use cases differ. Can you call a procedure in a SELECT statement?

30

What is a Cursor in PL/SQL and where is it used?

Explicit vs implicit cursors. Used when you need row-by-row processing of a query result. But when does cursor processing become a performance problem?

Consultant Interview Questions