Additional Blogs by SAP
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP Group Reporting: Predictive Consolidation

former_member131829
Discoverer
‎2022 Dec 08 8:51 AM
2,059
With this blog, I would like to help you understand how to integrate predictive accounting with Group Reporting, and which activities can be run as standard Group Reporting processes to produce predictive consolidated results.

From CE2302/OP2023 on, the scope item 3JP(Group Reporting - Predictive Consolidation) is deprecated, but with the information shared in this blog, you still can set it up yourselves by making use of SSCUI apps, and all features are still available to support this scenario.

You will find the following information in this blog:

  • Introduction of Predictive Consolidation

  • Roles

  • Business Conditions

  • Preliminary Steps

  • Procedures


Introduction of Predictive Consolidation


Predictive Accounting creates predictive journal entries for the corresponding future activities(like goods issue) in a special extension ledger, the prediction ledger. This is a special ledger that structures the predicted results just like your actual data is structured in the underlying ledger.

The Predictive Consolidation allows you to integrate predictive journal entries from the predictive ledger 0E (for example, those postings derived from sales orders) with the Group Reporting solution. You can run the standard Group Reporting process of validations and methods on this data to produce predictive consolidated results. You can analyze this consolidated data in a delivered report.


You may refer to the below detail procedure which is for predictive consolidation SAP S/4HANA Cloud, public edition, after you activate the scope item 1SG(Group Reporting - Financial Consolidation).

Roles


Create business roles using the following business role templates delivered by SAP and assign them to your individual test users.

Alternatively, if available, you can use the following spaces delivered by SAP. You create a space with pages containing predefined essential apps and assign it to the business role. You then assign this business role to your individual users.

For more information, refer to How to Create a Business Role for the Administrator in the product assistance for SAP S/4HANA Cloud, public edition.


























Name (Role Template) ID (Role Template) Name (Launchpad Space) ID (Launchpad Space) Log On
The user in SAP S/4HANA Cloud, public edition with the Consolidation Specialist role assigned SAP_BR_CONSLDTN_SPECIALIST
Configuration Expert - Business Process Configuration SAP_BR_BPC_EXPERT Configuration Expert - Business Process Configuration SAP_BR_BPC_EXPERT

Business Conditions


Please ensure you activate the predictive accounting scope items with predictive ledger 0E, and from below list you can prepare predictive postings for this ledger(for example, those postings derived from sales orders).

































































Scope Item
BKP - Customer Returns
1EZ - Credit Memo Processing
1F1 - Debit Memo Processing
1WO - Extended Intercompany Processes for Sales
BKA - Free Goods Processing
BDA - Free of Charge Delivery
1HO - Intercompany Sales Order Processing - Domestic
1MX - Intercompany Sales Order Processing - International
BKL - Invoice Correction Process with Credit Memo
BDQ - Invoice Correction Process with Debit Memo
BDH - Sales Order Entry with One-Time Customer
BKX - Sales Order Processing - SEPA Direct Debit Handling
BKZ - Sales Order Processing with Invoice List and Collective Billing
BD3 - Sales Processing using Third-Party with Shipping Notification
BDK - Sales Processing Using Third-Party Without Shipping Notification
BDN - Sales of Non-Stock Item with Order-Specific Procurement
BD9 - Sell from Stock
1BM - Make-to-Order Production - Semifinished Goods Planning and Assembly
1YT - Make-to-Order Production with Variant Configuration

Preliminary Steps


Please activate scope item 1SG(Group Reporting - Financial Consolidation) before you set up additional settings.

Configure your solution in case you are in Solution Builder Framework.







































































































Test Step # Test Step Name Instruction Expected Result Pass / Fail /Comment
1 Log On Log on to the SAP Fiori launchpad as a Configuration Expert - Business Process Configuration. The SAP Fiori launchpad displays.
2 Access the SAP Fiori App

Open Manage Your Solution (F1241) and choose Configure Your Solution.

Make the following entries:

Application Area: Finance

Sub Application Area: Corporate Close		 The Configure Your Solution view is displayed.
3 Define Versions

Select the Basic Settings Item Name.

Choose Configure in Define Versions.

Double-click Version YP1. Add 0E in Preparation Ledger field. Select K Group Currency in Group Crcy Source field.

Choose Back to go back to the previous view.
4 Define Group Reporting Preparation Ledgers

