SAP BusinessObjects Cost Center Rapid 3.2 User Manual

SAP BusinessObjects Cost Center Rapid Mart XI 3.2, version for SAP solutions ­User Guide
Version 12.2.2.0
October 2009
Copyright
Trademarks
© Copyright 2009 SAP AG. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose
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.

Contents

Chapter 1 Introduction 9
What is a Rapid Mart? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Rapid Marts packages accelerate Time to Value . . . . . . . . . . . . . . . . 11
SAP BusinessObjects Rapid Marts packages architecture . . . . . . . . . 12
About this document . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Chapter 2 Overview 15
What you can do with this Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Supported analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Dimensions available to support these analyses . . . . . . . . . . . . . . . . . 21
Related Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Fitting into the accounting process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
SAP BusinessObjects Cost Center Rapid Mart Schema . . . . . . . . . . . . . . 26
Chapter 3 Rapid Mart Subject Areas 29
Cost Analysis Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
Cost Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
Financial Organization Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Cost Elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Profit Centers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Vendors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
Accounting Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
Cost Transaction Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
Cost Summary Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 3
Contents
Profit Center Detail Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53
Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .54
Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
Profit Center Summary Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .59
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .59
Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .60
Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
General Ledger Account Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . .66
Chapter 4 Reports 69
Cost Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70
Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70
Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74
Cost Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .77
Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .77
Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91
Profit Center Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .97
Profit Center Details - Horizontal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .97
Profit Center Details - Vertical . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .100
Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103
Profit Center Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .110
Profit Center Summary - Horizontal . . . . . . . . . . . . . . . . . . . . . . . . . .111
Profit Center Summary - Vertical . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113
Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123
SAP Master Data Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128
Data Discovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .128
Data Auditing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .141
Recommended table joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .142
Chapter 5 Universe 147
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148
Universe Design Principles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .148
4 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Contents
Universe Terminology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149
Universe Table Layout . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151
Join Strategy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151
Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153
Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153
Hierarchies Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153
Geographic Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155
Time Dimension and Fiscal Period Hierarchies . . . . . . . . . . . . . . . . . 155
Material Product Hierarchy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155
Horizontal & Vertical Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156
Hierarchy Filters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162
Cost Center Specific Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167
Cost Center Universe . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167
Universe Objects & Classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168
Common Dimensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170
Cost Details Subject Area . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178
Cost Summary Subject Area . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181
Invalid Cost Center Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 190
Filters & Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 190
Universe Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191
SAP Profit Center Universe . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 192
Universe Objects & Classes - Profit Center . . . . . . . . . . . . . . . . . . . . 193
Common Dimensions - Profit Center . . . . . . . . . . . . . . . . . . . . . . . . . 195
Profit Center Detail Subject Area . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204
Profit Center Summary Subject Area . . . . . . . . . . . . . . . . . . . . . . . . . 208
Income Statement Setup Subject Area . . . . . . . . . . . . . . . . . . . . . . . 215
Universe Filters - Profit Center . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 217
Universe Validation - Profit Center . . . . . . . . . . . . . . . . . . . . . . . . . . . 218
Universe Objects & Classes - Master Data . . . . . . . . . . . . . . . . . . . . 220
Universe Validation - Master Data . . . . . . . . . . . . . . . . . . . . . . . . . . . 255
Chapter 6 Installing the Rapid Mart 259
Preparing Data Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 5
Contents
Preparing Target Database Environment . . . . . . . . . . . . . . . . . . . . . .265
Preparing Source Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .266
Preparing BusinessObjects Enterprise . . . . . . . . . . . . . . . . . . . . . . . . 266
Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .266
Create Target Schema . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .269
Renaming the Data Stores . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .272
Import ATL File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .274
Adjusting the Data Stores . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 276
Using Auxiliary Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .283
Using ABAP Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .284
Final Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .288
Import Wizard for Reporting Content BIAR File . . . . . . . . . . . . . . . . .290
Creating Universe Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .306
Additional Post-Installation Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . .308
Chapter 7 Using the Rapid Mart 311
Recovery framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 312
Data Services automatic recovery feature . . . . . . . . . . . . . . . . . . . . .312
Rapid Mart recovery framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313
Execution status framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .314
The execution status table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .314
The execution status API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .315
Executing a job with the Reset option . . . . . . . . . . . . . . . . . . . . . . . . . 316
Extraction, transformation and loading process . . . . . . . . . . . . . . . . . . . .316
Global Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .318
Global Variable Cross-Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . 318
Used in All Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .322
Used in 2 to 10 Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .325
Used in Only 1 Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331
Setting Global Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .345
Executing the job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .349
Initial (First) Extraction and Load . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349
Incremental (Delta) Extraction and Load . . . . . . . . . . . . . . . . . . . . . . .350
6 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Contents
Customizing the Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 351
Performance Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353
Customizations for the Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . 354
Chapter 8 Technical Implementation 359
Cost Transactions Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 360
Dimension table load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 360
Initial or incremental load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 364
Cost Summary Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365
Dimensional table load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365
Initial or incremental load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 368
Profit Center Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 368
Dimension table load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 369
Fact table load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373
Optimization Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 388
Table Partitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 388
Data Transfer Transform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 390
Hierarchy Optimizations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 391
Dealing with NULL values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 394
Fact Table Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 395
Fiscal Periods & Time Dim Load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 396
Chapter 9 Documentation References 399
Data Services Documentation References . . . . . . . . . . . . . . . . . . . . . . . 400
BusinessObjects Enterprise Documentation References . . . . . . . . . . . . 400
Appendix A Rapid Mart Data Schema 403
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 7
Contents
8 SAP 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-of­the-box solution.
10 SAP 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 Guide 11
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:
12 SAP 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 re­use. 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 Guide 13
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
14 SAP 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.
16 SAP 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, pre­calculated 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 Guide 17
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.
18 SAP 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 function Type of analysis Measures available in the Rapid Mart
Cost Center Accounting Costs 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 Guide 19
Overview
2
Supported analyses
Business function Type of analysis Measures 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
20 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Overview
Supported analyses
Business function Type of analysis Measures 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 Analysis Cost 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
Dimension Comment
Activity & Hierarchy Horizontal and Vertical hierarchies Business Area Chart of Accounts Company Code Controlling Area Controlling Transaction Cost Center & Hierarchy Horizontal and Vertical hierarchies Cost Element & Hierarchy Horizontal and Vertical hierarchies Currency Monetary Currency Debit Credit Indicator Financial Record Type Financial Version
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 21
Overview
2
Supported analyses
Dimension Comment
Fiscal Period FISL Ledger Special Ledger Master Data (for
Profit Center Accounting) Functional Area & Hierarchy Horizontal and Vertical hierarchies GL Account By Company GL Account Master & Hierarchy Internal Order & Hierarchy Horizontal and Vertical hierarchies Material & Product Hierarchy Material By Plant Object Class Object Type Plant Project Project Element & Hierarchy Horizontal and Vertical hierarchies Segment Time Dimension Transaction Type Unit Of Measure Vendor
22 SAP 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 Guide 23
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
24 SAP 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 Guide 25
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.
26 SAP 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 Guide 27
Overview
2
SAP BusinessObjects Cost Center Rapid Mart Schema
28 SAP 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.
30 SAP 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 Guide 31
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.
32 SAP 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, cross­functional view of overhead costs in addition to the traditional, location­oriented 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 Guide 33
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
34 SAP 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 Guide 35
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.
36 SAP 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 Guide 37
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 Name Dimension Table(s)
Activity & Hierarchy ACTIVITY, ACTIVITY_HIER,
Business Area BUSINESS_AREA Chart of Accts CHART_OF_ACCOUNTS Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Controlling Transaction CONTROLLING_TRANSACTION Cost Center & Hierarchy COST_CENTER,
Cost Element & Hierarchy COST_ELEMENT,
Monetary Currency CURRENCY
ACTIVITY_HIER_BAD, ACTIVITY_HIER_HZ, ACTIVITY_HIER_VR
COST_CENTER_HIER, COST_CENTER_HIER_BAD, COST_CENTER_HIER_HZ, COST_CENTER_HIER_VR
COST_ELEMENT_HIER, COST_ELEMENT_HIER_BAD, COST_ELEMENT_HIER_HZ, COST_ELEMENT_HIER_VR
38 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
Cost Transaction Section
Attribute Name Dimension Table(s)
Debit Credit Indicator DEBIT_CREDIT_INDICATOR Financial Record Type FINANCIAL_RECORD_TYPE Financial Version FINANCIAL_VERSION Fiscal Period FISC_PERIOD,
FISC_PERIOD_STAGE
Functional Area & Hierarchy FUNCTIONAL_AREA,
FUNCTIONAL_AREA_HIER, FUNCTIONAL_AREA_HIER_BAD, FUNCTIONAL_AREA_HIER_HZ,
FUNCTIONAL_AREA_HIER_VR GL Account By Company GL_ACCOUNT_BY_COMPANY Internal Order & Hierarchy INTERNAL_ORDER,
INTERNAL_ORDER_HIER,
INTERNAL_ORDER_HIER_BAD,
INTERNAL_ORDER_HIER_HZ,
INTERNAL_ORDER_HIER_VR Material & Product Hierarchy MATERIAL,
PRODUCT_HIERARCHY Material By Plant MATERIAL_BY_PLANT Object Class OBJECT_CLASS Object Type OBJECT_TYPE Plant PLANT Project PROJECT Project Element & Hierarchy PROJECT_ELEMENT,
PROJECT_ELEMENT_HIER,
PROJECT_ELEMENT_HIER_BAD,
PROJECT_ELEMENT_HIER_HZ,
PROJECT_ELEMENT_HIER_VR Time Dim TIME_DIM Unit Of Measure UNIT_OF_MEASURE Vendor VENDOR
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 Guide 39
Rapid Mart Subject Areas
3
Cost Transaction Section
Fact Table Fields
The Cost Transaction Detail table (COST_TRANSACTION_FACT) contains the following measures:
Col. Name Description
AMT_CTRL_AREA COEP-WKGBTR - Total Value in Controlling Area
Currency
AMT_FIXED_CTRL_AREA COEP-WKFBTR - Fixed Value in Controlling Area
Currency
AMT_FIXED_VAR_CTRL_AREA COEP-PAFBTR - Fixed Price Variance in Ctrl Area
Currency AMT_OBJ COEP-WOGBTR - Total Value in Object Currency AMT_TRX COEP-WTGBTR -Total Value in Transaction Currency AMT_VAR_CTRL_AREA COEP-PAGBTR - Total Price Variance in Ctrl Area
Currency QTY COEP-MEGBTR - Total Quantity QTY_ENTERED COEP-MBGBTR - Total quantity entered QTY_FIXED COEP-MEFBTR - Fixed Quantity QTY_FIXED_ENTERED COEP-MBFBTR - Fixed quantity entered
40 SAP 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 Guide 41
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
42 SAP 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 Guide 43
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 Name Table Name(s)
Activity & Hierarchy ACTIVITY, ACTIVITY_HIER,
Business Area BUSINESS_AREA Chart of Accounts CHART_OF_ACCOUNTS Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Controlling Transaction CONTROLLING_TRANSACTION Cost Center & Hierarchy COST_CENTER,
Cost Element & Hierarchy COST_ELEMENT,
Financial Record Type FINANCIAL_RECORD_TYPE Financial Version FINANCIAL_VERSION
ACTIVITY_HIER_BAD, ACTIVITY_HIER_HZ, ACTIVITY_HIER_VR
COST_CENTER_HIER, COST_CENTER_HIER_BAD, COST_CENTER_HIER_HZ, COST_CENTER_HIER_VR
COST_ELEMENT_HIER, COST_ELEMENT_HIER_BAD, COST_ELEMENT_HIER_HZ, COST_ELEMENT_HIER_VR
44 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
Cost Summary Section
Attribute Name Ta ble Name(s)
Fiscal Period FISC_PERIOD,
FISC_PERIOD_STAGE GL Account By Company GL_ACCOUNT_BY_COMPANY Internal Order & Hierarchy INTERNAL_ORDER,
INTERNAL_ORDER_HIER,
INTERNAL_ORDER_HIER_BAD,
INTERNAL_ORDER_HIER_HZ,
INTERNAL_ORDER_HIER_VR Monetary Currency CURRENCY Object Class OBJECT_CLASS Object Type OBJECT_TYPE Project PROJECT Project Element & Hierarchy PROJECT_ELEMENT,
PROJECT_ELEMENT_HIER,
PROJECT_ELEMENT_HIER_BAD,
PROJECT_ELEMENT_HIER_HZ,
PROJECT_ELEMENT_HIER_VR Unit of Measure UNIT_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):
Measures Definition
AMT_CR_CTRL_AREA Cost Summary Value in Controlling Area
Currency - Credit Value
AMT_CR_FIXED_CTRL_AREA Cost Summary Fixed Value in Controlling
Area Currency - Credit Value
AMT_CR_FIXED_YTD_CTRL_AREA Cost Summary Fixed Value Year-To-Date in
Controlling Area Currency - Credit Value
AMT_CR_FIXVAR_CTRL_AREA Cost Summary Fixed Variance in Controlling
Area Currency - Credit Value
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 45
Rapid Mart Subject Areas
3
Cost Summary Section
Measures Definition
AMT_CR_FIXVAR_YTD_CTRL_AREA Cost Summary Fixed Variance Year-To-Date
in Controlling Area Currency - Credit Value
AMT_CR_OBJ Cost Summary Value in Cost Center (Object)
Currency - Credit Value
AMT_CR_TRX Cost Summary Value in Transaction Currency
- Credit Value
AMT_CR_VAR_CTRL_AREA Cost Summary Price Variance in Controlling
Area Currency - Credit Value
AMT_CR_VAR_YTD_CTRL_AREA Cost Summary Price Variance Year-To-Date
in Controlling Area Currency - Credit Value
AMT_CR_YTD_CTRL_AREA Cost Summary Value Year-To-Date in
Controlling Area Currency - Credit Value
AMT_CR_YTD_OBJ Cost Summary Value Year-To-Date in Cost
Center (Object) Currency - Credit Value
AMT_CR_YTD_TRX Cost Summary Value Year-To-Date in
Transaction Currency - Credit Value
AMT_DR_CTRL_AREA Cost Summary Value in Controlling Area
Currency - Debit Value
AMT_DR_FIXED_CTRL_AREA Cost Summary Fixed Value in Controlling
Area Currency - Debit Value
AMT_DR_FIXED_YTD_CTRL_AREA Cost Summary Fixed Value Year-To-Date in
Controlling Area Currency - Debit Value
AMT_DR_FIXVAR_CTRL_AREA Cost Summary Fixed Variance in Controlling
Area Currency - Debit Value
AMT_DR_FIXVAR_YTD_CTRL_AREA Cost Summary Fixed Variance Year-To-Date
in Controlling Area Currency - Debit Value
AMT_DR_OBJ Cost Summary Value in Cost Center (Object)
Currency - Debit Value
AMT_DR_TRX Cost Summary Value in Transaction Currency
- Debit Value
AMT_DR_VAR_CTRL_AREA Cost Summary Price Variance in Controlling
Area Currency - Debit Value
AMT_DR_VAR_YTD_CTRL_AREA Cost Summary Price Variance Year-To-Date
in Controlling Area Currency - Debit Value
AMT_DR_YTD_CTRL_AREA Cost Summary Value Year-To-Date in
Controlling Area Currency - Debit Value
46 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
Cost Summary Section
Measures Definition
AMT_DR_YTD_OBJ Cost Summary Value Year-To-Date in Cost
Center (Object) Currency - Debit Value
AMT_DR_YTD_TRX Cost Summary Value Year-To-Date in
Transaction Currency - Debit Value
AMT_FIXED_PER_ROLLNG_CTRL_AREA Cost 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_AREA Cost Summary Rolling 16 Periods Total in
Controlling Area Currency
AMT_PER_ROLLNG_OBJ Cost Summary Rolling 16 Periods Total in
Cost Center (Object) Currency
AMT_PER_ROLLNG_TRX Cost Summary Rolling 16 Periods Total in
Transaction Area Currency
AMT_VAR_PER_ROLLNG_CTRL_AREA Cost Summary Price Variance Rolling 16
Periods Total in Controlling Area Currency QTY_CR Cost Summary Quantity - Credit Value QTY_CR_FIXED Cost Summary Fixed Quantity - Credit Value QTY_CR_FIXED_YTD Cost Summary Fixed Quantity Year-To-Date -
Credit Value QTY_CR_YTD Cost Summary Quantity Y ear-To-Date - Credit
Value QTY_DR Cost Summary Quantity - Debit Value QTY_DR_FIXED Cost Summary Fixed Quantity - Debit Value QTY_DR_FIXED_YTD Cost Summary Fixed Quantity Year-To-Date -
Debit Value QTY_DR_YTD Cost Summary Quantity Year-To-Date - Debit
Value QTY_FIXED_PER_ROLLNG Cost Summary Fixed Rolling 16 Periods
Quantity QTY_PER_ROLLNG Cost Summary Rolling 16 Periods Quantity
3
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 47
Rapid Mart Subject Areas
3
Cost Summary Section
COST_SUMMARY_FACT_HZ (Horizontal Organization):
Measures Definition
AMT_CR_FIXED_PER01_CTRL_AREA ­AMT_CR_FIXED_PER16_CTRL_AREA
AMT_CR_FIXVAR_PER01_CTRL_AREA ­AMT_CR_FIXVAR_PER16_CTRL_AREA
AMT_CR_PER01_CTRL_AREA ­AMT_CR_PER16_CTRL_AREA
AMT_CR_PER01_OBJ ­AMT_CR_PER16_OBJ
AMT_CR_PER01_TRX ­AMT_CR_PER16_TRX
AMT_CR_VAR_PER01_CTRL_AREA ­AMT_CR_VAR_PER16_CTRL_AREA
AMT_DR_FIXED_PER01_CTRL_AREA ­AMT_DR_FIXED_PER16_CTRL_AREA
AMT_DR_FIXVAR_PER01_CTRL_AREA ­AMT_DR_FIXVAR_PER16_CTRL_AREA
AMT_DR_PER01_CTRL_AREA ­AMT_DR_PER16_CTRL_AREA
AMT_DR_PER01_OBJ ­AMT_DR_PER16_OBJ
AMT_DR_PER01_TRX ­AMT_DR_PER16_TRX
AMT_DR_VAR_PER01_CTRL_AREA ­AMT_DR_VAR_PER16_CTRL_AREA
QTY_CR_FIXED_PER01 ­QTY_CR_FIXED_PER16
QTY_CR_PER01 - QTY_CR_PER16 Cost Summary Quantity (periods 1 - 16) -
QTY_DR_FIXED_PER01 ­QTY_DR_FIXED_PER16
QTY_DR_PER01 - QTY_DR_PER16 Cost Summary Quantity (periods 1 - 16) -
Cost Summary Fixed Value in Controlling Area Currency (periods 1 - 16) - Credit Values
Cost Summary Fixed Variance in Controlling Area Currency (periods 1 - 16) - Credit Values
Cost Summary Value in Controlling Area Currency (periods 1 - 16) - Credit Values
Cost Summary Value in Cost Center (Object) Currency (periods 1 - 16) - Credit Values
Cost Summary V alue in T ransaction Currency (periods 1 - 16) - Credit Values
Cost Summary Price Variance in Controlling Area Currency (periods 1 - 16) - Credit Values
Cost Summary Fixed Value in Controlling Area Currency (periods 1 - 16) - Debit Values
Cost Summary Fixed Variance in Controlling Area Currency (periods 1 - 16) - Debit Values
Cost Summary Value in Controlling Area Currency (periods 1 - 16) - Debit Values
Cost Summary Value in Cost Center (Object) Currency (periods 1 - 16) - Debit Values
Cost Summary V alue in T ransaction Currency (periods 1 - 16) - Debit Values
Cost Summary Price Variance in Controlling Area Currency (periods 1 - 16) - Debit Values
Cost Summary Fixed Quantity (periods 1 - 16)
- Credit Values
Credit Values Cost Summary Fixed Quantity (periods 1 - 16)
- Debit Values
Debit Values
48 SAP 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 Guide 49
Rapid Mart Subject Areas
3
Cost Summary Section
The following diagram shows the tables in the cost summary section in Star Schema Layout.
50 SAP 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 Guide 51
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?
52 SAP 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 Guide 53
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:
Attribute Dimension Table Name(s)
Activity & Hierarchy ACTIVITY, ACTIVITY_HIER,
ACTIVITY_HIER_BAD, ACTIVITY_HIER_HZ,
ACTIVITY_HIER_VR Business Area BUSINESS_AREA Chart of Accounts CHART_OF_ACCOUNTS Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Controlling Version FINANCIAL_VERSION Cost Center & Hierarchy COST_CENTER,
COST_CENTER_HIER,
COST_CENTER_HIER_BAD,
COST_CENTER_HIER_HZ,
COST_CENTER_HIER_VR
54 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Rapid Mart Subject Areas
Profit Center Detail Section
Attribute Dimension Table Name(s)
Cost Element & Hierarchy COST_ELEMENT,
COST_ELEMENT_HIER, COST_ELEMENT_HIER_HZ, COST_ELEMENT_HIER_VR,
COST_ELEMENT_HIER_BAD Customer CUSTOMER Debit / Credit Indicator DEBIT_CREDIT_INDICATOR Document Category DOCUMENT_CATEGORY Financial Document Type DOCUMENT_CATEGORY &
DOCUMENT_TYPE* Fiscal Period (Vertical Table only) FISC_PERIOD Functional Area & Hierarchy FUNCTIONAL_AREA,
FUNCTIONAL_AREA_HIER,
FUNCTIONAL_AREA_HIER_HZ,
FUNCTIONAL_AREA_HIER_VR,
FUNCTIONAL_AREA_HIER_BAD GL Account & Hierarchy GL_ACCOUNT_HIER,
GL_ACCOUNT_HIER_BAD,
GL_ACCOUNT_HIER_HZ,
GL_ACCOUNT_HIER_STAGE,
GL_ACCOUNT_HIER_VR,
GL_ACCOUNT_MASTER Internal Order & Hierarchy INTERNAL_ORDER,
INTERNAL_ORDER_HIER,
INTERNAL_ORDER_HIER_BAD,
INTERNAL_ORDER_HIER_HZ,
INTERNAL_ORDER_HIER_VR Material and Product Hierarchy MATERIAL, PRODUCT_HIERARCHY Monetary Currency CURRENCY Plant (or Factory) PLANT Profit Center & Hierarchy PROFIT_CENTER,
PROFIT_CENTER_HIER,
PROFIT_CENTER_HIER_BAD,
PROFIT_CENTER_HIER_HZ,
PROFIT_CENTER_HIER_VR Record Type FINANCIAL_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 Guide 55
Rapid Mart Subject Areas
3
Profit Center Detail Section
Fact Table Fields
Attribute Dimension Table Name(s)
Special Ledger Document Type DOCUMENT_CATEGORY &
DOCUMENT_TYPE* Special Ledger Group (New GL only) LEDGER_GROUP Time Dimension TIME_DIM Transaction Type TRANSACTION_TYPE Unit of Measure UNIT_OF_MEASURE Valuation Area VALUATION_AREA Vendor VENDOR
* 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:
PROFIT_CENTER_FACT_HZ:
PROFIT_CENTER_FACT_HZ Mea­sure Column Name
AMT_PER_BEGIN_LOC Period Beginning Balance - Local
AMT_PER_BEGIN_PCNTR Period Beginning Balance - Profit
AMT_PER_BEGIN_TRX Period Beginning Balance - Transac-
AMT_PER01_LOC ­AMT_PER16_LOC
AMT_PER01_PCNTR ­AMT_PER16_PCNTR
AMT_PER01_TRX ­AMT_PER16_TRX
56 SAP 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 Mea­sure Column Name
QTY_PER_BEGIN Quantity in Base Unit of Measure
QTY_PER01 - QTY_PER16 Quantity in Base Unit of Measure For
PROFIT_CENTER_FACT_VR:
PROFIT_CENTER_FACT_VR Mea­sure Column Name
AMT_TRX Value in Transaction (Document)
AMT_LOC Value in Local (Company Code) Cur-
AMT_PCNTR Value in Profit Center Currency QTY Quantity 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 Guide 57
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:
58 SAP 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 Guide 59
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:
Attribute Dimension Table Name(s)
Chart of Accounts CHART_OF_ACCOUNTS Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Controlling Version FINANCIAL_VERSION Fiscal Period (Vertical Table
only)
60 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
FISC_PERIOD
Rapid Mart Subject Areas
Profit Center Summary Section
Attribute Dimension Table Name(s)
Functional Area & Hierarchy FUNCTIONAL_AREA,
FUNCTIONAL_AREA_HIER, FUNCTIONAL_AREA_HIER_HZ, FUNCTIONAL_AREA_HIER_VR, FUNCTIONAL_AREA_HIER_BAD
GL Account & Hierarchy GL_ACCOUNT_HIER,
GL_ACCOUNT_HIER_BAD, GL_ACCOUNT_HIER_HZ, GL_ACCOUNT_HIER_STAGE, GL_ACCOUNT_HIER_VR,
GL_ACCOUNT_MASTER Monetary Currency CURRENCY Plant (or Factory) PLANT Profit Center & Hierarchy PROFIT_CENTER,
PROFIT_CENTER_HIER,
PROFIT_CENTER_HIER_BAD,
PROFIT_CENTER_HIER_HZ,
PROFIT_CENTER_HIER_VR Record Type FINANCIAL_RECORD_TYPE Segment (New GL only) SEGMENT Special Ledger (Master Data) FISL_LEDGER Special Ledger Group (New
GL only) Transaction Type TRANSACTION_TYPE Unit of Measure UNIT_OF_MEASURE
LEDGER_GROUP
3
Fact Table Fields
The Profit Center Summary Fact tables (PROFIT_CENTER_SUMMARY_FACT_HZ and PROFIT_CENTER_SUMMARY_FACT_VR) contain the following measures:
PROFIT_CENTER_SUMMARY_FACT_HZ:
PROFIT_CENTER_SUMMARY_ FACT_HZ Measure Column Name
AMT_CR_PER_BEGIN_LOC Credit Amount Period Beginning Bal-
AMT_CR_PER_BEGIN_PCNTR Credit Amount Period Beginning Bal-
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 61
Description
ance Local Currency
ance Profit Center Currency
Rapid Mart Subject Areas
3
Profit Center Summary Section
PROFIT_CENTER_SUMMARY_ FACT_HZ Measure Column Name
AMT_CR_PER_BEGIN_TRX Credit Amount Period Beginning Bal-
AMT_CR_PER01_LOC ­AMT_CR_PER16_LOC
AMT_CR_PER01_PCNTR ­AMT_CR_PER16_PCNTR
AMT_CR_PER01_TRX ­AMT_CR_PER16_TRX
AMT_CR_QTR01_LOC ­AMT_CR_QTR04_LOC
AMT_CR_QTR01_PCNTR ­AMT_CR_QTR04_PCNTR
AMT_CR_QTR01_TRX ­AMT_CR_QTR04_TRX
AMT_CR_YTD_LOC Credit Amount Year-to-Date Local
AMT_CR_YTD_PCNTR Credit Amount Year-to-Date Profit
AMT_CR_YTD_TRX Credit Amount Year-to-Date Trans-
AMT_DR_PER_BEGIN_LOC Debit Amount Period Beginning Bal-
AMT_DR_PER_BEGIN_PCNTR Debit Amount Period Beginning Bal-
AMT_DR_PER_BEGIN_TRX Debit Amount Period Beginning Bal-
AMT_DR_PER01_LOC ­AMT_DR_PER16_LOC
AMT_DR_PER01_PCNTR ­AMT_DR_PER16_PCNTR
AMT_DR_PER01_TRX ­AMT_DR_PER16_TRX
AMT_DR_QTR01_LOC ­AMT_DR_QTR04_LOC
AMT_DR_QTR01_PCNTR ­AMT_DR_QTR04_PCNTR
Description
ance Transaction Currency Credit Amount Period 1 - 16 Local
Currency Credit Amount Period 1 - 16 Profit
Center Currency Credit Amount Period 1 - 16 Trans-
action Currency Credit Amount Quarter 1 - 4 Local
Currency Credit Amount Quarter 1 - 4 Profit
Center Currency Credit Amount Quarter 1 - 4 Trans-
action Currency
Currency
Center Currency
action Currency
ance Local Currency
ance Profit Center Currency
ance Transaction Currency Debit Amount Period 1 - 16 Local
Currency Debit Amount Period 1 - 16 Profit
Center Currency Debit Amount Period 1 - 16 Transac-
tion Currency Debit Amount Quarter 1 - 4 Local
Currency Debit Amount Quarter 1 - 4 Profit
Center Currency
62 SAP 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_HZ Measure Column Name
AMT_DR_QTR01_TRX ­AMT_DR_QTR04_TRX
AMT_DR_YTD_LOC Debit Amount Year-to-Date Local
AMT_DR_YTD_PCNTR Debit Amount Year-to-Date Profit
AMT_DR_YTD_TRX Debit Amount Year-to-Date Transac-
QTY_CR_PER_BEGIN Credit Quantity Period Beginning
QTY_CR_PER01 ­QTY_CR_PER16
QTY_CR_QTR01 ­QTY_CR_QTR04
QTY_CR_YTD Credit Quantity Year-to-Date QTY_DR_PER_BEGIN Debit Quantity Period Beginning Bal-
QTY_DR_PER01 ­QTY_DR_PER16
QTY_DR_QTR01 ­QTY_DR_QTR04
QTY_DR_YTD Debit Quantity Year-to-Date
Description
Debit Amount Quarter 1 - 4 Transac­tion Currency
Currency
Center Currency
tion Currency
Balance Credit Quantity Period 1 - 16
Credit Quantity Quarter 1 - 4
ance Debit Quantity Period 1 - 16
Debit Quantity Quarter 1 - 4
PROFIT_CENTER_SUMMARY_FACT_VR:
PROFIT_CENTER_SUMMARY_ FACT_VR Measure Column Name
AMT_CR_LOC Credit Amount this Fiscal Period
AMT_CR_PCNTR Credit Amount this Fiscal Period
AMT_CR_TRX Credit Amount this Fiscal Period
AMT_CR_YTD_LOC Credit Amount Year-to-Date Local
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 63
Description
Local Currency
Profit Center Currency
Transaction Currency
Currency
Rapid Mart Subject Areas
3
Profit Center Summary Section
PROFIT_CENTER_SUMMARY_ FACT_VR Measure Column Name
AMT_CR_YTD_PCNTR Credit Amount Year-to-Date Profit
AMT_CR_YTD_TRX Credit Amount Year-to-Date Transac-
AMT_DR_LOC Debit Amount this Fiscal Period Local
AMT_DR_PCNTR Debit Amount this Fiscal Period Profit
AMT_DR_TRX Debit Amount this Fiscal Period
AMT_DR_YTD_LOC Debit Amount Year-to-Date Local
AMT_DR_YTD_PCNTR Debit Amount Year-to-Date Profit
AMT_DR_YTD_TRX Debit Amount Year-to-Date Transac-
AMT_PER_BEGIN_LOC Period Beginning Balance Local Cur-
AMT_PER_BEGIN_PCNTR Period Beginning Balance Profit Cen-
AMT_PER_BEGIN_TRX Period Beginning Balance Transac-
AMT_PER_ROLLING_LOC Rolling 16 Periods Balance Local
AMT_PER_ROLLING_PCNTR Rolling 16 Periods Balance Profit
AMT_PER_ROLLING_TRX Rolling 16 Periods Balance Transac-
AMT_PTD_LOC Period-to-Date Amount Local Cur-
AMT_PTD_PCNTR Period-to-Date Amount Profit Center
AMT_PTD_TRX Period-to-Date Amount Profit Center
QTY_CR Credit Quantity this Fiscal Period QTY_CR_YTD Credit 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
64 SAP 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_DR Debit Quantity this Fiscal Period QTY_DR_YTD Debit Quantity Year-to-Date QTY_PER_BEGIN Period Beginning Quantity QTY_PER_ROLLING Rolling 16 Periods Quantity QTY_PTD Period-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 Guide 65
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
66 SAP 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 Guide 67
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.
68 SAP 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
70 SAP 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.
Reports
Cost Details
4
Report SQL
SELECT DISTINCT FISC_PERIOD_CTRL_AREA.FISC_YEAR, FISC_PERIOD_CTRL_AREA.FISC_PERIOD, sum(COST_TRANSACTION_F ACT.AMT_CTRL_AREA), MATERIAL.MTRL_DESCR, VENDOR.VENDOR_NAME_01, sum(COST_TRANSACTION_FACT.AMT_FIXED_CTRL_AREA), sum(COST_TRANSACTION_F ACT.AMT_VAR_CTRL_AREA), sum(COST_TRANSACTION_FACT.AMT_FIXED_VAR_CTRL_AREA), CURRENCY_CTRL_AREA.CURR_ISO_CODE, CONTROLLING_AREA.CTRL_AREA_ID, COST_CENTER_HIER_HZ.LVL_00_ID, CONTROLLING_AREA.CTRL_AREA_FULL_NAME FROM CONTROLLING_AREA, COST_TRANSACTION_FA CT, MATERIAL, VENDOR, FINANCIAL_RECORD_TYPE, CURRENCY CURRENCY_CTRL_AREA,
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 71
4
Reports
Cost Details
FISC_PERIOD FISC_PERIOD_CTRL_AREA, COST_CENTER_HIER_HZ WHERE ( CONTROLLING_AREA.CTRL_AREA_ID =
COST_TRANSACTION_FACT.CTRL_AREA_ID )
AND ( COST_TRANSACTION_FACT.MATERIAL_ID =
MATERIAL.MATERIAL_ID ) AND ( COST_TRANSACTION_FACT.VENDOR_ID = VENDOR.VENDOR_ID ) AND ( FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID =
COST_TRANSACTION_FACT.RECORD_TYPE_ID and
FINANCIAL_RECORD_TYPE.DIM_SRC_ID = 'COST' ) AND (
CURRENCY_CTRL_AREA.CURR_ID=COST_TRANSACTION_FACT.CURR_I
D_CTRL_AREA ) AND (
COST_TRANSACTION_FACT.FISC_PERIOD=FISC_PERIOD_CTRL_AREA.FI
SC_PERIOD and COST_TRANSACTION_FACT.FISC_YEAR=FISC_PERIOD_CTRL_AREA.FISC_YE
AR and COST_TRANSACTION_FACT.FISC_YR_VARIANT_ID_CTRL_AREA =
FISC_PERIOD_CTRL_AREA.FISC_YR_VARIANT_ID ) AND (
COST_CENTER_HIER_HZ.COST_CNTR_ID=COST_TRANSACTION_FACT.C
OST_CNTR_ID and
COST_CENTER_HIER_HZ.CTRL_AREA_ID=COST_TRANSACTION_FACT.C
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
72 SAP 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 Guide 73
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.
Fact Table Dimension Table Join Text
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
ACTIVITY ACTIVITY.ACTIVITY_ID=COST_TRANSACTION_FA
ACTIVITY_HIER_HZ ACTIVITY_HIER_HZ.ACTIVITY_ID=COST_TRANSA
ACTIVITY_HIER_VR COST_TRANSACTION_FACT.CTRL_AREA_ID=ACT
BUSINESS_AREA BUSINESS_AREA.BUS_AREA_ID =
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS.CHART_OF_ACCT_ID=C
COMPANY_CODE COMPANY_CODE.CMPNY_CODE_ID =
CONTROLLING_AREA CONTROLLING_AREA.CTRL_AREA_ID =
CONTROLLING_TRANS ACTION
COST_CENTER COST_CENTER.COST_CNTR_ID=COST_TRANSA
COST_CENTER_HIER_HZCOST_CENTER_HIER_HZ.COST_CNTR_ID=COST
COST_CENTER_HIER_VRCOST_TRANSACTION_FACT.CTRL_AREA_ID=CO
COST_ELEMENT COST_ELEMENT.CHART_OF_ACCT_ID=COST_TR
CT.ACTIVITY_ID and ACTIVITY.CTRL_AREA_ID=COST_TRANSACTION_ FACT.CTRL_AREA_ID
CTION_FACT.ACTIVITY_ID and ACTIVITY_HIER_HZ.CTRL_AREA_ID=COST_TRAN SACTION_FACT.CTRL_AREA_ID
IVITY_HIER_VR.CTRL_AREA_ID and COST_TRANSACTION_FACT.ACTIVITY_ID=ACTIVI TY_HIER_VR.CHILD_ID
COST_TRANSACTION_FACT.BUS_AREA_ID
OST_TRANSACTION_FACT.CHART_OF_ACCT_ID
COST_TRANSACTION_FACT.CMPNY_CODE_ID
COST_TRANSACTION_FACT.CTRL_AREA_ID CONTROLLING_TRANSACTION.CTRL_TRX_ID =
COST_TRANSACTION_FACT.CTRL_TRX_ID
CTION_FACT.COST_CNTR_ID and COST_CENTER.CTRL_AREA_ID=COST_TRANSAC TION_FACT.CTRL_AREA_ID
_TRANSACTION_FACT.COST_CNTR_ID and COST_CENTER_HIER_HZ.CTRL_AREA_ID=COST_ TRANSACTION_FACT.CTRL_AREA_ID
ST_CENTER_HIER_VR.CTRL_AREA_ID and COST_TRANSACTION_FACT.COST_CNTR_ID=CO ST_CENTER_HIER_VR.CHILD_ID
ANSACTION_FACT.CHART_OF_ACCT_ID and COST_ELEMENT.COST_ELEM_ID=COST_TRAN SA CTION_FACT.COST_ELEM_ID
74 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Fact Table Dimension Table Join Text
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_ELEMENT_HIER_HZCOST_TRANSACTION_FACT.COST_ELEM_ID=CO
COST_ELEMENT_HIER_VRCOST_TRANSACTION_FACT.CHART_OF_ACCT_I
CURRENCY CURRENCY.CURR_ID =
CURRENCY CURRENCY.CURR_ID=COST_TRANSACTION_FAC
CURRENCY CURRENCY.CURR_ID=COST_TRANSACTION_FAC
DEBIT_CREDIT_INDICATORDEBIT_CREDIT_INDICATOR.DR_CR_ID=COST_TR
FINANCIAL_RECORD_T YPE
FINANCIAL_VERSION FINANCIAL_VERSION.LEDGER_ID = 'COST and
FISC_PERIOD COST_TRANSACTION_FACT.FISC_PERIOD=FISC_
FISC_PERIOD COST_TRANSACTION_FACT.FISC_PERIOD=FISC_
FUNCTIONAL_AREA COST_TRANSACTION_FACT.FUNCTNL_AREA_ID
FUNCTIONAL_AREA_HI ER_HZ
FUNCTIONAL_AREA_HI ER_VR
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
= FUNCTIONAL_AREA.FUNCTNL_AREA_ID COST_TRANSACTION_FACT.FUNCTNL_AREA_ID
= FUNCTIONAL_AREA_HIER_HZ.FUNCTNL_AREA_I D
COST_TRANSACTION_FACT.FUNCTNL_AREA_ID = FUNCTIONAL_AREA_HIER_VR.CHILD_ID
Reports
Cost Details
4
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 75
Reports
4
Cost Details
Fact Table Dimension Table Join Text
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
COST_TRANSACTION_F ACT
GL_ACCOUNT_BY_COM PANY
INTERNAL_ORDER INTERNAL_ORDER.INTERNAL_ORDER_ID =
INTERNAL_ORDER_HIE R_HZ
INTERNAL_ORDER_HIE R_VR
MATERIAL COST_TRANSACTION_FACT.MATERIAL_ID =
MATERIAL_BY_PLANT COST_TRANSACTION_FACT.PLANT_ID =
OBJECT_CLASS OBJECT_CLASS.OBJ_CLASS_ID =
OBJECT_TYPE COST_TRANSACTION_FACT.OBJ_TYPE_ID =
PLANT COST_TRANSACTION_FACT.PLANT_ID =
PROJECT COST_TRANSACTION_FACT.PROJ_ID=PROJECT.
PROJECT_ELEMENT COST_TRANSACTION_FACT.PROJ_ELEM_ID=PR
PROJECT_ELEMENT_HI ER_HZ
PROJECT_ELEMENT_HI ER_VR
TIME_DIM TIME_DIM.CALENDAR_DATE=COST_TRANSACTI
TIME_DIM TIME_DIM.CALENDAR_DATE=COST_TRANSACTI
UNIT_OF_MEASURE COST_TRANSACTION_FACT.UOM_ID=UNIT_OF_M
VENDOR COST_TRANSACTION_FACT.VENDOR_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
COST_TRANSACTION_FACT.INTERNAL_ORDER_I D=INTERNAL_ORDER_HIER_VR.CHILD_ID
MATERIAL.MATERIAL_ID
MATERIAL_BY_PLANT.PLANT_ID AND COST_TRANSACTION_FACT.MATERIAL_ID = MATERIAL_BY_PLANT.MATERIAL_ID
COST_TRANSACTION_FACT.OBJ_CLASS_ID
OBJECT_TYPE.OBJ_TYPE_ID AND OBJECT_TYPE.DIM_SRC_ID = 'COST'
PLANT.PLANT_ID
PROJ_ID
OJECT_ELEMENT.PROJ_ELEM_ID COST_TRANSACTION_FACT.PROJ_ELEM_ID=PR
OJECT_ELEMENT_HIER_HZ.PROJ_ELEM_ID COST_TRANSACTION_FACT.PROJ_ELEM_ID=PR
OJECT_ELEMENT_HIER_VR.CHILD_ID
ON_FACT.CREATE_DATE
ON_FACT.POST_DATE
EASURE.UOM_ID
VENDOR.VENDOR_ID
76 SAP 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 Guide 77
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.
78 SAP 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
COST_SUMMARY_FACT_VR.AMT_DR_CTRL_AREA-
COST_SUMMARY_FACT_VR.AMT_CR_CTRL_AREA else 0 end), 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 FROM
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 79
Reports
4
Cost Summary
FINANCIAL_VERSION, FINANCIAL_RECORD_TYPE, COST_SUMMARY_FACT_VR, FISC_PERIOD FISC_PERIOD_CTRL_AREA, CURRENCY CURRENCY_CTRL_AREA, COST_ELEMENT, COST_CENTER, CONTROLLING_AREA WHERE (
COST_SUMMARY_FACT_VR.FISC_PERIOD=FISC_PERIOD_CTRL_AREA.FI SC_PERIOD and
COST_SUMMARY_FACT_VR.FISC_YEAR=FISC_PERIOD_CTRL_AREA.FISC_YE
AR and
COST_SUMMARY_FACT_VR.FISC_YR_VARIANT_ID_CTRL_AREA =
FISC_PERIOD_CTRL_AREA.FISC_YR_VARIANT_ID )
AND (
CONTROLLING_AREA.CTRL_AREA_ID=COST_SUMMARY_FACT_VR.CTR L_AREA_ID )
AND (
CURRENCY_CTRL_AREA.CURR_ID=COST_SUMMARY_FACT_VR.CURR_I D_CTRL_AREA )
AND (
COST_SUMMARY_FACT_VR.COST_CNTR_ID=COST_CENTER.COST_CNT R_ID and COST_SUMMARY_FACT_VR.CTRL_AREA_ID=COST_CENTER.CTRL_ARE A_ID )
AND (
COST_ELEMENT.CHART_OF_ACCT_ID=COST_SUMMARY_FACT_VR.CHA RT_OF_ACCT_ID and COST_ELEMENT.COST_ELEM_ID=COST_SUMMARY_FACT_VR.COST_ELE M_ID )
AND (
FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID=COST_SUMMARY_FACT_ VR.RECORD_TYPE_ID and FINANCIAL_RECORD_TYPE.DIM_SRC_ID = 'COST' )
AND (
FINANCIAL_VERSION.VERSION_ID=COST_SUMMARY_FACT_VR.VERSIO
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
80 SAP 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 Guide 81
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
82 SAP 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 Guide 83
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
84 SAP 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 Guide 85
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
86 SAP 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 Guide 87
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
88 SAP 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 Guide 89
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
90 SAP 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 Guide 91
Reports
4
Cost Summary
Note: Additional joins between dimension and hierarchy tables are shown in
“Recommended table joins” on page 27 for master reports.
Fact Table Dimension Table Join Text
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
ACTIVITY ACTIVITY.CTRL_AREA_ID=COST_SUMMARY_FAC
ACTIVITY_HIER_HZ COST_SUMMARY_FACT_HZ.CTRL_AREA_ID=ACT
ACTIVITY_HIER_VR COST_SUMMARY_FACT_HZ.CTRL_AREA_ID=ACT
BUSINESS_AREA BUSINESS_AREA.BUS_AREA_ID=COST_SUMMAR
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS.CHART_OF_ACCT_ID=C
COMPANY_CODE COMPANY_CODE.CMPNY_CODE_ID=COST_SUM
CONTROLLING_AREA CONTROLLING_AREA.CTRL_AREA_ID=COST_SU
CONTROLLING_TRANS ACTION
COST_CENTER COST_SUMMARY_FACT_HZ.CTRL_AREA_ID=COS
COST_CENTER_HIER_HZCOST_SUMMARY_FACT_HZ.CTRL_AREA_ID=COS
COST_CENTER_HIER_VRCOST_SUMMARY_FACT_HZ.CTRL_AREA_ID=COS
COST_ELEMENT COST_ELEMENT.CHART_OF_ACCT_ID=COST_SU
COST_ELEMENT_HIER_HZCOST_SUMMARY_FACT_HZ.COST_ELEM_ID=CO
T_HZ.CTRL_AREA_ID and ACTIVITY.ACTIVITY_ID=COST_SUMMARY_FACT_ HZ.ACTIVITY_ID
IVITY_HIER_HZ.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.ACTIVITY_ID=ACTIVI TY_HIER_HZ.ACTIVITY_ID
IVITY_HIER_VR.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.ACTIVITY_ID=ACTIVI TY_HIER_VR.CHILD_ID
Y_FACT_HZ.BUS_AREA_ID
OST_SUMMARY_FACT_HZ.CHART_OF_ACCT_ID
MARY_FACT_HZ.CMPNY_CODE_ID
MMARY_FACT_HZ.CTRL_AREA_ID CONTROLLING_TRANSACTION.CTRL_TRX_ID=C
OST_SUMMARY_FACT_HZ.CTRL_TRX_ID
T_CENTER.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.COST_CNTR_ID=CO ST_CENTER.COST_CNTR_ID
T_CENTER_HIER_HZ.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.COST_CNTR_ID=CO ST_CENTER_HIER_HZ.COST_CNTR_ID
T_CENTER_HIER_VR.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.COST_CNTR_ID=CO ST_CENTER_HIER_VR.CHILD_ID
MMARY_FACT_HZ.CHART_OF_ACCT_ID and COST_ELEMENT.COST_ELEM_ID=COST_SUMMA RY_FACT_HZ.COST_ELEM_ID
ST_ELEMENT_HIER_HZ.COST_ELEM_ID and COST_SUMMARY_FACT_HZ.CHART_OF_ACCT_ID =COST_ELEMENT_HIER_HZ.CHART_OF_ACCT_I D
92 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Fact Table Dimension Table Join Text
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_ELEMENT_HIER_VRCOST_SUMMARY_FACT_HZ.CHART_OF_ACCT_ID
COST_SUMMARY_FACT _HZ
CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_H
CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_H
CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_H
CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_H
FINANCIAL_RECORD_T YPE
FINANCIAL_VERSION FINANCIAL_VERSION.LEDGER_ID = 'COST' and
GL_ACCOUNT_BY_COM PANY
INTERNAL_ORDER COST_SUMMARY_FACT_HZ.INTERNAL_ORDER_I
INTERNAL_ORDER_HIE R_HZ
INTERNAL_ORDER_HIE R_VR
OBJECT_CLASS OBJECT_CLASS.OBJ_CLASS_ID=COST_SUMMAR
OBJECT_TYPE COST_SUMMARY_FACT_HZ.OBJ_TYPE_ID=OBJE
PROJECT COST_SUMMARY_FACT_HZ.PROJ_ID=PROJECT.
PROJECT_ELEMENT COST_SUMMARY_FACT_HZ.PROJ_ELEM_ID=PR
=COST_ELEMENT_HIER_VR.CHART_OF_ACCT_I D and COST_SUMMARY_FACT_HZ.COST_ELEM_ID=CO ST_ELEMENT_HIER_VR.CHILD_ID
COST_SUMMARY_FACT_HZ.FISC_YEAR=COST_S UMMARY_FACT_HZ.PARTITION_YEAR
Z.CURR_ID_TRX
Z.CURR_ID_CTRL_AREA
Z.CURR_ID_OBJ
Z.CURR_ID_LOC FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID=C
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
D=INTERNAL_ORDER.INTERNAL_ORDER_ID COST_SUMMARY_FACT_HZ.INTERNAL_ORDER_I
D = INTERNAL_ORDER_HIER_HZ.INTERNAL_ORDER_ ID
COST_SUMMARY_FACT_HZ.INTERNAL_ORDER_I D=INTERNAL_ORDER_HIER_VR.CHILD_ID
Y_FACT_HZ.OBJ_CLASS_ID
CT_TYPE.OBJ_TYPE_ID AND OBJECT_TYPE.DIM_SRC_ID = 'COST'
PROJ_ID
OJECT_ELEMENT.PROJ_ELEM_ID
Reports
Cost Summary
4
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 93
Reports
4
Cost Summary
Fact Table Dimension Table Join Text
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _HZ
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
PROJECT_ELEMENT_HI ER_HZ
PROJECT_ELEMENT_HI ER_VR
UNIT_OF_MEASURE COST_SUMMARY_FACT_HZ.UOM_ID=UNIT_OF_M
ACTIVITY ACTIVITY.CTRL_AREA_ID=COST_SUMMARY_FAC
ACTIVITY_HIER_HZ COST_SUMMARY_FACT_VR.CTRL_AREA_ID=ACT
ACTIVITY_HIER_VR COST_SUMMARY_FACT_VR.CTRL_AREA_ID=ACT
BUSINESS_AREA BUSINESS_AREA.BUS_AREA_ID=COST_SUMMAR
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS.CHART_OF_ACCT_ID=C
COMPANY_CODE COMPANY_CODE.CMPNY_CODE_ID=COST_SUM
CONTROLLING_AREA CONTROLLING_AREA.CTRL_AREA_ID=COST_SU
CONTROLLING_TRANS ACTION
COST_CENTER COST_SUMMARY_FACT_VR.COST_CNTR_ID=CO
COST_CENTER_HIER_HZCOST_SUMMARY_FACT_VR.CTRL_AREA_ID=CO
COST_CENTER_HIER_VRCOST_SUMMARY_FACT_VR.CTRL_AREA_ID=CO
COST_ELEMENT COST_ELEMENT.CHART_OF_ACCT_ID=COST_SU
COST_ELEMENT_HIER_HZCOST_SUMMARY_FACT_VR.COST_ELEM_ID=CO
COST_SUMMARY_FACT_HZ.PROJ_ELEM_ID=PR OJECT_ELEMENT_HIER_HZ.PROJ_ELEM_ID
COST_SUMMARY_FACT_HZ.PROJ_ELEM_ID=PR OJECT_ELEMENT_HIER_VR.CHILD_ID
EASURE.UOM_ID
T_VR.CTRL_AREA_ID and ACTIVITY.ACTIVITY_ID=COST_SUMMARY_FACT_ VR.ACTIVITY_ID
IVITY_HIER_HZ.CTRL_AREA_ID and COST_SUMMARY_FACT_VR.ACTIVITY_ID=ACTIVI TY_HIER_HZ.ACTIVITY_ID
IVITY_HIER_VR.CTRL_AREA_ID and COST_SUMMARY_FACT_VR.ACTIVITY_ID=ACTIVI TY_HIER_VR.CHILD_ID
Y_FACT_VR.BUS_AREA_ID
OST_SUMMARY_FACT_VR.CHART_OF_ACCT_ID
MARY_FACT_VR.CMPNY_CODE_ID
MMARY_FACT_VR.CTRL_AREA_ID CONTROLLING_TRANSACTION.CTRL_TRX_ID=C
OST_SUMMARY_FACT_VR.CTRL_TRX_ID
ST_CENTER.COST_CNTR_ID and COST_SUMMARY_FACT_VR.CTRL_AREA_ID=CO ST_CENTER.CTRL_AREA_ID
ST_CENTER_HIER_HZ.CTRL_AREA_ID and COST_SUMMARY_FACT_VR.COST_CNTR_ID=CO ST_CENTER_HIER_HZ.COST_CNTR_ID
ST_CENTER_HIER_VR.CTRL_AREA_ID and COST_SUMMARY_FACT_VR.COST_CNTR_ID=CO ST_CENTER_HIER_VR.CHILD_ID
MMARY_FACT_VR.CHART_OF_ACCT_ID and COST_ELEMENT.COST_ELEM_ID=COST_SUMMA RY_FACT_VR.COST_ELEM_ID
ST_ELEMENT_HIER_HZ.COST_ELEM_ID and COST_SUMMARY_FACT_VR.CHART_OF_ACCT_I D=COST_ELEMENT_HIER_HZ.CHART_OF_ACCT_ ID
94 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Fact Table Dimension Table Join Text
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_ELEMENT_HIER_VRCOST_SUMMARY_FACT_VR.CHART_OF_ACCT_I
COST_SUMMARY_FACT _VR
CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_V
CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_V
CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_V
CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_V
FINANCIAL_RECORD_T YPE
FINANCIAL_VERSION FINANCIAL_VERSION.LEDGER_ID = 'COST' and
FISC_PERIOD COST_SUMMARY_FACT_VR.FISC_PERIOD=FISC_
FISC_PERIOD COST_SUMMARY_FACT_VR.FISC_PERIOD=FISC_
GL_ACCOUNT_BY_COM PANY
INTERNAL_ORDER COST_SUMMARY_FACT_VR.INTERNAL_ORDER_I
INTERNAL_ORDER_HIE R_HZ
D=COST_ELEMENT_HIER_VR.CHART_OF_ACCT_ ID and COST_SUMMARY_FACT_VR.COST_ELEM_ID=CO ST_ELEMENT_HIER_VR.CHILD_ID
COST_SUMMARY_FACT_VR.FISC_YEAR=COST_S UMMARY_FACT_VR.PARTITION_YEAR
R.CURR_ID_TRX
R.CURR_ID_CTRL_AREA
R.CURR_ID_OBJ
R.CURR_ID_LOC FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID=C
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
D=INTERNAL_ORDER.INTERNAL_ORDER_ID COST_SUMMARY_FACT_VR.INTERNAL_ORDER_I
D = INTERNAL_ORDER_HIER_HZ.INTERNAL_ORDER_ ID
Reports
Cost Summary
4
SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 95
Reports
4
Cost Summary
Fact Table Dimension Table Join Text
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
COST_SUMMARY_FACT _VR
INTERNAL_ORDER_HIE R_VR
OBJECT_CLASS OBJECT_CLASS.OBJ_CLASS_ID=COST_SUMMAR
OBJECT_TYPE COST_SUMMARY_FACT_VR.OBJ_TYPE_ID=OBJE
PROJECT COST_SUMMARY_FACT_VR.PROJ_ID=PROJECT.
PROJECT_ELEMENT COST_SUMMARY_FACT_VR.PROJ_ELEM_ID=PR
PROJECT_ELEMENT_HI ER_HZ
PROJECT_ELEMENT_HI ER_VR
UNIT_OF_MEASURE COST_SUMMARY_FACT_VR.UOM_ID=UNIT_OF_M
COST_SUMMARY_FACT_VR.INTERNAL_ORDER_I D=INTERNAL_ORDER_HIER_VR.CHILD_ID
Y_FACT_VR.OBJ_CLASS_ID
CT_TYPE.OBJ_TYPE_ID AND OBJECT_TYPE.DIM_SRC_ID = 'COST'
PROJ_ID
OJECT_ELEMENT.PROJ_ELEM_ID COST_SUMMARY_FACT_VR.PROJ_ELEM_ID=PR
OJECT_ELEMENT_HIER_HZ.PROJ_ELEM_ID COST_SUMMARY_FACT_VR.PROJ_ELEM_ID=PR
OJECT_ELEMENT_HIER_VR.CHILD_ID
EASURE.UOM_ID
96 SAP 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 Guide 97
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),
98 SAP 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 Guide 99
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
Cntr Hz - Dates & Fiscal Periods\Fiscal Year',Multi,Free,Persistent,,User:0) AND PROFIT_CENTER_FACT_HZ.CURR_ID_LOC = @prompt('Local Currency
Id:','A','Prof Cntr Hz - Monetary Currency\Local Currency
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.
100 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide
Loading...