Skip to end of metadata
Go to start of metadata

Note: The following information is one page of a multi-page walkthrough entitled Introduction to BPC Consolidations for Non-Accountants.

A BPC Consolidation application requires both a Rate application, used to store currency exchange rates, and an Ownership application used to store the relationships between the parent holding company and its fully- and/or partially-owned subisidiary companies and/or partners.

The following tables show the minimally required dimensions for each of the three applications based on SAP's online help documentation for the BPC for Microsoft (MS)  product and for the BPC for NetWeaver (NW)  product.

Consolidation

Ownership

Rate

Account (A)

O_Account (A)

R_Account (A)

Category (C)

Category (C)

Category (C)

Entity (E)

Entity (E)

R_Entity (E)

Groups (R)

Groups (R)

InputCurrency (R)

Time (T)

Time (T)

Time (T)

InterCompany (I)

InterCompany (I)

 

DataSource (D)

 

 

Flow (S)

 

 


Create the required dimensions

Use the attached Microsoft Excel workbook to create these dimensions.  There are two worksheets for each dimension, one worksheet shows a screenshot of the required dimension properties and property sizes based on the same online help links above, and the other worksheet contains the master data for the dimension (the dimension members and property values for each member). 

 Create these 12 dimensions in your application set.

      Dimensions.xls

Create the required applications

Since the Rate and Ownership applications are dependencies for creating a Consolidation application, they must be created first.

 Create the Rate to application match the following screenshot:
       

 Create the Ownership application to match the following screenshot:
       

  Create the Consolidation application to match the following screenshot:
       


  • No labels
  1. Guest

    Hi, The rest of the links are not working. It gives an error saying that page under construction. I got really hooked on to this article and had also finished creating the dimensions in my sandbox. I am from a non-accounting background and working in my 1st Consolidation project. I really need this exercise. Please get the rest of the links up and running so that I and so many others like me can benefit out of this awesome article.

  2. The other links are missing the content. Can you update the links.