Accessing Reconciliation Reports

This topic explains how to access the Reconciliation reports through SAP Fiori and SAP Analysis for Microsoft Office.

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

Prerequisites

Make sure that the following prerequisites are complete:

SAP Fiori launchpad or SAP Analysis for Microsoft Office is installed.
The SAP GUI user credentials are available to access SAP Fiori or SAP Analysis for Microsoft Office.
The users are assigned to the following roles:
- SAP_BR_EMPLOYEE: The SAP GUI user is assigned to this role and has access to Query Browser in SAP Fiori.
- /MAGSW/RECON_APF: The users who require access to the Reconciliation reports are assigned to this role.
- /MAGSW/RECON_OVP: The users who require access to the insightsoftware Reconciliation dashboard are assigned to this role.
A connection is set up in SAP GUI to enable SAP GUI users to access the reports through SAP Analysis for Microsoft Office.
Transaction and Reconciliation data load are complete.

Reconciliation Framework

The following framework helps in reconciling the documents transferred from the source systems to SAP S/4HANA using the transaction replication process.

A brief explanation of the levels depicted in the framework diagram is as follows.

Level-1: Refers to the first level of reconciliation in which the data from the source systems is loaded into the Stage 1 tables. For the Flat File data sources, the documents are provided in a flat file. For the remaining sources, the documents are available in the source system.

Level-2: Refers to the second level of reconciliation in which the Stage 1 table data is compared with the data in the Stage 2 tables.

Level-3: Refers to the third level of reconciliation in which the data in the Stage 2 tables or SLT Mirror tables is compared with the SLT table data,

Level-4: Refers to the fourth level of reconciliation in which the SLT table data is compared with the CFIN (BKPF/ACDOCA) data in SAP S/4HANA.

Level-5: Refers to the fifth level of reconciliation in which the Stage 1 table data is compared with the CFIN (BKPF/ACDOCA) data in SAP S/4HANA.

Note: A document is considered for reconciliation, only on reaching the SOURCE_DOC_INFO table. If it does not reach this table, it is not displayed as a part of the SAP Central Finance Transaction Replication by insightsoftware for SAP S/4HANA Reconciliation reports.

After installing the Reconciliation reports, you can access them through SAP Fiori or SAP Analysis for Microsoft Office add-in.

How to Access Reconciliation Reports through SAP FIORI

Perform the following tasks to access the reports through SAP Fiori.

Log on to SAP Fiori with your SAP GUI user credentials. The SAP Fiori launchpad displays the home page with tiles pertaining to your role.
On the menu, locate and select the insightsoftware Transaction Reconciliation Reports group. All the reports tiles pertaining to insightsoftware Transaction Reconciliation Reports appear.
Select the Reconciliation report that you want to view.
Note: When you select a reconciliation report tile, ensure it opens in a new tab, which is the default behavior. If it does not open in a new tab, use the T-code /n/UI2/FLP_CUS_CONF and set the system parameter NAVIGATION_WDA_INPLACE to false.
Or, on the menu, locate and select the Query Browser group. The Query Browser tile appears.
Select Query Browser. The Query Browser > Analytical Queries page displays the list of available reports.
Select one of the following Reconciliation reports:
- /MAGSW/C_RECON_LV1
- /MAGSW/C_RECON_LV2_DET
- /MAGSW/C_RECON_LV2_SUM
- /MAGSW/C_RECON_LV3_DET
- /MAGSW/C_RECON_LV3_SUM
- /MAGSW/C_RECON_LV4
- /MAGSW/C_RECON_LV5_DET
- /MAGSW/C_RECON_LV5_SUM
- /MAGSW/C_RECON_GL_BAL
- /MAGSW/C_RECON_EXP
Select Open for Analysis. The list of prompts, if available, is displayed.
Select the required prompts, and select OK.
The report shows the data with the list of measures and attributes under DIMENSIONS. If you cannot see the measures or attributes, click Pause and then Refresh.
Optionally, drag the required attributes to ROWS or COLUMNS. By default, all of the measures are included in the report. The report displays the data with the added rows and columns.
Save a copy of the report. You cannot modify the out-of-the-box reports.
Note: The GUI options may vary depending on the SAP Fiori version in your instance.

A sample report is as follows. A field with the value # in the report indicates that the data for the corresponding field is missing or unavailable. All fields in the report containing values with the prefix "#" indicate that the document itself is missing in the stage.

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

How to Access Reports through SAP Analysis for Microsoft Office

Perform the following tasks to access the reports through SAP Analysis for Microsoft Office.

In Microsoft Excel, go to the Analysis tab.
Select Insert Data Source > Select Data Source for Analysis. The Select Data Source window appears.
Select the SAP GUI connection that you have set up. A dialog box appears prompting you to specify the logon credentials.
Provide your SAP GUI credentials. The Select Data Source window is displayed again with the tabs.
On the Area tab, expand insightsoftware. The following Reconciliation reports are displayed among other reports.

insightsoftware Reconciliation Level - 1
insightsoftware Reconciliation Level - 2 Detail
insightsoftware Reconciliation Level - 2 Summary
insightsoftware Reconciliation Level - 3 Detail
insightsoftware Reconciliation Level - 3 Summary
insightsoftware Reconciliation Level - 4
insightsoftware Reconciliation Level - 5 Detail
insightsoftware Reconciliation Level - 5 Summary
GL Balance Report
insightsoftware Reconciliation Exception View

Expand the report that you want to view. The report name is displayed with the Query icon.
Select the report, and select OK. The Prompts for <ReportName> window appears with the list of prompts, as applicable.
Select the required prompts, and select OK.
Under Analysis, the report shows the data with the list of measures and attributes under Data Source.
Optionally, drag the required attributes to ROWS or COLUMNS. By default, all of the measures are included in the report. The report displays the data with the added rows and columns.
Save a copy of the report. You cannot modify the out-of-the-box reports.

Transaction Reconciliation Reports

The reconciliation reports enable you to compare the changes to the transaction data through the stages of replication and transformation from your source system into SAP S/4HANA. The reports help you identify the stage containing incorrect or missing data that must be reconciled.

Note: SAP ERP Central Component (ECC) data is shown only in the GL Balance, ECC GL Balance Conversion, Reconciliation Level - 5 Summary, and Reconciliation Level - 5 Detail reports.

Attributes

Some of the key attributes of the reconciliation reports are as follows:

Total amount in transaction and company code currency
Total units
Account group
Currencies
- Transaction currency
- Company code currency
- Group currency (USD)
Document header-level summary attributes
- Source system
- Company code
- Ledger
- Batch
- Document number
- Document type
- Unique ID
- Vendor
- Document date
- Document posted date
Document line-level detail attributes
- GL account
- Transaction types
- Trading partners
- Material
- UOM
- Account group
- Cost center
- Customer
- Product tax code
- Profit center
- WBS (project)

The key measures and attributes specific to each level of reconciliation reports are as follows.

Level-1 Report

Measures

Column	Business Description
Source: Document Count	The number of financial transactions in the source system.
Stage: Document Count	The number of financial transactions that have been replicated from the source system in the first stage.
Document Count VARIANCE	The difference between the number of financial transactions in the source system and the first stage of data replication.
Source: Total Units	The aggregate quantity of units recorded across all relevant transactions in the source system.
Stage: Total Units	The aggregate quantity of units replicated from the source system in the first stage.
Total Units VARIANCE	The difference between the aggregate quantity of units recorded in the source system and the first stage of data replication.
Source: Total Company Amount	The total amount of financial transactions specific to a particular company code in the source system.
Stage: Total Company Amount	The total amount of financial transactions specific to a particular company code in the first stage of replication.
Total Company Amount VARIANCE	The difference between the total company code-specific transaction values in the source system and the first stage of data replication.
Source Ref 26-30	Custom reference fields from the source system used for additional information or categorization.
Target Ref 26-30	Custom reference fields in the target system used for additional information or categorization.

Attributes

Column	Business Description
Location	The physical or organizational location associated with financial transactions.
Mapped SAP Company Code	The SAP company code to which the source system’s company code is mapped.
Source System	The original system from which financial data is replicated to the Central Finance system.
Source: Company	The originating company or business unit from which financial data is being extracted and integrated into the Central Finance system.
Source: Document Batch	A grouping or collection of related financial transactions (such as invoices, purchase orders, or journal entries) that are processed together during replication.
Source: Document Batch Type	The type or category of the document batch (e.g., sales, procurement, or general ledger) for organizational and reporting purposes.
Source: Document Number	Each financial transaction processed in the source system.
Source: Document Posted Date	The date on which a financial transaction was posted or recorded in the source system.
Source: Fiscal Period	The specific accounting period (e.g., month, quarter, or year) during which financial transactions occurred.
Source: Fiscal Year	The financial reporting year (e.g., 2024) to which the transactions belong.
Source Ref 1-25	Custom reference fields from the source system used for additional information or categorization.
Target Ref 1-25	Custom reference fields in the target system used for additional information or categorization.

Level-2 Report (Summary)

Measures

Column	Business Description
Stage 1: Company Amount	The total amount of financial transactions specific to a particular company code in the first stage of data replication.
Stage 2: Company Amount	The total amount of financial transactions specific to a particular company code in the second stage of data replication.
Company Amount Variance	The difference between the company code-specific transaction values in the first and second stages of data replication.
Stage 1: Document Amount	The total amount of a financial transaction in the first stage of data replication.
Stage 2: Document Amount	The total amount of a financial transaction in the second stage of data replication.
Document Amount Variance	The difference between the transaction values in the first and second stages of data replication.
Stage 1: Group Amount	The aggregated financial value grouped by specific criteria (e.g., business units, cost centers) in the first stage of data replication.
Stage 2: Group Amount	The corresponding aggregated group amount in the second stage.
Group Amount Variance	The difference between group amounts in the first and second stages of data replication.
Stage 1: Document Count	The total number of financial transactions in the first stage of data replication.
Stage 2: Document Count	The total number of financial transactions in the second stage of data replication.
Document Count Variance	The difference between the number of financial transactions in the first and second stages of data replication.
Stage 1: Total Units	The aggregate quantity of units recorded across all relevant transactions in the first stage of replication.
Stage 2: Total Units	The aggregate quantity of units replicated from the first stage to the second stage.
Total Units Variance	The difference between the number of financial transactions in the first and second stages of data replication.
Source Ref 26-30	Custom reference fields from the source system used for additional information or categorization.
Target Ref 26-30	Custom reference fields in the target system used for additional information or categorization.

Attributes

Column	Business Description
Company Code	The specific company code associated with financial transactions.
Document Currency Code	The currency in which the transaction is recorded.
Document Split Indicator	Indicator of a transaction being split for accounting purposes.
Group Currency Code	The currency used for group-level reporting.
Location	The physical or organizational location associated with financial transactions.
Logical System	The source system from which the data originates.
Mapped SAP Company Code	The SAP company code to which the source system’s company code is mapped.
Source System	The original system from which financial data is replicated to the Central Finance system.
Stage 1: Batch	The batch number assigned during the first stage of data processing.
Stage 1: Company Code	The company code used in the first stage of data processing.
Stage 1: Document Batch Type	The type of document batch processed in the first stage.
Stage 1: Document Date	The date on which a financial transaction was created in the first stage.
Stage 1: Document Number	The unique identifier for the transaction in the first stage.
Stage 1: Fiscal Period	The fiscal period applicable during the first stage.
Stage 1: Fiscal Year	The fiscal year applicable during the first stage.
Stage 1: Ledger Type	The type of ledger used in the first stage of processing.
Stage 1: MSC Interface Date	The date the data was interfaced with the MSC in the first stage.
Stage 1: Posted Date	The date the transaction was posted in the first stage.
Stage 1: Unique ID	A unique identifier assigned to the transaction in the first stage.
Stage 2: Company Code	The company code used in the second stage of data processing.
Stage 2: Document Date	The date the transaction was created in the second stage.
Stage 2: Fiscal Period	The fiscal period applicable during the second stage.
Stage 2: Fiscal Year	The fiscal year applicable during the second stage.
Stage 2: MSC Interface Date	The date the data was interfaced with the MSC in the second stage.
Stage 2: Posted Date	The date the transaction was posted in the second stage.
Stage 2: Unique ID	A unique identifier assigned to the transaction in the second stage.
Source Ref 1-25	Reference fields from the source system for additional details.
Target Ref 1-25	Reference fields in the target system for additional details.

