A learning path through the full SAP SuccessFactors Incentive Management stack — from SQL foundations to platform architecture, workflow automation, REST API, and reporting. 8+ years of implementation experience, no surface-level content.
SAP has replaced traditional MCQ exams with open-book, performance-based practical assessments. Already live for SAP Generative AI Developer, Business Data Cloud, and SAP BTP. The SAP SuccessFactors Incentive Management cert (C_THR70) is in the transition scope. Here's what changed, what's allowed open-book, and how to prepare.
Three changes in the Q1 2026 release that require action before you upgrade. Parallel pipeline execution (dependency audit required), Groovy runtime deprecation warnings (methods break in Q3 2026 — audit now), and HANA calculation view performance improvements.
Crystal Reports 2020 extended to December 2026, Crystal Reports 2025 to December 2027. SAP Embedded Analytics still can't replace Crystal for formatted compensation statements and regulatory documents. If you're on CR 2016 or earlier, you're already in a support gap. What to audit and what not to rush.
SAP ECC standard support ends December 2027. Migration is in active global execution — but 30% of projects are delayed or over budget and only 8% finished on schedule. The ICM-specific risks that most migration guides miss: PL/SQL rewrites, CS_ to CSC_ schema changes, and the absence of any standard SAP validation framework.
The SQL patterns that appear in every SAP SuccessFactors IM and Callidus Commissions query — SELECT with filtering, JOINs (INNER vs LEFT with ICM examples), GROUP BY and HAVING for aggregations, CTEs for readable multi-step logic, and window functions for running totals and rankings. Both Oracle Database and SAP HANA Database syntax throughout.
PL/SQL block structure, cursor patterns, BULK COLLECT and FORALL for performance, stored procedures, functions, and packages in the context of Callidus Commissions. Includes a worked attainment percentage function, a commission calculation procedure, and the Oracle schema exploration queries you need before any migration project.
Columnar storage and why it matters for ICM query performance. HANA SQL syntax that differs from Oracle: LIMIT, CURRENT_DATE, DAYS_BETWEEN, IFNULL, FROM DUMMY. Recursive CTEs replacing Oracle's CONNECT BY. Calculation Views. HANA SQL Script procedures with table variable patterns — no row-by-row cursors.
Architecture differences (row-based vs columnar). Full SQL syntax comparison table covering ROWNUM, CONNECT BY, NVL, DECODE, SYSDATE, LISTAGG, and outer join syntax. The CONNECT BY → recursive CTE rewrite in full. PL/SQL vs HANA SQL Script feature table. Data type mapping with the Oracle DATE → HANA timestamp warning that causes silent data loss.
The Oracle Database-based platform that became SAP SuccessFactors IM after SAP's 2018 acquisition. CS_ table schema, five core modules, the calculation pipeline, and how Callidus Workflow became SAP Advanced Workflow. Essential reading for anyone supporting legacy Callidus Commissions or planning a migration to the HANA-based platform.
Architecture on SAP HANA Database. Five core layers: Plan Administration, Participant Management, Pipeline Processing, Calculation Engine, and Compensation Statements. CSC_ table schema with key tables, pipeline monitoring SQL, results queries with attainment calculation, and the integration ecosystem — SAP Advanced Workflow, SAP Embedded Analytics, SAP Crystal Reports, SAP Datasphere, SAP Joule.
SAP Advanced Workflow is a separate product from SAP SuccessFactors IM — not a module inside it. Event-driven integration, three workflow types (Approval, Notification, Automation), workflow definition structure, common implementation patterns, and why every project underestimates this workstream. The Callidus Workflow lineage and Groovy scripting context explained.
Groovy runs inside the SAP Advanced Workflow sandbox — not general-purpose Groovy. Injected context objects (participant, plan, workflow, route, log, notification), null handling with safe navigation and Elvis operators, approval routing by hierarchy and plan value, pre-submit validation that returns a Map correctly, dynamic notification content, and debugging methodology.
OAuth 2.0 client credentials for server-to-server integrations. Token caching pattern (never fetch per-request). Paginated participant reads, batch credit POST, pipeline run trigger with polling, approved results extraction for payroll, and retry logic with exponential backoff for 429 and 5xx responses. curl reference for manual spot-checks.
Three tools, three jobs: SAP Embedded Analytics for interactive dashboards on live HANA data, SAP Crystal Reports for pixel-perfect formatted document output, SAP Datasphere for cross-system data integration. When to use which, quota attainment dashboard SQL, pipeline monitoring query, Crystal Reports use cases, and the Callidus Commissions to SAP reporting architecture comparison.