Choose Configure in Define Group Reporting Preparation Ledgers.

Choose Create New to add two line items using as below.

 


























Config. ID Group Reporting Preparation Ledger Consolidation COA FS Item Mapping Version FS Item Attributes Version
Z-0C 0C Y1 Y10 S10
Z-0E 0E Y1 Y10 S10

4 Log On Log on to the SAP Fiori launchpad as a Consolidation Specialist. The SAP Fiori launchpad displays.
5 Access the SAP Fiori App Open Map FS Items with G/L Accounts (F3333). The Map FS Items with G/L Accounts view displays.
6 Verify Map Availability On the Mapping Revisions table, verify that maps are available with Active status.






Note If there are no active maps in the table, return to the SAP Fiori launchpad and open Import FS Item Mappings (F3335) and import a file.

7 Access the SAP Fiori App Return to the SAP Fiori launchpad and open Assign FS Item Mappings (F3334) The Assign FS Item Mappings view displays.
8 Verify Items

Verify that the following values appear in the Items list:

Start of Assignment: For example, 001/1900

FS Item Mapping Version: Y10

Consolidation Chart of Accounts: Y1

G/L Chart of Accounts: YCOA

FS Item Mapping ID: Y1






Note If the values do not appear, choose New and enter the values on the dialog box and then choose Save.

9 Access the SAP Fiori App Return to the SAP Fiori launchpad and open Consistency Check of Accounting Integration (CX8CCI) The Consistency Check of Settings for FI Integration view displays.
10 Verify Execution Parameters

Verify that the following values appear in Execution Parameters:

Version: YP1

Consolidation COA: Y1

Fiscal Year: For example, 2019 (the year you are testing)

and choose Execute.






Note Please ignore any other error messages unrelated to consolidation units you tested..



The missing configuration for accounting integration displays.

All missing configuration issues must be corrected to read company code data.
11 Access the SAP Fiori App Return to the SAP Fiori launchpad and open Manage Group Structure - Group View (F3733) The Manage Consolidation Group Structure - Group View displays.
12 Verify Groups

Verify that the following groups are available:

Consolidation Group:

●      CGN2

●      CG3

 






Note If those groups are not available, follow the Organization Structure Creation section in the Group Reporting - Financial Consolidation (1SG) to add the groups.


 

SAP Central Business Configuration:

 
































































































Test Step # Test Step Name Instruction Expected Result Pass / Fail /Comment
1 Log On Log on to the project experience in SAP Central Business Configuration. The SAP Fiori Launchpad displays.
2 Open Define Versions

In the Product-Specific Configuration phase, navigate to the Configuration Activities tab and search for the following activity: Define Versions.

Choose the line item in the search result to see more details about this configuration activity.

Choose the Go to Activity button to navigate directly to the SAP system.

Log on to the SAP Fiori launchpad as a Configuration Expert - Business Process Configuration.

Double-click Version YP1. Add 0E in Preparation Ledger field. Select K Group Currency in Group Crcy Source field.

Choose Back to go back to the previous view.		 The Define Versions screen displays.
3 Define Group Reporting Preparation Ledgers

Choose Configure in Define Group Reporting Preparation Ledgers.

Choose Create New to add two line items using as below.

 


























Config. ID Group Reporting Preparation Ledger Consolidation COA FS Item Mapping Version FS Item Attributes Version
Z-0C 0C Y1 Y10 S10
Z-0E 0E Y1 Y10 S10

4 Log On Log on to the SAP Fiori launchpad as a Consolidation Specialist. The SAP Fiori launchpad displays.
5 Access the SAP Fiori App Open Map FS Items with G/L Accounts (F3333). The Map FS Items with G/L Accounts view displays.
6 Verify Map Availability On the Mapping Revisions table, verify that maps are available with Active status.






Note If there are no active maps in the table, return to the SAP Fiori launchpad and open Import FS Item Mappings (F3335) and import a file.

7 Access the SAP Fiori App Return to the SAP Fiori launchpad and open Assign FS Item Mappings (F3334) The Assign FS Item Mappings view displays.
8 Verify Items

Verify that the following values appear in the Items list:

Start of Assignment: For example, 001/1900

FS Item Mapping Version: Y10

Consolidation Chart of Accounts: Y1

G/L Chart of Accounts: YCOA

FS Item Mapping ID: Y1






