Skip to Content
Technical Articles

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.  In a reporting platform, the data changes  frequently compared to all other elements (reports, transformation logic, etc.). So, the critical data needs to be reconciled before business users find any problems (incorrect, missing or duplicates) with it. 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.

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

ADSO – This is an existing ADSO and it should contain raw data (e.g.: Staging layer). Make sure that the time stamp field is available in the ADSO.

Open ODS View – 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, etc.

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 or any SAP source systems data in BW. This architecture can also be used in prior versions of BW and any SAP source systems provided the same/similar objects are available.

/
2 Comments
You must be Logged on to comment or reply to a post.
  • Hello Shan,

    thanks very much for the article. I have two questions:

    1. How the variable of the time stamp works? For example: in the aDSO you load the data on 23.02.2021 at 23:00. In the open ODS view, only the documents created after 23:00 of 23.02.2021 can be shown.
    2. How you deal with the documents which are changed in the ACDOCA after the data being loaded into the aDSO.

    Thanks very much

    Xiaomin

  • Hello Xiaomin,

     

    the 1st Question can be achieved by the Timesstamp.

    but your 2nd Question is a valid one, how to avoid duplicate entries in the report?

    i was thinking of reading Live data only for the current period and the persistent Data will contain closed periods.

    regards

    Younes