Level-2 Report (Detail)

Measures

Column	Business Description
Stage-1: Quantity	The quantity recorded during the first stage of data processing.
Stage-2: Quantity	The quantity recorded during the second stage of data processing.
Quantity Variance	The difference in quantity between the first and second stages.
Stage-1: Company Amount	The total amount of financial transactions specific to a particular company code in the first stage of data replication.
Stage-2: Company Amount	The total amount of financial transactions specific to a particular company code in the second stage of data replication.
Company Amount Variance	The difference between the company code-specific transaction values in the first and second stages of data replication.
Stage-1: Document Amount	The total amount of a financial transaction in the first stage of data replication.
Stage-2: Document Amount	The total amount of a financial transaction in the second stage of data replication.
Document Amount Variance	The difference between the transaction values in the first and second stages of data replication.
Stage-1: Group Amount	The aggregated financial value grouped by specific criteria (e.g., business units, cost centers) in the first stage of data replication.
Stage-2: Group Amount	The corresponding aggregated group amount in the second stage.
Group Amount Variance	The difference between group amounts in the first and second stages of data replication.
Source Ref 26-30	Custom reference fields from the source system used for additional information or categorization.
Target Ref 26-30	Custom reference fields in the target system used for additional information or categorization.

Attributes

Column	Business Description
Company Currency Code	The currency used for financial transactions within a specific company code.
Document Currency Code	The currency in which the transaction is recorded.
Group Currency Code	The currency used for group-level reporting.
Location	The physical or organizational location associated with financial transactions.
Logical System	The source system from which the data originates.
Mapped SAP Company Code	The SAP company code to which the source system’s company code is mapped.
Source System	The original system from which financial data is replicated to the Central Finance system.
Stage-1: Batch	The batch number assigned during the first stage of data processing.
Stage-1: Business Activity	The type of business activity associated with the financial transaction in the first stage.
Stage-1: Business Unit	The business unit responsible for the financial transaction in the first stage.
Stage-1: Company Code	The company code used in the first stage of data processing.
Stage-1: Customer	The customer associated with the financial transaction in the first stage.
Stage-1: Document Batch Type	The type of document batch processed in the first stage.
Stage-1: Document Date	The date on which a financial transaction was created in the first stage.
Stage-1: Document Number	The unique identifier for the transaction in the first stage.
Stage-1: Document Type	The type of financial transaction in the first stage.
Stage-1: Due Date	The date by which the payment is due in the first stage.
Stage-1: Fiscal Period	The fiscal period applicable during the first stage.
Stage-1: Fiscal Year	The fiscal year applicable during the first stage.
Stage-1: Ledger Type	The type of ledger used in the first stage of processing.
Stage-1: MSC Interface Date	The date the data was interfaced with the MSC in the first stage.
Stage-1: Material Number	The number identifying the material involved in the financial transaction in the first stage.
Stage-1: Object Account	The account associated with the financial transaction in the first stage.
Stage-1: PRD Tax Code	The tax code used for the financial transaction in the first stage.
Stage-1: Posted Date	The date the transaction was posted in the first stage.
Stage-1: Product Code	The code representing the product involved in the financial transaction in the first stage.
Stage-1; Subsidiary	The subsidiary company associated with the financial transaction in the first stage.
Stage-1: Trading Partner ID	The identifier for the trading partner involved in the financial transaction in the first stage.
Stage-1: Transaction Type	The type of transaction in the first stage.
Stage-1: UOM Code	The unit of measure code used for quantities in the first stage.
Stage-1: Unique ID	A unique identifier assigned to the transaction in the first stage.
Stage-1: Vendor	The vendor associated with the financial transaction in the first stage.
Stage-1: WBS Element	The work breakdown structure element associated with the financial transaction in the first stage.
Stage-2: Business Activity	The type of business activity associated with the financial transaction in the second stage.
Stage-2: Company Code	The company code used in the second stage of data processing.
Stage-2: Cost Center	The cost center responsible for the financial transaction in the second stage.
Stage-2: Customer	The customer associated with the financial transaction in the second stage.
Stage-2: Document Type	The type of financial transaction in the second stage.
Stage-2: Due Date	The date by which the payment is due in the second stage.
Stage-2: Fiscal Period	The fiscal period applicable during the second stage.
Stage-2: Fiscal Year	The fiscal year applicable during the second stage.
Stage-2: GL Account	The general ledger account used for the financial transaction in the second stage.
Stage-2: MSC Interface Date	The date the data was interfaced with the MSC in the second stage.
Stage-2: Material Number	The number identifying the material involved in the financial transaction in the second stage.
Stage-2: PRD Tax Code	The tax code used for the financial transaction in the second stage.
Stage-2: Posted Date	The date the transaction was posted in the second stage.
Stage-2: Product Code	The code representing the product involved in the financial transaction in the second stage.
Stage-2: Profit Center	The profit center responsible for the financial transaction in the second stage.
Stage-2: Trading Partner ID	The identifier for the trading partner involved in the financial transaction in the second stage.
Stage-2: Transaction Type	The type of transaction in the second stage.
Stage-2: UOM Code	The unit of measure code used for quantities in the second stage.
Stage-2: Unique ID	A unique identifier assigned to the transaction in the second stage.
Stage-2: Vendor	The vendor associated with the financial transaction in the second stage.
Stage-2: WBS Element	The work breakdown structure element associated with the financial transaction in the second stage.
Source Ref 1-25	Reference fields from the source system for additional details.
Target Ref 1-25	Reference fields in the target system for additional details.

Level-3 Report (Summary)

Measures

Column	Business Description
Stage-2: Company Amount	The total amount of financial transactions specific to a particular company code in the second stage.
SLT: Company Amount	The total amount of financial transactions specific to a particular company code in the SLT (SAP Landscape Transformation) stage.
Company Amount Variance	The difference in company amounts between the second stage and the SLT stage.
Stage-2: Document Amount	The total amount of a financial transaction in the second stage.
SLT: Document Amount	The total amount of a financial transaction in the SLT stage.
Document Amount Variance	The difference in transaction amounts between the second stage and the SLT stage.
Stage-2: Document Count	The total number of financial transactions in the second stage.
SLT: Document Count	The total number of financial transactions in the SLT stage.
Document Count Variance	The difference in the number of financial transactions between the second stage and the SLT stage.
Stage-2: Total Units	The aggregate quantity of units in the second stage.
SLT: Total Units	The aggregate quantity of units in the SLT stage.
Total Units Variance	The difference in total units between the second stage and the SLT stage.
Source Ref 26-30	Custom reference fields from the source system used for additional information or categorization.
Target Ref 26-30	Custom reference fields in the target system used for additional information or categorization.

Attributes

Column	Business Description
Company Currency Code	The currency used for financial transactions within a specific company code.
Document Currency Code	The currency in which the transaction is recorded.
Location	The physical or organizational location associated with financial transactions.
Logical System	The source system from which the data originates.
SLT: Company Code	The company code used in the SLT stage.
SLT: Document Date	The date on which a financial transaction was created in the SLT stage.
SLT: Document Type	The type of financial transaction in the SLT stage.
SLT: Fiscal Period	The fiscal period applicable during the SLT stage.
SLT: Fiscal Year	The fiscal year applicable during the SLT stage.
SLT: MSC Interface Date	The date the data was interfaced with the MSC in the SLT stage.
SLT: Posted Date	The date the transaction was posted in the SLT stage.
SLT: Reference Document Number	The reference transaction number recorded during the SLT stage.
SLT: Unique ID	A unique identifier assigned to the transaction in the SLT stage.
Source Ledger	The ledger from the source system where the original transaction was recorded.
Source System	The original system from which financial data is replicated to the Central Finance system.
Stage-2: Company Code	The company code used in the second stage of data processing.
Stage-2: Document Date	The date the transaction was created in the second stage.
Stage-2: Document Type	The type of financial transaction in the second stage.
Stage-2: Fiscal Period	The fiscal period applicable during the second stage.
Stage-2: Fiscal Year	The fiscal year applicable during the second stage.
Stage-2: MSC Interface Date	The date the data was interfaced with the MSC in the second stage.
Stage-2: Posting Date	The date the transaction was posted in the second stage.
Stage-2 Reference Document Number	The reference transaction number recorded during the second stage.
Stage-2: Unique ID	A unique identifier assigned to the transaction in the second stage.
Source Ref 1-25	Reference fields from the source system for additional details.
Target Ref 1-25	Reference fields in the target system for additional details.

Level-3 Report (Detail)

Measures

Column	Business Description
Stage-2: Quantity	The quantity recorded during the second stage of data processing.
SLT: Quantity	The quantity recorded during the SLT stage.
Quantity Variance	The difference in quantity between the second stage and the SLT stage.
Stage-2: Company Amount	The total amount of financial transactions specific to a particular company code in the second stage.
SLT: Company Amount	The total amount of financial transactions specific to a particular company code in the SLT stage.
Company Amount Variance	The difference in company amounts between the second stage and the SLT stage.
Stage-2: Document Amount	The total amount of a financial transaction in the second stage.
SLT: Document Amount	The total amount of a financial transaction in the SLT stage.
Document Amount Variance	The difference in transaction amounts between the second stage and the SLT stage.
Source Ref 26-30	Reference fields from the source system for additional details.
Target Ref 26-30	Reference fields in the target system for additional details.

Attributes

