Saturday 16 January 2021

SAP Financial product subledger overview


What is Finance sub-ledger of SAP

SAP FPSL or Financial Product Sub-ledger is SAP’s solution to support various Financial services organization to manage finance products as separate sub-ledger and enable acquiring instant financial insight at any level of detail for analytics and reporting. SAP FPSL is also dedicated multi-GAAP and multi-entity sub-ledger.

The product came into existence in first quarter of 2019 as part of co innovation project between SAP and Swiss Re. Previously SAP had a product Bank analyzer and Insurance analyzer for the FSI space.

Why do we need one?

Financial reporting for FS industry has seen lot of changes in last few years and the complexity will increase. The some of the key regulations (but not limited to) which FS industry must deal with are :-

Regulation Scope 
IFRS 9 Scope for the financial instruments and investments
IFRS 15  Revenue recognition 
IFRS 17  Accounting for Insurance contract 
US GAAP LDTI or Long Duration Targeted Improvements  Insurance related contract 

To comply with the above regulations any organization will need to have system and processes to be able to comply with these regulatory requirements. Having a detailed product subledger allows to manage the complexity and required data parameters within the subledger and allow for an easier adoption of the standard.

SAP FPSL comes with two flavors:-

◉ SAP S/4HANA for financial products sub-ledger, Banking option which is shipped with pre-configuration and templates for IFRS 9 and US GAAP

◉ SAP S/4HANA for financial products subledger, Insurance option which is shipped with pre-configuration and template for IFRS 17 and US GAAP LDTI regulation.

What is its architecture

SAP FPSL is installed as an add-on on top of S/4HANA and links to S/4HANA General ledger. SAP FPSL can also be used standalone with any other ledger e.g. Oracle Financials or Peoplesoft GL.

Below is a representation of the SAP’s architecture to support the Financial services industry with Focus on Banks. The source transaction layer can be replaced with Actuarial and claims related systems for the Insurance based scenario.

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Guides
Solution architecture

Salient point about key components:-

Sno. Architecture layer   Key details 
1 Transaction system / TP system This represent the source systems which records the trade / front office transactions. These can be SAP’s own system or third-party system present with Financial service These system records the transactions
SAP FSDP / Financial services data platform (Data layer) 

SAP FSDP is the underlying data layer which can be used as a data service layer to support the subledger. FSDP will receive data from various TP system and this data will be then used for the subledger processing.

Some of the example of data can be Counter party, Cash Flow, Business transactions, IFRS 9 credit related parameters e.g. probability of default etc.

SAP FPSL/ Financial product subledger 

From the above diagram you would view the 3 key components of FPSL process are:-

1) Source data layer- This is layer where you stage data for Subledger processing.

2) Accounting rules- This reads the data and post the subledger posting

3) Result data layer-This layer stores the values from subledger posting and certain data from FSDM

S/4HANA Core 

S/4HANA provides the general ledger layer which can support the organization finances including various subledger like Fixed asset, Accounts Payables etc. The Financial product also becomes a subledger for S/4HANA.

There is drill down facility ( to be enabled) which allows drill through for the ledger to the sub ledger postings and ease reconciliation.

Additional components 

There are additional components which can also be used but the use case is optional in some cases.

These can be group reporting ( for enterprise consolidation), SAP Analytical cloud ( for reporting and is highly recommended to be used along side FPSL for both bank & insurance scenario) 

How does this work in real world?

Let’s take an example scenario to illustrate the above flow. For simplicity sake we will consider a loan product. Below is a short representation of different data points needed for the subledger processing:-

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Guides
Financial product system landscape

For our example we will consider an entity (bank for simplicity sake) which needs to follow IFRS and US GAAP. It issues a loan is issued to a customer and disburse the loan to customer. We will assume no upfront fees and ignore the FX and Currency position related processes. We want to see the simple debit and credit flow through and recognize the disbursement transaction. We will cover each of the steps in more details in further blogs.

Within SAP FSDM there is a data model for the Loan which we will refer, and we will use certain components within our demo. The details will be explored in further blogs.

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Guides
Loan table schema in SAP FSDM

The entity in question which issues the loan has EUR as its functional currency. The loan is recorded in a trading platform (Mysis / Finastra) for this example. There is a transaction in TP system which is disbursement of the loan and we want to make sure that this data flows in SAP FPSL and SAP S/4HANA General ledger.

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Guides
Loan transaction captured in Trading platform

The TP system will record the various events and may or may not record the financial postings (some  TP system will have their own ledger system). An additional point to note is that the accounting system in SAP FPSL is event based i.e. it would require a feed of events e.g. disbursement of loan etc. to be fed to the FPSL layer (more on this in later blogs).

There can be other source system e.g. Customer master data / counter party KYC system etc.

The TP system can be linked to SAP FSDM (Data layer) via smart data access mechanism. There can also be a file based.

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Guides

Data is moved from staging layers within FSDM and through process chain is moved to FPSL layer. There are multiple steps and setting involved, but the high-level result is :-

◉ Setup of Loan contract in FPSL system:-

A loan contract is setup in the subledger from the TP system data.

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Guides
Loan contract setup

Certain key parameters e.g. limits can also be configured and recorded.

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Guides

◉ Information relating to counter party e.g. rating etc.- This information is also used to create business partner and to link the contract to BP.

◉ Business transactions , Cash flow and other details- In this example we loaded a simple disbursement transaction for loan and there were no upfront fees involved.

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Guides
Sub ledger posting with coding block elements

We view the 4 disbursement lines for the subledger ( for the 2 accounting standards).

Additionally, subledger posting are posted to S/4HANA Ledger.

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Guides
Ledger posting at a summary level

Sub ledger posting

This provides a high-level overview, a more lay of land as to how the SAP Financial product subledger works and links various components. The above scenario is applicable for the banks , but the flow is similar for the Insurance client (using FPSL for IFRS 17 reporting). There are additional set of features to support the IFRS 17 related requirements.

No comments:

Post a Comment