Reporting Consolidated Data

Analyzing Financial Statements with the Review Booklet

Objective

After completing this lesson, you will be able to describe the review booklet

Review Booklet Introduction

Overview

Review booklets are application-guided reports that answer many business questions using out-of-the-box prepared layouts. The prepared layouts can be adapted by users as needed.

Use the Group Financial Statements Review Booklet app to display, analyze, and validate group reporting data at various levels of detail. The app presents an aggregated view of financial statements by combining predefined business pages grouped under the main areas of:

  • Consolidated Balance Sheet
  • Profit & Loss Statement
  • Cash Flow Statement
  • Statement of Changes in Equity.

This collection of pages forms a review booklet, which can be used to carry out a comprehensive financial review.

Using the Review Booklet

Watch the following video to see how you can use the Review Booklet.

Review Booklet Initial Setup

Initial Setup

To use the review booklet, check the following:

  • Global Parameters: Make sure that you’ve selected the appropriate global parameters in the Global Parameters app. The review booklet derives the default values for the global filters from what you've selected in the global parameters.
  • Check Hierarchies: You can use delivered or custom hierarchies. Regardless of which hierarchies you use, make sure that those hierarchies are activated before using them.
  • DEFAULT_HIERARCHY: By default, the consolidation unit hierarchy DEFAULT_HIERARCHY is used for the Consolidation Unit Hierarchy global filter in the review booklet. However, if you're not using the standard content delivered by SAP, you don't have DEFAULT_HIERARCHY in your system. In this case, you must do one of the following in the Manage Global Hierarchies app:
    1. Create a hierarchy called DEFAULT_HIERARCHY by copying your own custom hierarchy for this name.
    2. Replace DEFAULT_HIERARCHY with your own custom hierarchy using a different name.

Use the following link to learn more about the Group Financial Statements Review Booklet app: Group Financial Statements - Review Booklet

Review Booklet Business Page Groups

The review booklet comes delivered with five business page groups. These business page groups are organized by the type of financial statement.

The image shows the Group Financial Statements screen overview.

Each business page group has one or more pages with aggregated and detailed data. The Consolidated Balance Sheet page group is a financial statement that shows assets, liabilities and equity at the end of the fiscal period. The Consolidated Balance Sheet page group contains the following three detail pages where you can review the data:

  1. Overview: a basic overview of assets, liabilities, and equity.
  2. Assets: a detailed look at current and non-current assets.
  3. Liability & Equity: a detailed look at equity as well as current and non-current liabilities.
The image shows the Group Financial Statements screen displaying the Assets details.

The following business pages use FS items:

  • Consolidated Balance Sheet
  • Profit & Loss Statement (Function of Expense)

The following business pages use Reporting Items:

  • Profit & Loss (Nature of Expense)
  • Cash Flow Statement
  • Statement of Changes in Equity

Note

Business pages that use reporting items require Report Rule Variants.

Review Booklet Row Sets and Column Sets

You can adjust the columns and rows in the report to display your data in various ways. You can also select specific column structures that enable you to make comparisons with your data, such as Closing Period vs. Previous Period.

In the following image, you can use the dropdown next to the Rows set to select the most popular dimensions.

The image shows a SAP Group Financial Statements interface displaying a consolidated balance sheet for assets. A dropdown menu is open, allowing the user to select between different reporting lines and units.

You can also add any other dimension in group reporting into the report. For example, you can right-click on FS item and select other dimensions to include in the output.

The image shows a financial statement view in SAP with various options for adding dimensions and filters. The screen displays consolidated balance sheet data, including assets and liabilities.

The structures in the columns can be changed by using the dropdown next to the Columns set.

The image shows a financial statement report in SAP, displaying assets for different periods. A dropdown menu is open, offering various comparison options such as Closing Period vs. Previous Period and Closing Quarter vs. Previous Quarter.

Review Booklet Properties

You can use dimension properties to:

  1. Change how members are displayed.
  2. Change how members are sorted.
  3. Change hierarchy expansion level and position of nodes.

You can access the Properties for … dialog by right-click on the relevant dimension in the layout and choosing Dimension → Properties.

Note

There are similar properties for dimensions, measures and structures.

