When to use SAP Group Reporting Data Collection Data Mapping

SAP Group Reporting Data Collection data mapping is a flexible ETL (Extract, Transform and Load) application which includes the ability to define mappings (source to target), run / schedule mapping jobs, and check results in traceability logs.

Use it to:

  • Import data from remote systems from CSV source files

  • Import data from SAP ECC

  • Import data from remote systems with the Group Journal Entries - Import API

  • Import ACDOCA data from remote systems

  • Import additional ACDOCA data for statistical information (for example, aging information of AR/AP)

  • Copy missing consolidation units' reported data for non-material consolidation units

  • Run step consolidation

  • Supplement C/I (Consolidation of Investments) control data

  • Calculate annual net income for non-balancing books (for example, rounding differences from local ledger data transfers)

CSV to ACDOCU

This is the most general use case. Extract data from your source system in a CSV file. Data Mapping will map, transform, load data in the ACDOCU table. For more information, see Importing Data from SAP ECC into Data Mapping.

Import API to ACDOCU

This use case is more automated as you don’t need the intermediary CSV step. Implement data mapping’s Import API in your remote system. Your remote system will push data to data mapping in order to map, transform and load data in the ACDOCU table. For more information, see Group Journal Entries - Import API.

Remote ACDOCA to ACDOCU

If you’re running multiple SAP S/4HANA instances, use Data Mapping to import ACDOCA data from a remote SAP S/4HANA system into your target ACDOCU. For more information, see Create a Data Mapping Definition with an ACDOCA Table as Source.

ACDOCA to ACDOCU in the same SAP S/4HANA system

Use data mapping to transform and load ACDOCA into ACDOCU within the SAP S/4HANA system. For example, if you need to retrieve additional ACDOCA data for statistical information (for example, aging information of AR/AP).

ACDOCU to ACDOCU in the same SAP S/4HANA system

Use Data Mapping to transform ACDOCU data within the SAP S/4HANA system. For example, to copy missing consolidation units’ reported data for non-material consolidation units, help run your step consolidations or, supplement C/I control data.