Note If the values do not appear, choose New and enter the values on the dialog box and then choose Save.

9 Access the SAP Fiori App Return to the SAP Fiori launchpad and open Consistency Check of Accounting Integration (CX8CCI) The Consistency Check of Settings for FI Integration view displays.
10 Verify Execution Parameters

Verify that the following values appear in Execution Parameters:

Version: YP1

Consolidation COA: Y1

Fiscal Year: For example, 2019 (the year you are testing)

and choose Execute.






Note Please ignore any other error messages unrelated to consolidation units you tested..



The missing configuration for accounting integration displays.

All missing configuration issues must be corrected to read company code data.
11 Access the SAP Fiori App Return to the SAP Fiori launchpad and open Manage Group Structure - Group View (F3733) The Manage Consolidation Group Structure - Group View displays.
12 Verify Groups

Verify that the following groups are available:

Consolidation Group:

●      CGN2

●      CG3

 






Note If those groups are not available, follow the Organization Structure Creation section in the Group Reporting - Financial Consolidation (1SG) to add the groups.


 

Procedures


This section describes test procedures for each process step that belongs to this guide.

1. Data Monitor for Companies


There are some consolidation units that are available for integration in consolidation group CG2. Since the company code master data is customer-dependent, confirm that your available company codes are in your system and pick the corresponding consolidation units.

The values in the following table are provided as examples only.




















Cons unit / company code Description Local Currency
1010 Walldorf EUR
1710 Palo Alto USD

Test cases overview

Preparation for SAP Company integration:

  • Set global parameters

  • Run data monitor (for example), 2019.01 for S4 company 1010

  • Release universal journal (S4 accounting)

  • Validate universal journal (S4 accounting)

  • Run currency translation

  • Run remaining data monitor tasks

  • Review, using the Data Analysis (Deprecated) (F2848) SAP Fiori app

  • Lock tasks

  • Run all of the consolidation monitor tasks


1.1 Preparation for Company Integration


Purpose

In this activity, you review the settings for FI integration.

Procedure








































Test Step # Test Step Name Instruction Expected Result Pass / Fail /Comment
1 Log On Log on to the SAP Fiori launchpad as a Consolidation Specialist. The SAP Fiori launchpad displays.
2 Access the SAP Fiori App Open Consistency Check of Accounting Integration (CX8CCI) . The Consistency Check of Settings for FI Integration view displays.
3 Execute Consistency Check

Execute the consistency check for the following parameters:

Version: YP1

Consolidation COA: Y1






Note Ensure that all roles described below are assigned to your user:

 

Fiscal Year : 2019

and choose Execute from the bottom of the view.		 A table of results display.
4 Verify Integration Review the results and verify that your assigned consolidation unit is integrated.






Note Ignore the Sender group currency key inconsistent error notification.

Assigned consolidation unit is integrated.

 

1.2 Data Monitor for Companies


Context

In this activity, you run the data and consolidation monitor for the companies.

Procedure













































































































































































Test Step # Test Step Name Instruction Expected Result Pass / Fail / Comment
1 Log On Log on to the SAP Fiori launchpad as a Consolidation Specialist. The SAP Fiori launchpad displays.
2 Set Global Parameters Open Set Global Parameters (CXGP). A Global parameters dialog box displays.
3 Enter Criteria

Make the following entries,

Organization units section:

Cons. Group: CG2

Version/Time period section:

Version: YP1

Fiscal year: For example, 2019

Period: For example, 01

Further settings section:

Cons. COA: Y1

and choose Continue:		 The SAP Fiori launchpad displays.
4 Access the SAP Fiori App Open Data Monitor (CXCD). The Data Monitor view displays.
5 Open Period Right-click your consolidation unit and choose Open period.






Note If your unit is already open, you can skip this step.

The Period 01/2019 for CG2/CU 1010 opened notification displays.
6 Access the SAP Fiori App Open Group Data Analysis - With Reporting Rules (W0136). The Group Data Analysis - With Reporting Rules displays.
7 Enter Prompts

Choose Adapt Filters and maintain the following entries:

Consolidation COA: Y1

Consolidation Group: CG2

Reporting Item Hierarchy: X1

Reporting Rule Variant: Y10

Consolidation Unit: For example, 1010 (your assigned unit)

and choose Go.

(Other information is inherited from global parameters).

Some postings may exist in previous periods.
8 Enter Criteria Narrow your selection of the time period to 2019.01. All other information is inherited from global parameters.






Note Some postings may exist in previous periods and documents posted earlier are not available, as they are not yet released.

9 Return to Data Monitor Open Data Monitor (CXCD), right-click the top value in the Hierarchy column and select Detailed Overview. A list of tasks displays.
10 Release Universal Journal

Right-click the Release Universal Journal and select to run in both the Test and Update Run modes.

Review the line for your consolidation unit. Verify that the data list, in full (already submitted and pending delta for submission), or in delta (pending delta for submission) mode, using the left or right buttons.

Choose Release Universal Documents button to continue with release of the accounting data.

The timestamp is updated.

The system displays a green status update.
11 Access the SAP Fiori App Return to the SAP Fiori launchpad and open Group Data Analysis - With Reporting Rules (W0136). The Group Data Analysis - With Reporting Rules displays.
12 Enter Prompts

Maintain the following entries:

Consolidation Group: CG2

Consolidation Unit: For example, 1010 (your assigned unit)

and choose Go.

(Other information is inherited from global parameters).
13 Verify Data Verify that your relevant documents are available. To drilldown to the universal document, double-click an item. Data is available now with posting level blank and an 0F document type .
14 Return to Data Monitor Open Data Monitor (CXCD). A list of tasks displays.
15 Task - Validation Universal Journal Run the Validation Universal Journals task in Test and Update mode. No errors are shown for the uploaded FI document.
16 Task - Calculate Net Income Run the Calc. Net Income task in Test and Update mode. The task is executed successfully with detailed log about calculated net income result.
17 Task - Validation Reported Data LC

Run the 1080 Validation Reported Data LC task in Test and Update mode.

If the validation method for your cons unit is missing or wrong, you can maintain by selecting your consolidation unit, right-click, and select master data. Select the tab Methods and Assign Validation Method.

Or, you can access the Assign Validation Methods (VECMA) SAP Fiori app, to synchronize the latest validation settings.

Select the task ID 1080 and choose the Change mode.

Select version YP1 and period category 9.

Select consolidation unit to be assigned and select validation method SRD1.

Choose Save.		 The validation passes without error messages.
18 Access the SAP Fiori App Return to the SAP Fiori launchpad and open Currency Exchange Rates (F3616). The Currency Exchange Rates view displays.
19 Maintain Exchange Rate

Review the exchange rates for your local currency to group currency for 01/2019 and maintain the relevant rates for AVG and CLO, if they are missing.

Choose Exit.
20 Return to Data Monitor Open Data Monitor (CXCD), right-click the top value in the Hierarchy column and select Detailed Overview. A list of tasks displays.
21 Task - Currency Translation

Run the task Currency Translation in Test and Update mode.

The task status is Not applicable for the cons units where Local Currency = Global Currency.

The Task Logs view displays.

More lines with posting level blank and translation indicator 1 and 4 are created based on amount in LC and rules in currency translation method.
22 Task - Standardized Data Validation

Run the Standardized Data Validation task in Test and Update mode.

If the validation method for your consolidation unit is missing or wrong, you can maintain as follows:

Access the app Assign Validation Methods (VECMA) to synchronize the latest validation settings.

Select task ID 1180 and go to Change mode.

Select version YP1 and period category 9.

Select consolidation unit to be assigned and select validation method SCD1.

Choose Save.

The Manage Data Validation Task-FINCS Standardized Data Validation view displays.

The validation passes with one warning message.
23 Lock all Tasks Select each task and choose the Block button. Once the tasks are locked, it is impossible to submit more data to the current period.

2. Consolidation Monitor for Companies (Optional)



Purpose

In this activity, you run consolidation tasks for a period.

Procedure

































Test Step # Test Step Name Instruction Expected Result Pass / Fail / Comment
1 Log On Log on to the SAP Fiori launchpad as a Consolidation Specialist. The SAP Fiori launchpad displays.
2 Access the SAP Fiori App Open Consolidation Monitor (CX20) The Consolidation Monitor view displays.
3 Run Tasks

For the following parameters:

Cons. Group: CG2

Period: 01/2019

Run all of the tasks in the consolidation monitor.		 The task logs contain no errors.

Now, you can start deploying your solution and running the predictive consolidation. We hope you’ll find this blog useful.
Popular Blog Posts
Top kudoed authors
View all