Uploading Data from Table ACDOCA to ACDOCU

Objectives

After completing this lesson, you will be able to:

  • Get into the upload from the ACDOCA table to the ACDOCU table

The Upload Structures From Table ACDOCA to ACDOCU

Robert, our new consolidation consultant, wants to:

  • Get into the use cases for data uploads from the ACDOCA table into the ACDOCU table working with SAP S/4HANA Finance for group reporting Data Collection.
  • Understand what to pay attention to setting up the transformation from the ACDOCA table into the ACDOCU table.

You can use Data Mapping to transform and load data from the ACDOCA table into the ACDOCU table. Both tables are within the same SAP S/4HANA system.

Examples:

  • Retrieve additional ACDOCA data for statistical information (e.g., aging information of AR/AP).
  • If ACDOCA data or details on Movement Type or Sub-item are missing, you can also use the Data Mapping to push the data to Group Reporting.
  • Next to GLAccount, another field has to be considered in the Data Mapping to derive the FSItem in ACDOCU. This field would not be taken into account if you instead released the data in the Data Monitor.
  • Keep one ACDOCA field that has to be added as a custom field in Group Reporting.
  • Use the ACDOCA template if the data in ACDOCA does not have the correct granularity for ACDOCU.

If you're running multiple SAP S/4HANA instances or different S/4HANA systems, use Data Mapping to import ACDOCA data from a remote SAP S/4HANA system into your leading SAP S/4HANA system. 

Note

When your ACDOCA system is in another instance than ACDOCU, you can use the Data Mapping apps with source data in ACDOCA and the ACDOCA template instead of using the Release Task in the Data Monitor since the Release Task in the Data Monitor doesn't support this use case.

Once data from a source type "ACDOCA table" is processed by the mapping, its document type is by default set to DT = 0D.

To use the ACDOCA table as a source, you must first create a dedicated destination in the SAP BTP Cockpit, to let the application know the location of the ACDOCA table you want to use. 

See documentation: https://help.sap.com/docs/SAP_Group_Reporting_Data_Collection/e29950571a2b4065b1dacaf881c67413/80ce15c5a5944ea78ec070ea7d00e03d.html?latest&version=1.0.

Your Excel Mapping file for this scenario also has to be downloaded using the Define Data Mapping app.

If you use the template for SAP S/4HANA Accounting table, the input column already contains column names from the ACDOCA table.

What the Meta-data tab shows:

  • In column A, under "I", you'll find the input column names. These are the column names from the ACDOCA table.
  • The output column names are in column C, under "O". These output column names correspond to the ACDOCU columns.

For performance optimization purposes:

  • Specify source filter fields when you create the data mapping definition for ACDOCA in order to limit the number of rows to be processed.
  • Delete all unused columns from your mapping file.
Note

The list of fields to be processed by data mapping depends on the columns selected in your mapping file. If a field is selected as an input column, then the field is read from the source. If not, the field isn't read and the rows are aggregated.

Note

Your mapping file can't exceed 6 MB.

By default, the following dimensions:

  • ConsolidationLedger
  • ConsolidationVersion
  • ConsolidationChartOfAccounts
  • FiscalYear
  • FiscalPeriod

are automatically loaded, depending on the dimensions the user has selected in the Global parameters tile. You don't need to add them as target dimensions into your mapping file, except for the ConsolidationUnit dimension which must be entered as a target dimension.

However, FiscalYear, FiscalPeriod and ConsolidationVersion can be used as output columns. In that case, the global parameters are ignored.

Note

By default, opening data (period 000) is imported for the Fiscal Period field. If you want to exclude opening data, you can add a filter in the Fiscal Period input column of your mapping file using the syntax "<>000". The output column on this mapping tab will remain empty, as we only want the system to read the source data for the input column filter selection.

Using the Define Mapping app, you must select ACDOCA Table as Source type if you want to load closing data from an integrated SAP S/4HANA company like TA00 into table ACDOCU.

Make sure to select Ledger as field in the Source Filters and as the Source Filters Value select the ledger from which you want to transfer your closing data into table ACDOCU.

In the mapping file, ensure that all GLAccounts for which you want to upload data into table ACDOCU are mapped to the relevant Financial Statement Items. This is necessary since even for integrated consolidation units like TA00, which are companies in Financial Accounting, the existing mapping in SAP S/4HANA Finance for group reporting is not run by the system when the data upload is executed in SAP S/4HANA Finance for group reporting Data Collection.

The figure above gives an idea about the structure of the source data in table ACDOCA.

Having executed the Run Data Mapping app, you will find the aggregated uploaded data sets for consolidation unit TA00 in version M30 in table ACDOCU.

The figure above gives an idea of the resulting data sets.

As you can see, Financial Statement Item 172100 - Investments in subsidiaries, has an investment of EUR 10.000 but as there was no information about the company/partner unit and the ownership percentages in source table ACDOCA, this information is also missing in table ACDOCU after the upload but is needed for consolidation. To add this information, we will correct the data set for FS item 172100 by using Data Mapping to transform and load the data correction from table ACDOCU into table ACDOCU.

How to Download the ACDOCA-ACDOCU Template

Data Mapping and Data Upload from ACDOCA to ACDOCU for Consolidation Unit TA00

TA00 is the only integrated company in our scenario and its source data is stored in ACDOCA of the S/4HANA system. TA00 is also an investor in several subsidiaries. One of its investment clients is consolidation unit ES##.

First you will check the data of TA00 in Table ACDOCA. Then you will use a prepared ACDOCA-ACDOCU template file and adapt it. The next step is to set up a Mapping Definition. Finally, the Run Mapping is executed and the result data is checked in table ACDOCU.

  • After the upload you will only see TA00's total investment of EUR 10000 in all subsidiaries but there won't be any information that TA00 invested EUR 3000 of EUR 10000 in ES## and EUR 7000 of EUR 10000 in CH##.
  • There won't either be any information about the ownership percentages and the Partner Consolidation Units of investor TA00 available in table ACDOCU.

Log in to track your progress & complete quizzes