Dimension Properties for dimension Consolidation Unit

The image shows three tabs in the Properties for Consolidation Unit settings: Display, Sorting, and Hierarchies. Each tab contains various options for configuring the display, sorting, and hierarchical structure of the consolidation unit.

Review Booklet Filters

Global filters apply to all business pages in the app and underlying data providers. You define them in the filter bar. Use Adapt Filters to add to the global filters.

Note

Consolidation Unit Hierarchy must be added to the global filters and restricted to a hierarchy that is different than the default.
The image shows the screen of the Group Financial Statements with filters set for Version, Consolidation Group, Posting Period, Fiscal Year, and Consolidation Unit Hierarchy. Using the Adapt Filters option you can add more filter fields.

Page filters only apply to a specific business page and underlying data provider. Some variables for page filters are already derived based on your selection of global filters. You can display them in the side panel. In addition, you can apply page filters for specific dimensions in the report.

When the page filters are displayed, they show the default dimension filters. In the All view, you can Add additional dimensions to the filter or choose Clear to remove previously added dimensions.

The image shows the Page filters that are tools that allow users to refine and narrow down the data displayed on a particular page or application.

Note

The filter for the Consolidated Balance Sheet - Overview page is different than the other pages because the filter has an Asset view and Liabilities & Equity view.

You can also filter a dimension via the context menu. For example, right-click FS Item→Filter→Edit. You can then select a hierarchy node and choose OK.

Review Booklet Layout

You can access the report definition by going to the layout panel. The layout panel has the following components:

  • Builder Pane: Here you can see the information that you've selected under Available Objects. It's displayed in your statement, either as a row or as a column.
  • Available Objects: Here you choose which type of measure, structure, and dimension you want to display in your financial statement by selecting or deselecting it.

You can use drag and drop to change the rows and columns. You can use the ...More option to control:

  • Zero suppression: hide members if they have zero values.
  • Compact display: group dimension members hierarchically.
  • Set properties.
  • Edit filters.
  • Display unbooked members.
  • Control totals.
  • Control sorting.
The image shows a data analysis interface with options to select available objects, measures, and dimensions. The builder section allows configuring rows and columns for financial statement items and closing year-to-date comparisons.

Note

Structures are made up of multiple dimensions. For example Closing YTD 2025 includes the period mode, and time dimensions.

Questions and Predefined Answers are also available in the Group Financial Statements Review Booklet app.

Therefore the following dimensions can be added to the layout panel to provide additional information for analytical purposes:

  • Question, with the following display attributes:

    • Are Multiple Answers Allowed
    • Maximum Number of Allowed Answers
    • Minimum Number of Required Answers
    • Question Type
  • Predefined Answer .

On the SAP Business Accelerator Hub, the following APIs are provided to create, update, and delete questions and predefined answers:

  • API_CONSOLIDATIONQUESTION (Consolidation Question)
  • API_CNSLDTNQUESTIONTYPE (Consolidation Question Type)
  • API_CONSOLIDATIONANSWER (Consolidation Answer)
  • API_CNSLDTNREPORTEDANSWER (Consolidation Reported Answer).

In the Group Financial Statements Review Booklet app, the two dimensions are available on the following business pages:

  • Consolidated Balance Sheet
  • Profit & Loss (Nature of Expense)
  • Profit & Loss (Function of Expense)
  • Cashflow Statement.
The figure above shows the dimensions Question and Predefined Answer on the Profit & Loss (Nature of Expense) business page in the Group Financial Statements Review Booklet app.

Review Booklet Formatting

You can use the formatting option to:

  • Set a template
  • Select alternating rows and wrap text
  • Scale the UnitCurrency position
  • Select measures
  • Change scaling and formatting of the scaling
  • Set the number of decimal places
  • Change the sign display
  • Set up conditional formatting.

Formatting

The image shows a Styling panel with options for table properties and number formatting, including measure selection, scale, scale format, decimal places, and sign display. There is also a section for conditional formatting, which currently has no rules found.

Review Booklet Context Information

You can use the context option to display global filter values and jump to hierarchies.

The image shows the Context Information with various global filters related to accounting details and hierarchies. It includes consolidation COA, profit center hierarchy, segment hierarchy, and consolidation unit hierarchy.

