A data source restricts the data sets to be matched. One or two data sources are required depending on your choice in the first data source input box.
- If you choose a data source that has different fields defined as Leading Unit Field and Partner Unit Field, no second data source is needed. The matching is executed by comparing the data between the leading unit and partner unit.
- If you choose a data source that has the same field defined as Leading Unit Field and Partner Unit Field, a second data source is required, which has the identical leading unit field, partner unit field, mandatory filter fields, unit entity CDS view, and authorization object of unit as the first data source.
Note
Data sources are defined using the transaction code ICADS (Maintain Data Sources).SAP delivered data sources for consolidation include:
- SC_JOURNAL_ENTRIES_01 - Consolidation Journal Entry View (ACDOCU & ACDOCA): For journal entry data from the Universal Journal Entry Line Items (table ACDOCA) and Consolidation Journal Entries (table ACDOCU) for entity pairs of consolidation units and partner units.
- SC_JOURNAL_ENTRIES_02 - Consolidation Journal Entry View (ACDOCU): For journal entry data from the Consolidation Journal Entries (table ACDOCU) for entity pairs of consolidation units and partner units.
Note
In our use case, we are using a copy of SC_JOURNAL_ENTRIES_01. It is not set up for matrix reconciliation since it only has consolidation and partner unit. Also, the conversion profile C2 is used in the reconciliation case to calculate transaction variances. And, fiscal year period is one concatenated field.
You can maintain your own fields in custom data sources.
In the data source Mandatory Filter Fields, a variable is used to automically provide the current fiscal year period.
To calculate transaction differences, a Conversion Profile is added to the data source.
