SAP Business Planning and Consolidation(BPC440v10)



In this course, you will learn all of the key steps to set up consolidation based on the SAP Business Planning and Consolidation, version for SAP NetWeaver. You will learn consolidation-specific configuration and how to use the consolidation central tool. You will also learn how to use the data manager to execute currency translations, and perform eliminations for example. Additionally, you will be introduced to the EPM add-in for Excel.

This course is based on software release:

  • BPC 10.1 NW Standard Model SP5
  • SAP BW 7.4 SPS10
  • EPM add-in SP21
  • Design Studio 1.4
  • Analysis for Office 1.4.9


  • Application consultants
  • Business analysts
  • Business process owners / team leads / power users
  • Program / project managers

1. SAP Business Planning and Consolidation Overview

  • SAP Business Planning and Consolidation
  • the Rapid Deployment Solution Content for IFRS and US GAAP

2. Consolidation Structures

  • Configuring Environments and Dimensions
  • Creating Models for Consolidation
  • Creating Consolidation Logic
  • Creating a Report in the EPM Add-In Microsoft Excel Interface

3. Data Collection and Validation

  • Using input forms to input data
  • Using Account-Based Calculations for Reclassification
  • Using the Consolidation Module
  • Managing Journals
  • Converting Local Currency
  • Configuring Intercompany Matching
  • Using the Controls Monitor to Validate Data
  • Configuring Balance Carryforward

4. Consolidations and Eliminations

  • Consolidation and Elimination Principles
  • Using the Ownership Manager
  • Using Integration Rules
  • Eliminating Intercompany Transactions
  • Consolidating Using the Purchase Method
  • Consolidating Using the Equity Method
  • Configure US Elimination
  • Configuring Equity Pickup
  • Stage Consolidation

5. Consolidation Process Monitoring

  • Configuring Consolidation Business Process Flows
  • Work Status and Security