Standard reporting in SAP S/4HANA Cloud for group reporting is done with the help of SAP S/4HANA embedded analytics reports, that is standard reporting using SAP Fiori tiles at consolidation unit or group level.
SAP S/4HANA embedded analytics is available by default and allows drill-down to document level.
With the help of the Group Data Analysis app, you can display different views of consolidated data.
Group View: The group view is based on the group structure that includes consolidation groups and units.
Hierarchy View: The hierarchy view is based on hierarchies of profit centers, segments, and consolidation units. By selecting different FS item hierarchies within the app, you can generate consolidated financial statements such as balance sheets and profit and loss statements.
Before you use this app, make sure that you’ve selected values for the parameters in the Set Global Parameters app. Once these values are saved in the global parameters, they are then derived for the corresponding variables in this app.
Main Features in the Standard Reporting Apps for SAP S/4HANA Finance for Group Reporting
As the corporate accountants are performing the close, the Group Data Analysis app can be used to quickly access the financial data. The app contains the following features:
Drag and drop navigation
Every dimension in ACDOCU is available for navigation in the standard app
Filter on any dimension
Report on multiple periods and versions
Report on period or year-to-date data
Save report filtering and navigation with bookmarks and report variants
Create user-specific tiles based on personal report design
Download into Microsoft Excel
Collapsible filter and navigation areas
Use group reporting time-independent hierarchies
Use group reporting time-dependent hierarchies
Display sign adjusted data
Defer layout update
Grid and axis properties
Concept of Rule-Based Reporting Items
Reporting Item - key points
A reporting item is technically an FS item whose FS item type is REPT (Reporting Item).
A reporting item can be enhanced by assigning it a set of selection criteria of specific data such as:
- FS items
- Consolidation units
- Document types
The assignments of data selection criteria to reporting items are called reporting rules. These reporting rules determine how the values for a reporting item are derived in a report.
With the reporting rules in place, when you use a reporting item in a report, its values are calculated by aggregating the data from the selection criteria defined in the reporting rules.
Reporting items are arranged into reporting item hierarchies which are used in reports to display the reporting items in a hierarchical structure.
You can use reporting items as additional analytical dimensions in reports such as:
- Statement of cash flow
- Statement of changes in equity
- Statement of comprehensive income
- Profit and loss (P&L) statement by function of expense
The following figure shows how this comes together in a report. It also shows the relationship between an FS item, reporting item, reporting rules, and reporting item hierarchy.
In the figure above, you can see that:
The system calculates an aggregated amount for Reporting Item 1 based on the selection criteria that are assigned in the reporting rules.
The amount for Reporting Item 1 aggregates all the amounts from the range of FS items from FS Item 1 to FS Item 5.
The reporting item acts as one entity, but actually represents a set of data defined by these selection criteria in the reporting rules.
There are five delivered reporting item hierarchies:
X1: Statement of changes in equity
X2: Statement of cash flow
X3: Statement of comprehensive income.
X4: P&L by function of expense
X5: IC reconciliation
The figure shows the rule-based cash flow statement as an example: