Skip to Content
Author's profile photo Sanil Bhandari

Central Finance: Challenges in Finance Transformation

There are many business cases for S/4HANA Adoption for existing SAP Customers.  However, the journey to S/4HANA Business Suite is fraught with its own challenges which are inevitable – the costs and risks of migrating and upgrading to a new system, especially for those customers, who have built very complex and distributed landscapes spanning across geographies and businesses.

One element of S/4HANA, which has caught the imagination of many of the Global Customers is Central Finance, which has been projected as the “Smartest”, “Fastest”, “Simplest” way to latch on to S/4HANA bandwagon with a quick win of simplified and unified financial reporting structure. The approach of Central Finance, instead of forcing customers to migrate their SAP instances to S/4HANA Application, allows financial documents to be replicated into a new Central Finance instance running on S/4HANA Business Suite. This is particularly true for Customers who have multiple old SAP ERP Instances and non SAP Systems as well. This gives an organization wide financial reporting view, with minimal intervention to the Transaction Processing Source SAP and non SAP Systems. It has been claimed to be a quick win solution for all the Enterprise Customers of SAP, with extremely short turnaround time for adaption.

However, there are series of multiple challenges, which need to be considered in implementation of Central Finance. Some of them can dearly cost the S/4HANA Journey and cost thousands of dollars in terms of effort and missed objectives. Some of the business related challenges and technical product related challenges that I have encountered in my journey on Central Finance Project are below:

  1. Organizational Structure – One of the biggest use cases for central finance is to look at harmonized reporting for multiple markets. A logical extension of central finance on S/4HANA is to use the same CFIN System as a future Business System with integrated Finance and logistics transaction system. Therefore, it makes the organizational structure design extremely critical. In one of my projects, the customer in the legacy ERP (Source SAP ERP Systems) was using Business Area, Segment, Profit center etc as key considerations for reporting. Additionally, the Logistics Org Structures like Sales Org were not having in synch in various Source ERP System, as well as non SAP Source system did not have the org object which were relevant from SAP standpoint. As an IT Strategy roadmap, the customer wanted all the markets, where it operated to be on S/4HANA Business Suite and CFIN was the starting point. Additionally, many of the org structures were used in Account Based COPA in CFIN. So the Organizational structure design is a very crucial factor for long term journey and it is critical that design of org structure is thought through in CFIN. This should take into consideration the future logistics org structure as well

 

  1. New GL and Document Splitting in S/4HANA Central Finance: Document splitting and parallel ledgers functionality is one of the key asks from Finance Transformation for a large scale Enterprise level customer. Many of the customers might be using a source system without functionalities like new GL or Document splitting, but would want to use the S/4HANA CFIN with these functionalities. However a source system without Document splitting for eg and a target CFIN System with Document splitting is NOT a functionality which is supported out of box. It takes a real challenge to make sure that all the documents replicated from the source SAP ERP and non SAP Systems have the right level of details to support Document splitting. There are options available like BADI_FINS_CFIN_AC_INTERFACE, which can be used to enable the right rules for populating the account assignments for Document splitting. Some of the examples for Document splitting and parallel ledger usage:

 

  • The account assignments for Document splitting can be populated only in some of the line items and let standard Splitting set up take care of offsetting line item (eg, Profit Center and segment update in line items and let vendor line item derive the same from offsetting line item in case of Vendor Invoice Posting).
  • Some of the FI Document line items can derive account assignment objects for document splitting from areas like material master, cost center etc. The customer specific changes, should not be triggered in case, where standard derivation logic can work
  • Secondary CO Postings from Source systems, where the profit center is not available in one of the line items, the customer specification needs to be updated
  • Data from Non SAP systems needs to be enriched with account assignment details for postings in the target central finance system
  • There are transfer postings between subledgers which fail in the target system if it has document splitting active.

 

  1. Master Data Harmonization – Master data replication of objects like Cost Center, Profit center, GL Accounts, customers, Vendors etc is a challenge. Data harmonization is a key challenge in Enterprise customers with multiple SAP Systems. Some of the challenges in master data set up in Central Finance encountered in my experience are:

 

  • Customer Vendor Integration: The central finance function was used in S/4HANA 1610 EM instance, where the customers and vendors are created as Business Partners and the number ranges were overlapping in the source system for Customer and vendor account groups. To tide over the issue, the number ranges for Vendors were changed in the target CFIN System
  • GL Master Data Replication – The SAP ERP System were substantially old systems, where transactional data existed for more than 15 years. As part of CFIN replication, only few years of historical data was being replicated into the target CFIN System. So the GL Master replication was designed based on the no of years in past where transactional data existed for a GL, that only was replicated into the target system
  • Profit Center and Segments – One of the outcome of org structure redesign in CFIN was the whole profit center and segment usage in Central finance. The profit center in target CFIN system was tagged to Brand for reporting, while a segment was concentrated around line of business. However, the brands in the source system were limited to profit center with Business area being used for line of business reporting. The usage of different objects for reporting in source and target system entailed usage of complex mapping framework for replication of master data
  • Material master – The material master usage was also a challenge due to disparate systems. A governance structure was required to be put in place to synch up the master data in the source systems and than have the same replicated in the target system.
  • Data Services or SLT for Master Data – Harmonization and Business Objectives for Master data usage greatly determined the usage of the technology layer for replication between Source SAP and non SAP Systems to S/4HANA Central Finance Environment. Based on specific requirements like Data Filters for GL Account, Numbering changes etc, it was decided to introduce Data Services as a technology layer between Source and Target system for master data replication in S/4HANA Master Data replication.

 

  1. MDG Layer and Value / Key Mappings – Central Finance offers an integrated MDG layer which can be used to recreate the accounting document in the target system, based on the data replication from the source. Some of the key learnings from my association with the central finance project were:

 

  • Mapping Action: The mapping action determines if a transformation is required for any data element. In one of my project, business area was very widely used for financial reporting in the source SAP system. However, the complete reimagining of financial reporting meant that business area was not a key reporting factor in Central Finance. Hence a mapping action was set to clear the business area information from the source data. Essentially, the Mapping action should be designed taking into consideration of what are the key financial reporting parameters and if those parameters will hold true for the business even in case of a completely integrated system of records with finance and logistics transactions happening in the same system some time into future.
  • Key Mapping: Typically the identifiers for a business object can be different in source and target system, given that Central Finance has the ability to connect to a heterogeneous set of SAP and non SAP systems. Eg, a customer 2212 in a source system may be customer (BP) 500000 in CFIN to harmonize master data. In one of the projectw, the key ask was to manage millions of customer master, vendor, gl etc to name and arrive at a common structure. The current design of central finance does not support automatic mapping of the source and target object number, though there is a standard upload tool to do an excel upload using the transaction code FINS_CFIN_MAP_MANAGE. However, to manage the real time replication of master data in the mapping layer, a custom program was created for each of the object to ensure, that there are no failures in transactions
  • Value Mapping Structure: The value mapping is used in Central Finance to ensure if any transaction specific value has to be transformed. In some of the projects, the source systems had custom values for objects like Document types, Tax Codes etc. The whole objective of the transformation program was to ensure a standardized approach to finance structure across multiple markets. Eg, the markets used Document type R1 and RX for billing in two different geographies, but the intention in the target central finance system was to ensure that all the geographies, where the business operated should have the same document type for billing transactions. Hence the value mapping functionality was used to ensure that the new system has a standardized approach

 

  1. COPA Transformation from Costing based COPA to Account based COPA: Most of the customers in SAP World use Costing based COPA. However, the preferred approach for reporting in S/4HANA Is Account based COPA. The data replication from the Costing based COPA to Account based COPA is not a standard and out of box functionality in S/4HANA. Some of the challenges encountered have been:
    • There are scenarios in CB COPA where COPA data and GL postings happen at different time, whereas the expectation on AB COPA is to have the data based in COPA and GL at the same time. This presented it’s own challenges since AB COPA was supposed to be used for all kind of profitability analysis. Some of the design considerations for this transformation included moving key data like Sales Area data, material product hierarchy etc from material master, customer sales area data into central finance. These attributes were used in the derivation rule to ensure that the right attributes are populated. In some of the scenario like post goods issue, the data which is relevant for COPA was pulled through custom enhancements into Central finance.
    • There are condition types on the billing cycle, which post data into COPA but not into GL. This functionality is not yet supported in AB COPA in S/4HANA. This means that the business had to look at the way, in which some of the discounts and pricing could be extended to Billing cycle

 

  1. Transactional Data Posting: Central finance is supposed to reflect all of transactional financial data into a single place from multiple systems. However, the fine print is not all straight forward. There are not all scenarios which can be replicated into Central Finance. For eg, the transactional postings on Asset Sub ledger and WBS Elements through direct replication is not yet supported in central finance. There are quite a few challenges for customers, who already have SAP Source system which have parallel ledgers implemented. In such cases, the fiscal year differe nce in multiple ledgers presents its own issues. Some of the challenges assigned in Transactional data postings are:

 

  • Asset Subledger postings are not supported in S/4HANA Central Finance. The posting on asset sub ledger in the source system have to be replicated on a normal GL Accounts in the target central finance system. We utilized the Key Mapping functionality in MDG Layer in Central Finance to ensure that the postings happened correctly
  • The Transactional postings on WBS System in the source are not replicated into Central finance. This is mapped as a functionality, which will be addressed in the new releases of Central Finance. A custom enhancement was done in one of our projects to create the postings on other supported cost objects like internal order.
  • Some of the legal entities had multiple ledgers in the source system with both ledgers having different fiscal year variants (one corresponding to 5-5-4 set up and other being April – March). The specification of the cutover month in source system for balance upload and document replication start due to different fiscal years in leading and non leading ledger meant duplicate data being posted in the non leading ledger, since the balance upload happens based on the fiscal year set up for leading ledger.
  • A big challenge faced was the replication of the open items on the sub ledger and GL. The original document in source might be open at the time of initial load, but cleared in the period replication started. Such practical issues led to document failures in replication when subsequent actions on open items are not replicated immediately in central finance. These have been resolved through implementation of correction notes and custom code involvement

This is first of my series of blogs on S/4HANA and how it a finance transformation can be achieved in a simpler way

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez

      Nice doc !!!

       

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks a lot

       

      regards

       

      sanil

      Author's profile photo Mrinal Kanti Roy
      Mrinal Kanti Roy

      Sanil,

      Good summary of challenges with details !!

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      thanks a lot Mrinal

       

      regards

       

      sanil

      Author's profile photo Upendar Singh .
      Upendar Singh .

      Good document.

      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez

      Hi Sanil,

       

      I have some questions which could help me understand better. Here they are:

       

      1- Did you have to use MDG as a separate product ?

      I'm thinking if the scenario with multiple SAP systems with Vendor/Customer Migration and TAX ID must not be replicated. On System A, Vendor could be 1000 and on System B it could be 5043. How could you manage them?

       

      2- You mention Organizational Structure. TAX Code does have an equivalence table in MDG.

      If there are any object in MDG mapping which is not included, can it be added ? (BADI, Note, etc)

       

      3- What happens with Industry solutions like CA-JVA (Joint Venture Accounting) ?

      It should replicate FI documents but not JVA accounting.

       

      4- Exchange Rates should be synced accross all systems to have a consistent posting.

      Does Central Finance provide a solution ?

      Should we use some tool from S/4 Finance or SLT ?

       

      Thanks for your help in understanding the solution.

      Kind Regards

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Hi

      Apologies for a delayed response.

      Please find the updated answers:

       

      1- Did you have to use MDG as a separate product ?

      I’m thinking if the scenario with multiple SAP systems with Vendor/Customer Migration and TAX ID must not be replicated. On System A, Vendor could be 1000 and on System B it could be 5043. How could you manage them?

      You will have system id. For eg, System A vendor 1000 could be mapped to vendor 123 in CFIN and  similarly System B Vendor B 5043 could be mapped to123 as well. There is a standard transaction code which allows to upload this mapping structure in MDG through excel. You can also do this through standard transaction MDG_KEY_MAINTAIN which is used for key mapping. You will find the details of the t code I mentioned earlier in the CFIN Admin guide. In my case, we had done a small enhancement to automate this mapping as well and avoid Excel upload alltogether. Remember automatic mapping is not out of box functionality.

       

      2- You mention Organizational Structure. TAX Code does have an equivalence table in MDG.

      If there are any object in MDG mapping which is not included, can it be added ? (BADI, Note, etc)

      In our case, tax reporting was not a primary consideration for cfin. So we had created two tax codes, one each for out put and input in each tax procedure with zero rates. We used the value mapping functionality to replace the tax codes. In case, tax reporting is a primary consideration for you in CFIN, you might have to do dual maintainance of tax codes or if that is the not the case, you might want to use the value mapping approach i suggested.

       

      3- What happens with Industry solutions like CA-JVA (Joint Venture Accounting) ?

      It should replicate FI documents but not JVA accounting.

      I have no idea on Industry specific solutions. That would have to be explored.

       

      4- Exchange Rates should be synced accross all systems to have a consistent posting.

      Does Central Finance provide a solution ?

      Should we use some tool from S/4 Finance or SLT ?

       

      As of today, there is no standard solution for tax rates. The replication will post the exchange rates, as used in source system. However, for initial loads or on an ongoing basis if you want exchange rates to be in synch you will have to do a manual upload using TBEX in CFIN or build an interface with source system or terminals like Reuters etc.

       

      Regards

       

      Sanil Bhandari

      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez

      Thank you very much !!!!!!

       

      Even though I have followed the document and asked the question the new SAP Community didn't updated me on your answer . New tools ... hahahaha

       

      Kind Regards

      Author's profile photo Reddy Prabhakar
      Reddy Prabhakar

      Hi Sanil - I am doing a POC on central finance to replicate FI documents from my source system to CFIN system. I implement a badi 'ES_FINS_CFIN_INTERFACE' instead of using MDG upload functionality. I have completed the initial load extraction and posting from BSEG in my source to ACDOCA in my CFIN.I did this in a two step process - extraction and posting which I could find in SPRO of CFIN. I could pull documents from BSEG using RFC ' FIN_CFIN_PROCESS_PACKAGES'.

      Now while trying to replicate transactional data, it seems to be lying in my CFIN transfer tables (CFIN_ACCHD and CFIN_ACCIT) in my source. I am struggling to understand how will this move into CFIN, where's the interface in my source to move it to CFIN.

      Cheers, Arun

       

      Author's profile photo Former Member
      Former Member

      Dear Sanil Bhandari,

       

      Thank you for sharing valuable Information.

      I have following questions, could you please answer.

      1. Do we need to create Organisation elements manually or any other way to transfer/Create elements in Central Finance System ? (Org. elements : Company code, Controlling area, Etc...)
      2. What are all organisation elements are required in Central finance ? Do we have any list?
      3. Can we map custom org elements from source to Central Finance (Like Customized Document splitting characters)?
      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Hi

      Please find the responses as below:

       

      1. Do we need to create Organisation elements manually or any other way to transfer/Create elements in Central Finance System ? (Org. elements : Company code, Controlling area, Etc…)

      You need to create the Org elements in the target CFIN system through configuration. This is required because there could be multiple SAP and non SAP system which can send data to one CFIN System. Additionally, to harmonize reporting, the central finance system might have different codification of org elements from the source system

      2. What are all organisation elements are required in Central finance ? Do we have any list?

       

      The org elements required depend on your business requirements. But from finance stand point, Company Codes, Controlling area are the bare minimum. Additionally, if you are also using COPA than you need to create plants, Sales Org, Purchasing Org etc as well. Essentially, you should have all Org data created in CFIN, which will be required to recreate the accounting document in CFIN, when data replication is started.

       

      3. Can we map custom org elements from source to Central Finance (Like Customized Document splitting characters)?

      You need to create the same config in CFIN as well, if you want splitting to work with custom splitting characteristics.

       

      Regards

      Sanil Bhandari

      Author's profile photo MalolanTCS R
      MalolanTCS R

      Good  beginning.. and  good  debate on a very interesting topic.  Customers  are expecting more from  Central Finance  and  this is showing up..

      Author's profile photo Paul Constantine
      Paul Constantine

      Exceptional synopsis !

      I know a couple large almost-failed projects which stumbled in the very attention points you mentioned, which they obviously ignored.

      I suggest you write a book on the subject.

      Author's profile photo Deepesh Ruhela
      Deepesh Ruhela

      Hi Sanil,

      May be my comment will appear to you as foolish. Still while working in a Central Finance (Asset Accounting) project, I found there is no option in OAYC to provide the last depreciation posted in Previous system. It is strange. Though Sap has provided the same in LTMC template. But my client is using BODS.

      Can you please help us here providing the path to update that value? Otherwise system is not considering the depreciation posted posted in legacy system and calculating plan depreciation from the beginning of the year.

      BR

      Sudipta

       

      Author's profile photo Ramky Prabhakar
      Ramky Prabhakar

      Hi Deepesh,

      CFIN was created only to make or take baby steps toward S/4 Hana. CFIN is not an complete solution by itself. Mimicking Asset Transactions into CFIN is asking for more. Never do that. Depreciation posting is one of the stuff you are trying to do, tomorrow, post capitalization, partial retirement of legacy asset v/s new assets, asset transfers....etc all these will pose greater pain points. Convince clients to keep CFIN to bare minimum. No where in CFIN roadmap is going to be mirror of S/4 HANA....if that is the case why invest in S/4Hana....take judicious decision to expect complete Asset Accounting module in CFIN.....every country comes with its own asset rules, SAP can't accomodate both in CFIN and S/4H....too much to expect from them.

      Hope this helps.

       

      Prabhakar