without the express permission of SAP AG. The information contained herein may be
changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary
software components of other software vendors.
All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business
ByDesign, and other SAP products and services mentioned herein as well as their respective
logos are trademarks or registered trademarks of SAP AG in Germany and other countries.
Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal
Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services
mentioned herein as well as their respective logos are trademarks or registered trademarks
of Business Objects S.A. in the United States and in other countries. Business Objects is an
SAP company.
All other product and service names mentioned are the trademarks of their respective
companies. Data contained in this document serves informational purposes only. National
product specifications may vary.
These materials are subject to change without notice. These materials are provided by SAP
AG and its affiliated companies ("SAP Group") for informational purposes only, without
representation or warranty of any kind, and SAP Group shall not be liable for errors or
omissions with respect to the materials. The only warranties for SAP Group products and
services are those that are set forth in the express warranty statements accompanying such
products and services, if any. Nothing herein should be construed as constituting an
additional warranty.
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide7
Contents
8SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Introduction
chapter
Introduction
1
What is a Rapid Mart?
What is a Rapid Mart?
SAP BusinessObjects Rapid Marts packages are blueprints for building data
marts with SAP BusinessObjects technology:
•Data Services
•Universe Designer
•Web Intelligence.
Rapid Marts packages deliver jump-start ETL (extract, transform & load)
mappings, schema, and initial reporting content, accelerating the deployment
of BI (business intelligence) for enterprise applications from SAP, PeopleSoft,
Oracle, and Siebel.
Each Rapid Mart is designed to address the reporting needs of a specific
business area (or department) like accounting, sales, or purchasing. A
component-based framework allows conducting analysis across these
selected business areas by combining different packages within the same
source application suite.
Rapid Marts focus on basic standard configuration of the enterprise
applications. They are country and industry neutral templates meant to be
easily modified and extended to suit customer specific application
implementation and reporting needs.
Rapid Marts incorporate best practices, and provide easily modifiable
templates. With Rapid Marts total development time of a data mart solution is
greatly reduced.
Each customer situation is different. You will probably encounter one or more
of these:
•Customizations you have made to SAP solutions the Rapid Mart does not
cover.
•Standard SAP solutions data fields important for your specific business,
but not included in the Rapid Mart templates.
•Optimization and performance challenges unique to your environment.
•Reporting requirements not covered within the Rapid Mart template
reports.
Rapid Marts are flexible templates that you can adjust to account for these
unique situations. It is expected that some customization and optimization will
be needed to suit your individual environment. Rapid Marts are not an out-ofthe-box solution.
10SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
BI tools and analytic tools can access Rapid Mart data through SQL queries.
Rapid Marts can be implemented individually, or in any combination, to form a
single platform that delivers the infrastructure for your company’s internal and
external information needs. They can also serve as a staging area for
enterprise analytic applications.
Rapid Marts provide your business with an accelerated time to value through
rapid BI deployments because you can implement them quickly and easily
customize them to meet specific analytic requirements.
Rapid Marts packages accelerate Time to Value
Rapid Marts are packaged data solutions that you can quickly deploy to
address specific areas of business analysis.
Available Rapid Marts packages for SAP solutions include:
Financial Suite:
•SAP BusinessObjects General Ledger Rapid Mart, version for SAP
solutions
•SAP BusinessObjects Accounts Payable Rapid Mart, version for SAP
solutions
•SAP BusinessObjects Accounts Receivable Rapid Mart, version for SAP
solutions
•SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions
Operational Suite:
•SAP BusinessObjects Inventory Rapid Mart, version for SAP solutions
•SAP BusinessObjects Purchasing Rapid Mart, version for SAP solutions
•SAP BusinessObjects Sales Rapid Mart, version for SAP solutions
Manufacturing Suite:
•SAP BusinessObjects Plant Maintenance Rapid Mart, version for SAP
solutions
•SAP BusinessObjects Production Planning Rapid Mart, version for SAP
solutions
•SAP BusinessObjects Project Systems Rapid Mart, version for SAP
solutions
Human Capital Management (HCM) Suite:
•SAP BusinessObjects Human Resources Rapid Mart, version for SAP
solutions
Introduction
What is a Rapid Mart?
1
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide11
Introduction
1
What is a Rapid Mart?
You can combine multiple Rapid Marts packages into a single environment to
build the foundation for your data warehouse or use them as a staging area
for business intelligence applications.
SAP BusinessObjects Rapid Marts packages architecture
Rapid Marts architecture is driven by SAP BusinessObjects technology.
Rapid Mart Architecture:
Rapid Marts packages include the following components:
12SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Introduction
What is a Rapid Mart?
•Data Movement Jobs - packaged source-to-target mappings and data
transformations. Each job is designed to perform initial and incremental
data movement;
•Data Model & Schema - set of dat a mart database objects designed with
dimensional data modeling approach. Rapid Marts packages for SAP
solutions has a single integrated data model. The schema are available
for Oracle, SQL Server IBM DB2, and Teradata;
•Semantic Layer (Universes) - SAP BusinessObjects metadata packages
for efficient query generation. There can be one or more universes per
Rapid Mart. Each universe is developed using Rapid Marts design
principles to ensure compatibility, code readability, and component reuse. In addition, there is one Master universe for development/
maintenance of multiple use objects (like Customer, Material, Currency,
etc.);
•Reports (Samples) - set of 15-20 Web Intelligence reports per Rapid
Mart. They represent answers to mostly asked business questions (for
example, in the SAP BusinessObjects Sales Rapid Mart, version for SAP
solutions - 'What is the monthly Revenue trend by Division for this
year?'). The reports are developed using Rapid Mart color/layout
templates. Reports are examples of Web Intelligence best practice
development (trends, listing, guided analysis, roll ups and downs, etc.).
1
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide13
Introduction
1
About this document
About this document
This document describes the SAP BusinessObjects Cost Center Rapid Mart,
version for SAP solutions. This document contains information for a variety of
users—information that helps you understand the use of the Rapid Mart, the
data in the Rapid Mart, the reports you can create with the Rapid Mart, and
how to use and update the Rapid Mart.
This document contains the following chapters:
•Chapter 2: Overview — Describes the business problems you can solve
and the types of analyses you can do with this Rapid Mart
•Chapter 3: Rapid Mart Subject Areas — Contains detailed information
about each componentized section in the Rapid Mart, including the
processes each section captures
•Chapter 4: Reports — Provides examples of reports you can produce
•Chapter 5: Universe — Describes SAP BusinessObjects Universe upon
which the reports are based
•Chapter 6: Installing the Rapid Mart — Contains the information you need
to install the Rapid Mart
•Chapter 7: Using the Rapid Mart — Describes how to execute the Rapid
Mart, including information about setting parameters and considerations
you need to make when customizing the Rapid Mart
•Chapter 8: Technical Implementation — Describes each componentized
section and the work flows that run to load that section
•Chapter 9: Documentation References — Information about where to find
related to the Rapid Mart technical documentation on Data Services and
BusinessObjects Enterprise
•Appendix A: Rapid Mart Data Schema — Contains a detailed list of the
tables and views in the Rapid Mart
14SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Overview
chapter
Overview
2
Overview
Overview
This chapter describes the business problems you can solve with the SAP
BusinessObjects Cost Center Rapid Mart, version for SAP solutions and the
types of analyses you can do with this Rapid Mart. The information in this
chapter is useful for those who want a business-level overview of the Rapid
Mart and its benefits.
This chapter includes the following topics:
•What you can do with this Rapid Mart
•Supported analyses
•Related Rapid Marts
•Fitting into the accounting process
•SAP BusinessObjects Cost Center Rapid Mart Schema
What you can do with this Rapid Mart
The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions
is designed to handle data from the controlling (CO) module of SAP solutions.
The Rapid Mart enables businesses to manage and monitor expenses and
meet internal accounting needs for users within management, marketing,
finance, accounting, sales, and manufacturing.
The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions
addresses these sub-modules of CO:
•Cost element accounting (CO-CEL)
•Cost center accounting (CO-OM-CCA)
•Overhead (or internal) order accounting (CO-OM-OOA)
•Profit Center Accounting from the Enterprise Controlling (EC) module.
The Rapid Mart simplifies the data organization in these areas, making it
easier to investigate, analyze, and report on accounting transactions and
balances. Specifically, the Rapid Mart accesses the SAP solutions master
data tables and transaction tables to create fact and dimension tables.
Like other Rapid Marts, the SAP BusinessObjects Cost Center Rapid Mart,
version for SAP solutions is made up of several componentized sections.
Each section supports a subject related to analysis of business expenses:
•Cost Transaction Section — Tracks actual primary and secondary cost
transactions for both internal and external costs at the line item level or
rolled up to any dimension.
16SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Overview
What you can do with this Rapid Mart
•Cost Summary Section — Tracks planned (budgeted) and actual cost
period balances (both vertically and horizontally) by organization
structure, cost object, fiscal period, and other dimensions.
In vertical format, the data is presented with one row per fiscal period. In
horizontal format, the data is presented with one row per fiscal year with
upto 16 fiscal periods represented on each row of data.
SAP solutions only presents the horizontal format. The vertical format is
achieved in the Rapid Mart ETL process with Data Services with
Hierarchy Flattening Transforms, and Pivot Transforms.
•Profit Center Accounting (EC-PCA) — Tracks planned and actual costs
and revenue by profit center, fiscal period, and other dimensions. This
section sources data from the EC-PCA Standard Ledger.
Profit Center Detail transactions are categorized as either “Actuals” or
“Planned” (Budget) transactions. SAP solutions segregates the data in
this manner by storing the “Actuals” and “Planned” transactions in
separate database tables. These tables are combined into a single fact
table within the Rapid Mart to facilitate budget variance reporting
Summarized Profit Center reporting is also possible. Again, the ETL
process ensures both Horizontal and Vertical representations of the data
are available, with up to 16 fiscal periods represented. In addition, precalculated rolling 16 period activity summary allows analysis of various
financial ratios.
Analysis across several dimensions and hierarchies is possible, including
organization structure, monetary currency, fiscal period, customer,
vendor, etc. The dimensions available with hierarchies available are:
Material (with Product Hierarchy), Cost Element, Activity, Profit Center,
Cost Center, Internal Order, Functional area, and GL Account.
Note: Profit Center Accounting, as implemented in the SAP
BusinessObjects Cost Center Rapid Mart, version for SAP solutions,
is for customers using SAP solutions “Classic” GL only.
You can use Profit Center Accounting as implemented in the SAP
BusinessObjects Cost Center Rapid Mart, version for SAP solutions
if
•you are running SAP solutions release older than ECC 5.0. or
•you have not implemented the “New” GL module introduced in
ECC 5.0
If you are using “New” GL, use the SAP BusinessObjects General
Ledger Rapid Mart, version for SAP solutions for Profit Center
Accounting which covers both the “Classic” and “New” versions. The
2
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide17
Overview
2
What you can do with this Rapid Mart
Additionally , the Rapid Mart provides a series of hierarchies that are available
to all sections. Hierarchies are a group of dimensions with flexible vertically
and horizontally flattened accounting structures (or sets) for:
•Activities
•Cost Center
•Cost Element
•Functional Area
•GL Accounts
•Internal Orders
•Project Elements
Each of these hierarchies is in turn linked to data from the sections (Cost
Summary, Cost Transaction, Profit Center Accounting).
Each of the cost hierarchies may contain records that are valid in SAP
solutions but invalid for the Rapid Mart. This occurs when a node in the
hierarchy is defined as both parent and child of itself. This result s in a circular
dependency that cannot be resolved by the Rapid Mart.
The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions
identifies these records and loads them into separate validation tables. This
allows you to correct the data in SAP solutions and then re-load the Rapid
Mart.
Chapter 3: Rapid Mart Subject Areas discusses each of these sections in
more detail and describes how to link them together to form a complete cost
analysis solution.
Profit Center Accounting module in the Cost Center Rapid Mart is the
“Classic” version shared with the SAP BusinessObjects General
Ledger Rapid Mart, version for SAP solutions.
18SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Overview
Supported analyses
Supported analyses
The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions
supports several types of analyses.
Business functionType of analysisMeasures available in the Rapid Mart
Cost Center AccountingCosts and allocations
Plan/Actual/Variance
Cost Element
Accounting
Costs incurred by type
Plan/Actual/Variance
•Drill down or roll up using cost center
hierarchies
•Transaction and summary information
(fixed and variable quantities, units of
measure, and values, in transaction,
cost center, and controlling area
currencies) for all cost centers within a
reporting period
•Cost allocation trends by period by
year
•Overview of costs incurred on a cost
center or cost center hierarchy, by
planned and actual values for a
reporting period
•Overview of costs incurred on a cost
center or cost center hierarchy, by
planned and actual values during a
fiscal year or other time horizon
•Analysis of cost planning efficiency
•Drill down or roll up using cost element
hierarchies
•Overview of costs for cost centers,
internal orders and activities, by fixed
and variable quantities, units of
measure, and amounts in various
currencies for a reporting period
•Analysis of costs incurred by planned
and actual values for a reporting
period
•Analysis of cost elements rolled up by
cost center or internal order, by
planned and actual values during a
fiscal year or other time horizon
2
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide19
Overview
2
Supported analyses
Business functionType of analysisMeasures available in the Rapid Mart
Project Element (WBS)
accounting
Costs incurred by type
•Drill down or roll up using Project
Element hierarchies.
•Overview of costs by project element,
by cost element, by fixed and variable
quantities, units of measure, and
amounts in various currencies for a
reporting period
Plan/Actual/Variance
•Analysis of costs incurred by planned
and actual values for a reporting
period
•Analysis of project elements rolled up
by cost element, by planned and
actual values during a fiscal year or
other time horizon
Internal (Overhead)
Orders
Costs and Allocations
•Drill down or roll up using internal
order hierarchies
•Transaction and summary information
(fixed and variable quantities, units of
measure, and values, in transaction,
cost object, and controlling area
currencies) for all cost centers within a
reporting period
Plan/Actual/Variance
•Overview of costs incurred on an order
or order hierarchy, by planned and
actual values for a reporting period
•Overview of costs incurred on an order
or order hierarchy, by planned and
actual values during a fiscal year or
other time horizon
20SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Overview
Supported analyses
Business functionType of analysisMeasures available in the Rapid Mart
Account Based
Profitability
•Plan/Actual/Variance using cost and
revenue elements.
•Return on investment analysis
•Comparison of revenues and imputed
costs by cost and revenue elements.
Profitability AnalysisCost Based
Profitability
•Plan/Actual/Variance for revenues by
profit center based on cost of sales
valuation approach.
•Drill up and down using profit center
hierarchies.
•Overhead cost trends analysis by
profit center.
Dimensions available to support these analyses
The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions
contains a number of dimension tables that use business intelligence tools to
facilitate analysis. The Rapid Mart extracts these tables from SAP solutions
master data and customizable tables. The tables include enterprise entities
(such as controlling area, business area, company code, vendor and material
data) and CO module data (such as activity, value type, controlling object and
internal order information). A complete list of dimensions is presented below:
2
DimensionComment
Activity & HierarchyHorizontal and Vertical hierarchies
Business Area
Chart of Accounts
Company Code
Controlling Area
Controlling Transaction
Cost Center & HierarchyHorizontal and Vertical hierarchies
Cost Element & HierarchyHorizontal and Vertical hierarchies
CurrencyMonetary Currency
Debit Credit Indicator
Financial Record Type
Financial Version
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide21
Overview
2
Supported analyses
DimensionComment
Fiscal Period
FISL LedgerSpecial Ledger Master Data (for
Profit Center Accounting)
Functional Area & HierarchyHorizontal and Vertical hierarchies
GL Account By Company
GL Account Master & Hierarchy
Internal Order & HierarchyHorizontal and Vertical hierarchies
Material & Product Hierarchy
Material By Plant
Object Class
Object Type
Plant
Project
Project Element & HierarchyHorizontal and Vertical hierarchies
Segment
Time Dimension
Transaction Type
Unit Of Measure
Vendor
22SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Related Rapid Marts
Components of the SAP BusinessObjects Cost Center Rapid Mart, version
for SAP solutions are related to other SAP BusinessObjects Rapid Mart
components. For example,
•Vendor and material components are included in the Purchasing SAP
BusinessObjects Purchasing Rapid Mart, version for SAP solutions and
the SAP BusinessObjects Inventory Rapid Mart, version for SAP
solutions.
•The internal orders in this Rapid Mart include the production planning
orders found in the SAP BusinessObjects Production Planning Rapid
Mart, version for SAP solutions.
•Profitability analysis from the revenue reported in the SAP
BusinessObjects Sales Rapid Mart, version for SAP solutions.
•Cost Based Profitability Analysis is a shared component with the SAP
BusinessObjects General Ledger Rapid Mart, version for SAP solutions.
The Cost Center Rapid Mart supports SAP solutions before release ECC
5.0 (for legacy purposes). However, the SAP BusinessObjects General
Ledger Rapid Mart, version for SAP solutions supports Profitability
Analysis from all SAP solutions releases starting with R/3 4.6.
Each of the sections listed in “What you can do with this Rapid Mart” on
page 16 is a component. Y ou can identify a component within a Dat a Services
job by a “C_” prefix before its name. For example, the component that
contains cost transactions and the associated reporting dimensions is named
C_CostTransaction_Section_SAP.
Overview
Related Rapid Marts
2
The same components can be used in multiple Rapid Marts. For example, a
component that extracts information about materials bought, produced, and
sold is needed for a Rapid Mart that supports sales analysis and also for a
Rapid Mart that supports inventory analysis. Work flows that extract star
schema “dimensions” are components. You can add a component to any
Rapid Mart using a simple import procedure.
A Data Services job can include multiple instances of a component. For
example, each section includes all the required dimension components.
Therefore, a job with several sections may include several instances of a
particular dimension component. Components are set to execute only once
within a job. This “execute once” feature ensures that shared components do
not cause duplicate data extraction from SAP solutions. For more information
about the “execute once” feature, see the Data Integrator/Data Services Designer Guide.
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide23
Overview
2
Fitting into the accounting process
Fitting into the accounting process
The SAP solutions Cost Accounting process consists of the following
elements:
•Personnel costs
•G/L expenses
•Asset depreciation
•Billing documents
•Sales orders
•Goods issues
•Purchase orders
You can combine the sections contained in the SAP BusinessObjects Cost
Center Rapid Mart, version for SAP solutions with the purchasing sections
from the Purchasing Rapid Mart, the sales order section from the Sales Rapid
Mart, the employee payroll section from the HR Rapid Mart, and the general
24SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Overview
Goods
Issues
Sales
Orders
Cost
Summary
Personnel
Costs
G/L Expenses
Asset
Depreciation
Billing
Documents
Purchasing
Cost
Center
Purchase
Orders
Sales
HR
Accounts
Payable
Accounts
Receivable
Cost
Transactions
Profit Center
Detail
Profit Center
Summary
Fitting into the accounting process
ledger information from the Accounts Payable and the Accounts Receivable
Rapid Marts to create a comprehensive view of costs incurred by your
enterprise.
2
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide25
Overview
2
SAP BusinessObjects Cost Center Rapid Mart Schema
SAP BusinessObjects Cost Center Rapid
Mart Schema
The following diagram shows an overview of the SAP BusinessObjects Cost
Center Rapid Mart, version for SAP solutions components and their
relationships. The central boxes contain the fact tables corresponding to
componentized sections; the smaller boxes indicate dimensional components
that may apply to multiple sections.
26SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Overview
SAP BusinessObjects Cost Center Rapid Mart Schema
Additionally, the Cost Center Rapid MartContains these Hierarchies, Stage,
and Auxiliary tables.
2
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide27
Overview
2
SAP BusinessObjects Cost Center Rapid Mart Schema
28SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
chapter
Rapid Mart Subject Areas
3
Overview
Overview
Each section in the SAP BusinessObjects Cost Center Rapid Mart, version
for SAP solutions pertains to a particular subject area. This chapter describes
each section and the processes each section captures.
The information in this chapter is useful for readers who use the Rapid Mart to
develop reporting solutions for SAP solutions Controlling module and need to
understand the data in the Rapid Mart and how it relates to SAP solutions.
This chapter discusses:
•Cost Analysis Basics
•Cost Transaction Section
•Cost Summary Section
•Profit Center Detail Section
•Profit Center Summary Section
•General Ledger Account Hierarchies
Cost Analysis Basics
The Cost Center Rapid Mart details and processes transactional, summary,
and master data obtained from cost accounting transactions, cost objects,
and other areas. These include:
•Cost Objects
•Cost Centers
•Internal Orders
•Project Elements
•Activities
•Financial Organization Structure
•Cost Elements
•Profit Centers
•Projects
•Vendors
•Vendors
•Accounting Hierarchies
Each of these areas is detailed on the following pages.
30SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Cost Objects
Cost Centers
Rapid Mart Subject Areas
Cost Analysis Basics
WIth Cost Objects, costs are identified according to how they are incurred.
They are not an accounting system as such, but rather a detailed recording of
data that forms the basis for cost accounting. They are used to post
accounting transactions that describe such configured entities as Activities,
Internal Orders, Cost Centers, an Project Elements.
Cost Objects are mutually exclusive. That is, each Controlling transaction can
refer to only one type of Cost Object. Thus, a transaction for an Internal
Order, cannot also refer to a Project Element.
SAP solutions ties the various Cost Objects together with Cost Elements (a
type of GL Account). Different types of Cost Objects will post to the same
Cost Element. Thus, the Cost Element is used to consolidate these
transactions. For more details see “Cost Elements” on page 35.
SAP solutions’s cost center accounting sub-module tracks where costs occur
in your company.
Cost centers can be defined in several ways. For example, you can define
each low-level organizational unit that has responsibility for managing costs
as a cost center. As these organizational units incur costs, such as payroll,
rent, and utilities, SAP solutions posts the costs to the unit’s cost center.
Cost centers can also be defined by functional requirement, allocation criteria,
activities or services provided, geographic location, or by area of
responsibility.
Initially, cost center transactions are posted by other parts of SAP solutions,
such as financial accounting (FI) or materials management (MM). An
assignment field in the transaction directs the costs to a cost center.
Depending on the type of cost center, some or all of a transaction’ s costs may
be assigned to other cost centers or controlling objects. For example, a
cafeteria provides internal services to other cost centers and might allocate its
operating costs to those cost centers.
SAP solutions can allocate costs when work is completed, when other
business events take place, or at the end of each accounting period. SAP
solutions can allocate costs based on specific measurements, such as
number of employees in a cost center or on the actual cost incurred.
In the Rapid Mart, cost elements are derived from the object number (Field
COEP.OBJNR) assignment on Cost Transactions.
When object number starts with “KS” or “KL”, positions 7 - 16 of the object
number are the cost element.
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide31
Rapid Mart Subject Areas
3
Cost Analysis Basics
Internal Orders
SAP solutions allows companies to track an internal order throughout its life
cycle, from creation through the planning and posting of actual costs, up to
final settlement.
SAP solutions uses internal orders to receive cost postings that track the
costs associated with a particular accounting entity—be it an event, a
transitional activity, or type of activity. By using internal orders, SAP solutions
enables and preserves detailed information regarding the types and amount
of costs that these accounting entities incur. At the end of each accounting
period, SAP solutions can use the settlement function to allocate the order
costs to the responsible cost center.
Internal orders can receive cost postings through various types of
transactions, and can also pass costs along to other objects in CO. When an
internal order receives a cost posting that adds to the cost balance it carries
(such as FI postings or goods issues from MM), SAP solutions considers the
transaction to be a debit posting to the order. When a transaction reduces the
costs on an order (such as settlement to receivers either internal or external
to CO), SAP solutions considers the transaction to be a credit posting to the
order.
In the Rapid Mart, Internal Orders are derived from the object number (Field
COEP.OBJNR) assignment on Cost Transactions.
When object number starts with “OR”, positions 3 - 14 of the object number
are the Internal Order Number.
Project Elements
You structure your project using Project Elements. They are also called
WBS (Work Breakdown Structure). They are a hierarchical outline of an
undertaking described in the project definition.
Project Elements form the basis for the organization and coordination of a
project. They organize project tasks into a hierarchy.
The Project Elements describe specific tasks or actions in the project to be
carried out within a specific time period.
They are the functional basis for planning steps in a project, including:
process planning, cost planning, scheduling, capacity planning or costing, as
well as project control.
They give you a clear picture of the project and facilitate the coordination and
implementation of the project. They allow you to effectively manage a project.
In SAP solutions, individual Project Elements are assigned to the Cost
Transactions. Actual Projects are not.
32SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Activities
Rapid Mart Subject Areas
Cost Analysis Basics
In the Rapid Mart, Project elements are derived from the object number (Field
COEP.OBJNR) assignment on Cost Transactions.
When object number starts with “PR”, positions 3 - 10 of the object number
are the project element. When object number starts with “OR” and partner object (Field COEP.PAROB1) starts with “PR”, positions 3 - 10 of the partner
object are the project element.
You can use the Activities to provide a business process oriented, crossfunctional view of overhead costs in addition to the traditional, locationoriented view provided by Cost Center Accounting. Activities thus enhance
the Cost Center Accounting.
An Activity allocates process quantities based on resource and process
drivers, allowing you to define cost allocation more exactly along the Value
Added Chain that is possible with overhead rates.
Likewise, an Activity enhances product costing by assigning the sources of
costs to their originating business processes. Cost center resources can
allocate to business processes based on their true utilization of activities.
In contrast to traditional overhead cost accounting, Activities give a fairer
assignment of the overhead costs to products, customers, distribution
channels, and other objects.
In the Rapid Mart, Activities are derived from the object number (Field
COEP.OBJNR) assignment on Cost Transactions.
When object number starts with “KL”, positions 17 - 22 of the object number
are the Activity ID. When object number starts with “KS” and partner object
(Field COEP.PAROB1) starts with “KL”, positions 17 - 22 of the partner object
are the Activity ID.
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide33
Rapid Mart Subject Areas
Compa ny
Code
Controlling
Are a
Profit
Center
Cost
Center
Business
Are a
Key:
Arrows indicate a “one to
many” relationship:
on e many
Example:
O ne C ont rolling Ar ea ca n
h av e m any Co mpany Co des
Chart
of A ccts
G en. Ldgr.
Accts
Fin
Fin. Mgmt
Area
3
Cost Analysis Basics
Financial Organization Structure
The Financial Organization Structure from SAP solutions that is covered by
the Rapid Mart is shown in the diagram below
:Functional Areas are another optional organization related classification of
cost accounting transactions. You can freely define these to categorize the
accounting transactions in addition to other organizational elements.
Some examples of Functional Areas are:
•Sales & Marketing
•Administration
•Manufacturing
•Direct Production Costs
•Research & Development
Functional Areas can be associated with:
•G/L accounts
•Cost Elements
•Cost Centers
34SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
•Activities
Cost Elements
SAP solutions’s cost element module classifies a transaction according to the
nature of the cost being posted to a given cost object (such as cost center or
internal order). Each cost element maps back to a general ledger account
specified in SAP solutions’s financial accounting (FI) module.
There are two types of cost elements:
•Primary — Directly incurred costs. Primary cost elements are those
•Secondary — Costs previously incurred and posted that are being
When SAP solutions posts an FI transaction that uses an expense account
with a primary cost element, it checks that there is a valid CO object
assignment—such as to a cost center or an internal order—for that line item.
SAP solutions does not post an expense in FI unless the expense is passed
as a cost to CO at the same time.
Because Cost Elements are a subset of GL Accounts, the Rapid Mart stores
the Cost Element ID’s as both GL Account ID’s and Cost Element ID’s. The
values are identical in both fields for any given row of data.
Both fields serve as foreign keys to two different dimensions: Cost Center and
GL Account. The Cost Center dimension contains SAP solutions Controlling
module data. The GL Account dimension contains SAP solutions General
Ledger module data.
Rapid Mart Subject Areas
Cost Analysis Basics
relevant to cost accounting in the SAP solutions CO. A general ledger
expense account in the FI module must contain the cost element before it
can be created in the CO.
reassigned to another cost object. Secondary cost elements are used
exclusively for certain types of internal CO transactions. These
transactions have no corresponding general ledger accounts or other
definition in FI.
3
Profit Centers
Profit Centers are organizational units in Accounting that reflect a
management-oriented structure of the organization for the purpose of internal
control. Operating results for profit centers can be analyzed using either the
cost-of-sales approach or the period accounting approach.
A profit center represents an organizational subunit that operates
independently on the market and bears responsibility for its own costs and
revenues. You organize your organization into profit centers by assigning the
master data of each profit-relevant objects (materials, cost centers, orders,
projects, sales orders, assets, cost objects, and profitability segments) to a
profit center
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide35
Rapid Mart Subject Areas
3
Cost Analysis Basics
Projects
By analyzing the fixed capital as well, you can expand your profit centers for
use as investment centers.
In the Rapid Mart, Profit Centers are only associated with the Profit Center
Subject areas.
In SAP solutions cost transactions can optionally be assigned to a project. A
project is a complex structure of tasks within a controlling area. It is used
to control and monitor the schedule, resources, capacities, cost,
revenues, and funds availability .
Projects are generally part of the internal processes of a company. To be
able to control all tasks in project execution, you need an organizational
form that is specific to the project and which is shared by all departments
involved. Before you can carry out a project in its entirety, the project
goals must be precisely described and the project activities to be carried
out must be structured. A clear, unambiguous project structure is the
basis for successful project planning, monitoring, and control.
A project is not directly assigned to a cost transaction in SAP solutions. Only
a Project Element is assigned directly. The Rapid Mart uses the Project
Element to look up the Project ID as a Project Element can be associated with
only one Project.
Vendors
Business partner to whom amounts are payable for goods delivered/ services
performed. Examples of such services/goods include:
•Goods acquired
•Business services received
•The transfer of a right
In the Rapid Mart, Vendors are derived on Cost T ransactions associated with
Purchase Orders.
When the reference order type on the cost transaction (field COEP.RBEST) is
“20” then the cost transaction is associated to a purchase order, and the
purchase order number is stored in the cost transaction (field COEP.EBELN).
We use this purchase order number to lookup the Vendor ID on table LIFNR
in SAP solutions.
36SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Additionally, if the Value Type is “04” (Actuals) on a cost transaction (field
COEP.WRTTP = '04'), and the Controlling transaction is a through-posting
from FI (field COBK.VRGNG = 'COIN'), we get the Vendor ID from the
associated Accounting Document (table BSEG).
Accounting Hierarchies
The Cost Center Rapid Mart has 6 hierarchy dimensions that report cost and
profit breakdowns in the same manner as SAP solutions. These hierarchies
are organized in both horizontal and vertical format. They are:
•Activity
•Cost Center
•Cost Element
•Functional Area
•Project Element
•Internal Orders
•General Ledger Accounts. (For more detail on the General Ledger
Account Hierarchies, see the section General Ledger Account
Hierarchies in this chapter)
•Profit Center
A hierarchy is an ordered series of related objects. An example of a hierarchy
is time, or “date”, which may group objects as Year, Quarter, and Month. You
can use drill up or down to perform multi dimensional analysis with a
hierarchy.
Horizontal hierarchies are organized so that all levels (or nodes) appear as
columns on a single row of data. Vertical hierarchies represent each level or
node with an individual row of data. For more details refer to chapter 5
(Universe) section on “Filters & Techniques” on page 190.
Rapid Mart Subject Areas
Cost Analysis Basics
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide37
Rapid Mart Subject Areas
3
Cost Transaction Section
Cost Transaction Section
The Cost Transaction Section (also called Cost Detail) extracts SAP solutions
data that allows cost transactions to be monitored and classified.
Cost transaction data can be used to track costs that have been incurred
(such as labor, postage or telephone costs), and to pinpoint where costs
occur within a company . Cost transaction data can also be used to track costs
associated with a particular accounting entity, such as a building project or a
marketing event. Cost transaction data allows viewing details of individual
accounting transactions such as transaction number, posting date, material,
vendor, transaction amount and quantity.
Rapid Mart Processing
Extracted cost transaction data is stored in the
COST_TRANSACTION_FACT table. The cost transaction section also
captures the following dimensional attributes, and their associated dimension
tables:
Attribute NameDimension Table(s)
Activity & HierarchyACTIVITY, ACTIVITY_HIER,
Business AreaBUSINESS_AREA
Chart of AcctsCHART_OF_ACCOUNTS
Company CodeCOMPANY_CODE
Controlling AreaCONTROLLING_AREA
Controlling TransactionCONTROLLING_TRANSACTION
Cost Center & HierarchyCOST_CENTER,
FUNCTIONAL_AREA_HIER_VR
GL Account By CompanyGL_ACCOUNT_BY_COMPANY
Internal Order & HierarchyINTERNAL_ORDER,
INTERNAL_ORDER_HIER,
INTERNAL_ORDER_HIER_BAD,
INTERNAL_ORDER_HIER_HZ,
INTERNAL_ORDER_HIER_VR
Material & Product HierarchyMATERIAL,
PRODUCT_HIERARCHY
Material By PlantMATERIAL_BY_PLANT
Object ClassOBJECT_CLASS
Object TypeOBJECT_TYPE
PlantPLANT
ProjectPROJECT
Project Element & HierarchyPROJECT_ELEMENT,
PROJECT_ELEMENT_HIER,
PROJECT_ELEMENT_HIER_BAD,
PROJECT_ELEMENT_HIER_HZ,
PROJECT_ELEMENT_HIER_VR
Time DimTIME_DIM
Unit Of MeasureUNIT_OF_MEASURE
VendorVENDOR
3
The Cost Transaction section extracts cost-related data from the SAP
solutions header and line item tables (tables COBK and COEP in SAP
solutions respectively).
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide39
Rapid Mart Subject Areas
3
Cost Transaction Section
Fact Table Fields
The Cost Transaction Detail table (COST_TRANSACTION_FACT) contains
the following measures:
Col. NameDescription
AMT_CTRL_AREACOEP-WKGBTR - Total Value in Controlling Area
Currency
AMT_FIXED_CTRL_AREACOEP-WKFBTR - Fixed Value in Controlling Area
Currency
AMT_FIXED_VAR_CTRL_AREA COEP-PAFBTR - Fixed Price Variance in Ctrl Area
Currency
AMT_OBJCOEP-WOGBTR - Total Value in Object Currency
AMT_TRXCOEP-WTGBTR -Total Value in Transaction Currency
AMT_VAR_CTRL_AREACOEP-PAGBTR - Total Price Variance in Ctrl Area
Currency
QTYCOEP-MEGBTR - Total Quantity
QTY_ENTEREDCOEP-MBGBTR - Total quantity entered
QTY_FIXEDCOEP-MEFBTR - Fixed Quantity
QTY_FIXED_ENTEREDCOEP-MBFBTR - Fixed quantity entered
40SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Data
The cost transaction section includes cost information at the transaction level.
The COST_TRANSACTION_FACT table stores these details. The
COST_TRANSACTION_FACT table and associated dimension tables are
organized as a star schema as shown below.
Rapid Mart Subject Areas
Cost Transaction Section
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide41
Rapid Mart Subject Areas
3
Cost Transaction Section
Additionally, the Cost Transaction section includes the following hierarchies
that are associated with the dimensions of the same name:
You can analyze transaction costs along several dimensions:
•By Activity and Activity Hierarchies
•By Cost Center and Cost Center Hierarchies
•By Cost Element (GL Account) and Cost Element Hierarchies
•By Fiscal Periods (Fiscal Year, Quarter, Month)
•By Internal Orders and Internal Order Hierarchies
•By Material and Product Hierarchies
•By Monetary Currencies
•By Object Type
•By Object Class
•By Financial Organization:
•Business Area
•Company Code
•Controlling Area
•Functional Area
•By Project Element and Project Element Hierarchies
42SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
Cost Transaction Section
•By Project
•By Time Dimension (posting and creation dates)
•By Business Transaction Type
•By Controlling Version
•By Value Type
•By Unit of Measure
•By Vendor
Using the cost transaction section, you can answer questions like:
•How much was spent on labor (or telephone, or insurance) last year, by
cost center?
•What were the company’s total costs for trade shows this year?
•Who are out top 10 vendors (amount spent) this year?
•What is the cost breakdown by Product Hierarchy for this month?
•Which Projects and Project Elements are costliest?
•Which projects are over budget?
•What is the breakdown of project over-runs by project element?
•Which Activities have the highest expenses?
•Are production orders (a type of internal orders) completed within
budgeted costs?
•Which vendors can supply this material at the lowest cost?
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide43
Rapid Mart Subject Areas
3
Cost Summary Section
Cost Summary Section
The cost summary section stores cost period totals (balances) by fiscal period
and year.
This is the main data source for financial reporting to view the company cost
trends and to perform multi-dimensional analysis. It is also used for various
financial ratios calculation when average or total of 12 rolling periods is
involved.
Cost summary data is organized both horizontally and vertically. Table
COST_SUMMARY_FACT_HZ stores the horizontal representation. Table
COST_SUMMARY_FACT_VR stores the vertical representation.
Rapid Mart Processing
The cost summary section captures the following dimensional attributes, and
their associated dimension tables:
Attribute NameTable Name(s)
Activity & HierarchyACTIVITY, ACTIVITY_HIER,
Business AreaBUSINESS_AREA
Chart of AccountsCHART_OF_ACCOUNTS
Company CodeCOMPANY_CODE
Controlling AreaCONTROLLING_AREA
Controlling TransactionCONTROLLING_TRANSACTION
Cost Center & HierarchyCOST_CENTER,
Cost Element & HierarchyCOST_ELEMENT,
Financial Record TypeFINANCIAL_RECORD_TYPE
Financial VersionFINANCIAL_VERSION
PROJECT_ELEMENT_HIER_VR
Unit of MeasureUNIT_OF_MEASURE
3
The cost summary section extracts cost-related data from the SAP solutions
summary tables for internal and external costs: table COSS for internal costs,
and table COSP for external costs.
Fact Table Fields
The Cost Summary tables (COST_SUMMARY_FACT_HZ &
COST_SUMMARY_FACT_VR) contain the following measures:
COST_SUMMARY_FACT_VR (Vertical Organization):
MeasuresDefinition
AMT_CR_CTRL_AREACost Summary Value in Controlling Area
Currency - Credit Value
AMT_CR_FIXED_CTRL_AREACost Summary Fixed Value in Controlling
Area Currency - Credit Value
AMT_CR_FIXED_YTD_CTRL_AREACost Summary Fixed Value Year-To-Date in
Controlling Area Currency - Credit Value
AMT_CR_FIXVAR_CTRL_AREACost Summary Fixed Variance in Controlling
Area Currency - Credit Value
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide45
AMT_DR_YTD_CTRL_AREACost Summary Value Year-To-Date in
Controlling Area Currency - Debit Value
46SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
Cost Summary Section
MeasuresDefinition
AMT_DR_YTD_OBJCost Summary Value Year-To-Date in Cost
Center (Object) Currency - Debit Value
AMT_DR_YTD_TRXCost Summary Value Year-To-Date in
Transaction Currency - Debit Value
AMT_FIXED_PER_ROLLNG_CTRL_AREACost Summary Fixed Rolling 16 Periods Tot al
in Controlling Area Currency
AMT_FIXVAR_PER_ROLLNG_CTRL_AREA Cost Summary Fixed Variance Rolling 16
Periods Total in Controlling Area Currency
AMT_PER_ROLLNG_CTRL_AREACost Summary Rolling 16 Periods Total in
Controlling Area Currency
AMT_PER_ROLLNG_OBJCost Summary Rolling 16 Periods Total in
Cost Center (Object) Currency
AMT_PER_ROLLNG_TRXCost Summary Rolling 16 Periods Total in
Transaction Area Currency
AMT_VAR_PER_ROLLNG_CTRL_AREACost Summary Price Variance Rolling 16
Periods Total in Controlling Area Currency
QTY_CRCost Summary Quantity - Credit Value
QTY_CR_FIXEDCost Summary Fixed Quantity - Credit Value
QTY_CR_FIXED_YTDCost Summary Fixed Quantity Year-To-Date -
Credit Value
QTY_CR_YTDCost Summary Quantity Y ear-To-Date - Credit
Value
QTY_DRCost Summary Quantity - Debit Value
QTY_DR_FIXEDCost Summary Fixed Quantity - Debit Value
QTY_DR_FIXED_YTDCost Summary Fixed Quantity Year-To-Date -
Debit Value
QTY_DR_YTDCost Summary Quantity Year-To-Date - Debit
Value
QTY_FIXED_PER_ROLLNGCost Summary Fixed Rolling 16 Periods
Quantity
QTY_PER_ROLLNGCost Summary Rolling 16 Periods Quantity
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide47
48SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Data
The COST_SUMMARY_FACT_HZ table has one row summarizing cost
information for each cost object for each fiscal year, with columns for quantity
and value totals for all fiscal periods in each row. There can be upto 16 fiscal
periods in the SAP solutions system: 12 regular periods and 4 special posting
periods used for adjustments.
COS_SUMMARY_F ACT_VR, has the same info rmation, bu t with one row for
each fiscal period, resulting in upto 16 times as many rows in the table.
The organization of the SAP solutions source tables (COSS and COSP)
follows the horizontal format. Therefore, COST_SUMMARY_FACT_HZ is
analogous to SAP solutions. Data Services uses the Pivot transform to create
the vertical format for COST_SUMMARY_FACT_VR.
Both the COST_SUMMARY_FACT_VR and COST_SUMMARY_FACT_HZ
tables contain a Transaction Type Flag (column name TRX_TYPE_ID). The
flag is set to “I” for Internal or “E” External. Data from SAP solutions table
COSS is flagged with “I” for Internal. Data from SAP solutions table COSP is
flagged with “E” for External.
Rapid Mart Subject Areas
Cost Summary Section
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide49
Rapid Mart Subject Areas
3
Cost Summary Section
The following diagram shows the tables in the cost summary section in Star
Schema Layout.
50SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
Cost Summary Section
Additionally, the Cost Summary Section includes the following hierarchies
which are associated to the dimension of the same name.
3
You can analyze summary costs along several dimensions:
•By Activity and Activity Hierarchies
•By Cost Center and Cost Center Hierarchies
•By Cost Element (GL Account) and Cost Element Hierarchies
•By Fiscal Periods (Fiscal Year, Quarter, Month)
•By Internal Orders and Internal Order Hierarchies
•By Monetary Currencies
•By Object Type
•By Object Class
•By Financial Organization:
•Business Area
•Company Code
•Controlling Area
•By Project Element and Project Element Hierarchies
•By Project
•By Business Transaction Type
•By Controlling Version
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide51
Rapid Mart Subject Areas
3
Cost Summary Section
•By Value Type
•By Unit of Measure
Using the cost summary section, you can answer questions like:
•“For which cost items is the company overall in variance?”
•“How much was spent on labor (or telephone, or insurance) last year,
versus how much was planned?”
•“Which cost centers are in variance for specific cost elements and which
activity types were involved?”
•“What are the planned versus actual costs for a specific cost center or
group of cost centers?”
•“What was the variance in planned versus actual costs for trade shows by
cost element?”
•“Which activities were responsible for the variance?”
•What is the variance between actual and planned (budget) amounts by
cost center hierarchy for this year?
•Have I been able to reduce costs (by cost element hierarchy) this year
compared to last?
•What are my cost trends for any rolling 12 month period?
52SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Profit Center Detail Section
Overview
The Profit Center Detail section obtains information from the EC-PCA Profit
Center Accounting Standard Ledger in SAP solutions. Profit Ce nter Summary
Section (discussed later in this chapter) is a part of the same Standard
Ledger.
SAP solutions divides the Profit Center Detail data into Actuals and Planned
(Budgeted) values. In Classic GL, these are stored in separate tables
(GLPCA and GLPCP respectively). The Rapid Mart assigns combines data
from both tables and assigns an Actual or Budget Flag to each row of profit
center data. Values are “A” for Actuals data, and “P” for Budget (or Planned)
data.
This section allows you to report profits and losses by profit center using
either period accounting or the cost-of-sales approach. It also lets you
analyze fixed capital and so-called “statistical key figures” (number of
employees, square meters, and so on) by profit center. Consequently, you
can calculate all the key figures commonly used in cost accounting (return on
investment, cash flow, sales per employee, and so on).
What is a Profit Center? A profit center is a management-oriented
organizational unit used for internal controlling purposes. Dividing your
company up into profit centers allows you to analyze areas of
responsibility and to delegate responsibility to decentralized units, thus
treating them as “companies within the company”.
Every profit center is assigned to the organizational unit Controlling area.
This assignment is necessary because Profit Center Accounting displays
values in G/L accounts. The profit centers in a controlling area are all
contained in a standard hierarchy for that controlling area.
The essential difference between a profit center and a business area is
that profit centers are used for internal control, while business areas are
more geared toward an external viewpoint.
The profit center differs from a cost center in that cost centers merely
represent the units in which capacity costs arise, whereas the person in
charge of the profit center is responsible for its balance of costs and
revenues.
Rapid Mart Subject Areas
Profit Center Detail Section
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide53
Rapid Mart Subject Areas
3
Profit Center Detail Section
Profit Center Detail data is organized horizontally and vertically. In horizontal
organization, a single row in the table represents an entire fiscal year’s worth
of data, with separate fields for monetary amounts in each fiscal period. In
vertical organization, a single row represents a single fiscal period. There is a
separate row for each fiscal period / fiscal year combination.
Profit Center Detail carries amounts in Transaction (Document) Currency,
Object (Profit Center) Currency, and Local (Company Code) Currency. It also
carries quantities in Base Unit of Measure.
Table PROFIT_CENTER_FACT_HZ stores the horizontal representation.
Table PROFIT_CENTER_FACT_VR stores the vertical representation.
Profit Center Detail allows to produce year trend reports with finer granularity
than the Profit Center Summary section.
Rapid Mart Processing
Extracted Profit Center Detail data are stored in the
PROFIT_CENTER_FACT_HZ and PROFIT_CENTER_FACT_VR tables and
their associated dimension tables.
Dimensions
This section includes the following dimensional attributes, and their
associated dimension tables:
AttributeDimension Table Name(s)
Activity & HierarchyACTIVITY, ACTIVITY_HIER,
ACTIVITY_HIER_BAD,
ACTIVITY_HIER_HZ,
ACTIVITY_HIER_VR
Business AreaBUSINESS_AREA
Chart of AccountsCHART_OF_ACCOUNTS
Company CodeCOMPANY_CODE
Controlling AreaCONTROLLING_AREA
Controlling VersionFINANCIAL_VERSION
Cost Center & HierarchyCOST_CENTER,
COST_CENTER_HIER,
COST_CENTER_HIER_BAD,
COST_CENTER_HIER_HZ,
COST_CENTER_HIER_VR
54SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
GL_ACCOUNT_MASTER
Internal Order & HierarchyINTERNAL_ORDER,
INTERNAL_ORDER_HIER,
INTERNAL_ORDER_HIER_BAD,
INTERNAL_ORDER_HIER_HZ,
INTERNAL_ORDER_HIER_VR
Material and Product HierarchyMATERIAL, PRODUCT_HIERARCHY
Monetary CurrencyCURRENCY
Plant (or Factory)PLANT
Profit Center & HierarchyPROFIT_CENTER,
PROFIT_CENTER_HIER,
PROFIT_CENTER_HIER_BAD,
PROFIT_CENTER_HIER_HZ,
PROFIT_CENTER_HIER_VR
Record TypeFINANCIAL_RECORD_TYPE
Segment (New GL only)SEGMENT
Special Ledger (Master Data)FISL_LEDGER
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide55
Rapid Mart Subject Areas
3
Profit Center Detail Section
Fact Table Fields
AttributeDimension Table Name(s)
Special Ledger Document TypeDOCUMENT_CATEGORY &
DOCUMENT_TYPE*
Special Ledger Group (New GL only) LEDGER_GROUP
Time DimensionTIME_DIM
Transaction TypeTRANSACTION_TYPE
Unit of MeasureUNIT_OF_MEASURE
Valuation AreaVALUATION_AREA
VendorVENDOR
* DOCUMENT_TYPE is the dimension table for both Special Ledger
Document Type and Financial Document Type.
Profit Center Details section extracts data from the transaction t ables for SAP
module Profit Center Accounting (EC-PCA). Table GLPCA is the Actuals
transactions. Table GLPCP is the Planned (or Budget) transactions.
The Profit Center Transaction tables (PROFIT_CENTER_FACT_HZ and
PROFIT_CENTER_FACT_VR) contain the following measures:
56SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Description
Currency
Center (Object) Currency
tion Currency
Amount For Fiscal Periods 1 - 16 -
Local Currency
Amount For Fiscal Periods 1 - 16 -
Profit Center (Object) Currency
Amount For Fiscal Periods 1 - 16 -
Transaction Currency
Rapid Mart Subject Areas
Profit Center Detail Section
3
PROFIT_CENTER_FACT_HZ Measure Column Name
QTY_PER_BEGINQuantity in Base Unit of Measure
QTY_PER01 - QTY_PER16Quantity in Base Unit of Measure For
PROFIT_CENTER_FACT_VR:
PROFIT_CENTER_FACT_VR Measure Column Name
AMT_TRXValue in Transaction (Document)
AMT_LOCValue in Local (Company Code) Cur-
AMT_PCNTRValue in Profit Center Currency
QTYQuantity in Base Unit of Measure
Description
Period Beginning Balance
Fiscal Periods 1 - 16
Description
Currency
rency
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide57
Rapid Mart Subject Areas
3
Profit Center Detail Section
Rapid Mart Data
The PROFIT_CENTER_FACT_HZ and PROFIT_CENTER_FACT_VR tables
are represented in the Star Schema below, along with their associated
hierarchy tables:
58SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
Profit Center Summary Section
You can analyze profit center transactions along several dimensions:
•By Cost Element (GL Account) and Cost Element Hierarchies
•By Fiscal Periods (Fiscal Year, Quarter, Month)
•By Internal Orders and Internal Order Hierarchies
•By Material and Product Hierarchies
•By Monetary Currencies
•By Financial Organization:
•Business Area
•Company Code
•Controlling Area
•Functional Area
•By Profit Center and Profit Center Hierarchies
•By General Ledger Account and Associated Hierarchies
•By Time Dimension (posting and creation dates)
•By Controlling Version
•By Unit of Measure
•By Vendor
•By Valuation Area
Using the profit center transactions section, you can answer questions like:
•Which Profit Centers bring in the most revenue this quarter?
•What are my weekly Actual vs. Planned costs (Variance) by Profit Center
hierarchy?
•Which are my top 10 transactions by fiscal year?
•Which materials are most profitable by profit center during the last
month?
•What are my profit center transactions by internal order hierarchy?
3
Profit Center Summary Section
Overview
The Profit Center Summary section obtains information from the EC-PCA
Profit Center Accounting Standard Ledger in SAP solutions. Profit Center
Detail Section (discussed earlier in this chapter) is a part of the same
Standard Ledger.
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide59
Rapid Mart Subject Areas
3
Profit Center Summary Section
Profit Center Summary data is stored in the GLPCT table. These are
summarized transaction for the EC-PCA Profit Center Accounting Standard
Ledger.
This section allows you to report profits and losses by profit center using
either period accounting or the cost-of-sales approach. It also lets you
analyze fixed capital and so-called “statistical key figures” (number of
employees, square meters, and so on) by profit center. Consequently, you
can calculate all the key figures commonly used in cost accounting (return on
investment, cash flow, sales per employee, and so on).
Profit Center Summary data is organized horizontally and vertically. In
horizontal organization, a single row in the table represents an entire fiscal
year’s worth of data, with separate fields for monetary amounts in each fiscal
period. In vertical organization, a single row represents a single fiscal period.
There is a separate row for each fiscal period / fiscal year combination.
Profit Center Summary carries amounts in Transaction (Document) Currency,
Object (Profit Center) Currency, and Local (Company Code) Currency. It also
carries quantities in Base Unit of Measure.
Table PROFIT_CENTER_SUMMARY_FACT_HZ stores this horizontal
representation. Table PROFIT_CENTER_SUMMARY_FACT_VR stores the
vertical representation.
Rapid Mart Processing
Extracted Profit Center Summary data are stored in the
PROFIT_CENTER_SUMMARY_FACT_HZ and
PROFIT_CENTER_SUMMARY_FACT_VR tables and their associated
dimension tables.
Dimensions
This section includes the following dimensional attributes, and their
associated dimension tables:
AttributeDimension Table Name(s)
Chart of AccountsCHART_OF_ACCOUNTS
Company CodeCOMPANY_CODE
Controlling AreaCONTROLLING_AREA
Controlling VersionFINANCIAL_VERSION
Fiscal Period (Vertical Table
only)
60SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
AMT_PER_ROLLING_LOCRolling 16 Periods Balance Local
AMT_PER_ROLLING_PCNTRRolling 16 Periods Balance Profit
AMT_PER_ROLLING_TRXRolling 16 Periods Balance Transac-
AMT_PTD_LOCPeriod-to-Date Amount Local Cur-
AMT_PTD_PCNTRPeriod-to-Date Amount Profit Center
AMT_PTD_TRXPeriod-to-Date Amount Profit Center
QTY_CRCredit Quantity this Fiscal Period
QTY_CR_YTDCredit Quantity Year-to-Date
Description
Center Currency
tion Currency
Currency
Center Currency
Transaction Currency
Currency
Center Currency
tion Currency
rency
ter Currency
tion Currency
Currency
Center Currency
tion Currency
rency
Currency
Currency
64SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
Profit Center Summary Section
3
PROFIT_CENTER_SUMMARY_
FACT_VR Measure Column Name
QTY_DRDebit Quantity this Fiscal Period
QTY_DR_YTDDebit Quantity Year-to-Date
QTY_PER_BEGINPeriod Beginning Quantity
QTY_PER_ROLLINGRolling 16 Periods Quantity
QTY_PTDPeriod-to-Date Quantity
Rapid Mart Data
The PROFIT_CENTER_SUMMARY_FACT_HZ and
PROFIT_CENTER_SUMMARY_FACT_VR are represented in the Star
Schema below along with associated hierarchy and stage tables.
Description
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide65
Rapid Mart Subject Areas
3
General Ledger Account Hierarchies
You can analyze profit center summary transactions along several
dimensions:
•By Fiscal Periods (Fiscal Year, Quarter, Month)
•By Monetary Currencies
•By Financial Organization:
•Company Code
•Controlling Area
•Functional Area
•By Profit Center and Profit Center Hierarchies
•By General Ledger Account and Associated Hierarchies
•By Segment (New GL only)
•By Cost Version
•By Unit of Measure
Using the profit center transactions section, you can answer questions like:
•Which Profit Centers bring in the most revenue for the last 5 years?
•How did my profit center perform this year versus last year?
•What is the revenue period trend for selected accounts within selected
Profit Centers or Profit Center groups?
•How does my income statement for this year compare to last year?
•How does the revenue trend look this year?
•How does budget compare to actuals by each profit center for this year
broken by fiscal periods?
•How did my profit center perform this year versus last year?
How does last year period trend compare to this year for each profit
center within the same group?
General Ledger Account Hierarchies
SAP solutions incorporates several hierarchies based on General Ledger
account as the lowest level (leaf) of the hierarchy. In the BusinessObjects
Cost Center Rapid Mart, we’ve combined these disparate sources into a
single master hierarchy that facilitates reporting by any of the included
hierarchies.
The hierarchies included are visible in two separate transactions in SAP
solutions
66SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
General Ledger Account Hierarchies
•Sets Hierarchies (Transaction GS03). Set hierarchies can be set up
with items other than a GL Account as the leaf level. For this reason, we
only include information for two of the Set Hierarchies in the Rapid Mart.
•GLT0-RACCT - The FI Standard Ledger GL Account Hierarchy
•GLPCT-RACCT - The EC-PCA Profit Center GL Account Hierarchy
Here is a screen shot of GS03 showing how this hierarchy is presented in
SAP solutions:
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide67
Rapid Mart Subject Areas
3
General Ledger Account Hierarchies
•Financial St atement s V ersion Hierarchies (Transaction FSE3). These
hierarchies are used to generate financial statements. Leaf levels are
always a GL Account. All of these hierarchies are included in the Rapid
Mart. Here is a screen shot of FSE3 showing how this hierarchy is
presented in SAP solutions:
This flexible master hierarchy allows you to report by alternative hierarchies
that may not be available in SAP.
Example: In SAP solutions the EC-PCA Profit Center Standard Ledger
allows reporting by the GLPCT-RACCT hierarchy, but not the GLT0-RACCT
hierarchy. In the Rapid Mart, you can report by either, or both.
You can use hierarchies as dimensions in your operational reports. You can
also report on the hierarchies by themselves to examine how your
organization is structured, and fine tune that organization.
68SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Reports
chapter
Reports
4
Overview
Overview
You can use the SAP BusinessObjects Cost Center Rapid Mart, version for
SAP solutions to perform adhoc analysis and produce many kinds of reports.
This chapter provides examples of reports you could generate using the Cost
Center Rapid Mart universes. The information in this chapter is useful for
those who design reporting solutions for Cost and Profitability analysis.
This chapter describes content of Web Intelligence (WEBI) reports shipped
with the and the Rapid Mart Reporting Content package and recommended
joins for each componentized section in the Rapid Mart, including:
•Cost Details
•Cost Summary
•Profit Center Details
•Profit Center Summary
•SAP Master Data Reports
Note that all report SQL is located in the Rapid Mart installation directory
under "\Sample\DDL".
Cost Details
Cost details (or cost accounting transactions) are extracted from SAP
solutions’s Controlling accounting module. You can use this information to
analyze incurred costs within each Controlling Area and/or Company Code by
Cost Elements and several cost objects, such as Cost Center, Activity,
Internal Order, Project Element.
Reports
Using the cost detail information, you can complete numerous analyses and
generate different reports including the following examples:
•Transaction Summary by Material
•Transaction Detail Listing
•Top 10 Vendor Cost Accounting Docs
70SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Transaction Summary by Material
View a Controlling Area transaction summary for each Vendor by Material.
The results are limited to a single Fiscal Year and Fiscal Period.This report
offers drill-down capability, by allowing the user to select a Material and open
the Transaction Detail Listing to review all cost details.
TRL_AREA_ID )
AND
(
FISC_PERIOD_CTRL_AREA.FISC_YEAR = 2000
AND
FISC_PERIOD_CTRL_AREA.FISC_PERIOD = 1
AND
FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID = '04'
AND
MATERIAL.MTRL_DESCR <> '?'
AND
CONTROLLING_AREA.CTRL_AREA_FULL_NAME = '1000 - CO Europe'
)
GROUP BY
FISC_PERIOD_CTRL_AREA.FISC_YEAR,
FISC_PERIOD_CTRL_AREA.FISC_PERIOD,
MATERIAL.MTRL_DESCR,
VENDOR.VENDOR_NAME_01,
CURRENCY_CTRL_AREA.CURR_ISO_CODE,
CONTROLLING_AREA.CTRL_AREA_ID,
COST_CENTER_HIER_HZ.LVL_00_ID,
CONTROLLING_AREA.CTRL_AREA_FULL_NAME
72SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Transaction Detail Listing
View detailed Controlling Area cost information for a selected Cost Center
Hierarchy and Material. The results are limited to a single Fiscal Year and
Fiscal Period.
Report SQL
All report SQL is located in the Rapid Mart installation directory under
"\Sample\DDL".
Top 10 Vendor Cost Accounting Docs
View the Top 10 Vendor Cost Accounting documents (for selected calendar
year and month); grouped by Controlling Area. This report uses the Web
Intelligence ranking feature to limit to the top 10 documents by Actual V alue in
Controlling Area Currency.
Reports
Cost Details
4
Report SQL
All report SQL is located in the Rapid Mart installation directory under
"\Sample\DDL".
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide73
Reports
4
Cost Details
Recommended Table Joins
To analyze Cost Details data you will need to create joins between the fact and
dimension tables as follows
Note: Additional joins between dimension and hierarchy tables are shown in
“Recommended table joins” on page 27 for master reports.
ST_ELEMENT_HIER_HZ.COST_ELEM_ID and
COST_TRANSACTION_FACT.CHART_OF_ACCT_I
D=COST_ELEMENT_HIER_HZ.CHART_OF_ACCT_
ID
D=COST_ELEMENT_HIER_VR.CHART_OF_ACCT_
ID and
COST_TRANSACTION_FACT.COST_ELEM_ID=CO
ST_ELEMENT_HIER_VR.CHILD_ID
COST_TRANSACTION_FACT.CURR_ID_OBJ
T.CURR_ID_CTRL_AREA
T.CURR_ID_TRX
ANSACTION_FACT.DR_CR_ID and
DEBIT_CREDIT_INDICATOR.DIM_SRC_ID = 'COST'
FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID =
COST_TRANSACTION_FACT.RECORD_TYPE_ID
and FINANCIAL_RECORD_TYPE.DIM_SRC_ID =
'COST'
FINANCIAL_VERSION.VERSION_ID =
COST_TRANSACTION_FACT.VERSION_ID and
FINANCIAL_VERSION.DIM_SRC_ID = 'COST'
PERIOD.FISC_PERIOD and
COST_TRANSACTION_FACT.FISC_YEAR=FISC_P
ERIOD.FISC_YEAR and
COST_TRANSACTION_FACT.FISC_YR_VARIANT_I
D_CTRL_AREA =
FISC_PERIOD.FISC_YR_VARIANT_ID
PERIOD.FISC_PERIOD and
COST_TRANSACTION_FACT.FISC_YEAR=FISC_P
ERIOD.FISC_YEAR and
COST_TRANSACTION_FACT.FISC_YR_VARIANT_I
D_CMPNY_CODE =
FISC_PERIOD.FISC_YR_VARIANT_ID
COST_TRANSACTION_FACT.CHART_OF_ACCT_I
D=GL_ACCOUNT_BY_COMPANY.CHART_OF_ACC
T_ID and
COST_TRANSACTION_FACT.GL_ACCT_ID=GL_AC
COUNT_BY_COMPANY.GL_ACCT_ID and
COST_TRANSACTION_FACT.CMPNY_CODE_ID=G
L_ACCOUNT_BY_COMPANY.CMPNY_CODE_ID
COST_TRANSACTION_FACT.INTERNAL_ORDER_I
D
COST_TRANSACTION_FACT.INTERNAL_ORDER_I
D =
INTERNAL_ORDER_HIER_HZ.INTERNAL_ORDER_
ID
76SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Cost Summary
The cost summary contains cost transaction balances by fiscal period. The
summary data is presented in horizontal format, where each period balance is
stored in a separate column (up to 16 periods), and in vertical format, where
there is an individual record for each fiscal period.
You can use this information to analyze planned versus actual costs and to
determine the variance within each Controlling Area and/or Company Code
by Cost Elements and several cost objects, such as Cost Center, Activity,
Internal Order, Project Element.
Reports
Using the cost summary information, you can complete numerous analyses
and generate different reports including the following examples:
•Cost Center Actual-Planned-Variance
•Cost Center Activities
•Cost Summary Trend by Cost Center
•Cost Summary Trend by Cost Element
•YTD Cost Drilldown by Activity and Cost Center
•Cost Summary Actuals Analysis
•Cost Summary Rolling 12 Periods vs. Period Comparison
Reports
Cost Summary
4
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide77
Reports
4
Cost Summary
Cost Center Actual-Planned-Variance
View Cost Center Actual/Planned/Variance and Top 10 Analysis for a
specified Fiscal Year and Fiscal Period range.
by Cost Element Summary
Analyze Cost Center Actual/Planned/Variance values for a Controlling Area
over a selected Fiscal Year and Fiscal Period range.
78SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Reports
Cost Summary
Top 10 Analysis
View basic Top 10 Analysis; including Top 10 Cost Centers by Actual Value
and Planning Efficiency Analysis (based on variance%).
Web Intelligence ranking
feature to limit to the top 10 Cost Centers.
This report uses the
4
Report SQL
SELECT DISTINCT
sum(case when FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID = '04' AND
FINANCIAL_VERSION.VERSION_ID = '000' THEN
COST_SUMMARY_FACT_VR.AMT_DR_CTRL_AREA-
COST_SUMMARY_FACT_VR.AMT_CR_CTRL_AREA else 0 end),
sum(case when FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID = '01' AND
FINANCIAL_VERSION.VERSION_ID = '000' THEN
N_ID and FINANCIAL_VERSION.DIM_SRC_ID = 'COST' )
AND
(
CONTROLLING_AREA.CTRL_AREA_ID = '1000'
AND
FISC_PERIOD_CTRL_AREA.FISC_YEAR = 2000
)
GROUP BY
FISC_PERIOD_CTRL_AREA.FISC_YEAR,
FISC_PERIOD_CTRL_AREA.FISC_QUARTER,
FISC_PERIOD_CTRL_AREA.FISC_PERIOD,
CURRENCY_CTRL_AREA.CURR_ISO_CODE,
COST_ELEMENT.COST_ELEM_FULL_NAME,
COST_CENTER.COST_CNTR_FULL_NAME
80SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Cost Center Activities
View Cost Center summary by Activity for a specified Controlling Area,
including Actual/Planned/Variance amounts by Activity.
Reports
Cost Summary
4
Top 10 Analysis
View Top 10 Cost centers according to highest Variance%. This report uses
the Web Intelligence ranking
on Variance%.
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide81
feature to limit to the Top 10 Cost Centers based
Reports
4
Cost Summary
Report SQL
All report SQL is located in the Rapid Mart installation directory under
"\Sample\DDL".
Cost Summary Trend by Cost Center
View Cost Center period trends for a selected fiscal year. View graphical
analysis of cost summary data to analyze cost center planning efficiency . This
report offers drill down capability in order to further analyze cost details in
Transaction Summary by Material.
by Actual Values
82SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Reports
Cost Summary
by Variance%
Cost Center Analysis
View overall Variance vs. Actual Value and Cost Center Actual Value Trends
by Fiscal Month.
4
Report SQL
All report SQL is located in the Rapid Mart installation directory under
"\Sample\DDL".
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide83
Reports
4
Cost Summary
Cost Summary Trend by Cost Element
View Cost Element period trends for a selected fiscal year. View graphical
analysis of cost summary data to analyze cost center planning efficiency.
by Actual Value
84SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Cost Summary
by Variance%
Cost Element Analysis
View overall Variance vs. Actual Value and Cost Elements Actual Value
Trends by Fiscal Month.
Reports
4
Report SQL
All report SQL is located in the Rapid Mart installation directory under
"\Sample\DDL".
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide85
Reports
4
Cost Summary
YTD Cost Drilldown by Activity and Cost Center
View YTD cost summary breakdown (for a specified Controlling Area) by
Activities or Cost Centers.
by Activity
86SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
by Cost Center
Reports
Cost Summary
4
Report SQL
All report SQL is located in the Rapid Mart installation directory under
"\Sample\DDL".
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide87
Reports
4
Cost Summary
Cost Summary Actuals Analysis
View Cost Summary actuals trend analysis by Controlling Area for the
selected Company Code, and Fiscal Year.
Actual Balance by Quarter
88SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Actual Balance by Period
Reports
Cost Summary
4
Report SQL
All report SQL is located in the Rapid Mart installation directory under
"\Sample\DDL".
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide89
Reports
4
Cost Summary
Cost Summary Rolling 12 Periods vs. Period Comparison
View Cost Rolling 12 periods versus Actual PTD Balances for the selected
Fiscal Years.
By Company
90SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
By Cost Center
Reports
Cost Summary
4
Report SQL
All report SQL is located in the Rapid Mart installation directory under
"\Sample\DDL".
Recommended Table Joins
To analyze Cost Summary data you will need to create joins between the fact and
dimension tables as follows
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide91
Reports
4
Cost Summary
Note: Additional joins between dimension and hierarchy tables are shown in
“Recommended table joins” on page 27 for master reports.
OST_SUMMARY_FACT_HZ.RECORD_TYPE_ID
and FINANCIAL_RECORD_TYPE.DIM_SRC_ID =
'COST'
FINANCIAL_VERSION.VERSION_ID=COST_SUMM
ARY_FACT_HZ.VERSION_ID and
FINANCIAL_VERSION.DIM_SRC_ID = 'COST'
GL_ACCOUNT_BY_COMPANY.CHART_OF_ACCT_I
D=COST_SUMMARY_FACT_HZ.CHART_OF_ACCT
_ID and
GL_ACCOUNT_BY_COMPANY.CMPNY_CODE_ID=
COST_SUMMARY_FACT_HZ.CMPNY_CODE_ID
and
GL_ACCOUNT_BY_COMPANY.GL_ACCT_ID=COST
_SUMMARY_FACT_HZ.COST_ELEM_ID
OST_SUMMARY_FACT_VR.RECORD_TYPE_ID
and FINANCIAL_RECORD_TYPE.DIM_SRC_ID =
'COST'
FINANCIAL_VERSION.VERSION_ID=COST_SUMM
ARY_FACT_VR.VERSION_ID and
FINANCIAL_VERSION.DIM_SRC_ID = 'COST'
PERIOD.FISC_PERIOD and
COST_SUMMARY_FACT_VR.FISC_YEAR=FISC_P
ERIOD.FISC_YEAR and
COST_SUMMARY_FACT_VR.FISC_YR_VARIANT_I
D_CTRL_AREA =
FISC_PERIOD.FISC_YR_VARIANT_ID
PERIOD.FISC_PERIOD and
COST_SUMMARY_FACT_VR.FISC_YEAR=FISC_P
ERIOD.FISC_YEAR and
COST_SUMMARY_FACT_VR.FISC_YR_VARIANT_I
D_CMPNY_CODE =
FISC_PERIOD.FISC_YR_VARIANT_ID
GL_ACCOUNT_BY_COMPANY.CHART_OF_ACCT_I
D=COST_SUMMARY_FACT_VR.CHART_OF_ACCT
_ID and
GL_ACCOUNT_BY_COMPANY.CMPNY_CODE_ID=
COST_SUMMARY_FACT_VR.CMPNY_CODE_ID
and
GL_ACCOUNT_BY_COMPANY.GL_ACCT_ID=COST
_SUMMARY_FACT_VR.COST_ELEM_ID
96SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Profit Center Details
The Profit Center Detail section obtains information from the EC-PCA Profit
Center Accounting Standard Ledger in SAP ERP and R/3. Profit Center
Details contain actual and planned (or budget) transactions for profit centers.
You can use this information to analyze profit center performance and trends
within each Controlling Area and/or Company Code by Cost Elements, Cost
Centers, Profit Centers, and other accounting transaction attributes.
Profit Center Detail data is organized horizontally and vertically.
Profit Center Details - Horizontal
In horizontal organization, a single row in the table represents an entire fiscal
year’s worth of data, with separate fields for monetary amounts in each fiscal
period.
Reports
Using the profit center detail horizontal information, you can complete
numerous analyses. A single report, Profit Center Detail Trend Analysis, is
included as an example of how to use this horizontal summary data.
Reports
Profit Center Details
4
Profit Center Detail Trend Analysis
Analyze Profit Center detail statistics for selected Fiscal Years and Local
Currency. Results displayed by Customer Geography and Profit Center.
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide97
Reports
4
Profit Center Details
Calculations
All Average Debit amounts are calculated as:
•Avg Debit Amt 01 = [PC DTL Hz Line Debit Amt Period 01 LOC]/[PC DTL
Hz Document Count Period 01]
Report SQL
SELECT DISTINCT
COMPANY_CODE.CMPNY_CODE_NAME,
PROFIT_CENTER_FACT_HZ.FISC_YEAR,
PROFIT_CENTER.DEPARTMENT,
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER_BEGIN_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER_BEGIN_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER01_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER01_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER02_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER02_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER03_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER03_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER04_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER04_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER05_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER06_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER06_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER07_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER07_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER08_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER08_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER09_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER09_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER10_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER10_LOC else 0 end),
98SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Reports
Profit Center Details
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER11_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER11_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then
PROFIT_CENTER_FACT_HZ.AMT_PER12_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER12_LOC else 0 end),
SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then
PROFIT_CENTER_FACT_HZ.AMT_PER05_LOC else 0 end),
PROFIT_CENTER_F ACT_HZ.CURR_ID_LOC,
CUSTOMER.COUNTRY_NAME,
CUSTOMER.REGION_NAME,
CUSTOMER.CITY,
PROFIT_CENTER.PROFIT_CNTR_FULL_NAME,
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER01_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER02_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER03_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER04_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER05_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER06_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER07_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER08_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER09_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER10_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER11_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER12_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER13_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER14_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER15_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER16_TRX !=
0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end),
CUSTOMER.CUSTOMER_FULL_NAME
FROM
COMPANY_CODE,
PROFIT_CENTER_F ACT_HZ,
PROFIT_CENTER,
CUSTOMER
WHERE
( COMPANY_CODE.CMPNY_CODE_ID =
PROFIT_CENTER_FACT_HZ.CMPNY_CODE_ID )
4
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide99
Reports
4
Profit Center Details
AND (
PROFIT_CENTER_FACT_HZ.PROFIT_CNTR_ID=PROFIT_CENTER.PROFIT_
CNTR_ID and
PROFIT_CENTER_FACT_HZ.CTRL_AREA_ID=PROFIT_CENTER.CTRL_ARE
A_ID )
AND (
PROFIT_CENTER_FACT_HZ.CUSTOMER_ID=CUSTOMER.CUSTOMER_ID )
AND
(
( PROFIT_CENTER_FACT_HZ.RECORD_TYPE_ID='0' )
AND
PROFIT_CENTER_FACT_HZ.FISC_YEAR In @prompt('Fiscal Year(s):','N','Prof
Id',Mono,Free,Persistent,,User:1)
)
GROUP BY
COMPANY_CODE.CMPNY_CODE_NAME,
PROFIT_CENTER_FACT_HZ.FISC_YEAR,
PROFIT_CENTER.DEPARTMENT,
PROFIT_CENTER_FACT_HZ.CURR_ID_LOC,
CUSTOMER.COUNTRY_NAME,
CUSTOMER.REGION_NAME,
CUSTOMER.CITY,
PROFIT_CENTER.PROFIT_CNTR_FULL_NAME,
CUSTOMER.CUSTOMER_FULL_NAME
Profit Center Details - Vertical
In vertical organization, a single row represents a single fiscal period. There is
a separate row for each fiscal period / fiscal year combination.
Reports
Using the profit center detail vertical information, you can complete numerous
analyses and generate different reports including the following examples:
•Profit Center Trend Activity Analysis
•Top 10 Profit Centers Actual/Planned/Variance
•Profit Center Listing
Profit Center Trend Activity Analysis
View Profit Center period activity trends and Top 10 Analysis for a selected
Profit Center hierarchy and Controlling Area during the desired fiscal year and
period range.
This report contains two tabs; Profit Center Trend and Top 10 Analysis.
100SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Loading...
+ hidden pages
You need points to download manuals.
1 point = 1 manual.
You can buy points or you can get point for every manual you upload.