Monday 1 February 2021

Real-Time reconciliation of S/4HANA data in BW/4HANA

I am sure many of us have come across a number of use cases where we need to perform real-time reconciliation of S/4HANA data in BW/4HANA system.  Let us consider one of the most critical use cases and go through how this can be achieved.

In many companies, BW system is being used for financial month-end closing requirements. As part of it, the financial related data is extracted (e.g.: 0FI_ACDOCA_10 – Universal Journal Entry) from S/4HANA system and it is fed into a standard/custom ADSO in BW system.

During the month-end closing (specifically last 2 to 3 days), the financial data is frequently updated in S/4HANA system and the same data is extracted and reported (e.g.: Profit & Lost Statement, Balance Sheet, etc.) in BW system. It’s an iterative process.

We need to make sure that the data in BW system is in synch with S/4 system. The challenge for real-time reconciliation is that the data is extracted in batch mode (e.g. Every 15 mins) or in streaming mode in BW/4HANA and the data is continuously updated in S/4HANA. So, we need to have a timestamp in source and target system and tools to read the data in real time.

Refer to the architecture diagram below to achieve the real-time data reconciliation.

    

SAP HANA Tutorial and Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Preparation, SAP HANA Career

CDS View – Select only the required fields (e.g.: Document type, GL Account, Timestamp, Amount, etc.) and required data for the reconciliation.

ADSO – Make sure that the time stamp field is added. This is an existing ADSO which is used for reporting.

Open ADSO – This doesn’t persist data and it will act as a virtual table.

BW Query – Make sure that the variable for time stamp is added. This will help to reconcile as of a specific time stamp. You can add other variables such as Ledger. The fields in the report could be Document type, Number of documents in BW, Number of documents in S4, Amount in BW, Amount in S4.

The reconciliation of S/4HANA data in BW/4HANA system is becoming easier and effective due to the new objects (e.g.: CDS view, Open ODS view, Composite provider, etc.).

Note: The same method can be used to reconcile any S/4 data in BW. This architecture can also be used in prior version of BW and S/4 systems provided the same/similar objects are available.

No comments:

Post a Comment