SAP CO ECC 6.0 Bootcamp - Day 4
SAP CO ECC 6.0 Bootcamp - Day 4
SAP CO ECC 6.0 Bootcamp - Day 4
ppt
Agenda – Day 4
• Review of Day 3
• Profitability Analysis Overview
• Project System
– Introduction
– Project Structure
– Planning
– Budgeting
– Execution
– Closing
2
Key Message(s):
Additional Information:
Review of Day 3
• We covered the following topics on Day 3:
– Profit Centre Accounting – Aim of PCA
– Profit Centre Accounting – Master Data
– Profit Centre Accounting – Transaction Data
Processing
– Profit Centre Accounting – Transfer Pricing
– Profit Centre Accounting – Planning
– Profit Centre Accounting – Reporting
– Product Costing Overview
Key Message(s):
Note to faculty: Refer to the Previous Day Review Approach section in the Faculty
Guide for review questions and answers.
Additional Information:
Agenda – Day 4
• Review of Day 3
• Profitability Analysis Overview
• Project System
– Introduction
– Project Structure
– Planning
– Budgeting
– Execution
– Closing
4
Key Message(s):
Additional Information:
Key Message(s):
Additional Information:
Overview (cont.)
• Key Points:
– Profitability analysis information is a combination of
characteristics and value fields.
• Characteristics are the subject to be analysed (customer,
products, profit centre).
• Value fields are the performance figures (revenues,
discounts, product costs, etc.).
Key Message(s):
Additional Information:
There are two types of Profitability Analysis – account-based profitability analysis
and costing-based profitability analysis.
Value fields can be created for costing-based profitability analysis. In the case of
account-based profitability analysis, values are reported from the cost
elements/revenue elements.
Types
• TypesofofProfitability Analysis
Profitability Analysis
• Costing-based • Account-based
– Reports displays values – Reports display values
by value fields. by cost elements (CO
– Indirectly reconciles with revenue and cost
FI. element).
– Uses CO-PA-specific – Reconcile directly with
transaction tables. FI (on account level)
– Revenue and cost of – Share data tables with
sales are recognised other CO applications.
simultaneously. – Revenues and cost-of-
sales are updated
asynchronously. 7
Key Message(s):
Costing-based profitability analysis provides the flexibility to define value fields
based on the way an organisation wants to view the sales performance.
Example of custom value fields – Realisation (Gross Sales revenue less Trade
Discount less On-invoice Discount)
Account-based profitability analysis gives the facility to reconcile value flow in FI and
PA, as the reporting base is the cost element.
Additional Information:
In an operating concern, either or both of the types of profitability analysis can be
activated.
Key Message(s):
Example: Johnson & Johnson has grouped its business into three segments –
Consumer Care, Medical Devices & Diagnostics, and Pharmaceuticals. Each
segment has several franchises. For example, Consumer Care business segment
has skin care, hair care, oral care, baby care and so on.
This organisation conducts business across several countries.
• If J & J wishes to analyse how much contribution does the baby care
franchise within the Consumer Care business segment in the APAC region
is adding to the organisation, then profitability analysis could be used to
provide this type of information. In this case, franchise, business segment and
region are the characteristics and contribution is one of the value fields.
• If J & J wants to report P&L-based on the three segments, for management
control, then the three business segments can be treated as profit centre, and
Profit Centre accounting could be used to meet this requirement.
Additional Information:
Note: This illustration is hypothetical to explain the possible uses of the application’s
components.
Revenue Revenue
Sales Deduction Sales Deduction
Cost of Sales Stock changes
Capitalised internal activities
Changes in work in process
Key Message(s):
Cost of sales accounting and period accounting methods are two different
approaches and have two different structures, although they do not impact the net
profit reporting ultimately.
Cost of sales accounting categorises and reports the transaction values – function
wise (administration, Sales 7 distribution, etc.).
Additional Information:
Key Message(s):
Additional Information:
Profit Centre
Product Cost of Good Sold
Costing
Activity Allocation
Overhead Assessment
Management
Settlement
Direct FI Posting
• Costing-
Costing-based in CO-
CO-PA: • Account-
Account-based in CO-
CO-PA:
• Information taken from SD: • Information taken from SD:
– Order is taken or changed (optional) – Good issues is performed
– An invoice for an order is generated – An invoice for an order is generated
11
Key Message(s):
Postings to FI-GL accounts, which are primary cost elements, result in data flow
from FI into CO-PA.
Additionally, transaction processing within the CO module can also result in data
flow into CO-PA; examples: period-end allocations, order settlements.
Settlement of Production Variances into CO-PA and billing information from SD
invoices can update the CO-PA tables.
Line items have to be assigned to an account assignment object “Profitability
segment.”
Additional profitability analysis documents are created to post values into CO-PA.
Additional Information:
Account-Based
Controlling
CO – Profitability Transaction Company Code
Currency Currency Area
Analysis Currency
Costing-
Costing-Based
ased
Operating
CO – Profitability Company Code
Concern
Analysis Currency
Currency
12
Key Message(s):
In costing-based profitability analysis, actual data is updated in the operating
concern currency. Additionally, data can be stored in company code currency for
organisations having multi-national operations. Data in these two currencies can be
stored for legal valuation as well as “profit centre valuation.” Multiple valuation
approaches are activated.
Additional Information:
n
ris
io
t e
eg
ac
ar
Customer
Ch • Revenue
• Cost of goods sold
Key Message(s):
Operating concern, the organisation unit for CO-PA application component is
integrated with other components.
Controlling area is assigned to an operating concern. One or several controlling
areas can be assigned to an operating concern.
Controlling area, by itself, can have one or more company codes assigned to it.
Company code > Controlling Area > Operating Concern.
Transactions are account assigned to a “Profitability segment” and updated in PA.
Additional Information:
Referring to the hypothetical illustration of the J & J case, business segment,
franchise, region, etc. are examples of characteristics. Contribution is a value field.
Key Message(s):
Collection of characteristics and value fields build up the “data structure” for an
operating concern.
Examples of fixed characteristics: Company code and Controlling Area
Additional Information:
Characteristics
15
Key Message(s):
This is a pre-delivered characteristic. Custom characteristics are created with a
prefix WW.
Characteristics are created independent of operating concern.
Additional Information:
Value Fields
• In costing-based Profitability Analysis, value fields
can be either highly summarised (a summary of cost
element balances) or highly detailed (representing
just one part of a single cost element balance).
• There are no fixed value fields for a new operating
concern.
16
Key Message(s):
SAP pre-delivered value fields can be used. If required, a custom value fields can
be included.
Value fields are created independent of operating concern.
Two value field types: amount and quantity
Examples: Invoiced quantity is a value field of Quantity type.
Additional Information:
17
Key Message(s):
Additional Information:
Characteristic Derivation
Concept
• Refers to the system’s attempts to determine
characteristic values for characteristics for all CO-PA-
relevant transactions.
• Supplementing those values determined through the
automatic mappings, derivation can access additional
information (characteristic values) both on and off the
originating transaction.
• For every CO-PA-relevant transactions, the system
attempts to derive a characteristic value for each
characteristic in the operating concern (if derivation
configuration is complete).
18
Key Message(s):
Additional Information:
Characteristic Derivation
Concept (cont.)
• Unsuccessful derivation
Customer Group for characteristic results
CG 1 in the posting of a blank,
null, or unassigned
Customer District State
characteristic value.
C1 D1 S1
• The total combination of
characteristic values for
Product Product Group
a given transaction
P1 PG 1
comprises the definition
Strategic Business Unit
of the relevant
SB 1
Sales Rep. Sales Region profitability segment,
R1 SR 1 which is an account
assignment object for
CO-PA.
19
Key Message(s):
In this illustration, the characteristic for Strategic Business Unit can be derived
based on the values of the other characteristics.
Additional Information:
• Bonuses
FI General ledger postings • Freight costs
20
Key Message(s):
For example, SD invoice has a pricing procedure. Pricing procedure is a collection
of condition types, calculation and posting rules.
Condition type can reflect a pricing/costing element (example: Gross Price or Basic
price can be identified in the pricing procedure with a condition type PR00). Each
condition type can then be assigned to a value field in CO-PA. When the SD invoice
is posted, the condition types receive values. Data flows into CO-PA with the value
fields receiving data from the assigned condition types.
Similarly data flow into value fields are set-up for each source: Cost Estimate in
Product Costing, Cost Centre in Overhead cost management, etc.
Additional Information:
COGS = COGM + direct overhead
COGM = Direct material + labour + other direct costs
Basic Reporting
Contribution Contribution
Region Revenue
Margin 1 Margin 2
Southeast
Characteristic Value
West
Key Message(s):
Standard reports are not available for CO-PA reporting as the data structure itself is
flexible.
Profitability reports have to be custom-designed, although it does not require any
advanced programming knowledge.
In addition to using value fields, key figure schemes can be defined for reporting
requirements. Example for a key figure scheme: Contribution is derived based on
the formula (Revenue – Variable costs). Revenue and variable costs would be a
collection of one or more value fields.
Additional Information:
Knowledge Check
1. What are the types of Profitability Analysis?
2. What are the organisation units in CO-PA?
3. What are the sources in SD invoice for the value
fields?
4. Which element in CO-PA can be used as an
account assignment object during postings?
22
Key Message(s):
Note to faculty: Refer to the Knowledge Checks section in the Faculty Guide for the
answers to these review questions.
Additional Information:
Questions
23
Key Message(s):
Additional Information:
Agenda – Day 4
• Review of Day 3
• Profitability Analysis Overview
• Project System
– Introduction
– Project Structure
– Planning
– Budgeting
– Execution
– Closing
24
Key Message(s):
Additional Information:
25
Key Message(s):
Additional Information:
Key Message(s):
Additional Information:
Phase
Project Structuring Planning Budgeting Execution Closing
Function Definition
Project
Definition
WBS
Rough planning Original budget Material Settlement
Primary costs Updates Service Cost transfers
Unit costing Releases Internal activity
Activity planning
Time
27
Key Message(s):
Additional Information:
Organisational Structure
• The PS module does not have organisational
structures. It uses other modules’ structures (from
Logistics and from Accounting) to present its
information in different ways.
28
Key Message(s):
Additional Information:
29
Key Message(s):
Additional Information:
Questions
30
Key Message(s):
Additional Information:
Agenda – Day 4
• Review of Day 3
• Profitability Analysis Overview
• Project System
– Introduction
– Project Structure
– Planning
– Budgeting
– Execution
– Closing
31
Key Message(s):
Additional Information:
Project Structure
Project Definition: P-9999
P-9999
Work
P-9999-01 P-9999-02 Breakdown
Structure
(WBS)
Networks
32
Key Message(s):
Work breakdown structure forms the basis for organisation and management of a
project.
WBS (work breakdown structure) consists of WBS elements. Each WBS element
represents a task to be performed within a project.
Planning and budgeting activities can be performed for a WBS element.
Revenues/Costs can be posted to a WBS element.
WBS element can be an account assignment object.
Additional Information:
Project Definition
• The first step in a project is project definition.
• At the project definition phase, you identify the project
goals and characteristics.
• PS project definition contains project’s general data.
• Organisational structure data in the PS project
definition:
– Controlling Area
– Company Code
– Business Area
– Profit Centre
– Plant
33
Key Message(s):
Project definition contains general data: name, description, person responsible,
start/end dates, etc.
Key attributes of the projects include planning profile, budgeting profile, investment
profile, assignment of a project to organisational units like controlling area, company
code, profit centre, etc.
Example: Setting up a car manufacturing plant can be defined as a project.
Additional Information:
Key Message(s):
Work breakdown structure represents the tasks to be performed. WBS elements
represent each task to be performed. More importantly WBS element definition of
the task or sub-task should be at a level of detail at which management of the WBS
element is possible and meaningful.
WBS definition should strike a balance between having too many WBS elements or
too few WBS elements within a project definition.
Additional Information:
Note: You can establish start and finish dates for WBS elements.
However, this course does not cover dates.
35
Key Message(s):
WBS element definition has general data: name, person responsible, start/end
dates, etc.
WBS element can also be assigned to organisational data.
WBS element, being cost collectors, can be used as account assignment objects.
Plan/Actual costs and revenues can be posted and assigned to a WBS element.
Additional Information:
Responsible Person
• You can assign a responsible person to each WBS
element.
• Functionalities:
– Reports – You can get project information per
responsible person (via standard reports or changing
reports layout).
– Availability control – The system can be configured to
send an email to the responsible person when actuals
posted to their WBS element exceed a pre-defined
percentage of budget.
36
Key Message(s):
Additional Information:
Responsible Person
Configuration
37
Key Message(s):
Person responsible is created with a code and name. The SAP user name can be
assigned to the person responsible.
Project components, WBS elements for example, can be assigned to a person
responsible.
For certain transaction postings to WBS elements, mail intimation to the person
responsible can be automated to report exceptions like “Budget exceeded”,
“availability control,” etc.
Additional Information:
Path: IMG > Project System > Structures > Operative Structures > Work
Breakdown Structure (WBS) > Specify Persons Responsible for WBS
Elements
Transaction: OPS6
Project Mask
• To be able to codify PS project definition and WBS
elements, you need to define a project mask. It
includes a key and strings:
Key Strings
P -0000-00-XX
38
Key Message(s):
Project masks help to display the project numbers. (0 – numeric characters; X –
alphanumeric characters)
Additional Information:
39
Key Message(s):
Additional Information:
Coding Mask
configuration
40
Key Message(s):
Additional Information:
Path: IMG > Project System > Structures > Operative Structures > Work
Breakdown Structure (WBS) > Project Coding Mask > Define Project
Coding Mask
(Transaction: OPSJ)
Pre
Concept Feasibility Execution Commission
feasibility
Wells Raisers
Well 1, 2, …, n Raiser 1, 2, …, n
Build Drill
41
Key Message(s):
Additional Information:
Key Message(s):
Additional Information:
43
Key Message(s):
Additional Information:
44
Key Message(s):
Additional Information:
Networks
• After establishing the project hierarchy, you can break
down your work packages into tasks (or operations).
At this step, you determine tasks duration and which
tasks are dependent on each other, establishing the
sequence in which they will be performed.
• PS networks present the operational view of the
project.
45
Key Message(s):
Additional Information:
Networks (cont.)
• PS networks functionalities not available for WBS
elements:
– Relationships
– Critical path determination
– Work centres and individual resources planning and
analysis
– Work centres capacity levelling
– Automatic creation of reservation and purchase
requisitions and their integration with networks
scheduling
– Automatic calculation of estimate to complete (ETC)
and forecast
46
Key Message(s):
Additional Information:
Network Objects (1 of 3)
• Network header:
– Contains the network’s general data and data that is
common to all operations and components
• General costs operation:
– Used when you do not know if work will be performed
internally or externally
– Main information: duration and cost
• Internal operation:
– Used when work is performed internally
– Main information: work centre, work, individual
resources (integration with HR)
– Functionalities: resource analysis, capacity levelling
47
Key Message(s):
Additional Information:
Network Objects (2 of 3)
• External operation:
– Used when work is performed externally
– Main information: contract (integration with MM)
– Functionalities: purchase requisition created
automatically to consume the contract assigned
• Services operation:
– Used when work is performed externally
– Main information: services from Service Master Data or
services description + MM information (e.g., Purchasing
organisation, Material group)
– Functionalities: purchase requisition created
automatically to purchase the services assigned
48
Key Message(s):
Additional Information:
Network Objects (3 of 3)
• Material components:
– Assigned to any operation to indicate materials that will be
consumed by the operation
– Functionalities: purchase requisition created automatically
to purchase the materials assigned or reservation created
automatically to consume the materials assigned from stock
• Purchase requisitions and reservations are integrated with
the operations date. If an operation date changes, the
purchase requisition or reservation assigned will have its
delivery date also changed.
• Purchase orders are not integrated with the operations
date as it represents a commitment with the vendor.
49
Key Message(s):
Additional Information:
50
Key Message(s):
Additional Information:
Project Profile
• To be able to create a project in the system, you need
to define a Project Profile.
• The Project Profile puts together a number of other
profiles that define the project’s way of work.
• You will see the Project Profile details after you have
seen the other profiles’ details.
51
Key Message(s):
Additional Information:
52
Key Message(s):
Additional Information:
53
Key Message(s):
Additional Information:
Questions
54
Key Message(s):
Additional Information:
Agenda – Day 4
• Review of Day 3
• Profitability Analysis Overview
• Project System
– Introduction
– Project Structure
– Planning
– Budgeting
– Execution
– Closing
55
Key Message(s):
Additional Information:
WBS Element
Project Funds
Budget
Planned Values
Commitments
Actual Values
AuC
Cost Planning
Key Message(s):
Additional Information:
Planning
• Plan costs are the costs you expect to incur in your
project as it is executed. Project System allows you to
plan costs in different ways:
– Rough planning: total amounts in each WBS by year
– Primary cost elements: total amounts in each WBS by
primary cost element by year
– Unit cost planning: objects and quantities in each WBS
by year (e.g., material, service)
– Activity planning: sender cost centres, activity types
and quantities in each WBS by year
57
Key Message(s):
Additional Information:
Planning Profile
• To be able to plan a project in the Overall Values
transaction (CJ40), you need to define a planning profile.
• It includes bottom-up planning flag; total or annual
planning; planning years; cost elements, sender cost
centres, activity types and other objects allowed in the
project planning.
– You can also plan a project in the Costs and Activities Input
transaction (CJR2). In this case you need to define layouts
and planner profiles (IMG > Project System > Costs >
Planned Costs > Manual Cost Planning in WBS > Detailed
Planning). This functionality is the same as you have
learned for Overhead Management.
58
Key Message(s):
Planning Profile is assigned to a project profile.
Additional Information:
Planning Horizon
59
Key Message(s):
For detailed planning, the corresponding master data (cost element group, cost
centre group and activity group) needs to be maintained in the planning profile.
Additional Information:
Path: IMG > Project System > Costs > Planned Costs > Manual Cost Planning
in WBS > Hierarchical Cost Planning > Create/Change Planning Profile
(Transaction: OPSB)
60
Key Message(s):
Additional Information:
61
Key Message(s):
Additional Information:
Questions
62
Key Message(s):
Additional Information:
Agenda – Day 4
• Review of Day 3
• Profitability Analysis Overview
• Project System
– Introduction
– Project Structure
– Planning
– Budgeting
– Execution
– Closing
63
Key Message(s):
Additional Information:
Budgeting
• Budget is the approved cost structure for a project.
• It is what the management expects from the project
costs over a period of time.
64
Key Message(s):
Additional Information:
Budget Updates
• Supplements (+)
To project
• Returns (-)
• Transfers (+/-)
• Original Budget + Budget $
Updates = Current Budget In project $
From project
65
Key Message(s):
Additional Information:
Budget Releases
• In many businesses, distributing a budget is not the same as
releasing the funds.
• For this reason, the Project System includes a separate
funds release facility, which you can use to make successive
budget releases.
• The release is based on the current budget – that is, the
original budget as amended by budget updates.
Current budget Released budget Management
(2007) (2007) strategy
Key Message(s):
Additional Information:
Availability Control
• Checks Budget X Actuals.
• Actuals can be checked Limits of
against current or tolerance
exceeded
released budget.
Purchase
Documents
Message
Message + Mail to
responsible
Error
67
Key Message(s):
Tolerance limit can be set up for budget availability control. The system checks the
available amount and displays a message (error/warning) if the tolerance limits are
exceeded.
Additional Information:
Budget Profile
• Budget Profile:
– To be able to approve project funds in the system,
you need to define a budget profile.
– It includes overall or annual budgeting, budgeting
years and availability control.
• Limits of tolerance:
– Since you have defined your budget profile, you
have to assign the limits of tolerance for the
availability control to it.
68
Key Message(s):
Budget profile is assigned to a project profile.
Additional Information:
Activation of
availability control
Budget Horizon
69
Key Message(s):
Additional Information:
Path: IMG > Project System > Costs > Budget > Maintain Budget Profiles
(Transaction: OPS9)
70
Key Message(s):
Tolerance limits are defined for a budget profile for a controlling area.
Based on usage (in %), the required action, in case of tolerance being exceeded, is
defined.
Additional Information:
Path: IMG > Project System > Costs > Budget > Define Tolerance Limits
Key Points
• Availability control is activated when the project is
budgeted (status AVAC is defined at the same time
as status BUDG.)
• It means that until the project is budgeted, the system
will not check any actuals posted to it.
71
Key Message(s):
Additional Information:
Key Message(s):
Additional Information:
73
Key Message(s):
Additional Information:
74
Key Message(s):
Status CRTD is set as the initial status.
Status BUDG will substitute CRTD.
Additional Information:
Path: IMG > Project System > Structures > Operative Structures > Work
Breakdown Structure (WBS) > WBS User Status > Create Status Profile
(Transaction: OK02)
75
Key Message(s):
Allowed object types are assigned to the status profile.
In this illustration, WBS element is allowed for this Status profile.
Additional Information:
76
Key Message(s):
For each status, the allowed/not allowed business transactions are defined.
In this illustration, for status CRTD, the Release transaction is not allowed.
Additional Information:
77
Key Message(s):
Additional Information:
Key Message(s):
Additional Information:
79
Key Message(s):
Additional Information:
Questions
80
Key Message(s):
Additional Information:
Agenda – Day 4
• Review of Day 3
• Profitability Analysis Overview
• Project System
– Introduction
– Project Structure
– Planning
– Budgeting
– Execution
– Closing
81
Key Message(s):
Additional Information:
Project Release
• To be able to spend money, a project needs to be
released.
• You do this by changing the project status.
• If it is an investment project, some considerations take
place:
– Assets under Construction exist during the project execution and
increase their values as the project is progressing.
– When the project closes, the Assets under Construction become one
or more Fixed Asset.
– The PS module can create AuCs automatically for each account
assignment WBS with an Investment Profile when you release the
project.
– The Investment Profile includes automatic creation of AuCs; AuC
asset class (AuC characteristics in FI-AA).
82
Key Message(s):
Additional Information:
AUC Managed
In Asset Class,
AuC is set as
“Investment
Measure”
83
Key Message(s):
Additional Information:
Path: IMG > Investment Management > Projects as Investment Measures >
Master Data > Define Investment Profile
(Transaction: OITA)
Budget
Transactions during
execution Planned Values
Purchase Docs Commitments
Down payment
Actual Values
Invoice
Internal Activity
AuC
Cost planning
Key Message(s):
Additional Information:
85
Key Message(s):
Additional Information:
86
Key Message(s):
Additional Information:
Questions
87
Key Message(s):
Additional Information:
Agenda – Day 4
• Review of Day 3
• Profitability Analysis Overview
• Project System
– Introduction
– Project Structure
– Planning
– Budgeting
– Execution
– Closing
88
Key Message(s):
Additional Information:
Settlement
• WBSs are temporary cost collectors, which means
that every cost in the project has to go somewhere
else at the end of each month. You do this via
periodic settlement.
• To be able to settle WBSs periodically, you need to
define a Settlement Profile (IMG > Project System >
Automatic and Periodic Allocations > Settlement >
Settlement Profile). This functionality is the same as
you learned for Overhead Management.
• You also need to define a settlement rule for each
account assignment WBS.
89
Key Message(s):
Additional Information:
Settlement (cont.)
• For the investment projects, when AuCs are created
automatically, settlement rules for these AuCs are
also created automatically after the first periodic
settlement.
• When project closes, AuCs’ costs have to be
transferred to the fixed assets. You do this transfer
via final settlement.
• To be able to run the final settlement, you need to
change the project status to TECO (technically
completed). You also need to add a settlement rule
to the fixed asset to each WBS.
90
Key Message(s):
Additional Information:
Periodic Settlement
• Settlement Profile WBS EIement
Project funds
Budget
Transactions during
execution Planned Values
Purchase Docs Commitments
Down payment
Actual Values
Invoice
Internal Activity Periodic settlement
Asset history
AuC sheet
Cost planning
Key Message(s):
Additional Information:
Final Settlement
• Status TECO WBS Element
Project funds
Budget
Transactions during
execution Planned Values
Asset 1
Purchase Docs Commitments
settlement
Down payment
Final
Actual Values
Invoice Asset 2
Internal Activity Periodic settlement
AuC Asset 3
Cost planning
Asset history
Planned Values Cost Objects Actual Values sheet
92
Key Message(s):
Additional Information:
93
Key Message(s):
Additional Information:
94
Key Message(s):
Additional Information:
Knowledge Check
1. How is the planning horizon for a project
determined?
2. From a planning perspective, what needs to be
setup to have detailed planning for a project –
primary costs, activity type, etc.?
3. How is the budget availability controlled?
4. When the status of the project is set to TECO, what
are the key implications?
95
Additional Information:
96
Key Message(s):
Additional Information:
97
Key Message(s):
Additional Information:
Key Message(s):
Additional Information:
Key Message(s):
Additional Information: