SAP Central Finance is the known solution where customers have multiple legacy systems and they can harmonize the data model and implement SAP S/4HANA. SAP has a nice and somewhat stable solution (product is still evolving) where legacy system is SAP ECC. However when I say multiple legacy systems, we cannot ignore the fact that the portfolio of ERP includes Non SAP systems to a very large extent like Oracle, MS-Dynamics, BPCS, JDE and many more.
Thinking about integrating non SAP systems always comes with a complexity of different data models across ERPs. Like Oracle does not have company code, cost centre or profit Center concept while the data replication will look for mapping of “some” field from oracle to Cost centre field of SAP let’s say.
Another example is, In SAP GL account is a simple object but oracle have a Natural Account and that also comes with a string of Management unit, business unit, organizational unit etc.
To achieve integration with non SAP systems this there are TWO options:
- Implement Magnitude (SAP certified product)
- Develop Custom solution (preferred option)
Magnitude these days support more of an excel upload and does not extract data from all non-SAP source system.
Supported systems for Transaction replication via Magnitude are below (refer to product guide for latest updates/changes).
- Oracle E-Business Suite
- JD Edwards EnterpriseOne
- Oracle PeopleSoft
- IFS Applications
- Microsoft Dynamics AX
- Microsoft Dynamics NAV
- Microsoft Dynamics SL
- Microsoft Dynamics GP
- Epicor iScala
- Infor CloudSuite Industrial (SyteLine)
- Infor Baan
- Universal flat file
Its expected from customer to extract data in a specified format called UFF and Magnitude load that in CFIN. Does it really worth paying thousands of dollars for that? Excel extraction is customer responsibility and at the end of the day its all manual process so this can be achieved by doing manual/custom solution similar to magnitude at fairly low cost.
Transaction data is loaded to SAP SLT from Magnitude into the relevant staging tables (below) and that can be done by any solution as after data reaches standard SLT tables its all standard SAP cFIN component which takes action
- /1LT/CF_E_HEADER – document header table
- /1LT/CF_E_ACCT – accounting items
- /1LT/CF_E_DEBIT – debitor items
- /1LT/CF_E_CREDIT – creditor items
- /1LT/CF_E_PRDTAX – product tax items
- /1LT/CF_E_WHTAX – withhold tax items
- /1LT/CF_E_EXTENT – customer extension
Last Update: August 17, 2023