Review Booklet Exports

If you need to evaluate the review booklet results in Microsoft Excel, you can download it.

The image shows the process of exporting financial data to a Microsoft Excel file, specifically a Profit and Loss (P&L) statement. The exported Excel file contains various financial metrics such as revenue, gross margin, and net income for different time periods.

Review Booklet Report Navigation

From your review booklet, you can navigate to other areas and apps of group reporting.

This navigation is context-sensitive: The booklet settings (for example, the global filters and page filters) are automatically applied in the group reporting app that you navigate to.

You can jump to the Manage Global Hierarchies app by selecting a hierarchy from the Context Information in the side panel.

You can also transfer the context (selections and filters) to the Display Group Journal Entries With Reporting Logic app. You do this by right-clicking a data cell in the table and choosing Navigate to → Display Group Journal Entries With Reporting Logic.

The image shows a financial report , and the detailing of the Gains on the disposal of other assets displaying a view of group journal entries related to this item, including various transaction amounts in different currencies.

Review Booklet Views

After you apply filters and select the rows, columns, and dimensions that you want, you can then save the pages as a view. Saved views can then be selected to reload all the pages in the review booklet as you had saved them. Depending on your authorization, you may be able to save a view as Public so that other users can use it as well.

To save a view, choose the dropdown list of views and select Save As. When you save the view, you can also select Set as Default so that it appears by default every time you enter the app.

You can also manage views by selecting Manage from the dropdown list of views. Here, you can view the details of views, rename them, set them as default, and delete them.

The image shows the process of saving and managing views, including options to set a view as default and make it public. The Manage Views section displays a list of views with details on sharing settings, default status, and the creator.

Review Booklet Business Insights

Financial business insights quick actions combine drilldown and filter actions with Artificial Intelligence (AI) prompts. They automate navigation and provide users with explanations of the data. Business insights answer predefined business questions and offer detailed information to business users.

Business Insights for group financial statement booklet using generative AI:

  • Analyzes and summarizes tabular data on a review booklet page
  • Identifies and evaluates relevant business situations
  • Highlights findings within large datasets
  • Creates a management summary of group-level financial data
  • Includes comments and calculates KPIs
  • Allows easier and faster analysis and gives insights into group financial data for increased end user efficiency.

The figure gives an example for the analysis of P&L data in a review booklet using Business Insights.

Review Booklet Commenting

Comments in review booklets allow users to create, display, rename, and search for comments for data cells and pages. It also enables adding tags, changing status, and filtering comments. Using tags you are able to filter your comments and change their status.

The different perspectives of the multidimensional reporting in a review booklet allow you to see comments for different aggregations and filters, i. e. you can see comments from different angles.

Analytical cell-based comments:

  • Ability to discuss numbers in certain cells
  • Categorize, tag, filter and edit
  • History of comments and contributions
  • Live cycle status for each comment.

Comments of all loaded cells:

  • Show all loaded comments on a page
  • Rename "Cell Comment Header"
  • Classify and filter comments.

Comments of Selected Cells:

  • Add and view comments via context menu
  • Click on comment to see detailed history.
The figure shows how to create a comment and when somebody is notified in the comment to check the data how to reply to the comment after having checked the data.

With the @Mention Feature you can Inform colleagues about comments via email and notifications. You as the receiver of such a notification can click the notification icon and then click the message. You can then check the data according to the comment and answer to the comment.

The figure shows the Editing functionality of a comment. It contains the creation and change of the title, the classification of a comment, the setting and changing of the status and the creation of a comment tag.

When you set up a comment you can classify it and you can also set and change the status of the comment, change the title and create a tag for the comment.

The figure shows the content of the My Comments app which you can reach from the Navigate to My Comments button.

Using the Navigate to My Comments button gives you an overview about the titles of your comments, the status, the classification and t the comment tag you had defined.

Use the Review Booklet

Business Scenario

At ABC Corporation, your business users are interested in the review booklet because you can use one app to access many different reports. They're also interested in how to use and modify the predefined views.

What skills will you develop in this practice exercise?

  • Run the Consolidated Balance Sheet reports.
  • Run the Profit & Loss reports.
  • Run the Cash Flow Statement report using report rules.
  • Save your settings with a report variant.

