Financial data reconciliation of universal journal for S/4HANA migration






IT industry keeps changing all the time and companies can’t afford staying behind. Searching and using state-of-the art solutions is one of the factors that help companies maintain their growth in success. SAP S/4 HANA is definitely one of those solutions. There are many benefits of upgrading old SAP system to the latest S/4 HANA environment. Just like in case of other upgrade projects, the process requires a lot of time and effort spent on the analysis as well as the actual realization. At the end, there is no place for errors, going back might be too expensive or simply impossible. Therefore reconciliation tools are becoming essential. Being aware of this fact, Int4 delivers a solution that can facilitate accounting data reconciliation process and eliminate the risk of the data inconsistency. The Universal Journal is in fact a single large table that consolidates all transactional information that was previously stored in several tables. It is called ACDOCA. Complex migration process that populates this  table, consists of numerous steps that have to be performed in a particular sequence. SAP provides detailed instructions of the whole migration procedure. During the process, various steps produce reports that can be validated and used as a basis for early error detection purposes. When the actual migration is considered to be complete, reconciliations can be started with few simple standard tools accessible from the IMG tree. Extended and customer-specific reconciliations however requires an extra tool that can be easily adjusted to the requirements of the company’s accounting and auditing teams. Int4 designed a group of reports that perfectly fit into this scenario.

How does it work:

Our tools read ACDOCA and compare its content against the data stored in the pre-migration tables eg. FAGLFLEXT_BCK or V_FAGLFLEXA_ORI. Selection, dimensions as well as the comparison levels can be dynamically adjusted to the particular client requirements. This solution can be used until there is a memory footprint reduction step performed on the migrated system. In other words, as long as the old pre-migration data is being kept and therefore available for consumption. Usually it happens when all of the reconciliation tasks are signed off, all auditors are satisfied with the results and of course the system is considered to be fully upgraded. At that point of time, there is no need to keep the old data in the system. We understand that business has to reconcile the data on several different levels depending on the internal and external financial and statutory requirements. Various groups of accountants may be interested in different sets of data being compared and then displayed in the aggregated form and across all accounting dimensions or customized currencies. There are standard dimensions like e.g. G/L account, Counterparty or Profit Center and also the ones customized as a coding block extension of the general ledger (COBL). Both types are fully supported. The same applies to the authorization concept, different groups of users have different access levels, therefore reconciliation always has to be done within assigned authorization profiles.

Benefits of INT4 Universal Journal Migration Reconciliation Tools:

Simplification – integration is no more a black hole
DYNAMIC DIMENTION COMPARISON – fulfills reporting requirements of different groups of accountants and auditors. Including, excluding dimensions like e.g. Counterparty, Profit Center etc. is easy and does not require any extra effort.
DRILL DOWN CAPABILITY WITH COMPARISON ON THE LINE ITEM LEVEL – allows deeper level of analysis on demand. User can easily move from the highest aggregation level down to the line item view. Top level balance differences can be narrow down to the particular splitting item that contains inconsistencies.
Automation – execution of hundreds of test cases is a matter of minutes not days
INCLUDED ALREADY IN DRY RUN AND DRESS REHEARSAL PHASES - Finding all of the issues as early as possible saves time and allows companies to perform the data cleansing process and rectifying potential more complex problems. Therefore as a good practice, Int4 strongly recommends to include reconciliation tasks into the list of “dry run“ and “dress rehearsal” activities.
SAP testing - Minimal effort of creating test cases
MULTIPLE CURRENCIES SUPPORT – depends on the particular system customizing. All amounts and their corresponding currencies are recognized dynamically based on the FINSC_LD_CMP customizing.


ul. Bednarska 1
60-571 Poznan, Poland



Write to us