Column	Business Description
Company Currency Code	The currency used for financial transactions within a specific company code.
Document Currency Code	The currency in which the transaction is recorded.
Location	The physical or organizational location associated with financial transactions.
Logical System	The source system from which the data originates.
SLT: Business Activity	The type of business activity associated with the financial transaction in the SLT stage.
SLT: Company Code	The company code used in the SLT stage.
SLT: Cost Center	The cost center responsible for the financial transaction in the SLT stage.
SLT: Customer	The customer associated with the financial transaction in the SLT stage.
SLT: Document Date	The date on which a financial transaction was created in the SLT stage.
SLT: Document Type	The type of financial transaction in the SLT stage.
SLT: Due Date	The date by which the payment is due in the SLT stage.
SLT: Fiscal Period	The fiscal period applicable during the SLT stage.
SLT: Fiscal Year	The fiscal year applicable during the SLT stage.
SLT: GL Account	The general ledger account used for the financial transaction in the SLT stage.
SLT: Item Number Account	The account number associated with the item during the SLT stage.
SLT: MSC Interface Date	The date the data was interfaced with the MSC in the SLT stage.
SLT: Material Number	The number identifying the material involved in the financial transaction in the SLT stage.
SLT: PRD Tax Code	The tax code used for the financial transaction in the SLT stage.
SLT: Posted Date	The date the transaction was posted in the SLT stage.
SLT: Product Code	The code representing the product involved in the financial transaction in the SLT stage.
SLT: Profit Center	The profit center responsible for the financial transaction in the SLT stage.
SLT: Reference Document Number	The reference transaction number recorded during the SLT stage.
SLT: Trading Partner ID	The identifier for the trading partner involved in the financial transaction in the SLT stage.
SLT: Transaction Type	The type of transaction in the SLT stage.
SLT: UOM Code	The unit of measure code used for quantities in the SLT stage.
SLT: Unique ID	A unique identifier assigned to the transaction in the SLT stage.
SLT: Vendor	The vendor associated with the financial transaction in the SLT stage.
SLT: WBS Element	The work breakdown structure element associated with the financial transaction in the SLT stage.
Source Ledger	The ledger from the source system where the original transaction was recorded.
Source System	The original system from which financial data is replicated to the Central Finance system.
Stage-2: Business Activity	The type of business activity associated with the financial transaction in the second stage.
Stage-2: Company Code	The company code used in the second stage of data processing.
Stage-2: Cost Center	The cost center responsible for the financial transaction in the second stage.
Stage-2: Customer	The customer associated with the financial transaction in the second stage.
Stage-2: Document Date	The date the transaction was created in the second stage.
Stage-2: Document Type	The type of financial transaction in the second stage.
Stage-2: Due Date	The date by which the payment is due in the second stage.
Stage-2: Fiscal Period	The fiscal period applicable during the second stage.
Stage-2: Fiscal Year	The fiscal year applicable during the second stage.
Stage-2: GL Account	The general ledger account used for the financial transaction in the second stage.
Stage-2: Item Number Account	The account number associated with the item during the second stage.
Stage-2: MSC Interface Date	The date the data was interfaced with the MSC in the second stage.
Stage-2: Material Number	The number identifying the material involved in the financial transaction in the second stage.
Stage-2: PRD Tax Code	The tax code used for the financial transaction in the second stage.
Stage-2: Posted Date	The date the transaction was posted in the second stage.
Stage-2: Product Code	The code representing the product involved in the financial transaction in the second stage.
Stage-2: Profit Center	The profit center responsible for the financial transaction in the second stage.
Stage-2: Reference Document Number	The reference transaction number recorded during the second stage.
Stage-2: Trading Partner ID	The identifier for the trading partner involved in the financial transaction in the second stage.
Stage-2: Transaction Type	The type of transaction in the second stage.
Stage-2: UOM Code	The unit of measure code used for quantities in the second stage.
Stage-2: Unique ID	A unique identifier assigned to the transaction in the second stage.
Stage-2: Vendor	The vendor associated with the financial transaction in the second stage.
Stage-2: WBS Element	The work breakdown structure element associated with the financial transaction in the second stage.
Source Ref 1-25	Reference fields from the source system for additional details.
Target Ref 1-25	Reference fields in the target system for additional details.

Level-4 Report

Measures

Column	Business Description
SLT: Document Count	The total number of financial transactions in the SLT stage.
CFIN: Document Count	The total number of financial transactions in the Central Finance system.
Document Count Variance	The difference in transaction counts between the SLT stage and the Central Finance system.
Source Ref 26-30	Custom reference fields from the source system used for additional information or categorization.
Target Ref 26-30	Custom reference fields in the target system used for additional information or categorization.

Attributes

Column	Business Description
CFIN: Company Code	The specific company code associated with financial transactions being processed within the Central Finance system.
CFIN: Document Date	The date on which a financial transaction was created or posted in the Central Finance system.
CFIN: Document Number	Each financial transaction processed within the Central Finance system.
CFIN: Document Type	The type of financial transaction in the Central Finance system.
CFIN: Fiscal Period	The accounting period within a fiscal year during which financial transactions are recorded.
CFIN: Fiscal Year	The fiscal year during which financial transactions are recorded and processed.
CFIN: Logical System	The identifier for the logical system within the Central Finance system.
CFIN: Posted Date	The date on which a financial transaction was posted in the Central Finance system.
CFIN: Unique ID	A unique identifier for each financial transaction within the Central Finance system.
Document Currency Code	The currency in which a financial transaction is recorded.
Location	The physical or organizational location associated with financial transactions.
Logical System	The source system from which financial data is replicated to the Central Finance system.
MSC Interface Date	The date when data was interfaced through the MSC (Master Data Synchronization) process.
SLT: Company Code	The company code used in the SLT stage.
SLT: Document Date	The date on which a financial transaction was created in the SLT stage.
SLT: Fiscal period	The fiscal period applicable during the SLT stage.
SLT: Fiscal Year	The fiscal year applicable during the SLT stage.
SLT: Posting Date	The date the transaction was posted in the SLT stage.
SLT: Reference Document Number	The reference transaction number recorded during the SLT stage.
SLT: Unique ID	A unique identifier assigned to the transaction in the SLT stage.
Source Ref 1-25	Custom reference fields from the source system used for additional information or categorization.
Target Ref 1-25	Custom reference fields in the target system used for additional information or categorization.

Level - 5 Report (Summary)

Measures

Column	Business Description
Source: Document Count	The number of financial transactions in the source system.
cFIN: Document Count	The number of financial transactions in the Central Finance system.
Document Count Variance	The difference between the number of financial transactions in the source system and the Central Finance system.
Source: Total Units	The aggregate quantity of units recorded across all relevant transactions in the source system.
cFIN: Total Units	The aggregate quantity of units replicated from the source system to the Central Finance system.
Total Units variance	The difference between the aggregate quantity of units recorded in the source system and the Central Finance system.
Source: Document Amount	The total amount of a financial transaction in the source system.
cFIN: Document Amount	The total amount of a financial transaction in the Central Finance system.
Document Amount variance	The difference between the transaction values in the source system and the Central Finance system.
Source: Company Amount	The total amount of financial transactions specific to a particular company code in the source system.
cFIN: Company Amount	The total amount of financial transactions specific to a particular company code in the Central Finance system.
Company Amount variance	The difference between the company code-specific transaction values in the source system and the Central Finance system.
Source: Group Amount	The total amount of financial transactions consolidated across all company codes in the source system.
cFIN: Group Amount	The total amount of financial transactions consolidated across all company codes in the Central Finance system.
Group Amount variance	The difference between the consolidated transaction values across company codes in the source system and the Central Finance system.
AIF: Document count	The number of transactions processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
AIF: Total units	The total number of units across transactions processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
AIF: Document Amount	The transaction value processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
AIF: Company Amount	The transaction value specific to each company code processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
AIF: Group Amount	The total transaction value for all company codes processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
In Process: Document count	The number of financial transactions that are currently being processed and have not yet been posted.
In Process: Total units	The total number of financial transaction units that are currently being processed and have not yet been posted.
In Process: Document Amount	The total amount of financial transactions that are currently being processed and have not yet been posted.
In Process: Company Amount	The total amount of financial transactions specific to a particular company code that are currently being processed and have not yet been posted.
In Process: Group Amount	The total amount of financial transactions consolidated across all company codes that are currently being processed and have not yet been posted.

Attributes

Column	Business Description
As of Date	The date up to which financial data is considered current and accurate.
CFIN: Company Code	The specific company code associated with financial transactions being processed within the Central Finance system.
CFIN: Document Date	The date on which a financial transaction was created or posted in the Central Finance system.
CFIN: Document Number	Each financial transaction processed within the Central Finance system.
CFIN: Document Posted Date	The date on which a financial transaction was posted in the Central Finance system.
CFIN: Fiscal Period	The accounting period within a fiscal year during which financial transactions are recorded.
CFIN: Fiscal Year	The fiscal year during which financial transactions are recorded and processed.
CFIN: Ledger Type	The type of ledger used for financial reporting and consolidation within the Central Finance system.
CFIN: Market	The market or region associated with financial transactions in the Central Finance system.
CFIN: Mode	The operational mode or status of financial transactions being processed in the Central Finance system.
CFIN: Unique ID	A unique identifier for each financial transaction within the Central Finance system.
Company Currency Code	The currency used for financial transactions within a specific company code.
Document Currency Code	The currency in which a financial transaction is recorded.
Group Currency Code	The currency used for consolidated financial reporting across all company codes.
Location	The physical or organizational location associated with financial transactions.
Logical System	The source system from which financial data is replicated to the Central Finance system.
MSC Interface Date	The date when data was interfaced through the MSC (Master Data Synchronization) process.
Mapped SAP Company Code	The SAP company code to which the source system’s company code is mapped.
Processing Status	The current status of financial transactions being processed, such as pending or completed.
Source System	The original system from which financial data is replicated to the Central Finance system.
Source: Batch	The batch process that replicated the financial data from the source system.
Source: Company Code	The specific company code associated with financial transactions being processed within the source system.
Source: Document Date	The date on which a financial transaction was created in the source system.
Source: Document Number	Each financial transaction processed in the source system.
Source: Document Posted Date	The date on which a financial transaction was posted in the source system.
Source: Fiscal Period	The accounting period within a fiscal year during which financial transactions are recorded.
Source: Ledger Type	The type of ledger (e.g., general ledger, subledger) from which the financial data is sourced.
Source: Market	The market or region associated with financial transactions in the source system.
Source: Mode	The operational mode or status of financial transactions being processed in the source system.
Source: Unique ID	A unique identifier for each financial transaction within the source system.
Source Ref 1-25	Custom reference fields from the source system used for additional information or categorization.
Target Ref 1-25	Custom reference fields in the target system used for additional information or categorization.

Level - 5 Report (Detail)

Measures

Column	Business Description
Source: Quantity	The quantity of items recorded in the source system.
Target: Quantity	The quantity of items recorded in the target system.
Quantity Variance	The difference in quantity between the source and target systems.
Source: Document Amount	The total amount of a financial transaction in the source system.
CFIN: Document Amount	The total amount of a financial transaction in the Central Finance system.
Document Amount Variance	The difference between the transaction values in the source system and the Central Finance system.
Source: Company Amount	The total amount of financial transactions specific to a particular company code in the source system.
CFIN: Company Amount	The total amount of financial transactions specific to a particular company code in the Central Finance system.
Company Amount Variance	The difference between the company code-specific transaction values in the source system and the Central Finance system.
Source: Group Amount	The total amount of financial transactions consolidated across all company codes in the source system.
CFIN: Group Amount	The total amount of financial transactions consolidated across all company codes in the Central Finance system.
Group Amount Variance	The difference between the consolidated transaction values across company codes in the source system and the Central Finance system.
Source: Alternate Quantity	An alternate quantity measure recorded in the source system.
CFIN: Alternate Quantity	An alternate quantity measure recorded in the Central Finance system.
Alternate Quantity Variance	The difference in alternate quantities between the source and Central Finance systems.
AIF: Quantity	The quantity of items processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
AIF: Document Amount	The transaction value processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
AIF: Company Amount	The transaction value specific to each company code processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
AIF: Group Amount	The total transaction value for all company codes processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
AIF: Alternate Quantity	An alternate quantity measure processed through the Application Interface Framework (AIF) from the source system to the Central Finance system.
Source Ref 26-30	Custom reference fields from the source system used for additional information or categorization.
Target Ref 26-30	Custom reference fields in the target system used for additional information or categorization.

Attributes