Task 1: Run the Consolidated Balance Sheet Reports

ExerciseStart Exercise

Task 2: Run the Profit & Loss Reports

ExerciseStart Exercise

Task 3: Run the Cash Flow Statement Reports

ExerciseStart Exercise

Task 4: Save Your Settings with a Report Variant.

ExerciseStart Exercise

Use the Review Booklet

Business Scenario

Your business users are interested in the review booklet because you can use one tile to access many different reports. They're also interested in how to use and modify the predefined views.

In this exercise, you'll enhance your review booklet skills by performing the following tasks:

  • Run the Consolidated Balance Sheet reports.
  • Run the Profit & Loss reports.
  • Run the Cash Flow Statement report using report rules.
  • Save your settings with a report variant.

Note

In this exercise, when you see ##, replace the characters with your group number.

Task 1: Use the Balance Sheet Page

Steps

  1. Open the Group Financial Statements Review Booklet tile.

    1. Go to the Analytics for Group Reporting group.

    2. Choose the Group Financial Statements Review Booklet tile.

  2. Add the Consolidation Unit Hierarchy field to the global filter.

    1. On the Group Financial Statements page, choose Adapt Filters.

    2. In the Adapt Filters dialog select Consolidation Unit Hierarchy .

    3. Choose OK.

  3. Select CS17/ALL_CU_HIERARCHY - All Consolidation Units for the Consolidation Unit Hierarchy field in the global filter section.

    1. Open the Input Help of the Consolidation Unit Hierarchy drop-down in the global filter.

    2. In the field Display select ID and Description from the dropdown menu.

    3. In the Consolidation Unit Hierarchy dialog select the hierarchy provided in the exercise.

    4. Choose OK.

  4. Save the global filter as a view with the following settings:

    FieldValue
    ViewU##
    Set as Default
    Public
    Apply Automatically
    Execute the review booklet.

    1. In the global filter section choose (Select View) to the right of Standard.

    2. In the My Views dialog choose Save As.

    3. In the Save View dialog enter the data provided in the table.

    4. Choose Save.

    5. Choose Go.

  5. Open the Consolidated Balance Sheet - Overview page.

    1. Choose next to the Consolidated Balance Sheet page group.

    2. Select the Overview page.

  6. With the help of the Page Filters define the filter selections of the Assets tab as follows:

    FieldValue
    Assets 
      
    Variables 
    Profit Center for Elimination 
    Segment for Elimination 
    Consolidation Unit (Node) 
    Consolidation Unit for Elimination (Node) 
    Segment 
    Profit Center 
    FS Item HierarchyBS_PL (BS and PL)(use the search help)
    Consolidation FS Item (Node)Y1/BS_PL/TA0000 (Assets)(use the search help)

    1. Choose the (Page Filters) icon to the right of your screen.

      Note

      If the Page Filters button is greyed out, choose F5 on your keyboard to refresh the browser and empty the cache.

    2. In the Page Filters section to the right, make sure the Assets tab is selected.

    3. Enter the selections provided in the table above using the search help.

    Note

    In Settings for Display select ID and Description from the dropdown menu.

  7. With the help of the Page Filters define the filter selections of the Liabilities & Equity tab as follows:

    FieldValue
    Assets 
      
    Variables 
    Segment 
    Consolidation Unit (Node) 
    Profit Center 
    Segment for Elimination 
    Consolidation Unit for Elimination (Node) 
    Profit Center for Elimination 
    Consolidation FS Item (Node)Y1/BS/TLE000 (Liabilities & Equity)(use the search help)
    FS Item HierarchyBS_PL (BS and PL)(use the search help)
      
    Finally, close the Page Filters section.

    1. With the (Page Filters) icon selected, make sure the Liabilities & Equity tab is selected in the Page Filters section to the right of your screen.

    2. Enter the selections provided in the table above using the search help.

      Note

      In Settings for Display select ID and Description from the dropdown menu.

    3. Choose the (Page Filters) icon to the right of your screen to close the Page Filters section.

  8. In the Row set and Column set of the Consolidated Balance Sheet - Overview page select the following:

    FieldValue
    Row Set of the Consolidated Balance Sheet - Overview pageFinancial Statement Item
    Column Set of the Consolidated Balance Sheet - Overview pageClosing Period vs. Previous Period

    1. On the Consolidated Balance Sheet - Overview page, to the right of Auto-Refresh choose the (Choose Rows) icon next to Rows (which is the Row Set).

    2. If necessary, select the information provided in the table.

    3. To the right of Auto-Refresh choose the (Choose Columns) icon next to Columns (which is the Column Set).

    4. Select the information provided in the table.

      Result

      The figure shows the Consolidated Balance Sheet - Overview Page which contains Assets and Liabilities & Equity.
      The value for Assets is equal to the value for Liabilities & Equity.

  9. Switch to the Consolidated Balance Sheet - Assets page.

    1. Choose next to the Consolidated Balance Sheet page group.

    2. Select the Assets page.

  10. With the help of the Page Filters define the filter selections of the Assets page as follows:

    FieldValue
    Assets Page 
      
    Variables 
    Consolidation Unit for Elimination (Node) 
    Segment 
    Profit Center 
    Consolidation Unit (Node) 
    Profit Center for Elimination 
    Segment for Elimination 
    Consolidation FS Item (Node)Y1/BS/TA0000 (Assets)(use the search help)
    FS Item HierarchyBS (Balance Sheet)
      
    Dimensions 
    Consolidation Unit 
    Profit Center 
    Segment 
    Consolidation FS Item 

    1. Choose the (Page Filters) icon to the right of your screen.

    2. In the Page Filters section enter the selections provided in the table above using the search help. For the field Display select ID and Description.

    3. Choose the (Page Filters) icon to the right of your screen to close the Page Filters section.

  11. In the Row set and Column set of the Consolidated Balance Sheet - Assets page select the following:

    FieldValue
    Row Set of the Consolidated Balance Sheet - Assets pageFinancial Statement Item
    Column Set of the Consolidated Balance Sheet - Assets pageClosing Period vs. Previous Period

    1. On theConsolidated Balance Sheet - Assets page, to the right of Auto-Refresh choose the (Choose Rows) icon next to Rows.

    2. If necessary, select the information provided in the table.

    3. To the right of Auto-Refresh choose the (Choose Columns) icon next to Columns.

    4. Select the information provided in the table.

      Result

      The figure shows the Consolidated Balance Sheet - Assets page with the values of period 12 in 2025.
      Asset values are displayed in the rows with the FS Item hierarchy.

  12. Switch to the Consolidated Balance Sheet - Liability & Equity page.

    1. Choose next to the Consolidated Balance Sheet page group.

    2. Select the Liability & Equity page.

  13. With the help of the Page Filters define the filter selections of the Liability & Equity page as follows:

    FieldValue
    Liability & Equity Page 
      
    Variables 
    Profit Center 
    Consolidation Unit for Elimination (Node) 
    Segment for Elimination 
    Consolidation Unit (Node) 
    Segment 
    Profit Center for Elimination 
    Consolidation FS Item (Node)Y1/BS/TLE000 (Liabilities & Equity)
    FS Item HierarchyBS (Balance Sheet)
      
    Dimensions 
    Consolidation Unit 
    Profit Center 
    Segment 
    Consolidation FS Item 

    1. Choose the (Page Filters) icon to the right of your screen.

    2. In the Page Filters section enter the selections provided in the table above using the search help. For the field Display select ID and Description.

    3. Choose the (Page Filters) icon to the right of your screen to close the Page Filters section.

  14. In the Row set and Column set of the Consolidated Balance Sheet - Liquidity & Equity page select the following:

    FieldValue
    Row Set of the Consolidated Balance Sheet - Liquidity & Equity pageFinancial Statement Item
    Column Set of the Consolidated Balance Sheet - Liquidity & Equity pageClosing Period vs. Previous Period

    1. On the Consolidated Balance Sheet - Liquidity & Equity page, to the right of Auto-Refresh choose the (Choose Rows) icon next to Rows.

    2. If necessary, select the information provided in the table.

    3. To the right of Auto-Refresh choose the (Choose Columns) icon next to Columns.

    4. Select the information provided in the table.

      Result

      This figure shows the Consolidated Balance Sheet - Liquidity & Equity page with the values of period 12 in 2025.

  15. Change the FS Item properties to display all nine levels of the hierarchy.

    1. Right-click Consolidation FS Item.

    2. Choose Dimension→Properties.

    3. In the Properties for Consolidation FS Item dialog, choose the Hierarchies tab.

    4. In the Nodes to show dropdown, choose From root to level 9.

    5. Choose OK.

    Result

    The FS Item hierarchy is now expanded to level 9 in the rows.

  16. Add Consolidation Unit into the rows to the left of FS Item.

    1. Right-click Consolidation FS Item.

    2. Choose Dimension → + Add Dimension.

    3. Select Consolidation Unit.

    4. Right-click Consolidation Unit.

    5. Choose Dimension → Move → Left.

    Result

    The figure shows the Consolidated Balance Sheet - Liquidity & Equity page with Consolidation Unit in the Rows and with the FS Item hierarchy expanded. The figure shows the values of period 12 in 2025.

