Product Information
SAP Group Reporting: Predictive Consolidation
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.
|
|||||||||||||||||
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.
|
|||||||||||||||||
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
|
|||||||||||||||||
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.
|
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
|
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.
|
|||||||||||||||||
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.
|
|||||||||||||||||
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
|
|||||||||||||||||
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.
|
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
|
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
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.
|
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.
|
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.
|
|||
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.