Column	Business Description
As of Date	The date up to which financial data is considered current and accurate.
CFIN: Account Group	Group of accounts associated with financial transactions.
CFIN: Alternate UOM	An alternate unit of measure for quantities in the Central Finance system.
CFIN: Baseline Date	The date from which payment terms are calculated in the Central Finance system.
CFIN: Business Activity	The type of business activity associated with the financial transaction.
CFIN: Company Code	The specific company code associated with financial transactions being processed within the Central Finance system.
CFIN: Cost Center	The cost center responsible for the financial transaction in the Central Finance system.
CFIN: Cost Object Number	The unique identifier for a cost object in the Central Finance system.
CFIN: Customer	The customer associated with the financial transaction in the Central Finance system.
CFIN: Document Date	The date on which a financial transaction was created or posted in the Central Finance system.
CFIN: Document Number	Each financial transaction processed within the Central Finance system.
CFIN: Document Posted Date	The date on which a financial transaction was posted in the Central Finance system.
CFIN: Document Type	The type of financial transaction in the Central Finance system.
CFIN: Fiscal Period	The accounting period within a fiscal year during which financial transactions are recorded.
CFIN: Fiscal Year	The fiscal year during which financial transactions are recorded and processed.
CFIN: GL Account	The general ledger account used for the financial transaction in the Central Finance system.
CFIN: HI4	A custom field used for specific reporting or reconciliation needs in the Central Finance system.
CFIN: Ledger	The type of ledger used for financial reporting and consolidation within the Central Finance system.
CFIN: Market	The market or region associated with financial transactions in the Central Finance system.
CFIN: Mode	The operational mode or status of financial transactions being processed in the Central Finance system.
CFIN: Net Due Date	The date by which the payment is due in the Central Finance system.
CFIN: Number of Days	The number of days used to calculate payment terms or aging in the Central Finance system.
CFIN: PRD Tax Code	The tax code used for the financial transaction in the Central Finance system.
CFIN: Payment Block	Blocked payment indicator for the financial transaction in the Central Finance system.
CFIN: Payment Terms	The terms of payment for the financial transaction in the Central Finance system.
CFIN: Product Code	The code representing the product involved in the financial transaction.
CFIN: Profit Center	The profit center responsible for the financial transaction in the Central Finance system.
CFIN: Trading Partner ID	The identifier for the trading partner involved in the financial transaction.
CFIN: Transaction Type	The type of transaction in the Central Finance system.
CFIN: Unique ID	A unique identifier for each financial transaction within the Central Finance system.
CFIN: Vendor	The vendor associated with the financial transaction in the Central Finance system.
CFIN: WBS Element	The work breakdown structure element associated with the financial transaction.
Company Currency Code	The currency used for financial transactions within a specific company code.
Derived Mapped Product Code	The product code obtained by mapping data from the source system to the Central Finance system.
Document Currency Code	The currency in which a financial transaction is recorded.
Group Currency Code	The currency used for consolidated financial reporting across all company codes.
Location	The physical or organizational location associated with financial transactions.
Logical System	The source system from which financial data is replicated to the Central Finance system.
MSC Interface Date	The date when data was interfaced through the MSC (Master Data Synchronization) process.
Mapped SAP Currency Code	The SAP company code to which the source system’s company code is mapped.
Processing Status	The current processing status of the financial transaction in the Central Finance system.
Source: Alternate UOM	An alternate unit of measure for quantities in the source system.
Source: Baseline Date	The date from which payment terms are calculated in the source system.
Source: Batch	The batch process that replicated the financial data from the source system.
Source: Business Activity	The type of business activity associated with the financial transaction in the source system.
Source: Business Unit	The business unit responsible for the financial transaction in the source system.
Source: Company Code	The specific company code associated with financial transactions being processed within the source system.
Source: Cost Center	The cost center responsible for the financial transaction in the source system.
Source: Cost Object Number	The unique identifier for a cost object in the source system.
Source: Customer	The customer associated with the financial transaction in the source system.
Source: Document Date	The date on which a financial transaction was created in the source system.
Source: Document Number	Each financial transaction processed in the source system.
Source: Document Posted Date	The date on which a financial transaction was posted in the source system.
Source: Document Type	The type of financial transaction in the source system.
Source: Due Date	The date by which the payment is due in the source system.
Source: Fiscal Period	The accounting period within a fiscal year during which financial transactions are recorded.
Source: Fiscal Year	The fiscal year during which financial transactions are recorded and processed.
Source: HI4	A custom field used for specific reporting or reconciliation needs in the source system.
Source: Ledger	The type of ledger (e.g., general ledger, subledger) from which the financial data is sourced.
Source: Market	The market or region associated with financial transactions in the source system.
Source: Material Number	The number identifying the material involved in the financial transaction in the source system.
Source: Mode	The operational mode or status of financial transactions being processed in the source system.
Source: Number of Days	The number of days used to calculate payment terms or aging in the source system.
Source: Object Account	The account associated with the financial transaction in the source system.
Source: PRD Tax Code	The tax code used for the financial transaction in the source system.
Source: Payment Block	Blocked payment indicator for the financial transaction in the source system.
Source: Payment Terms	The terms of payment for the financial transaction in the source system.
Source: Product Code	The code representing the product involved in the financial transaction in the source system.
Source: Profit Center	The profit center responsible for the financial transaction in the source system.
Source: Subsidiary	The subsidiary company associated with the financial transaction in the source system.
Source: Trading Partner ID	The identifier for the trading partner involved in the financial transaction in the source system.
Source: Transaction Type	The type of transaction in the source system.
Source: UOM Code	The unit of measure code used for quantities in the source system.
Source: Unique ID	A unique identifier for each financial transaction within the source system.
Source: Updated Transaction Type	The updated type of transaction in the source system.
Source: Vendor	The vendor associated with the financial transaction in the source system.
Source: WBS Element	The work breakdown structure element associated with the financial transaction in the source system.
Source Ref 1-25	Custom reference fields from the source system used for additional information or categorization.
Target Ref 1-25	Custom reference fields in the target system used for additional information or categorization.

GL Balance Report

Measures

Column	Business Description
Source: Beginning Balance Period - GC	The opening balance for the period in the source system, measured in the global currency.
Source: Debit Posting Period - GC	Total debit postings for the period in the source system, measured in the global currency.
Source: Credit Posting Period - GC	Total credit postings for the period in the source system, measured in the global currency.
Source: Ending Balance Period - GC	The closing balance for the period in the source system, measured in the global currency.
CFIN: Beginning Balance Period - GC	The opening balance for the period in SAP Central Finance, measured in the global currency.
CFIN: Debit Posting Period - GC	Total debit postings for the period in SAP Central Finance, measured in the global currency.
CFIN: Credit Posting Period - GC	Total credit postings for the period in SAP Central Finance, measured in the global currency.
CFIN: Ending Balance Period - GC	The closing balance for the period in SAP Central Finance, measured in the global currency.
Variance: Beginning Balance Period - GC	The difference in opening balances between the source system and SAP Central Finance, measured in the global currency.
Variance: Debit Posting Period - GC	The difference in debit postings between the source system and SAP Central Finance, measured in the global currency.
Variance: Credit Posting Period - GC	The difference in credit postings between the source system and SAP Central Finance, measured in the global currency.
Variance: Ending Balance Period - GC	The difference in closing balances between the source system and SAP Central Finance, measured in the global currency.
Source: Beginning Balance Period - TC	The opening balance for the period in the source system, measured in the transaction currency.
Source: Debit Posting Period - TC	Total debit postings for the period in the source system, measured in the transaction currency.
Source: Credit Posting Period - TC	Total credit postings for the period in the source system, measured in the transaction currency.
Source: Ending Balance Period - TC	The closing balance for the period in the source system, measured in the transaction currency.
CFIN: Beginning Balance Period - TC	The opening balance for the period in SAP Central Finance, measured in the transaction currency.
CFIN: Debit Posting Period - TC	Total debit postings for the period in SAP Central Finance, measured in the transaction currency.
CFIN: Credit Posting Period - TC	Total credit postings for the period in SAP Central Finance, measured in the transaction currency.
CFIN: Ending Balance Period - TC	The closing balance for the period in SAP Central Finance, measured in the transaction currency.
Variance: Beginning Balance Period - TC	The difference in opening balances between the source system and SAP Central Finance, measured in the transaction currency.
Variance: Debit Posting Period - TC	The difference in debit postings between the source system and SAP Central Finance, measured in the transaction currency.
Variance: Credit Posting Period - TC	The difference in credit postings between the source system and SAP Central Finance, measured in the transaction currency.
Variance: Ending Balance Period - TC	The difference in closing balances between the source system and SAP Central Finance, measured in the transaction currency.
Source: Beginning Balance Period - CC	The opening balance for the period in the source system, measured in the company code currency.
Source: Debit Posting Period - CC	Total debit postings for the period in the source system, measured in the company code currency.
Source: Credit Posting Period - CC	Total credit postings for the period in the source system, measured in the company code currency.
Source: Ending Balance Period - CC	The closing balance for the period in the source system, measured in the company code currency.
CFIN: Beginning Balance Period - CC	The opening balance for the period in SAP Central Finance, measured in the company code currency.
CFIN: Debit Posting Period - CC	Total debit postings for the period in SAP Central Finance, measured in the company code currency.
CFIN: Credit Posting Period - CC	Total credit postings for the period in SAP Central Finance, measured in the company code currency.
CFIN: Ending Balance Period - CC	The closing balance for the period in SAP Central Finance, measured in the company code currency.
Variance: Beginning Balance Period - CC	The difference in opening balances between the source system and SAP Central Finance, measured in the company code currency.
Variance: Debit Posting Period - CC	The difference in debit postings between the source system and SAP Central Finance, measured in the company code currency.
Variance: Credit Posting Period - CC	The difference in credit postings between the source system and SAP Central Finance, measured in the company code currency.
Variance: Ending Balance Period - CC	The difference in closing balances between the source system and SAP Central Finance, measured in the company code currency.
Source: Beginning Quantity Period	The opening quantity for the period in the source system.
Source: Debit Quantity Period	Total debit quantities for the period in the source system.
Source: Credit Quantity Period	Total credit quantities for the period in the source system.
Source: Ending Quantity Period	The closing quantity for the period in the source system.
CFIN: Beginning Quantity Period	The opening quantity for the period in SAP Central Finance.
CFIN: Debit Quantity Period	Total debit quantities for the period in SAP Central Finance.
CFIN: Credit Quantity Period	Total credit quantities for the period in SAP Central Finance.
CFIN: Ending Quantity Period	The closing quantity for the period in SAP Central Finance.
Variance: Beginning Quantity Period	The difference in opening quantities between the source system and SAP Central Finance.
Variance: Debit Quantity Period	The difference in debit quantities between the source system and SAP Central Finance.
Variance: Credit Quantity Period	The difference in credit quantities between the source system and SAP Central Finance.
Variance: Ending Quantity Period	The difference in closing quantities between the source system and SAP Central Finance.
Source: Debit Alt. Quantity Period	Total debit alternative quantities for the period in the source system.
Source: Credit Alt. Quantity Period	Total credit alternative quantities for the period in the source system.
Source: Ending Alt. Quantity Period	The closing alternative quantity for the period in the source system.
CFIN: Beginning Alt. Quantity Period	The opening alternative quantity for the period in SAP Central Finance.
CFIN: Debit Alt. Quantity Period	Total debit alternative quantities for the period in SAP Central Finance.
CFIN: Credit Alt. Quantity Period	Total credit alternative quantities for the period in SAP Central Finance.
CFIN: Ending Alt. Quantity Period	The closing alternative quantity for the period in SAP Central Finance.
Variance: Beginning Alt. Quantity Period	The difference in opening alternative quantities between the source system and SAP Central Finance.
Variance: Debit Alt. Quantity Period	The difference in debit alternative quantities between the source system and SAP Central Finance.
Variance: Credit Alt. Quantity Period	The difference in credit alternative quantities between the source system and SAP Central Finance.
Variance: Ending Alt. Quantity Period	The difference in closing alternative quantities between the source system and SAP Central Finance.
Source Ref 26-30	Custom reference fields from the source system used for additional information or categorization.
Target Ref 26-30	Custom reference fields in the target system used for additional information or categorization.

Attributes