Task 2: Use the Profit & Loss Page

Steps

  1. Switch to the Profit & Loss (Nature of Expense) - Overview page.

    1. Choose next to the Profit & Loss (Nature of Expense) page group.

    2. Select the Overview page.

      Result

      The Profit & Loss values by FS Item appear.

  2. OPTIONAL

    Choose the Business Insights icon to get informed about the following KPI results in 012.2025 :

    • EBIT - Earnings Before Interest and Taxes
    • Operating Income/Loss.

    1. Choose the (Business Insights) icon to the right of your screen.

    2. Expand > Recommended in the Business Insights section.

    3. Click the EBIT button.

      Result

      The figure shows the AI calculation results of the EBIT.

    4. In the Business Insights section to the right, choose <(Navigation-left-arrow) .

    5. Click the Operating Income/Loss button.

      Result

      The figure shows the AI calculation results of the Operating Income/Loss.

    6. In the Business Insights section to the right, choose <(Navigation-left-arrow) .

    7. Choose the (Business Insights) icon to the right of your screen to close the Business Insights section.

      END OPTIONAL

  3. Switch to the Profit & Loss (Nature of Expense) - P&L by Reporting Unit page.

    1. Choose next to the Profit & Loss (Nature of Expense) page group.

    2. Select the P&L by Reporting Unit page.

  4. With the help of the Page Filters define the filter selections of the P&L by Reporting Unit page as follows:

    FieldValue
    Page Filters 
      
    Variables 
    Profit Center for Elimination 
    Segment for Elimination 
    Segment 
    Profit Center 
    Consolidation Unit (Node) 
    Consolidation Unit for Elimination (Node) 
    FS Item HierarchyPL (Profit and Loss Statement)
    Consolidation FS Item (Node)Y1/PL/TOI000 (Operating Income / Loss) (Expand the nodes NET INCOME / LOSS→Profit (Loss) from Continuing Operations→Profit (Loss) Before Tax, and select Operating Income / Loss).
    Budget VersionU## Act EUR GC
    Constant Currency VersionU## Act EUR GC
    Dimensions 
    Consolidation Unit for Elimination 
    Consolidation Unit 
    Profit Center 
    Segment 
    Segment for Elimination 
    Profit Center for Elimination 
    Consolidation FS Item 

    1. Choose the (Page Filters) icon to the right of your screen.

    2. In the Page Filters section enter the selections provided in the table above using the search help. For the field Display select ID and Description.

      Result

      The P&L by Reporting Unit page shows the Operating Income / Loss values.

  5. In the layout, switch the columns to the following:

    • Current Year 2025
    • Previous Year 2024
    • CY 2025 Δ PY 2024.

    1. Choose the (Layout) icon to the right of your screen.

    2. On the right side (Builder) of the Layout dialog, in the lower part of the Columns section, hover on Structure.

    3. Choose … (More)→Filter→Edit....

    4. In the Structure dialog choose Clear Selection.

    5. Select the three structures provided in the exercise.

    6. Choose OK.

    7. Choose the (Layout) icon to the right of your screen to close the Layout section.

      Result

      You should have values for 2025 but not for 2024. Now you know how to change columns in a report.

  6. Switch to the Profit & Loss (Nature of Expense) - Profit Margins - Waterfall View page.

    1. Choose next to the Profit & Loss (Nature of Expense) page group.

    2. Select the Profit Margins - Waterfall View page.

  7. Define the filter selections of the Profit Margins - Waterfall View page chart as follows:

    FieldValue
    Page Filters 
      
    Variables 
    Profit Center 
    Segment 
    Segment for Elimination 
    Consolidation Unit (Node) 
    Consolidation Unit for Elimination (Node) 
    Profit Center for Elimination 
    FS Item HierarchyPL (Profit and Loss Statement)
    Consolidation FS Item (Node)Y1/PL/TOI000 (Operating Income / Loss) (Expand the nodes NET INCOME / LOSS→Profit (Loss) from Continuing Operations→Profit (Loss) Before Tax, and select Operating Income / Loss).
    Constant Currency VersionU## Act EUR GC
    Budget VersionU## Act EUR GC
      
    Dimensions 
    Consolidation Unit 
    Profit Center 
    Segment 
    Consolidation FS Item 

    1. Choose the (Page Filters) icon to the right of your screen.

    2. In the Page Filters section enter the selections provided in the table above using the search help.

      Note

      In the search help, for field Display select ID and Description from the dropdown menu.

    3. Choose the (Page Filters) icon to the right of your screen to close the Page Filters section.

    Result

    The image displays a financial statement analysis in SAP, focusing on profit margins in a waterfall view format. It includes various financial metrics such as revenue, changes in inventory, gross margin, and depreciation.

