Exporting Finance Transaction Data to SAP S/4HANA for Finance for Group Reporting

Objective

After completing this lesson, you will be able to export finance transaction data to SAP S/4HANA.

Export Transaction Data for Group Reporting

So far, you have imported the group reporting data from SAP S/4HANA into SAP Analytics Cloud and your team has worked on the consolidation. Now, you need to export the group reporting transaction data from SAP Analytics Cloud into the ACDOCU table in SAP S/4HANA so it can be used for subsequent consolidation tasks.

Watch the following video to find out more about the transaction data for group reporting export process.

Export Group Reporting Transaction Data to SAP S/4HANA Finance for Group Reporting

In this lesson, we cover the process of exporting transaction data from the SAP Analytics Cloud to the SAP S/4HANA ACDOCU table. The process is the same as exporting accounting data and the steps are covered in detail in the practice exercise, however, a few key points to note are highlighted below.

Connections

While group reporting master data is imported using an OData connection, the data is exported using the same SAP S/4HANA connection that is used for importing accounting master data and accounting transaction data.

Export Application

For exports to SAP S/4HAHA, it is recommended to use the built-in API Service export application Group Reporting Planning Integration. This is the service for writing plan data to the ACDOCU table in SAP S/4HANA. API Subscriptions are not recommended for exporting data to SAP S/4HANA.

Target Data Selection dialog with API Service Group Reporting Planning Integration highlighted.

Filters

It is possible to set filters while mapping the data. In the example we use in this lesson, you only want to export data for 2025, so a filter is set in the Mapping.

Mapping dialog with Source Filter set for Date for year 2025.
The export cannot be edited after it is triggered.

View the Exported Data in SAP S/4HANA

You can view the data in SAP S/4HANA in the Group Data Analysis SAP Fiori app.

Group Reporting Input Query information displayed as described in the paragraph above.

Export Group Reporting Transaction Data to SAP S/4HANA Finance for Group Reporting

Business Scenario: As part of the integration project, you need to export the group reporting plan data from SAP Analytics Cloud to the ACDOCU table in SAP S/4HANA.

Task Flow: In this practice exercise, you will:

  • Build the export query in SAP Analytics Cloud
  • Map the source and target data and run the export
  • View the imported data in SAP S/4HANA

Log in to track your progress & complete quizzes