It was supposed to be a routine quarter-end close. The finance team, led by a seasoned FPSL consultant, set out to execute the IFRS 17 compliance processes for their insurance contracts. But when they checked the results, something was alarmingly wrong—the Contractual Service Margin (CSM) for a major insurance portfolio had vanished without a trace. The suspense began.
- Contract Recognition and Grouping Configuration The team started by tracing the contract recognition process, as outlined in the IFRS 17 standards. Contracts had to be grouped by profitability at inception, categorizing them as onerous, no significant risk of being onerous, or other. They confirmed that the contracts were correctly assigned to groups using the Annual Cohort Grouping settings within SAP FPSL, checking each category under IMG > Financial Products Subledger > End User Business Processes > Grouping.
- Initial Measurement with the General Measurement Model (GMM) Next, they checked the initial CSM calculation under the General Measurement Model (GMM). This process involves calculating the present value of future cash inflows and outflows, discounting them based on market data, which was inputted directly into the Result Data Layer (RDL). They examined each data input for cash flows, noting that the Fulfillment Cash Flows and Risk Adjustment were accounted for and correctly stored in the RDL for further processing.
- Time Value of Money Adjustments The team delved deeper into the Time Value of Money (TVM) adjustments, verifying discount rates through the SDL (Source Data Layer) where market data such as yield curves was stored. Everything seemed perfect—cash flows were discounted at the correct rates, and the calculations were in line with IFRS 17 principles.
- Unexpected Data Aggregation Issue When checking the aggregation process, the team discovered something unsettling. Delta GAAP aggregations, configured to adjust for local GAAP compliance, showed a slight inconsistency in totals. Using the Delta Procedure under IMG > Financial Products Subledger > General Ledger Integration > Define General Ledger Connection, they recalculated entries, but the discrepancy persisted, suggesting that the subledger entries were somehow dropping CSM values during posting.
- Contractual Service Margin Posting - The Ghostly Exit As the team combed through the posting rules, they found a hidden, rarely used parameter in the PI Structure Mapping—it defined CSM data flow specifically for multi-GAAP entries. The NotifyOfAccountingDocuments web service should have posted entries to FI, but the service log revealed that certain entries were skipped due to a configuration left from an old implementation project. The configuration allowed postings only if the CSM values were positive; any zero or negative CSM was silently excluded.
- Final Clue: The Curse of Duplicate CSM Clearing The final piece of the puzzle fell into place when they found that a previous consultant had set a custom rule for clearing CSM in scenarios where liability measurements exceeded cash flow projections. As a failsafe, the system had attempted to balance these with temporary entries in a clearing account, which vanished upon month-end processing, leaving no trace in the FI ledger. This temporary clearing rule, hidden deep in the General Ledger Connector settings, had turned into a black hole for the CSM values.
The Mysterious Twist: A Vanished CSM
With the configurations corrected and the temporary clearing rule disabled, the team reran the process. To their horror, the CSM was still gone, as if it had never existed. They realized that their last attempt at correction had wiped the history of entries, erasing them permanently from both the RDL and SDL without the option of a rollback. The CSM was lost, as if cursed to disappear at every quarter’s end—a ghost in the machine, waiting to strike again.
The Lesson? In SAP FPSL and IFRS 17 integration, the most minor configuration can create ghostly data flows. Beware the hidden settings, or risk being haunted by vanishing values and disappearing margins for good.
SAP Consultant - CFIN | RAR | SAP FPSL | SAP FM GM | SAP FS-CD | SAP FICA | SAP BRIM | SAP IBP RMCA PS-CD FPSL SAP PAPM | SAP FSCM | RE-FX CLM Lease Accounting
3 周??