Follow our LinkedIn SAP Learner Community for a lot of Free Content
Session 1 - Introduction to SAP S/4HANA Finance and Group Reporting
Session 2 - Integrated and Non-Integrated Consolidation Units Setup
Session 3 - Consolidation Units Attributes and Group Structure Setup
Session 4 - Assigning Consolidation Units and Groups with Methods
Session 5 - Calculation of Net Income and Retained Earnings
Session 6 - Validation of Reported Data in Group Reporting
Session 7 - Currency Translation and Exchange Rate Differences
Session 8 - Intercompany Reconciliation and Matching Methods
Session 9 - Intercompany Eliminations and Rule-Based Configuration
Session 10 - Consolidation of Investments and Goodwill Calculation
Session 11 - Subsequent Consolidation, Plan Data Upload and Realignment
Additional Session Videos
-
Introduction to SAP Group Reporting (42:28)
-
Session Video - Overview (183:30)
-
Session Video - Describing the Structure (151:38)
-
Session Video - Master Data and Structures, Module Hierarchies for Group Reporting (178:38)
-
Session Video - Consolidation Unit Groups (171:25)
-
Session Video - Managing Breakdown Categories, Subitems (186:39)
-
Session Video - Consolidating Financial Data (192:38)
-
Session Video - Configuring Data Validation (175:59)
-
Session Video - Describing Document Types and Posting (151:22)
-
Session Video - Reclassifying Data (172:43)
-
Session Video - Designing Historic and Income Currency Translation (170:00)
-
Session Video - Consolidation and Elimination (162:47)
-
Session Video - Review Intercompany Matching and Reconciliation (174:50)
-
Session Video - Implementing Intercompany & Matrix Eliminations (180:21)
-
Session Video - Explaining the Rule-Based Method, Reporting, Planning, and Balance Carryforward (170:03)
-
Session Video - Using Report Logic and Reporting Rules (152:32)
-
Session Video - Reporting, Planning, and Balance Carryforward (82:32)
Assessments
Assignments
Lab Activity
-
Lab Activity - 1. Perform Month End Closing
-
Lab Activity - 2. Create Consolidation Groups and Units
-
Lab Activity - 3. Create and Upload Consolidation Hierarchies
-
Lab Activity - 4. Maintain FS Items and Map to GL Accounts
-
Lab Activity - 5. Release data from S4HANA Accounting
-
Lab Activity - 6. Upload Reported Financial Data
-
Lab Activity - 7. Configure and Run Validation
-
Lab Activity - 8. Book Top Side Entries and Explain Selected Items
-
Lab Activity - 9. Use Journal Validation & Substitution
-
Lab Activity - 10. Configure and Run a Reclassification
-
Lab Activity - 11. Configure Currency Translation for Non- Historic Items
-
Lab Activity - 12. Configure Currency Translation for Historic and Income Related Items
-
Lab Activity - 13. Match and Reconcile Consolidation Units
-
Lab Activity - 14. Eliminate Intercompany Receivables and Payables
-
Lab Activity - 15. Eliminate Intercompany Revenue and Cost
-
Lab Activity - 16. Analyze Matrix Revenue and Cost Eliminations
-
Lab Activity - 17. Update Ownership Data
-
Lab Activity - 18. Run Consolidation of Investments
-
Lab Activity - 19. Configure and Run Balance Carryforward
-
Lab Activity - 20. Use Reporting Rules to Analyze Financial Data
-
Lab Activity - 21. Integrated Planning
Datasets
-
CI FS Item - Activity Based
-
CI FS Item
-
Consolidation Group Structure CG00A and CG00E
-
Consolidation Units U00
-
FS_Items 2020 U00
-
GL Account FS Item Mapping Map ID U00 Rev 1
-
Group Share 2019.12 U00 CG00A E W Upload File DE
-
Group Share 2019.12 U00 CG00A E W Upload File
-
Import Report Rule FS Item Based.csv
-
Import Report Rule.csv
-
Journals for TA00 2018.12
-
U00 Management Consolidation Unit Hier
-
U00 PC Line of Business Hier
-
Upload 2019.12 ALL CU U00 PPC TC LC.csv
Configuration Guides (Downloaded from the Internet as it is available for Public Use)
-
Configure Guide - business-consolidation-sem-bcs
-
Configure Guide - group-reporting-in SAP S 4 HANA
-
Configure Guide - group-reporting-s4
-
Configure Guide - sap-group-reporting-1909
-
Configure Guide - sap-group-reporting-and-consolidation_compress
-
Configure Guide - SAP-s 4 HANA-finance-for-group-reporting-2021-feature-deck_compress
Configuration Documents (Part 1)
-
1 - Configuration Guide - Running Data Monitor for SAP S4HANA Companies
-
2 - Configuration Guide - Checking Late Coming Data Posted in Previous Periods
-
3 - Configuration Guide - Checking Time Dependent Assignment FS Item Mappings
-
4 - Configuration Guide - Reviewing and Maintaining Consolidation Units
-
5 - Configuration Guide - Setting Up a Consolidation Group Structure and Performing Data Preparation for Initial Consolidation
-
6 - Configuration Guide - Performing the Consolidation Process for Initial Consolidation
-
7 - Configuration Guide - Performing Data Preparation for Full Consolidation
-
8 - Configuration Guide - Performing the Consolidation Process for Full Consolidation
-
9 - Configuration Guide - Setting Up a Consolidation Group Structure and Performing Data Preparation for Initial Consolidation (Actuals_Activity Based)
-
10 - Configuration Guide - Performing the Consolidation Process for Initial Consolidation (Actuals_Activity Based)
-
11 - Configuration Guide - Performing Data Preparation for Full Consolidation (Actuals_Activity Based)
-
12 - Configuration Guide - Performing the Consolidation Process for Full Consolidation (Actuals_Activity Based)
-
13 - Configuration Guide - Viewing Consolidated Balance Sheet Reports
-
14 - Configuration Guide - Viewing Consolidated P&L by Nature of Expense
-
15 - Configuration Guide - Generating Cash Flow Statements
-
16 - Configuration Guide - Configuring Consolidation Using Self Service UI
-
17 - Configuration Guide - Configuring Consolidation Using Organization Structure Creation
-
18 - Configuration Guide - Configuring Consolidation Using Master Data Configuration with Fiori UI
-
19 - Configuration Guide - Validating Configurations
Configuration Documents (Part 2)
Certification MCQs
Capstone Projects / Case Studies
-
Capstone Project - 1. Automated Budget Control and Oversight for Multi-Department Organizations
-
Capstone Project - 2. End-to-End Commitment Management and Funds Reservation Workflow
-
Capstone Project - 3. Grant and Funded Program Compliance Reporting
-
Capstone Project - 4. Public Sector Budget Execution and Performance Monitoring
-
Capstone Project - 5. Real-Time Fund Allocation and Reconciliation Across Multiple Legal Entities
Interview Questions
Sample Resumes
Prepare your Resume
Prepare your Linkedin profile
Final Quiz
