Configuring Data Sources

Objectives

After completing this lesson, you will be able to:

  • Configure data sources

Data Sources

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:

  1. 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.
  2. 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.
The datasource has an id of ZSC_JOURNAL_ENTRIES_01 and description of Consolidation Journal Entry View(ACDOCU & ACDOCA)

You can maintain your own fields in custom data sources.

The fields in the datasource are listed

In the data source Mandatory Filter Fields, a variable is used to automically provide the current fiscal year period.

The FISCYEARPER field has a default value of $CurrentFiscalYearPeriod$

To calculate transaction differences, a Conversion Profile is added to the data source.

The conversion profile uses the CLO exchange rate type and the EUR target currency

Log in to track your progress & complete quizzes