Task 3: Run the Cash Flow Report

Steps

  1. Switch to the Cash Flow Statement - Overview page.

    1. Choose next to the Cash Flow Statement page group.

    2. Select the Overview page.

  2. Make sure the following filter selections of the Cash Flow Statement - Overview page are set:

    FieldValue
    Page Filters 
      
    Variables 
    Consolidation Unit for Elimination (Node) 
    Segment for Elimination 
    Consolidation Unit (Node) 
    Segment 
    Profit Center 
    Profit Center for Elimination 
    Reporting Item (Node) 
    Reporting Item HierarchyX2 - Statement of Cash Flow
    Reporting Rule VariantY10
      
    Dimensions 
    Profit Center 
    Segment 
    Consolidation Unit 
    Reporting Item 

    1. Choose the (Page Filters) icon to the right of your screen.

    2. In the Page Filters section enter the selections provided in the table above using the search help.

      Note

      In the search help, for field Display select ID and Description from the dropdown menu.

    3. Choose the (Page Filters) icon to the right of your screen to close the Page Filters section.

  3. In the Row set of the Cash Flow Statement - Overview page select the following:

    FieldValue
    Row Set of the Cash Flow Statement - Overview pageConsolidation Unit
    Column Set of the Cash Flow Statement - Overview pageClosing Year vs. Previous Year

    1. On the Cash Flow Statement - Overview page, to the right of Auto-Refresh choose the (Choose Rows) icon next to Rows.

    2. Select the information provided in the table.

    3. To the right of Auto-Refresh choose the (Choose Columns) icon next to Columns.

    4. Select the information provided in the table.

      Result

      The figure shows the Cash Flow Statement - Overview page with the Consolidation Unit dimension in the rows.
      Reporting Item is replaced with Consolidation Unit in the rows.

  4. Switch the Row set of the Cash Flow Statement - Overview page to the following:

    FieldValue
    Row Set of the Cash Flow Statement - Overview pageProfit Center

    1. On the Cash Flow Statement - Overview page, to the right of Auto-Refresh choose the (Choose Rows) icon next to Rows.

    2. Select the information provided in the table.

    Result

    The figure shows the Cash Flow Statement - Overview page with the Profit Center dimension in the rows.
    Consolidation Unit is replaced with Profit Center in the rows.

  5. Switch the Column set of the Cash Flow Statement - Overview page to the following:

    FieldValue
    Column Set of the Cash Flow Statement - Overview pageClosing Period CY vs. Same Period PY

    1. On the Cash Flow Statement - Overview page, to the right of Auto-Refresh choose the (Choose Columns) icon next to Columns.

    2. Select the information provided in the table.

      Result

      The figure shows the Cash Flow Statement - Overview page with Closing Period CY vs. Same Period PY in Columns.
      The columns now include the following:
      • Closing Period 012.2025
      • PY Period 012.2024 (you won’t have any data)
      • CP 012.2025 Δ CPPY 012.2024
      • %CP 012.2025 Δ CPPY 012.2024

  6. Save the global filter as a view with the following settings:

    FieldValue
    ViewRevBook##
    Set as Default
    Public
    Apply Automatically

    1. In the global filter section choose (Select View) to the right of U##.

    2. In the My Views dialog choose Save As.

    3. In the Save View dialog enter the data provided in the table.

    4. Choose Save.

    5. Choose Go.

