BW Consolidations Enterprise Backbone Project
BW Consolidations
BW Consolidations Enterprise Backbone Project
Consolidations Overview
BW content for SEM-BCS (EC-CS)
Implementation at Weyerhaeuser
BW Consolidations Enterprise Backbone Project
Consolidations Overview
Consolidated financial statements are created on the basis of financial
data reported by individual consolidation units.
The consolidation types are represented by dimensions.
For example, you can define one dimension for company
consolidations and, at the same time, another dimension for profit
center consolidations. Each dimension lets you process flexible and,
when needed.
consolidation functions you can use for external (statutory) rendering
of accounts as well as internal (management) reporting
BW Consolidations Enterprise Backbone Project
Consolidation type
An indicator that determines the types of organizational units that are
consolidated.
Feasible options are consolidations based on Companies, Business
areas, Profit centers, Divisions or Branches, or the objects of Internal cost
Accounting.
The one-to-one relationship between dimensions and consolidation types
is not mandatory.
If needed, you can portray several consolidation types within one
dimension
BW Consolidations Enterprise Backbone Project
Consolidation Unit (0cs_unit)
Smallest element in a corporate group structure that can be used as a
basis of complete consolidation.
A consolidation unit can be such things as a Company, Business areas
within a company, or Profit centers within a company.
What a consolidation unit is made up of depends on the consolidation
type for which you are using the consolidation units.
The consolidation unit depends on the dimension in which it was created.
BW Consolidations Enterprise Backbone Project
Consolidation Group (0cs_Group)
User-defined group of consolidation units created for consolidation and
reporting purposes.
The consolidation group depends on the dimension chosen for consolidation
We can use the consolidation group to represent the structure of the group.
Depending on the complexity of your group, you can:
Group the consolidation units into a consolidation group
Create multiple consolidation groups and arrange them into a hierarchy.
Create multiple hierarchies of consolidation groups in parallel to
structure the organizational units according to different perspectives.
A given consolidation unit can belong to different consolidation groups, and a
given consolidation group can belong to different hierarchies.
BW Consolidations Enterprise Backbone Project
Consolidation Chart of Accounts (0cs_Chart)
A systematic classification of financial statement items that serve a common
purpose.
The classification is marked by either corporate external and/or internal
requirements.
For instance, you could have one consolidation chart of accounts for the purpose
of generating financial statements to meet the requirements of statutory
authorities, and you could have another consolidation chart of accounts to
accommodate corporate- interna(l requirements for contribution margin
accounting.
Like the dimension, the consolidation chart of accounts is one of the foundations
in the architecture of consolidation.
The consolidation chart of accounts is not dependent dimension.
BW Consolidations Enterprise Backbone Project
Financial Statement Item (0cs_Item)
The fundamental account assignment of the Consolidation system.
It forms the basis for consolidation data entry, posting and reporting.
FS items are used for accounting purposes on balance sheets, income
statements or statements of retained earnings.
Financial statement items can be used in multiple consolidation charts
of accounts.
BW Consolidations Enterprise Backbone Project
Sub Item (0CS_SITEM)
A sub assignment of a financial statement item.
Sub items are used for further breakdowns of financial statement items.
The sub item is a further optional sub assignment in the Consolidation
system, in addition to partner unit, transaction currency, and year of
acquisition.
Sub items might be used to further classify FS items with transaction
types, product groups, division and so on.
Sub items can be classified using sub item categories.
BW Consolidations Enterprise Backbone Project
Sub Item Category (0CS_SITEMCT)
The sub item category allows you to classify your sub items.
A sub item category is assigned to each financial statement item.
we can define sub item categories for transaction types, product groups,
divisions, and so forth.
BW Consolidations Enterprise Backbone Project
Consolidation Version (0CS_VERSION)
Identifies a separate area in the consolidation database.
Versions make it possible to consolidate financial data according to
different criteria.
Manage and consolidate different categories of data separately, such as
actual data, budget data, forecast data, or long-term planning data.
Consolidation versions are Independent of dimensions
BW Consolidations Enterprise Backbone Project
Ledger (ZLEDGER)
Contains transaction figures and documents showing the changes in
the values and quantities resulting from accounting transactions.
The currency of the ledger determines the currency in which the
consolidation groups carried in the ledger report their financial data.
This is therefore the consolidation group currency.
If you want to consolidate in different currencies, you need a separate
ledger for each currency.
BW Consolidations Enterprise Backbone Project
Consolidations Overview
BW content for SEM-BCS (EC-CS)
Implementation at Weyerhaeuser
BW Consolidations Enterprise Backbone Project
SAP Delivered Std Business Content
Extractors:
1. 3EC_CS_1A Consolidations transaction data
2. 3EC_CS_1R Consolidations transaction data remote cube
Info Sources:
1. 0EC_CS_1 Consolidations transaction data
Info Cubes:
1. 0ECCS_C01 Consolidations transaction data Basic Cube
This cube of type basic cube will hold data for all the closed periods.
2. 0ECCS_C05 Consolidations transaction data Remote Cube
This cube of type remote cube will fetch consolidations transaction data at run
time for the open periods
3. 0ECCS_C06 Consolidations transaction data Multi cube
This cube of type multi cube will serve as reporting structure. The result set will
be union of the data from basic cube (0ECCS_C01) and remote cube
(0ECCS_C05). All the reports will be built off this cube.
BW Consolidations
BW Consolidations Enterprise Backbone Project
Data flow Diagram
BW Consolidations Enterprise Backbone Project
Consolidations Overview
BW content for SEM-BCS (EC-CS)
Implementation at Weyerhaeuser
BW Consolidations Enterprise Backbone Project
Implementation at Weyerhaeuser
EDW
Extraction Transformation and Loading
Reports
BW Consolidations Enterprise Backbone Project
EDW Layer at weyerhaeuser
BW Consolidations Enterprise Backbone Project
Few Consolidation Reports at weyerhaeuser
Balance Sheet - Balance Sheet
Cash Flow - Current Year vs Prior Year
Cost of Production - Current Year vs Prior Year - $/UOM
Labor Cost - Current Year vs Prior Year - $/UOM
Statement of Earnings - Current Year vs Prior Year - $/UOM
Cost of Production - Current Year vs Prior Year - $/UOM - Organization View
SG & A - Current Year vs Prior Year - % Sales
Cash Flow - Current Year vs Prior Year - Organization View
Analysis of Deferred Taxes
Analysis of Inventory
Analysis of Sales (per GAAP)
Analysis of Timber & Timberlands by Entity
Consolidation Unit Detail by FSI
Financial Statement Item by Cons Unit
PP&E Cost by Entity & Cons Unit - Entity
Sales (per GAAP) by Account
Sales (per GAAP) by Segment
Timber & Timberlands Summary by Cons Unit & Account
