Exporting Accounting Transaction Data to SAP S/4HANA

So far, you have imported the actual accounting data from SAP S/4HANA into SAP Analytics Cloud and your team has worked on the forecast and developed plan values. Now, you need to export the plan accounting data from SAP Analytics Cloud into the ACDOCP table in SAP S/4HANA so it can be used for further operational planning activities.

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

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

The same SAP S/4HANA connection that is used for importing accounting master data and accounting transaction data is also used to export the accounting transaction data from the SAP Analytics Cloud model to SAP S/4HANA.

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

To allow the built-in SAP Service to export plan data, it must be enabled in the model. From the Data and Performance settings in the Model Preferences, simply choose the Enable Legacy Export slider and save the model.

Once you start the data export job from the Data Management workspace, you select the fields to update in the target system.

One thing to remember when you are selecting the target data in the Target Data Selection dialog is that during the export, only allowed combinations of dimension members can be exported. For example, if a cost center is exported to SAP S/4HANA, it must be assigned to the company code that is being exported. Otherwise, an error appears, and you will need to download the error file that contains the error message information.

In the Mapping dialog, you map the target dimensions to the source dimensions. When a target dimension is selected on the left of the dialog, the mapping details are displayed on the right.

In the following example, you can see that the Target DimensionCompany Code is mapped to Source DimensionS4H_COMPCODE and Source Dimension Member MappingMember ID.

In the practice exercise that follows, the following mapping is used:

• Cost Center is mapped to S4H_COSTCENTER Member ID.
• FiscalYearPeriod is mapped to Date.
• G/L Account is mapped to U00D_S4HGLACCT Member ID.
• Profit Center is mapped to S4H_PROFITCENTER Member ID.

When you are mapping Plan Category, only public versions can be exported.

Only one Target Measure can be exported per export query. In the following example, you can see that the Amount in Company Code Currency is mapped to LocalAmount.

Before you map Company Code Currency, you need to map the Target Measure.

The system default for the Export Method dialog is CompanyCode, FiscalYearPeriod, and PlanningCategory. The more dimensions you select, the smaller the data region that will be overwritten. At a minimum, FiscalYearPeriod and PlanningCategory must be selected.

You would need to select additional dimensions if you are planning on ACDOCP in SAP S/4 HANA and you don’t want to overwrite the data. For example, if SAP S/4HANA planners are working on Profit Center 1-10 and SAP Analytics Cloud planners are working on Profit Center 11-20, then Profit Center should be selected.

Once you select the scope for the Clean and Replace values and select Finish, the export is triggered.

You can view the data in SAP S/4HANA in the Planning for Group Reporting SAP Fiori app.

In the following example, you can see the exported plan data in the LC PLAN10 2021 column.

The accounting transaction data is released from the ACDOCP table to the ACDOCU table using the Data Monitor app in SAP S/4HANA.

Once you set your Global Parameters to the appropriate time frame and plan version, simply choose the Rel Uni J task, and select Update Run.

When you release the universal documents, the data from ACDOCP is imported into the ACDOCU table.

• Company codes in ACDOCP are converted to consolidation units in ACDOCU based on group reporting assignments.
• G/L accounts in ACDOCP are converted to financial statement items in ACDOCU based on the group reporting mappings.

Once the data has been released, you can view using the Group Data Analysis SAP Fiori app.