Implementation of SAP Bank Analyzer Smart AFI for customer's retail portfolio
Project Goal
The growing necessity for flexible data provisioning and single transaction presentation in the accounting system required our customer to replace the previous interface to the general ledger.
The new interface replaced the old sub-ledger aggregation interface with the SAP Subledger of SAP Bank Analyzer Smart AFI solution. All major upstream systems should now deliver data via this interface.
As-Is Situation
Due to the initial situation, data for the financial area was only made available in a very aggregated form. Consequently, it was not possible to present individual transaction data from GL or reporting without adding the data from the previous system.
This resulted in a high effort in reconciliation and with regard to the corresponding resources. As a result, the reconciliation itself was also very difficult due to the different aggregation levels and cost a lot of time.
Challenges
The data volume of the retail area of our customer was very large. As a result, it was important to find a solution that could deliver the performance required to forward data to GL and reporting within the specified SLAs.
Furthermore, it had to be considered that the data structures of each source system were different - even if they were routed through a centralized data hub. Harmonization with the target data model of the SAP subledger was therefore necessary on a pre-system basis.
Solution
In the first step, the individual data deliveries and their structures from the respective source systems were analyzed and a design was set up.
The data integration was carried out with the technology of SAP HANA SDI in which the harmonization to the SAP Bank Analyzer Smart AFI data model took place.
In order to be able to reconcile the data properly and on time, a uniform and central reconciliation tool with SAP HANA Calculation Views was implemented. In the final step, the data was integrated with the existing SAP ERP GL system.
Are you also looking for a competent implementation partner or would you like to explore more about our service offerings?
