Objective
After completing this lesson, you will be able to Integrate data from SAP S/4HANA Finance.
At ABC Corporation, one of your responsibilities is to acquire data. Since you are using SAP S/4HANA Accounting, you need to understand the integration with group reporting.
Let’s learn more about this below.
Learn how group reporting and accounting are integrated in the following video.
As postings occur in the general ledger for integrated companies, they're captured in the ACDOCA (Accounting Document for Actual) table. Before the data is released into group reporting, the general ledger trial balance report can be used to view the group reporting related data in ACDOCA.
You can also view group reporting data in the accounting journal entry. This feature is related to the preparation ledger, which became available in the 2022 edition. The benefit is that reporting and reconciliation can occur before the Data Release task (the sooner discrepancies are discovered, the better).
In the following image, there are four steps in the data release process:
Note
Company codes are typically assigned on a one-to-one basis to companies. In this scenario, company code 1010 is assigned to company 1010.As postings occur in the general ledger, group reporting fields are recorded along with the rest of the accounting data. You can view the group reporting fields in the Manage Journal Entries app with these steps:
There are several group reporting fields that are recorded in the general ledger (ACDOCA table):
Note
In this scenario, company code 1010 in combination with profit center P9002 are included in a substitution rule to derive consolidation unit DE02.Group reporting data can also be displayed when accessing the line items of general ledger documents.
You can include group reporting fields in the standard trial balance report by extending the underlying core data services query.
In the following image, the accounting trial balance includes the following fields in the rows:
The following fields are included in the columns:
As postings occur in the general ledger, group reporting information is recorded in the ACDOCA table. The data is later released into group reporting. You need to learn how to view the group reporting data in the general ledger.
One of the main sources of reported data is SAP S/4HANA Finance. You release accounting data (from the SAP General Ledger) into group reporting using the data monitor. The data release process controls the flow of data into group reporting. It has a preview and offers several ways to drill down into the source data to perform sanity checks.
Data release is an important control mechanism that prevents unwanted data from becoming available to group reporting.
Prerequisites:
The period is open.
The company is a consolidation unit.
G/L accounts are mapped to FS items.
The data release task can be run from the Data Monitor.
When you release data from the data monitor, you can view the released data.
In Release of Universal Documents - Result, you can see the following:
Note
The release process will only release one FI document number at a time. The tracking mechanism is based on a timestamp.After you close the period in accounting, data release should be run for the last time (for that period). After you run Release of Universal Journals, you can then block the task.
When transferring accounting financial data, the system derives the posting period based on the accounting posting date and the period definition of the assigned fiscal year variant (FYV).
Example: You assign the K4 (Calendar Year, 4 Special Periods) FSV to a consolidation unit and make an accounting posting using December 31 as the posting date and any of the four special periods (13, 14, 15, or 16) as the posting period. In group reporting, the system releases data using the same special period as in accounting.
During the release process, you can access the document view to display the data by FS Item (Summary Result based of Financial Statement Item).
You can then toggle to the G/L account (Summary Result based of Account Number) view as well.
After data is released into group reporting, the Line Item Validation is run. This detects incorrect sub assignments such as a missing trading partner for an intercompany account. Sub-assignment issues would most likely need to be fixed in accounting and then data release would need to be run again.
If there’s a G/L account that isn’t mapped to an FS item, the data validation log displays an error. To resolve this G/L account-mapping issues, complete the following steps:
As a result, the value for the previously unmapped G/L account will be in group reporting and the log won't display any errors.
You can use the Schedule Jobs for Consolidation Tasks app to schedule and monitor jobs for consolidation tasks using the provided templates. If you have manual activities that you often need to do at a specific time (such as data release), this app can reduce your workload by automatically running these tasks smoothly in the background.
To schedule data release, complete the following steps:
Note
The Schedule Jobs for Consolidation Tasks app can also be used to schedule the following tasks:The preparation for consolidation group changes and reclassification job templates bundle multiple tasks.
In this video, you'll see how to schedule the data release task. Scheduling the data release is similar to scheduling other tasks.
At ABC Corporation, new postings in the general ledger need to be released into group reporting. You need to learn how the data release process works.
After data is released from accounting into group reporting, the Line Item Validation task is run.
In the Line Item Validation image, the Line Item Validation task ran successfully.
Log in to track your progress & complete quizzes