SAP Central Finance - Reconciliation Approach

[nitin_gupta10]

SAP Central Finance is the mechanism where data from SAP and Non-SAP systems is loaded/replicated to SAP Central Finance. However, from business perspective, the most important aspect is data reconciliation. If the data elements, value or currency doesn’t match then business can raise questions on technology and the way data is replicated.

To reconcile data SAP has provided some standard reports for many objects and we will discuss the usage as well as limitations to ensure you take right decisions in your projects.

Note – this blog only covers reconciliation from ECC source systems

Finance Data

 

FINS_CFIN_DFV_FI_NUM

These reports are part of authorization object – F_BKPF_BUK

• In source system – Number of documents in ECC system based on the selection criteria


• In AIF: With Errors – Documents are stuck in AIF. Check /n/AIF/IFMON transaction


• In AIF: Without Errors – Sometime the postings are transferred but not posted in S/4HANA. Like Foreign currency valuation postings for a currency type that is not set up in the CFIN system


• Documents not in CFIN – Count of documents not loaded/replicated

Standard reports provided by SAP are available, but they have limited capabilities.

1. Limited fields are available – These reports have limited fields available like GL Account, document number, value and currencies but does not provide more details which are core dimensions of any data model like – Trading Partner, Cost Center, profit center, segment, transaction types. When the data is being changed from ECC to S/4 it is important to see on same line the source master data and target master data


2. Balance Reconciliation – Balance level reconciliation is not that simple with standard SAP reports. If you just want to compare the trial balance at particular date lets say 31.12.2021 when you have don’t the initial load with balances as of 31.12.2021 + Open items + transactions of January. Report should be simple comparing the F.01 report from ECC to S/4. This can be done in excel but practically with mass data and large number of company codes, its not possible.


3. (AP/AR) Sub-Ledger reconciliation – If you want to compare Vendors and customers line then there is no standard report available. Existing reports does not provide sub ledger visibility where you can simply compare vendor lines in ECC to Vendor lines in S/4HANA. This takes too much priority when Central Payments is active, and you have to rely on AIF downloads for error messages and no report shows how many vendor and customer documents are missing and what’s the commercial impact.

Given these limitations these reports does not really server the purpose so most of the customers create custom report(s) to meet the reconciliation needs

Management Accounting (CO) Data:

Standard reports are available and can be used given you just want to tie back values against Cost elements

These reports are part of authorization object – K_VRGNG

AVL Data:

For each object the reconciliation report is available and since AVL is mostly used for reporting purposes these report still suffice the requirements

PCA Documents:

Standard Reports are available and suffice the purpose.

Commitments:

Standard Reports are available and suffice the purpose.

COPA Data:

There is no standard report available in SAP for CO-PA reconciliation. Their can be below situation which makes reconciliation too complex

• ECC have Cost based COPA and S/4HANA Central Finance have Margin Analysis


• ECC have Cost based COPA & Account based COPA and S/4HANA Central Finance have Margin Analysis

The data model is completely different in these cases in ECC and S/4HANA Central Finance so something is needed to reconcile. You need to figure that out – what’s that something?

For Replication/Reconciliation from Non-SAP systems please refer to this blog - CLICK HERE

Keep reading, keep sharing..