Group Reporting Migration Accelerator for Historical Data

Launch of the Historical Data Loader tool – Migration accelerator

Hi Group Reporting enthusiasts !

We at the Content Hub are happy to deliver the Historical Data Loader, a migration tool enabling you to load your historical consolidated data from your legacy tool into Group Reporting. This tool can greatly reduce the effort of your overall data takeover as part of your Group Reporting implementation project.

This tool was initially limited to the migration of historical data for existing Financial Consolidation (FC) customers but is also open for all SAP legacy consolidation tools.

The Historical Data Loader is an ABAP program that loads CSV formatted files containing legacy consolidated historical data into Group Reporting.

You can use GRDC to produces these CSV formatted files. For FC only, a pre existing mapping exists.

It is not intended and permitted to use any other Group Reporting standard functions beyond analytics such as reprocessing consolidated data or running balance carry-forwards based on the data.

Process concept:

E2E Process

Functionality :

• Able to load your legacy historical data from SAP legacy tools into Group Reporting
• Performs basic validation checks on, the loaded data.
• Able to load data for multiple consolidation units and periods at the same time.
• Able to load Consolidated level data in GR which is otherwise not possible and thus avoiding the need to reconsolidate your legacy historical data.
• Able to load any kind of data as long as it meets the CSV format and field requirements.
• Able to load CSV files produced by the transformation/mapping capabilities of Group Reporting Data Collection.

When to use this migration tool :

• You are implementing Group Reporting and have the need to takeover historical data from your legacy tool
• You want you load consolidated level data for comparative reporting.
• You want to load consolidated data that does not need to be re-consolidated
• You have SAP S/4HANA for Group Reporting, on-premise, private cloud edition (GR) version 2021 or higher

Installation and Configuration

The Data Loader is released as an ABAP export package, that you need to import in the target S/4HANA environment.

The CSV file – key Requirements :

The date needs to be prepared in CSV format for import by the tool. Any data that confirms to the requirements can be loaded into GR. Special attention should be paid to the mandatory fields and making sure the file fits the provided format.

• The tool only accepts file in CSV format with comma separators
• The first line of the CSV file should have the header fields
• The last column of the CSV file should contain value
• The tool does not support CSV files in ZIP archive
• The tool can only handle file size less than 2GB

Scope of the solution – limitations :

There are some important limitations to be considered

• Only to be used for Consolidated Data; no reconsolidation can be performed on the loaded data and there are measures taken to ensure that attempts to reprocess loaded consolidated data are limited.
• The tool is only available from version 2021 and higher for On Premise and Private Cloud editions. The tool is NOT available in public cloud i.e., « S/4HANA Cloud, Public Edition »
• This tool is provided by SAP Consulting / Content Hub and is not part of the standard product code delivery. You need to implement the loader as a customer program in the customer name space.
• No standard maintenance is offered.
• Customers will need the support of SAP consultants to solve issues.
• Customer messages on data records created by this tool cannot be answered by standard SAP support (CSS incidents).

Warning :

Warning ; this tool is delivered as is, at no additional cost by SAP and intended for use by SAP consultants only

Stay tuned !

Stay tuned for Jana’s blog containing with much more detailed product information as well as User and Installation guidance !

Please use the ‘Add Comment’ section for posting comments or questions.

The Content Hub for Group Reporting team :

Jana Annapureddy – Content Hub Contributor – Technical Lead and Architect

Bart De Schepper – Content Hub Member – Global Group Reporting Expert