Column	Business Description
As Of Date	The date up to which financial data is considered current and accurate.
CFIN: Account	The general ledger account in SAP Central Finance.
CFIN: Account UOM	The unit of measure associated with the account in SAP Central Finance.
CFIN: Base UOM	The base unit of measure for transactions in SAP Central Finance.
CFIN: Business Activity Code	The code representing the business activity in SAP Central Finance.
CFIN: Company Code	The specific company code associated with financial transactions being processed within the Central Finance system.
CFIN: Company Currency Code (CC)	The currency code used by the company in SAP Central Finance.
CFIN: Cost Center	The cost center responsible for the financial transaction in the Central Finance system.
CFIN: Customer	The customer associated with the financial transaction in the Central Finance system.
CFIN: Document Type	The type of financial transaction in the Central Finance system.
CFIN: Fiscal Period	The accounting period within a fiscal year during which financial transactions are recorded.
CFIN: Fiscal Year	The fiscal year during which financial transactions are recorded and processed.
CFIN: Group Currency Code (GC)	The currency code used for group-level reporting in SAP Central Finance.
CFIN: HI4	A custom field used for specific reporting or reconciliation needs in the Central Finance system.
CFIN: JV Partner	The joint venture partner associated with the transaction in SAP Central Finance.
CFIN: JV Recovery Indicator	The indicator for joint venture recovery in SAP Central Finance.
CFIN: Ledger	The type of ledger used for financial reporting and consolidation within the Central Finance system.
CFIN: Product Code	The code representing the product involved in the financial transaction.
CFIN: Product Sold Code	The code representing the product sold in SAP Central Finance.
CFIN: Profit Center	The profit center responsible for the financial transaction in the Central Finance system.
CFIN: Trading Partner	The trading partner involved in the transaction in SAP Central Finance.
CFIN: Transaction Currency Code (TC)	The currency code used for the transaction in SAP Central Finance.
CFIN: Transaction Type	The type of transaction in the Central Finance system.
CFIN: Vendor	The vendor associated with the financial transaction in the Central Finance system.
CFIN: Venture Number	The number identifying the venture in SAP Central Finance.
CFIN: WBS Element	The work breakdown structure element associated with the financial transaction.
Mapped CFIN Company Code	The company code mapped in SAP Central Finance.
Reconciliation Site	The site used for reconciliation in SAP Central Finance.
Source System	The original system from which financial data is replicated to the Central Finance system.
Source: Account	The general ledger account in the source system.
Source: Account UOM	The unit of measure associated with the account in the source system.
Source: Base UOM	The base unit of measure for transactions in the source system.
Source: Business Activity Code	The code representing the business activity in the source system.
Source: Company Code	The specific company code associated with financial transactions being processed within the source system.
Source: Company Currency Code (CC)	The currency code used by the company in the source system.
Source: Cost Center	The cost center associated with the transaction in the source system.
Source: Customer	The customer involved in the transaction in the source system.
Source: Document Type	The type of transaction in the source system.
Source: ERP Type	The type of ERP system used as the source.
Source: Fiscal Period	The accounting period within a fiscal year during which financial transactions are recorded.
Source: Fiscal Year	The fiscal year during which financial transactions are recorded and processed.
Source: Group Currency Code (GC)	The currency code used for group-level reporting in the source system.
Source: HI4	A custom field used for specific reporting or reconciliation needs in the source system.
Source: JV Partner	The joint venture partner associated with the transaction in the source system.
Source: JV Recovery Indicator	The indicator for joint venture recovery in the source system.
Source: Ledger	The type of ledger (e.g., general ledger, subledger) from which the financial data is sourced.
Source: Product Code	The code representing the product involved in the financial transaction in the source system.
Source: Product Sold Code	The code representing the product sold in the source system.
Source: Profit Center	The profit center responsible for the financial transaction in the source system.
Source: Subsidiary	The subsidiary company associated with the financial transaction in the source system.
Source: Trading Partner	The trading partner involved in the transaction in the source system.
Source: Transaction Currency Code (TC)	The currency code used for the transaction in the source system.
Source: Transaction Type	The type of transaction in the source system.
Source: Vendor	The vendor associated with the financial transaction in the source system.
Source: Venture Number	The number identifying the venture in the source system.
Source Ref 1-25	Custom reference fields from the source system used for additional information or categorization.
Target Ref 1-25	Custom reference fields in the target system used for additional information or categorization.

Level-1 Reconciliation Report

The insightsoftware Reconciliation Level – 1 report compares the financial documents created in your source system with the documents that are extracted and loaded by Transaction into the initial staging tables of Stage 1 in the staging database.

To access the report, provide values for the following prompts:

Source System
Source Ledger
Source Company Code
Source Document Number
Source Batch
Source Doc. Posted Date-Start
Source Doc. Posted Date-End
Source Fiscal Period
Source Fiscal Year
Source Location

A screenshot of the report is as follows.

Level-2 Reconciliation Report

The insightsoftware Reconciliation Level - 2 Summary and insightsoftware Reconciliation Level - 2 Detail reports compare the financial documents in the initial staging tables of Stage 1 and in the FIN% tables of Stage 2 in the staging database. The reports help you ensure that all documents are transferred into the FIN% tables after transformations and validations.

To access the reports, provide values for the following prompts:

Source System
Source Ledger
Source Company Code
Source Document Number
Source Batch
Source Doc. Posted Date-Start
Source Doc. Posted Date-End
Source Fiscal Period
Source Fiscal Year
Source Location

A screenshot of the insightsoftware Reconciliation Level - 2 Summary report showing the comparison of document header attributes is as follows.

A screenshot of the insightsoftware Reconciliation Level - 2 Detail report showing the comparison of document line item attributes is as follows.

Level-3 Reconciliation Report

The insightsoftware Reconciliation Level - 3 Summary and insightsoftware Reconciliation Level - 3 Detail reports compare the financial documents in the FIN% tables of Stage 2 in the staging database and in the interface tables in SLT Replication Server. The reports help you ensure that all documents are transferred into the interface tables.

To access the reports, provide values for the following prompts:

Source System
Source Company Code
Source Batch
Source Doc. Posted Date-Start
Source Doc. Posted Date-End
Source Fiscal Period
Source Fiscal Year
Source Location

A screenshot of the insightsoftware Reconciliation Level - 3 Summary report showing the comparison of document header attributes is as follows.

A screenshot of the insightsoftware Reconciliation Level - 3 Detail report showing the comparison of document line item attributes is as follows.

Level-4 Reconciliation Report

The insightsoftware Reconciliation Level - 4 report compares the financial documents in the interface tables in SLT Replication Server and in SAP S/4HANA. This report helps you ensure that all documents are transferred to SAP S/4HANA.

To access the report, provide values for the following prompts:

Source System
Source Company Code
Source Batch
Source Doc. Posted Date-Start
Source Doc. Posted Date-End
Source Fiscal Period
Source Fiscal Year
Source Location

A screenshot of the insightsoftware Reconciliation Level - 4 report is as follows.

Level-5 Reconciliation Report

The insightsoftware Reconciliation Level - 5 Summary and insightsoftware Reconciliation Level - 5 Detail reports compare the financial documents at the line-item level in the initial staging tables of Stage 1 of the staging database and in SAP S/4HANA.

The reports provide the variance in amounts and quantities that help you reconcile the amount and quantity information. The reports include the following transaction types:

Financial Accounting (FI) documents
Controlling (CO) documents
Accounts receivables and accounts payable open items

Note: You must filter the rows by the As Of Date field for the report to function correctly.

To access the reports, provide values for the following prompts:

Source System
Source Ledger
Source Company Code
Source Document Number
Source Batch
Source Doc. Posted Date-Start
Source Doc. Posted Date-End
Source Fiscal Period
Source Fiscal Year
Source Location
Source Market
Source Mode
Source Cost Center (Only for Detail Level)

A screenshot of the insightsoftware Reconciliation Level - 5 Summary report showing the comparison of document header attributes is as follows.

A screenshot of the insightsoftware Reconciliation Level - 5 Detail report showing the comparison of document line item attributes is as follows.

GL Balance Report

The GL Balance report compares the GL account balance between the Stage 1 of the initial staging tables in the staging database and SAP S/4HANA. The balance includes the beginning balance, net credit posting, net debit posting, and ending balance for a period. The report also captures the variance in amounts that may have occurred due to the exceptions in SAP Application Interface Framework (SAP AIF) or Transaction.

To access the report, provide values for the following prompts:

Source Ledger
Source Company Code
Statement Type
Source Fiscal Year
Source Fiscal Period From
Source Fiscal Period To
Currency Type

A screenshot of the GL Balances report is as follows.

AVL Reconciliation Reports

The AVL reconciliation reports enable you to compare the changes to the accounting view of logistics data through the stages of replication and transformation from your source system into SAP S/4HANA.

Note: AVL reconciliation reports are available for the Oracle PeopleSoft source system.

Attributes

The key measures and attributes specific to each level of reconciliation reports are as follows.

Level-1 Report

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Purchase Order (PO) object:

SOURCE_RPLD_PO_ORDER
STAGE1_RPLD_PO_ORDER
SOURCE_RPLD_PO_ITEM
STAGE1_RPLD_PO_ITEM
SOURCE_RPLD_SCHEDLINE
STAGE1_RPLD_SCHEDLINE
SOURCE_COMPANYCODE
STAGE1_COMPANYCODE
SOURCE_ORD_CREATIONDT
STAGE1_ORD_CREATIONDT
SOURCE_ORD_CREATEDBY
STAGE1_ORD_CREATEDBY
SOURCE_DELIVERY_DT
STAGE1_DELIVERY_DT
SOURCE_SALESGROUP
STAGE1_SALESGROUP
SOURCE_MATERIAL
STAGE1_MATERIAL
SOURCE_PLANT
STAGE1_PLANT
SOURCE_UOM
STAGE1_UOM
SOURCE_CURRENCY
STAGE1_CURRENCY
SOURCE_SUPPLIER
STAGE1_SUPPLIER
SOURCE_QTY
STAGE1_QTY
QTY_VARIANCE
SOURCE_NETAMOUNT
STAGE1_NETAMOUNT
NETAMOUNT_VARIANCE
SOURCE_DOCUMENT_CNT
STAGE1_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Order (CO) object:

SOURCE_RPLD_SODOC
STAGE1_RPLD_SODOC
SOURCE_RPLD_SOITEM
STAGE1_RPLD_SOITEM
SOURCE_RPLD_SCHEDLINE
STAGE1_RPLD_SCHEDLINE
SOURCE_COMPANYCODE
STAGE1_COMPANYCODE
SOURCE_ORD_CREATIONDT
STAGE1_ORD_CREATIONDT
SOURCE_CUSTOMER
STAGE1_CUSTOMER
SOURCE_DELIVERY_DT
STAGE1_DELIVERY_DT
SOURCE_SALESORDERTYPE
STAGE1_SALESORDERTYPE
SOURCE_MATERIAL
STAGE1_MATERIAL
SOURCE_PLANT
STAGE1_PLANT
SOURCE_UOM
STAGE1_UOM
SOURCE_CURRENCY
STAGE1_CURRENCY
SOURCE_QTY
STAGE1_QTY
QTY_VARIANCE
SOURCE_NETAMOUNT
STAGE1_NETAMOUNT
NETAMOUNT_VARIANCE
SOURCE_DOCUMENT_CNT
STAGE1_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Invoice (CI) object:

SOURCE_REPLICATED_CIDOC
STAGE1_REPLICATED_CIDOC
SOURCE_REPLICATED_CIITEM
STAGE1_REPLICATED_CIITEM
SOURCE_BILLINGDATE
STAGE1_BILLINGDATE
SOURCE_CREATIONDATE
STAGE1_CREATIONDATE
SOURCE_COMPANYCODE
STAGE1_COMPANYCODE
SOURCE_SOLDTOPARTY
STAGE1_SOLDTOPARTY
SOURCE_MATERIAL
STAGE1_MATERIAL
SOURCE_PLANT
STAGE1_PLANT
SOURCE_UOM
STAGE1_UOM
SOURCE_CURRENCY
STAGE1_CURRENCY
SOURCE_QUANTITY
STAGE1_QUANTITY
QUANTITY_VARIANCE
SOURCE_NETAMOUNT
STAGE1_NETAMOUNT
NETAMOUNT_VARIANCE
SOURCE_DOCUMENT_CNT
STAGE1_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Supplier Invoice (SI) object:

SOURCE_REPLICATED_SIDOC
STAGE1_REPLICATED_SIDOC
SOURCE_REPLICATED_SIITEM
STAGE1_REPLICATED_SIITEM
SOURCE_DOCUMENTDATE
STAGE1_DOCUMENTDATE
SOURCE_CREATIONDATE
STAGE1_CREATIONDATE
SOURCE_COMPANYCODE
STAGE1_COMPANYCODE
SOURCE_INVOICINGPARTY
STAGE1_INVOICINGPARTY
SOURCE_PLANT
STAGE1_PLANT
SOURCE_MATERIAL
STAGE1_MATERIAL
SOURCE_UOM
STAGE1_UOM
SOURCE_CURRENCY
STAGE1_CURRENCY
SOURCE_QUANTITY
STAGE1_QUANTITY
QUANTITY_VARIANCE
SOURCE_NETAMOUNT
STAGE1_NETAMOUNT
NETAMOUNT_VARIANCE
SOURCE_DOCUMENT_CNT
STAGE1_DOCUMENT_CNT
DOC_CNT_VARIANCE

Level-2 Report (Summary)

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Purchase Order (PO) object:

STAGE1_RPLD_PO_DOC
STAGE2_RPLD_PO_DOC
STAGE1_RPLD_PO_ITEM
STAGE2_RPLD_PO_ITEM
STAGE1_RPLD_SCHEDLINE
STAGE2_RPLD_SCHEDLINE
STAGE1_COMPANYCODE
STAGE2_COMPANYCODE
STAGE1_ORD_CREATIONDT
STAGE2_ORD_CREATIONDT
STAGE1_ORD_CREATEDBY
STAGE2_ORD_CREATEDBY
STAGE1_SALESGROUP
STAGE2_SALESGROUP
STAGE1_DELIVERY_DT
STAGE2_DELIVERY_DT
STAGE1_MATERIAL
STAGE2_MATERIAL
STAGE1_PLANT
STAGE2_PLANT
STAGE1_UOM
STAGE2_UOM
STAGE1_CURRENCY
STAGE2_CURRENCY
STAGE1_SUPPLIER
STAGE2_SUPPLIER
STAGE1_QUANTITY
STAGE2_QUANTITY
QUANTITY_VARIANCE
STAGE1_NETAMOUNT
STAGE2_NETAMOUNT
NETAMOUNT_VARIANCE
STAGE1_DOCUMENT_CNT
STAGE2_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Order (CO) object:

STAGE1_RPLD_SODOC
STAGE2_RPLD_SODOC
STAGE1_RPLD_SOITEM
STAGE2_RPLD_SOITEM
STAGE1_RPLD_SCHEDLINE
STAGE2_RPLD_SCHEDLINE
STAGE1_COMPANYCODE
STAGE2_COMPANYCODE
STAGE1_ORD_CREATIONDT
STAGE2_ORD_CREATIONDT
STAGE1_CUSTOMER
STAGE2_CUSTOMER
STAGE1_DELIVERY_DT
STAGE2_DELIVERY_DT
STAGE1_MATERIAL
STAGE2_MATERIAL
STAGE1_PLANT
STAGE2_PLANT
STAGE1_UOM
STAGE2_UOM
STAGE1_CURRENCY
STAGE2_CURRENCY
STAGE1_QTY
STAGE2_QTY
QTY_VARIANCE
STAGE1_NETAMOUNT
STAGE2_NETAMOUNT
NETAMOUNT_VARIANCE
STAGE1_DOCUMENT_CNT
STAGE2_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Invoice (CI) object:

STAGE1_REPLICATED_CIDOC
STAGE2_REPLICATED_CIDOC
STAGE1_REPLICATED_CIITEM
STAGE2_REPLICATED_CIITEM
STAGE1_BILLINGDATE
STAGE2_BILLINGDATE
STAGE1_CREATIONDATE
STAGE2_CREATIONDATE
STAGE1_COMPANYCODE
STAGE2_COMPANYCODE
STAGE1_SOLDTOPARTY
STAGE2_SOLDTOPARTY
STAGE1_MATERIAL
STAGE2_MATERIAL
STAGE1_PLANT
STAGE2_PLANT
STAGE1_UOM
STAGE2_UOM
STAGE1_CURRENCY
STAGE2_CURRENCY
STAGE1_QUANTITY
STAGE2_QUANTITY
QUANTITY_VARIANCE
STAGE1_NETAMOUNT
STAGE2_NETAMOUNT
NETAMOUNT_VARIANCE
STAGE1_DOCUMENT_CNT
STAGE2_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Supplier Invoice (SI) object:

STAGE1_REPLICATED_SIDOC
STAGE2_REPLICATED_SIDOC
STAGE1_REPLICATED_SIITEM
STAGE2_REPLICATED_SIITEM
STAGE1_DOCUMENTDATE
STAGE2_DOCUMENTDATE
STAGE1_CREATIONDATE
STAGE2_CREATIONDATE
STAGE1_COMPANYCODE
STAGE2_COMPANYCODE
STAGE1_INVOICINGPARTY
STAGE2_INVOICINGPARTY
STAGE1_PLANT
STAGE2_PLANT
STAGE1_MATERIAL
STAGE2_MATERIAL
STAGE1_UOM
STAGE2_UOM
STAGE1_CURRENCY
STAGE2_CURRENCY
STAGE1_QUANTITY
STAGE2_QUANTITY
QUANTITY_VARIANCE
STAGE1_NETAMOUNT
STAGE2_NETAMOUNT
NETAMOUNT_VARIANCE
STAGE1_DOCUMENT_CNT
STAGE2_DOCUMENT_CNT
DOC_CNT_VARIANCE

Level-2 Report (Detail)

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Purchase Order (PO) object:

STAGE1_RPLD_PO_DOC
STAGE2_RPLD_PO_DOC
STAGE1_RPLD_PO_ITEM
STAGE2_RPLD_PO_ITEM
STAGE1_RPLD_SCHEDLINE
STAGE2_RPLD_SCHEDLINE
STAGE1_COMPANYCODE
STAGE2_COMPANYCODE
STAGE1_ORD_CREATIONDT
STAGE2_ORD_CREATIONDT
STAGE1_ORD_CREATEDBY
STAGE2_ORD_CREATEDBY
STAGE1_SALESGROUP
STAGE2_SALESGROUP
STAGE1_DELIVERY_DT
STAGE2_DELIVERY_DT
STAGE1_MATERIAL
STAGE2_MATERIAL
STAGE1_PLANT
STAGE2_PLANT
STAGE1_UOM
STAGE2_UOM
STAGE1_CURRENCY
STAGE2_CURRENCY
STAGE1_SUPPLIER
STAGE2_SUPPLIER
STAGE1_QUANTITY
STAGE2_QUANTITY
QUANTITY_VARIANCE
STAGE1_NETAMOUNT
STAGE2_NETAMOUNT
NETAMOUNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Order (CO) object:

STAGE1_RPLD_SODOC
STAGE2_RPLD_SODOC
STAGE1_RPLD_SOITEM
STAGE2_RPLD_SOITEM
STAGE1_RPLD_SCHEDLINE
STAGE2_RPLD_SCHEDLINE
STAGE1_COMPANYCODE
STAGE2_COMPANYCODE
STAGE1_ORD_CREATIONDT
STAGE2_ORD_CREATIONDT
STAGE1_CUSTOMER
STAGE2_CUSTOMER
STAGE1_DELIVERY_DT
STAGE2_DELIVERY_DT
STAGE1_MATERIAL
STAGE2_MATERIAL
STAGE1_PLANT
STAGE2_PLANT
STAGE1_UOM
STAGE2_UOM
STAGE1_CURRENCY
STAGE2_CURRENCY
STAGE1_QTY
STAGE2_QTY
QTY_VARIANCE
STAGE1_NETAMOUNT
STAGE2_NETAMOUNT
NETAMOUNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Supplier Invoice (SI) object:

STAGE1_REPLICATED_SIDOC
STAGE2_REPLICATED_SIDOC
STAGE1_REPLICATED_SIITEM
STAGE2_REPLICATED_SIITEM
STAGE1_DOCUMENTDATE
STAGE2_DOCUMENTDATE
STAGE1_CREATIONDATE
STAGE2_CREATIONDATE
STAGE1_COMPANYCODE
STAGE2_COMPANYCODE
STAGE1_INVOICINGPARTY
STAGE2_INVOICINGPARTY
STAGE1_PLANT
STAGE2_PLANT
STAGE1_MATERIAL
STAGE2_MATERIAL
STAGE1_UOM
STAGE2_UOM
STAGE1_CURRENCY
STAGE2_CURRENCY
STAGE1_QUANTITY
STAGE2_QUANTITY
QUANTITY_VARIANCE
STAGE1_NETAMOUNT
STAGE2_NETAMOUNT
NETAMOUNT_VARIANCE

Level-3 Report (Summary)

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Purchase Order (PO) object:

STAGE2_RPLD_PODOC
SLT_RPLD_PODOC
STAGE2_RPLD_POITEM
SLT_RPLD_POITEM
STAGE2_RPLD_SCHEDLINE
SLT_RPLD_SCHEDLINE
STAGE2_COMPANYCODE
SLT_COMPANYCODE
STAGE2_ORD_CREATIONDT
SLT_ORD_CREATIONDT
STAGE2_ORD_CREATEDBY
SLT_ORD_CREATEDBY
STAGE2_SALESGROUP
SLT_SALESGROUP
STAGE2_DELIVERY_DT
SLT_DELIVERY_DT
STAGE2_MATERIAL
SLT_MATERIAL
STAGE2_PLANT
SLT_PLANT
STAGE2_UOM
SLT_UOM
STAGE2_CURRENCY
SLT_CURRENCY
STAGE2_SUPPLIER
SLT_SUPPLIER
STAGE2_QUANTITY
SLT_QUANTITY
QUANTITY_VARIANCE
STAGE2_NETAMOUNT
SLT_NETAMOUNT
NETAMOUNT_VARIANCE
STAGE2_DOCUMENT_CNT
SLT_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Order (CO) object:

STAGE2_RPLD_SODOC
SLT_RPLD_SODOC
STAGE2_RPLD_SOITEM
SLT_RPLD_SOITEM
STAGE2_RPLD_SCHEDLINE
SLT_RPLD_SCHEDLINE
STAGE2_COMPANYCODE
SLT_COMPANYCODE
STAGE2_ORD_CREATIONDT
SLT_ORD_CREATIONDT
STAGE2_CUSTOMER
SLT_CUSTOMER
STAGE2_DELIVERY_DT
SLT_DELIVERY_DT
STAGE2_MATERIAL
SLT_MATERIAL
STAGE2_PLANT
SLT_PLANT
STAGE2_UOM
SLT_UOM
STAGE2_CURRENCY
SLT_CURRENCY
STAGE2_QTY
SLT_QTY
QTY_VARIANCE
STAGE2_NETAMOUNT
SLT_NETAMOUNT
NETAMOUNT_VARIANCE
STAGE2_DOCUMENT_CNT
SLT_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Invoice (CI) object:

STAGE2_REPLICATED_CIDOC
SLT_REPLICATED_CIDOC
STAGE2_REPLICATED_CIITEM
SLT_REPLICATED_CIITEM
STAGE2_BILLINGDATE
SLT_BILLINGDATE
STAGE2_CREATIONDATE
SLT_CREATIONDATE
STAGE2_COMPANYCODE
SLT_COMPANYCODE
STAGE2_SOLDTOPARTY
SLT_SOLDTOPARTY
STAGE2_MATERIAL
SLT_MATERIAL
STAGE2_PLANT
SLT_PLANT
STAGE2_UOM
SLT_UOM
STAGE2_CURRENCY
SLT_CURRENCY
STAGE2_BILLINGQUANTITY
SLT_BILLINGQUANTITY
BILLINGQUANTITY_VARIANCE
STAGE2_NETAMOUNT
SLT_NETAMOUNT
NETAMOUNT_VARIANCE
STAGE2_DOCUMENT_CNT
SLT_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Supplier Invoice (SI) object:

STAGE2_REPLICATED_SIDOC
SLT_REPLICATED_SIDOC
STAGE2_REPLICATED_SIITEM
SLT_REPLICATED_SIITEM
STAGE2_DOCUMENTDATE
SLT_DOCUMENTDATE
STAGE2_CREATIONDATE
SLT_CREATIONDATE
STAGE2_COMPANYCODE
SLT_COMPANYCODE
STAGE2_INVOICINGPARTY
SLT_INVOICINGPARTY
STAGE2_PLANT
SLT_PLANT
STAGE2_MATERIAL
SLT_MATERIAL
STAGE2_UOM
SLT_UOM
STAGE2_CURRENCY
SLT_CURRENCY
STAGE2_QUANTITY
SLT_QUANTITY
QUANTITY_VARIANCE
STAGE2_NETAMOUNT
SLT_NETAMOUNT
NETAMOUNT_VARIANCE
STAGE2_DOCUMENT_CNT
SLT_DOCUMENT_CNT
DOC_CNT_VARIANCE

Level-3 Report (Detail)

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Purchase Order (PO) object:

STAGE2_RPLD_PODOC
SLT_RPLD_PODOC
STAGE2_RPLD_POITEM
SLT_RPLD_POITEM
STAGE2_RPLD_SCHEDLINE
SLT_RPLD_SCHEDLINE
STAGE2_COMPANYCODE
SLT_COMPANYCODE
STAGE2_ORD_CREATIONDT
SLT_ORD_CREATIONDT
STAGE2_ORD_CREATEDBY
SLT_ORD_CREATEDBY
STAGE2_SALESGROUP
SLT_SALESGROUP
STAGE2_DELIVERY_DT
SLT_DELIVERY_DT
STAGE2_MATERIAL
SLT_MATERIAL
STAGE2_PLANT
SLT_PLANT
STAGE2_UOM
SLT_UOM
STAGE2_CURRENCY
SLT_CURRENCY
STAGE2_SUPPLIER
SLT_SUPPLIER
STAGE2_QUANTITY
SLT_QUANTITY
QUANTITY_VARIANCE
STAGE2_NETAMOUNT
SLT_NETAMOUNT
NETAMOUNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Order (CO) object:

STAGE2_RPLD_SODOC
SLT_RPLD_SODOC
STAGE2_RPLD_SOITEM
SLT_RPLD_SOITEM
STAGE2_RPLD_SCHEDLINE
SLT_RPLD_SCHEDLINE
STAGE2_COMPANYCODE
SLT_COMPANYCODE
STAGE2_ORD_CREATIONDT
SLT_ORD_CREATIONDT
STAGE2_CUSTOMER
SLT_CUSTOMER
STAGE2_DELIVERY_DT
SLT_DELIVERY_DT
STAGE2_MATERIAL
SLT_MATERIAL
STAGE2_PLANT
SLT_PLANT
STAGE2_UOM
SLT_UOM
STAGE2_CURRENCY
SLT_CURRENCY
STAGE2_QTY
SLT_QTY
QTY_VARIANCE
STAGE2_NETAMOUNT
SLT_NETAMOUNT
NETAMOUNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Invoice (CI) object:

STAGE2_REPLICATED_CIDOC
SLT_REPLICATED_CIDOC
STAGE2_REPLICATED_CIITEM
SLT_REPLICATED_CIITEM
STAGE2_BILLINGDATE
SLT_BILLINGDATE
STAGE2_CREATIONDATE
SLT_CREATIONDATE
STAGE2_COMPANYCODE
SLT_COMPANYCODE
STAGE2_SOLDTOPARTY
SLT_SOLDTOPARTY
STAGE2_MATERIAL
SLT_MATERIAL
STAGE2_PLANT
SLT_PLANT
STAGE2_UOM
SLT_UOM
STAGE2_CURRENCY
SLT_CURRENCY
STAGE2_BILLINGQUANTITY
SLT_BILLINGQUANTITY
BILLINGQUANTITY_VARIANCE
STAGE2_NETAMOUNT
SLT_NETAMOUNT
NETAMOUNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Supplier Invoice (SI) object:

STAGE2_REPLICATED_SIDOC
SLT_REPLICATED_SIDOC
STAGE2_REPLICATED_SIITEM
SLT_REPLICATED_SIITEM
STAGE2_DOCUMENTDATE
SLT_DOCUMENTDATE
STAGE2_CREATIONDATE
SLT_CREATIONDATE
STAGE2_COMPANYCODE
SLT_COMPANYCODE
STAGE2_INVOICINGPARTY
SLT_INVOICINGPARTY
STAGE2_PLANT
SLT_PLANT
STAGE2_MATERIAL
SLT_MATERIAL
STAGE2_UOM
SLT_UOM
STAGE2_CURRENCY
SLT_CURRENCY
STAGE2_QUANTITY
SLT_QUANTITY
QUANTITY_VARIANCE
STAGE2_NETAMOUNT
SLT_NETAMOUNT
NETAMOUNT_VARIANCE

Level-4 Report

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Purchase Order (PO) object:

SLT_RPLD_PODOC
CFIN_RPLD_PODOC
SLT_RPLD_POITEM
CFIN_RPLD_POITEM
SLT_RPLD_SCHEDLINE
CFIN_RPLD_SCHEDLINE
SLT_COMPANYCODE
CFIN_COMPANYCODE
SLT_ORD_CREATIONDT
CFIN_ORD_CREATIONDT
SLT_ORD_CREATEDBY
CFIN_ORD_CREATEDBY
SLT_DELIVERY_DT
CFIN_DELIVERY_DT
SLT_SALESGROUP
CFIN_SALESGROUP
SLT_MATERIAL
CFIN_MATERIAL
SLT_PLANT
CFIN_PLANT
SLT_UOM
CFIN_UOM
SLT_CURRENCY
CFIN_CURRENCY
SLT_SUPPLIER
CFIN_SUPPLIER
SLT_QUANTITY
CFIN_TRGT_QTY
QTY_VARIANCE
SLT_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Order (CO) object:

SLT_RPLD_SODOC
CFIN_RPLD_SODOC
SLT_RPLD_SOITEM
CFIN_RPLD_SOITEM
SLT_RPLD_SCHEDLINE
CFIN_RPLD_SCHEDLINE
SLT_COMPANYCODE
CFIN_COMPANYCODE
SLT_ORD_CREATIONDT
CFIN_ORD_CREATIONDT
SLT_CUSTOMER
CFIN_CUSTOMER
SLT_MATERIAL
CFIN_MATERIAL
SLT_PLANT
CFIN_PLANT
SLT_UOM
CFIN_UOM
SLT_CURRENCY
CFIN_CURRENCY
SLT_QTY
CFIN_QTY
QTY_VARIANCE
SLT_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE
SLT_DOC_CNT
CFIN_DOC_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Invoice (CI) object:

SLT_REPLICATED_CIDOC
CFIN_REPLICATED_CIDOC
SLT_REPLICATED_CIITEM
CFIN_REPLICATED_CIITEM
SLT_BILLINGDATE
CFIN_BILLINGDATE
SLT_COMPANYCODE
CFIN_COMPANYCODE
SLT_ORD_CREATIONDT
CFIN_ORD_CREATIONDT
SLT_SOLDTOPARTY
CFIN_SOLDTOPARTY
SLT_MATERIAL
CFIN_MATERIAL
SLT_PLANT
CFIN_PLANT
SLT_UOM
CFIN_UOM
SLT_CURRENCY
CFIN_CURRENCY
SLT_QUANTITY
CFIN_QUANTITY
QUANTITY_VARIANCE
SLT_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE
SLT_DOC_CNT
CFIN_DOC_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Supplier Invoice (SI) object:

SLT_REPLICATED_SIDOC
CFIN_REPLICATED_SIDOC
SLT_REPLICATED_SIITEM
CFIN_REPLICATED_SIITEM
SLT_DOCUMENTDATE
CFIN_DOCUMENTDATE
SLT_CREATIONDATE
CFIN_CREATIONDATE
SLT_COMPANYCODE
CFIN_COMPANYCODE
SLT_INVOICINGPARTY
CFIN_INVOICINGPARTY
SLT_PLANT
CFIN_PLANT
SLT_MATERIAL
CFIN_MATERIAL
SLT_UOM
CFIN_UOM
SLT_CURRENCY
CFIN_CURRENCY
SLT_QUANTITY
CFIN_QUANTITY
QUANTITY_VARIANCE
SLT_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE
SLT_DOC_CNT
CFIN_DOC_CNT
DOC_CNT_VARIANCE

Level-5 Report (Summary)

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Purchase Order (PO) object:

SOURCE_RPLD_PODOC
CFIN_RPLD_PODOC
SOURCE_RPLD_POITEM
CFIN_RPLD_POITEM
SOURCE_RPLD_SCHEDLINE
CFIN_RPLD_SCHEDLINE
SOURCE_COMPANYCODE
CFIN_COMPANYCODE
SOURCE_ORD_CREATIONDT
CFIN_ORD_CREATIONDT
SOURCE_ORD_CREATEDBY
CFIN_ORD_CREATEDBY
SOURCE_DELIVERY_DT
CFIN_DELIVERY_DT
SOURCE_SALESGROUP
CFIN_SALESGROUP
SOURCE_MATERIAL
CFIN_MATERIAL
SOURCE_PLANT
CFIN_PLANT
SOURCE_UOM
CFIN_UOM
SOURCE_CURRENCY
CFIN_CURRENCY
SOURCE_SUPPLIER
CFIN_SUPPLIER
SOURCE_QTY
CFIN_QTY
QTY_VARIANCE
SOURCE_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE
SOURCE_DOCUMENT_CNT
CFIN_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Order (CO) object:

SOURCE_RPLD_SODOC
CFIN_RPLD_SODOC
SOURCE_RPLD_SOITEM
CFIN_RPLD_SOITEM
SOURCE_RPLD_SCHEDLINE
CFIN_RPLD_SCHEDLINE
SOURCE_COMPANYCODE
CFIN_COMPANYCODE
SOURCE_ORD_CREATIONDT
CFIN_ORD_CREATIONDT
SOURCE_CUSTOMER
CFIN_CUSTOMER
SOURCE_DELIVERY_DT
CFIN_DELIVERY_DT
SOURCE_MATERIAL
CFIN_MATERIAL
SOURCE_PLANT
CFIN_PLANT
SOURCE_UOM
CFIN_UOM
SOURCE_CURRENCY
CFIN_CURRENCY
SOURCE_QTY
CFIN_QTY
QTY_VARIANCE
SOURCE_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE
SOURCE_DOCUMENT_CNT
CFIN_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Invoice (CI) object:

SOURCE_REPLICATED_CIDOC
CFIN_REPLICATED_CIDOC
SOURCE_REPLICATED_CIITEM
CFIN_REPLICATED_CIITEM
SOURCE_BILLINGDATE
CFIN_BILLINGDATE
SOURCE_CREATIONDATE
CFIN_CREATIONDATE
SOURCE_COMPANYCODE
CFIN_COMPANYCODE
SOURCE_SOLDTOPARTY
CFIN_SOLDTOPARTY
SOURCE_MATERIAL
CFIN_MATERIAL
SOURCE_PLANT
CFIN_PLANT
SOURCE_UOM
CFIN_UOM
SOURCE_CURRENCY
CFIN_CURRENCY
SOURCE_QUANTITY
CFIN_QUANTITY
QUANTITY_VARIANCE
SOURCE_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE
SOURCE_DOCUMENT_CNT
CFIN_DOCUMENT_CNT
DOC_CNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Supplier Invoice (SI) object:

SOURCE_REPLICATED_SIDOC
CFIN_REPLICATED_SIDOC
SOURCE_REPLICATED_SIITEM
CFIN_REPLICATED_SIITEM
SOURCE_DOCUMENTDATE
CFIN_DOCUMENTDATE
SOURCE_CREATIONDATE
CFIN_CREATIONDATE
SOURCE_COMPANYCODE
CFIN_COMPANYCODE
SOURCE_INVOICINGPARTY
CFIN_INVOICINGPARTY
SOURCE_PLANT
CFIN_PLANT
SOURCE_MATERIAL
CFIN_MATERIAL
SOURCE_UOM
CFIN_UOM
SOURCE_CURRENCY
CFIN_CURRENCY
SOURCE_QUANTITY
CFIN_QUANTITY
QUANTITY_VARIANCE
SOURCE_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE
SOURCE_DOCUMENT_CNT
CFIN_DOCUMENT_CNT
DOC_CNT_VARIANCE

Level-5 Report (Detail)

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Purchase Order (PO) object:

SOURCE_RPLD_PODOC
CFIN_RPLD_PODOC
SOURCE_RPLD_POITEM
CFIN_RPLD_POITEM
SOURCE_RPLD_SCHEDLINE
CFIN_RPLD_SCHEDLINE
SOURCE_COMPANYCODE
CFIN_COMPANYCODE
SOURCE_ORD_CREATIONDT
CFIN_ORD_CREATIONDT
SOURCE_ORD_CREATEDBY
CFIN_ORD_CREATEDBY
SOURCE_DELIVERY_DT
CFIN_DELIVERY_DT
SOURCE_SALESGROUP
CFIN_SALESGROUP
SOURCE_MATERIAL
CFIN_MATERIAL
SOURCE_PLANT
CFIN_PLANT
SOURCE_UOM
CFIN_UOM
SOURCE_CURRENCY
CFIN_CURRENCY
SOURCE_SUPPLIER
CFIN_SUPPLIER
SOURCE_QUANTITY
CFIN_QUANTITY
QUANTITY_VARIANCE
SOURCE_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Order (CO) object:

SOURCE_RPLD_SODOC
CFIN_RPLD_SODOC
SOURCE_RPLD_SOITEM
CFIN_RPLD_SOITEM
SOURCE_RPLD_SCHEDLINE
CFIN_RPLD_SCHEDLINE
SOURCE_COMPANYCODE
CFIN_COMPANYCODE
SOURCE_ORD_CREATIONDT
CFIN_ORD_CREATIONDT
SOURCE_CUSTOMER
CFIN_CUSTOMER
SOURCE_DELIVERY_DT
CFIN_DELIVERY_DT
SOURCE_MATERIAL
CFIN_MATERIAL
SOURCE_PLANT
CFIN_PLANT
SOURCE_UOM
CFIN_UOM
SOURCE_CURRENCY
CFIN_CURRENCY
SOURCE_QTY
CFIN_QTY
QTY_VARIANCE
SOURCE_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Customer Invoice (CI) object:

SOURCE_REPLICATED_CIDOC
CFIN_REPLICATED_CIDOC
SOURCE_REPLICATED_CIITEM
CFIN_REPLICATED_CIITEM
SOURCE_BILLINGDATE
CFIN_BILLINGDATE
SOURCE_CREATIONDATE
CFIN_CREATIONDATE
SOURCE_COMPANYCODE
CFIN_COMPANYCODE
SOURCE_SOLDTOPARTY
CFIN_SOLDTOPARTY
SOURCE_MATERIAL
CFIN_MATERIAL
SOURCE_PLANT
CFIN_PLANT
SOURCE_UOM
CFIN_UOM
SOURCE_CURRENCY
CFIN_CURRENCY
SOURCE_QUANTITY
CFIN_QUANTITY
QUANTITY_VARIANCE
SOURCE_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE

Measures and attributes for the Accounting View of Logistics (AVL) data related to the Supplier Invoice (SI) object:

SOURCE_REPLICATED_SIDOC
CFIN_REPLICATED_SIDOC
SOURCE_REPLICATED_SIITEM
CFIN_REPLICATED_SIITEM
SOURCE_DOCUMENTDATE
CFIN_DOCUMENTDATE
SOURCE_CREATIONDATE
CFIN_CREATIONDATE
SOURCE_COMPANYCODE
CFIN_COMPANYCODE
SOURCE_INVOICINGPARTY
CFIN_INVOICINGPARTY
SOURCE_PLANT
CFIN_PLANT
SOURCE_MATERIAL
CFIN_MATERIAL
SOURCE_UOM
CFIN_UOM
SOURCE_CURRENCY
CFIN_CURRENCY
SOURCE_QUANTITY
CFIN_QUANTITY
QUANTITY_VARIANCE
SOURCE_NETAMOUNT
CFIN_NETAMOUNT
NETAMOUNT_VARIANCE

Exception Report

The Exception report provides information about the documents that cannot be posted into SAP S/4HANA due to exceptions. The exceptions occur if the documents do not meet the following validations of Transaction when they are posted from your source system into SAP S/4HANA:

Sum of credit and debit amounts in documents must be equal to zero.
The following mandatory columns must not be null:

Unique ID
Effective date
Posted date
Vendor number/customer number
Fiscal year
Currency code
Document type
Accounting document number
Accounting logical system
GL account number
Company code

Documents with lines in FIN_PRDTAX must contain the corresponding tax codes in FIN_ACCT.
The tax amounts in documents should be less than the taxable amounts.
Documents with lines in FIN_WHTAX must contain the corresponding lines in FIN_CREDIT.
Documents with lines in FIN_CREDIT and FIN_PRDTAX must contain the corresponding lines in FIN_ACCT.

The Error Date, Error Description, and Error Location fields in the report show the exception details. A screenshot of the Exception report is as follows.

ECC GL Balance Conversion Report

The SAP ECC GL Balance Conversion report compares the GL account balance between the source system and SAP S/4HANA. The balance includes the conversion beginning balance, net credit posting, net debit posting, and ending balance for a period.

To access the report, provide values for the following prompts:

Source Ledger
Source Company Code
Statement Type
Source Fiscal Year
Source Fiscal Period From
Source Fiscal Period To

A screenshot of the ECC GL Balance Conversion report is as follows.

insightsoftware Reconciliation Dashboard

The insightsoftware Reconciliation dashboard is based on the Reconciliation Level - 5 Summary report and shows data for all locations except "GL Balance" and "AP/AR Bal".

To access the dashboard

Log on to SAP Fiori with your SAP GUI user credentials. The SAP Fiori launchpad displays the home page with tiles pertaining to your role.
On the menu, locate and select the insightsoftware Dashboard Apps group. The insightsoftware Dashboard Overview Page appears.

The dashboard provides information on the unreconciled group currency amount, unreconciled document, and unreconciled quantity, by the following attributes:

Ledger: Indicates the ledger in the SAP Central Finance Master Data Replication by insightsoftware for SAP S/4HANA Central Finance system.
Processing Status: Indicates whether records are AIF In Process, AIF Application Error, AIF Technical Error, In Process, or Successfully processed. When financial records initially show errors during AIF processing, they automatically appear in reports once the errors are corrected and the records are reprocessed. The incremental refresh capability eliminates the need for full job reruns.
Age Range: Indicates the age range that is calculated using the formula, Source Document Posted Date – Current Date. As an administrator, you can configure the following age range attributes:
- Age Range Name: Indicates the age range, such as 0-7 or 8-14.
- Age Days From: Indicates the beginning of the age range in days, such as 0 or 8.
- Age Days To: Indicates the end of the age range in days, such as 7 or 14.

Also, the dashboard displays the total group currency amount, total number of documents, and total quantity.

Optionally, provide values for the following prompts:

Source System
Source Company Code
Source Fiscal Year
Source Fiscal Period
Age Range
Week (Week number in the Source Fiscal Period based on Source Document Posted Date)

A screenshot of the Reconciliation dashboard is as follows.

The dashboard displays data pertaining to the following columns in the Reconciliation Level - 5 Summary report:

Group Amount Variance
Group Amount
Total Units Variance
Total Units
Document Count Variance
Document Count

The dashboard consists of the following cards:

Percent Reconciled: In this card, you can see the following measures based on the filters you have applied:
- Group Currency Amount
  - $ Value Unreconciled: Displays the sum of the Group Amount Variance
  - Total: Displays the sum of the Group Amount
  - Bar: Displays the percentage of the Group Amount Variance by the Total Group Amount
- Quantity
  - Qty Value Unreconciled: Displays the Total Units Variance
  - Total: Displays the Total Units
  - Bar: Displays the percentage of the Total Units Variance by the Total Units
- Count
  - Total Transactions Unreconciled: Displays the sum of the Document Count Variance
  - Total: Displays the sum of the Document Count
  - Bar: Displays the percentage of the Document Count Variance by the Document Count
A sample screenshot of the Percent Reconciled card is as follows.
Unreconciled Count by Processing Status: This bar chart card displays the Document Count Variance on the vertical axis by the Processing Status on the horizontal axis based on the filters you have applied. A sample screenshot is as follows.
Unreconciled Quantity by Processing Status: This bar chart card displays the Total Units Variance on the vertical axis by the Processing Status on the horizontal axis based on the filters you have applied. A sample screenshot is as follows.
Unreconciled Group Currency Amount by Processing Status: This bar chart card displays the Group Amount Variance on the vertical axis by the Processing Status on the horizontal axis based on the filters you have applied. A sample screenshot is as follows.
Unreconciled Count by Ledger: This bar chart card displays the Document Count Variance on the vertical axis by the Ledger on the horizontal axis based on the filters you have applied. A sample screenshot is as follows.
Unreconciled Quantity by Ledger: This bar chart card displays the Total Units Variance on the vertical axis by the Ledger on the horizontal axis based on the filters you have applied. A sample screenshot is as follows.
Unreconciled Group Currency Amount by Ledger: This bar chart card displays the Group Amount Variance on the vertical axis by the Ledger on the horizontal axis based on the filters you have applied. A sample screenshot is as follows.
Unreconciled Count Aging: This donut chart card displays the Document Count Variance by the Age Range based on the filters you have applied. The age ranges are indicated through different colors. A sample screenshot is as follows.
Unreconciled Quantity Aging: This donut chart card displays the Total Units Variance by the Age Range based on the filters you have applied. The age ranges are indicated through different colors. A sample screenshot is as follows.
Unreconciled Group Currency Amount Aging: This donut chart card displays the Group Amount Variance by the Age Range based on the filters you have applied. The age ranges are indicated through different colors. A sample screenshot is as follows.