Reconciliation Reports

Reconciliation reports provide information on the changes to your master data as it goes through the stages of extraction from a source system to being imported into SAP S/4HANA using Master Data Replication. These reports help you identify the incorrect or missing data that must be reconciled.

The Level-5 reports compare data between the source system and SAP S/4HANA.

Important: With version 8.0 SP01, you can access reconciliation reports through the SourceConnect Management Console. For detailed instructions, please refer to the Use Reconciliation Reports section in the SAP Central Finance Transaction Replication by insightsoftware Installer and Management Console Guide. You can also access the reports via SAP Fiori, as explained in this topic.

Accessing Reconciliation Reports

This section explains how to access the reconciliation reports through SAP Fiori.

Prerequisites

Ensure that the following prerequisites are complete:

• SAP Fiori launchpad is installed.
• The SAP GUI user credentials are available to access SAP Fiori.
• The users are assigned to the /MAGSH/RECON_REPORTS role.
• A connection is set up in SAP GUI to enable SAP GUI users to access the reports through SAP Analysis for Microsoft Office.
• Extraction of source data, replication of master data, and import of replicated master data into SAP S/4HANA is complete.

After your administrator has created the tables and views that are required for the reconciliation reports, you can access the reports through SAP Fiori.

Access Through SAP Fiori

To access the reports through SAP Fiori, perform the following steps:

1. Log on to SAP Fiori with your SAP GUI user credentials. The SAP Fiori launchpad displays the home page with the tiles pertaining to your role.
2. On the menu, select the insightsoftware Harmonization Reconciliation Reports tab. The insightsoftware Harmonization Reconciliation Reports tile is displayed.
   
3. Select one of the following reconciliation reports:
   • Business Partner Level-5
   • Cost Center Level-5
   • GL Account Level-5
   • Material Level-5

   The reconciliation report for the entity is displayed. By default, all the columns are included in the report.

4. Select the required source from the Source System dropdown list and select OK. The reconciliation report is displayed for the selected source system.
5. To view details of a line item, select Show Details. The selected master data record details are displayed.

   Important: When you select a master data record, you will see a blank page with the text Second Facet. As a workaround for this problem, please use step 5. For more information about this known issue, refer to SAP Central Finance Master Data Replication by insightsoftware for SAP S/4HANA Release Notes.

6. Optionally, select the Settings icon on the right-hand corner of the report. The View Settings window is displayed. You can deselect columns that you do not want to display in the report and can sort and group the columns.
7. Save a copy of the report. Note that you cannot modify the out-of-the-box reports.

   Note: The GUI options may vary depending on the SAP Fiori version in your instance.

Access Through SAP Analysis for Microsoft Office

To access the reports through SAP Analysis for Microsoft Office, perform the following steps:

1. In Microsoft Excel, go to the Analysis tab.
2. Select Insert Data Source > Select Data Source for Analysis. The Select Data Source window is displayed.
3. Select the SAP GUI connection that you have set up. A dialog box is displayed prompting you to specify the logon credentials.
4. Provide your SAP GUI credentials. The Select Data Source window is displayed again with the tabs.
5. On the Area tab, expand Magnitude. The following reconciliation reports are displayed among other reports.
6. Select one of the following reconciliation reports:
   • SCH_BP_RECON_L5_VIEW
   • SCH_MATERIAL_RECON_L5_VIEW
   • SCH_COSTCENTER_RECON_L5_VIEW
   • SCH_GLACCOUNT_RECON_L5_VIEW
7. Select Open for Analysis. The list of prompts, if available, is displayed.
8. Select the required prompts, and select OK.
9. Save a copy of the report. Note that you cannot modify the out-of-the-box reports.

   Note: The GUI options may vary depending on the SAP Fiori version in your instance.

Note: By default, the report is displayed in the Standard view containing the out-of-the-box fields. You can use the standard view to further build reports based on your requirements.

Key Attributes

The error description is one of the key attributes in the reconciliation reports for all the entities. The ERROR_DESCRIPTION attribute stores the validation and data processing errors that occur while loading the master data into the SAP S/4HANA target system.

A sample reconciliation report for the business partner entity is as follows.

The following table contains the other attributes of the different entities.