S4 Financial Planning With SAC V24
S4 Financial Planning With SAC V24
Public
Disclaimer
The information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP.
Except for your obligation to protect confidential information, this presentation is not subject to your license agreement or any other service
Or subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or any related
document, or to develop or release any functionality mentioned therein.
This presentation, or any related document and SAP's strategy and possible future developments, products and or platforms directions and
functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information in this
presentation is not a commitment, promise or legal obligation to deliver any material, code or functionality. This presentation is provided
without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a
particular purpose, or non-infringement. This presentation is for informational purposes and may not be incorporated into a contract. SAP
assumes no responsibility for errors or omissions in this presentation, except if such damages were caused by SAP’s intentional or gross
negligence.
All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from
expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates,
And they should not be relied upon in making purchasing decisions.
Public 2
Agenda
Further Information
Public 3
Overview and Architecture
Mapping of Planning Areas to SAP Products
Logistics Planning Financial Planning
P&L
Demand Planning Profitability Planning
Planning
SAP S/4HANA
Product Cost
Detailed Scheduling MRP Cost Rates
Estimate
Public 5
SAP Analytics Cloud – SAP S/4HANA Integration : Architecture
Plan operations
SAP S/4HANA
Public 6
Integration of Integrated Financial Planning with Group Financial Planning
Group Financial Planning Use group data for planning – master & transaction data
Use entity actuals as start for planning - master & transaction data
Public 7
Basic Equation
Public 8
SAP Analytics Cloud for Planning
SAP Analytics Cloud - SaaS Platform
Public 10
SAP Analytics Cloud - Core BI Workflow
▪ Prepare and model cloud and on premise ▪ Design, visualize, and create your ▪ Simply collaborate with your team
data from your browser stories live ▪ Take action on your data
▪ Connect to data from SAP (SAP S/4HANA, ▪ Add simple location analytics into your ▪ Use permissions to control who can view
SAP BW, SAP HANA, SAP Apps, etc.) and visualizations and edit your analytics
non-SAP sources ▪ Personalize your own dashboard views
▪ Support linking aggregated data
▪ Cross dataset calculations
Public 11
SAP Analytics Cloud - Core Planning Workflow
▪ Simply create and modify calculations ▪ Analyze, plan and visualize in the same ▪ Enjoy a new generation of planning in the
and planning models and on the fly application cloud with a modern look and feel
▪ Take action anytime, anywhere on the ▪ Personalize your KPIs, dashboard, ▪ Plan and simulate at any level of detail, with
desktop or on the go processes and stories any number of users, at any time
▪ Align plans across finance and ▪ Collaborate in-context of your plan and ▪ Drive high performance planning and
business units with direct integration make faster decisions forecasting process
into SAP Business Planning and
Consolidation
Public 12
Models
Easy set up
• Models with multiple dimensions are easy to
create in an Excel-like interface
Preview Panel
• Visual representation of your modeled data
Data Import
• Upload of external data sources and integration
with SAP Cloud and on premise systems
Public 13
Stories
Version Management
• Create and copy versions of data and define
access rights
Formatting
• Create, personalize fixed reports and visualizations
Visualization
• Context-specific visualization proposals
Public 14
Private Versions
Feature
▪ Planning done in private versions for
individuals or teams and then published
as a public version for everyone to view
Benefit
▪ Changes can be made to private version and then
easily discarded or shared (i.e., publish)
as needed
Example
▪ Analyst wants to model some sales promotion
scenarios using private model prior to sharing with his
colleagues
Public 15
Direct Entry
Feature
▪ Adjust value in a report view by directly entering
this value at parent or base level
or by adding by %
Benefit
▪ Can directly enter plan change at various levels
or change them by a certain % to streamline plan
adjustments
Example
▪ Purchasing manager wants to estimate cost
saving by switching vendors to lower raw
material costs
Public 16
Direct Entry and Collaboration
Collaboration
Manual changes
Public 17
Hierarchies and Disaggregation
Change value
Public 18
Distribution and Spreading
Feature
▪ Distribution and spreading allows users to quickly From node to childs From member to siblings
extend a plan to other dimensions such as time,
products or regions
Benefit
▪ Simple dialogs guide the user through the distribution
and spreading process and preview adjusted
amounts for maximum efficiency
Example
▪ Analyst may want to distribute some internal costs to
other regions manually to refine an allocation that
was previous performed
Public 19
Currency Conversion
Feature Currency
▪ Ability to plan in global, local and transactional currency Conversion
▪ Currency conversion on the fly via virtual “conversion measures” in the Measure
model
▪ Currency conversion persisted via currency conversion steps in a data
action
Public 20
Allocations
Feature
▪ The allocation functionality allows users to define rules for
source and target data spreading
Benefit
▪ Create allocation rules within the application without the
requirement for complex script-based modeling
Example
▪ Analyst wants to spread shared services costs across other
cost centers based on user defined rules
Public 21
Allocation Execution
Public 22
Advanced Formulas
Public 23
Planning Process Management
Attach Story
Public 24
SAP S/4HANA Integration
Create Communication Arrangement in SAP S/4HANA Cloud
Create communication arrangement based on SAP
delivered communication scenario SAP_COM_0087
Note: In SAP S/4HANA On Premise, use service activation in Gateway and PFCG to create the role
Public 26
Create SAP S/4HANA Connection in SAP Analytics Cloud
Connection name
Enter User
Enter Password
Public 27
Select OData Service
Public 28
Create Master Data Query Based on OData Service
Define Filter
Public 29
Result: Account Master Data with Hierarchy in SAP Analytics Cloud
Public 30
Create Transaction Data Query Based on OData Service
Public 31
Result: Same Data in SAP S/4HANA and SAP Analytics Cloud
Public 32
Export Plan Data from SAP Analytics Cloud to SAP S/4HANA
Target dimensions
Define Filter
Public 33
SAP Delivered Sample Content for
Integrated Financial Planning
Data Flow
Integrated Financial Planning for SAP S/4HANA & S/4HANA Cloud
Financial Statement Planning Reporting / Analytics Capital Expense Planning Reporting / Analytics
▪ One central access point for all stories of the Integrated Financial Planning content
Public 36
Operating Expense Planning Details
Sales & Profitability
CAPEX Planning
Planning
Cost Center Expense Cost Center Activity Type Cost Center Activity Price Product Cost
Cost Center Allocation
Planning Splitting Calculation Planning
Fix / Variable Fix / Variable
Inverse Calculation
of Activity Quantities
Resource
Calculation
Public 37
Cost Center Expense Planning
Public 38
Cost Center Overhead Allocation
Driver
Result
Overhead Allocation
▪ Either with a fixed allocation account
▪ Or with a flexible account mapping that
allows to assign different expense accounts
to different allocation accounts like with an
allocation structure in the classic financial
planning
Public 39
Allocation Rules for Activity Type Splitting
Public 41
Activity Type Splitting for Expenses
Public 42
Fix / Variable Splitting for Expenses
Split to fix / variable
▪ Either automatic according to
Allocation Rule
▪ Or directly via manual input
Public 43
Calculate Variable Costs from Activity Output
288000 = 24000 * 12
▪ Copy activity quantities either from Actuals or read from resource planning
▪ Planning of capacities also possible
Public 45
Activity Output Quantity Planning by Partner
Public 47
Integration with Workforce Planning
Copy Expenses from Workforce Plan (left side) to Cost Center Plan (right side)
Public 48
Cost Center Analytics
Public 49
Project Expense Planning
Public 50
Project Activity Input Planning
Plan activity consumption of WBS element from sending cost center / activity type
▪ Cost are calculate from activity cost rate of the sending cost center
Public 51
Allocate Project Costs
Public 52
Product Cost Planning Details Product
Cost Estimate
(SAP S/4HANA &
S/4HANA Cloud)
Sales and
Sales Quantity
Sales Quantities Quantity Structure Product Cost Rates Profitability
Planning
Planning
Universal
Journal (SAP
S/4HANA &
S/4HANA
Cloud) Raw Material Inventory Raw Material Price Planning
Balance Sheet
Public 53
Cost Estimate with Quantity Structure
▪ Based on Lot Size
▪ Cost Estimate from SAP S/4HANA is the basis for Product Cost Planning in SAP Analytics Cloud
▪ The quantity structure shows the quantitative relation between a finished or semi-finished product and the
corresponding raw material / cost center activities
Public 54
Raw Material Prices
Public 55
Activity Cost Rates
Public 56
Plan Manufacturing Overheads
Public 57
Calculate Product Cost Rates
Public 58
Product Cost Analytics
Public 59
Cost Center Resource Calculation
▪ Based on the sales quantities and the quantity structure, the total cost center activity output is calculated
▪ The total activity output is needed in cost center planning
Public 60
Raw Material Resource Calculation
▪ Based on the sales quantities and the quantity structure, the total raw material quantity consumption is
calculated (Credit)
▪ The purchased raw material quantity can be copied from last years actuals and manually adjusted (Debit)
Public 61
Raw Material Inventory Changes
▪ The raw material purchase and consumption quantities are multiplied with the raw material price
▪ The difference (purchase – consumption for production) can be moved later on to the balance sheet
Public 62
Sales & Profitability Planning Details
Predictive Accounting
- Universal Journal Quantity Parameter Sales Deduction
Sales Price Planning
(SAP S/4HANA & Setting Percentage Planning
S/4HANA Cloud)
Universal Journal
(SAP S/4HANA & Sales Quantity Planning Profitability Planning
S/4HANA Cloud)
Public 63
Sales Quantity Planning
▪ Simple approach: Copy actual quantities from last year as starting point
▪ Other approaches: Copy sales quantities from SAP Integrated Business Planning or Consumer Products
Sales Planning (see slides below)
Public 64
Sales Quantity Planning: Control Parameters
▪ Define on a certain level (e.g. customer/product/period) how proposal for plan quantities shall be
generated
▪ E.g. rolling average from actuals, predictive accounting, previous month plan, growth rate from previous
month plan, etc.
Public 65
Sales Prices
▪ Planning proposal calculated as average from actual revenues and sales quantities
Public 66
Sales Deduction Percentages
Public 67
Product Cost Rates
▪ Derive product cost rates either from
actuals or read from product cost planning
Public 68
Product Profitability
▪ Valuate sales quantity plan with sales prices, deduction percentages and product cost rates
Public 69
Allocation of Sales & Admin Costs
• Operational expenses on cost centers can be allocated to products in the profitability plan
• This typically is done for costs that are not routed through product cost planning but nevertheless should be visible on
product level
• Allocation factors here are derived from the product gross revenue
Public 70
Multi-Level Contribution Margin on Market Segments
▪ Contribution margin 1 - Gross margin
– Includes only cost of goods sold
▪ Contribution margin 2 - Operating income
– Includes sales & admin costs from allocation
Public 71
Integration with SAP Integrated Business Planning (SAP IBP)
Public 72
Integration with SAP Integrated Business Planning (SAP IBP)
▪ Import SAP IBP consensus demand plan as basis for sales quantity planning within Integrated Financial
Planning
▪ Perform Sales and Profitability Planning within Integrated Financial Planning
▪ Write back revenue and cost of goods sold to SAP IBP for decision support in management business review
Public 73
Integration with Consumer Products Sales Planning
▪ Import sales quantities from CP Sales Planning as basis for sales quantity planning within Integrated
Financial Planning
▪ Perform quantity unit conversion into the base unit of the products
▪ Perform Sales and Profitability Planning within Integrated Financial Planning
Public 74
Quantity Unit Conversion
Public 75
Capital Expense Planning Details
Balance Sheet Planning
Public 76
Capital Expense Planning - Baseline
▪ Plan extraordinary investments (Delta) on an investment account / cost center / profit center / period level
▪ Calculate depreciations
Public 78
Capital Expense Planning
Parameter Setting
Public 81
P&L Planning
▪ Starting point
– “Standalone”: Actuals from last year
– “Integrated”: Underlying profitability and OPEX plans
Public 82
Balance Sheet Planning - Manually
Public 84
Balance Sheet Report
Public 85
Cash Flow Statement
▪ Calculated from P&L and Balance Sheet
▪ Using both direct and indirect method
▪ Compare both methods in “Validation Balance”
Public 86
Financial Statement Analytics
Public 87
Financial Statement KPIs
Public 88
Financial Statement Target Planning
P&L Target
Public 90
End-to-End Demo Story
• Implements a sample process within a single story that guides through Integrated Financial Planning in 14 steps
Public 91
End-to-End Demo Story
Jump to home screen Click sequentially through the 14 steps
Jump to documentation
Public 92
Simulation Cockpit
Starting Point
• A finished, reconciled, integrated Financial Plan
• As described in the steps before
What-if simulations
• Change dedicated drivers, e.g. sales quantities, raw materials prices or expenses
• Recalculate the integrated plan up to P&L, Balance Sheet and Cash Flow statement
• “Save as” into simulation versions
Implementation/Adaptation
• Simulation Cockpit is implemented as an Analytical Application in SAP Analytics Cloud
• It can be adapted by the customer for other simulation scenarios
Public 93
Simulation Cockpit: Raw Material Price Simulation
Public 94
Simulation Cockpit: Raw Material Price Simulation
Public 95
Simulation Cockpit: Sales Simulation
Public 96
Simulation Cockpit: Expense Simulation
Public 97
SAP Delivered Sample Content for
Greenhouse Gas Emission Planning
GHG Protocol Scopes and Emissions across the value chain
Source: https://www.ghgprotocol.org/sites/default/files/ghgp/standards/Scope3_Calculation_Guidance_0.pdf
Public 99
Data Flow
Greenhouse Gas Emission Planning for SAP S/4HANA & SAP S/4HANA Cloud
Financial Statement CO2e
Product CO2e
Sales Quantity
Product CO2e
Planning
Emission Factors
Raw Material CO2e Factor
(SAP Sustainability CO2e Product Rate Quantity Structure
Planning
Footprint Mgmt)
planned
Cost Center CO2e
Activity Quantity CO2e Activity Cost Rate Cost Center CO2e
Allocations
Planning Calculation Calculation
Product CO2e
Corporate CO2e Financial Statement CO2e Raw Material CO2e
Cost Center CO2e
Public 101
CO2e Valuation
Product CO2e
Corporate CO2e Financial Statement CO2e Raw Material CO2e
Cost Center CO2e
Public 102
Raw Material CO2e Valuation
Public 103
Cost Center CO2e Factors
Public 104
Cost Center CO2e Valuation
Public 105
Corporate CO2e
Public 106
CO2e Allocation
Product CO2e
Corporate CO2e Financial Statement CO2e Raw Material CO2e
Cost Center CO2e
Public 107
CO2e Allocation
Products
Public 108
Overhead Allocation between Cost Centers
Public 109
Activity Allocation between Cost Centers
Public 110
CO2e Activity Rate
Public 111
CO2e Product Rate
Public 112
Allocate Sales & Admin CO2e to Products by Revenue
Public 113
CO2e Analytics
Product CO2e
Corporate CO2e Financial Statement CO2e Raw Material CO2e
Cost Center CO2e
Public 114
Raw Material CO2e
Public 115
Cost Center CO2e
Public 116
Product CO2e
Public 117
CO2e in Financial Statement
Total CO2e
Public 118
“CO2e-Flow” Statement
Public 119
Relation to Classic Financial Planning
in SAP S/4HANA On Premise
“Classic” and “New” Financial Planning: Architecture
COSP_BAK,
ACDOCP
COSS_BAK
Transfer programs
COSL
SAP S/4HANA
On Premise 1909
COST See note 3118397 ACCOSTRATE
COSR FINSSKF
Public 121
“Classic” and “New” Financial Planning: Transfer Programs
Public 122
“Classic” and “New” Financial Planning: Building Blocks
Classic Planning New Planning
Building Block SAP S/4HANA SAP S/4HANA SAP Analytics Cloud
(COSP_BAK/COSS_BAK, COST, (ACDOCP, ACCOSTRATE, FINSSKF)
COSR)
Typical Setup
• SAP Analytics Cloud is the primary planning tool, complete financial planning is done in SAP Analytics Cloud
• After planning round is finished, plan data, activity cost rates and statistical key figures are exported to SAP S/4HANA
• Embedded Analytics (e.g., plan-actual comparisons) runs in SAP S/4HANA
• In certain scenarios Universal Allocation is used in SAP S/4HANA
– When it is crucial that actual an plan allocation run with the same rules and when it is too much effort to replicate
the allocation rules between SAP Analytics Cloud and SAP S/4HANA
– When required allocation features are missing in SAP Analytics Cloud
• Transfer programs between new tables (ACDOCP, ACCOSTRATE, FINSSKF) and classic tables are not needed
Public 124
“Classic” and “New” Financial Planning:
Scenario 2: SAP Analytics Cloud Combined with Classic Planning
Typical Setup
• In a transition phase, migrate some planning areas to SAP Analytics Cloud and leave others with classic
planning
• Move planning results from new planning to classic planning to be consumed in processes like activity
confirmation or cost estimate
• Leave dedicated planning tasks with classic planning, e.g., activity cost rate calculation with iteration and cost
component split
• Use data transfer programs between classic and new planning
Public 125
Manage Financial Plan Data in
SAP S/4HANA
Manage Financial Plan Data
Import
Steer Import
Compatibility Validation
Steer Checks
Transfer
Steer Copy
Report
ACDOCA ACDOCP
Extensibility
Derivation
Zero
Public 127
Import Financial Plan Data
Public 128
Copy Financial Plan Data
Use
▪ With this app you can select financial plan data in a source category and copy it to
a target category
Key Features
You can use this app to
▪ Search for existing financial plan data by entering values in the filter fields.
You need to at least enter a value in the field Plan Category. The plan data in the
table is adjusted whenever you change an entry in a filter field
▪ Copy financial plan data from a source category to a target category.
Select the data you want to copy by filling in the filter values as described above
and copy the data to a target plan category. If your target category already contains
data for the filter selections you entered for the fields Ledger, Ledger Fiscal Year,
Fiscal Period, and Company Code, the data of the target category will be
overwritten by the data that is copied from the source category. In particular data in
the target category that matches the filter values for which no corresponding source
data exists will be deleted
Effects on Configuration
▪ It must be possible to copy data into the plan categories that are used. This means
that the plan categories must be flagged as Copy Allowed in the Maintain Category
for Planning configuration step
Public 129
Delete Financial Plan Data
Public 130
Compress Financial Plan Data
Use
▪ The app allows you to reduce the number of plan data items stored in
planning table ACDOCP. Note that the application does not delete
existing plan data. Only the history of changes is deleted. After
compression, all plan data remains consistent
Value Proposition
▪ Using this app to compress plan data can reduce the size of table
ACDOCP, which can improve the overall performance of planning
processes
Public 131
Import Statistical Key Figure Plan Data
Use
▪ A statistical key figure is a number providing information about non-monetary data
relating to organizational units. Statistical key figures can be used as reference data
for universal allocation. For more information, see Statistical Key Figures
▪ Use this app to upload statistical key figure plan data stored in a comma-separated
values file (CSV file). The app allows you to perform your planning in an external
system, such as Microsoft Excel. As a key user, you can use the Custom Analytical
Query app to create a report based on the released I_FinStatisticalKeyFigureItem
DDL view that allows you to view your uploaded plan data
Key Features
You can use this app to
▪ Import statistical key figure plan data records stored in a CSV file
▪ Automatically validate all values from the CSV file before the import
Public 132
Public API “Financial Plan Data – Write” for Data transfer into ACDOCP
Use
▪ This service enables you to write financial plan data from one system to another
through an API call. It is based on an OData service and can be consumed by
external systems or user interfaces in a financial plan data scenario in SAP
S/4HANA. You can only post financial plan data. For master data, specific OData
services are available
▪ With this service, it is not possible to read, update or delete financial plan data or
search based on filters
Service Structure
▪ The service metadata file can be retrieved through
/sap/opu/odata/SAP/API_FINPLANNINGDATA_SRV/$metadata
▪ The service Message Header (optional) contains information on the service, the
involved sender and receiver as well as date and time. The entities contain the
business data of the service
Public 133
Flexibility, Adaptability, Extensibility
SAP Analytics Cloud and SAP S/4HANA – Modeling Objects and Adaptability
Overall design, Arrangement of
charts, grids and functions, …
Story
Documentation
Public 137