Task 4: Use the Comment Feature on the Cash Flow Statement - Overview Page

Steps

  1. Regarding the negative result for profit center PC 4 - Racing in December 2025 enter the following cell comment for PC4/Amount in Group Crcy: Why do we have such a negative financial result?

    1. Right-click in the data cell for PC4/Amount in Group Crcy.

    2. Choose Comment → + Create Comment.

    3. In the Comments section to the right enter the comment provided in the exercise.

    4. Choose Add in the Comments section.

      Result

      The user who created the comment is added to the comment. The comment is in parallel also saved as comment title.

  2. Change the comment title to the following: Analysis of Financial Results. Classify the comment as Critical and create the tag ToCheck for this comment.

    1. In the Comments section to the right, next to Why do we have such a negative financial result? choose (Additional Options) → Edit.

    2. In the Edit dialog enter the title provided in the exercise.

      Result

      In the Edit dialog you will see that initial Status of the comment is Open.

    3. Open the Classification dropdown in the Edit dialog and select Critical.

    4. In the Tags field of the Edit dialog type ToCheck .

    5. Choose Save.

  3. In order to ask a colleague - in this scenario you are also the colleague - to do further analysis, enhance the comment by choosing the @(Mention) icon after the comment. After @ enter the first letter of your training system user. A pop-up will come up. Select your own user.

    Finally, add the following comment after your user in the Edit Comment dialog: Please review the data as soon as possible.

    1. To the right of the comment choose (More) → Edit .

    2. Put the cursor in the first empty row after the comment.

    3. Choose @(Mention) .

    4. Enter the first letter of your training system user.

      Result

      A list of training system users comes up.

    5. Select your training system user.

    6. To the right of your training user name enter the comment provided in the exercise.

    7. Choose Save.

  4. Check if you received a notification with a similar text: … mentioned you in a comment in the Group Financial Statement app . Don't click the notification hyperlink.

    Note

    A real colleague would have clicked the notification hyperlink in order to jump to the dedicated comment.

    1. In the upper right of your screen open the (1 Notifications) icon.

      Result

      You should get a similar result:

    2. Don't click the notification hyperlink.

  5. Reply to the comment with the following answer: After analyzing the data, we found out that the data on this profit center is OK. and update the status to resolved.

    1. Enter the answer provided in the exercise by choosing the Reply button in the Comments section.

    2. Choose Add.

    3. Right to Why do we have such a negative financial result? in the Comments section choose (Additional Options) → Edit.

    4. In the Edit dialog open the Status dropdown and select Resolved.

    5. Choose Save.

      Result

      The figure shows the configuration of cell comments in the Comments section of the Review Booklet.
      The (Resolved) icon shows that the status is resolved.

  6. Navigate to the My Comments tile and check your comments. Finally, return to the Group Financial Statements web page.

    1. In the Comments section, right to the Search field and Setting icon, choose (Additional Options) → Navigate to My Comments.

      Result

      The figure shows the My Comments tile. It contains the comment and the review comment.

    2. Choose <(Back).

      Result

      You should now be on the Group Financial Statements web page and see your Review Booklet.

  7. Re-save the global filter as a view with the following settings:

    FieldValue
    ViewRevBook##
    Set as Default
    Public
    Apply Automatically

    Finally, return to the SAP Fiori Launchpad Home Page.

    1. In the global filter section choose (Select View) to the right of RevBook##.

    2. In the My Views dialog choose Save.

    3. Choose Go.

    4. Choose the icon to return to the SAP Fiori Launchpad Home Page.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn