[go: up one dir, main page]

0% found this document useful (0 votes)
315 views137 pages

S4 Financial Planning With SAC V24

SalesTaxMasterSheet01_STT_SirTariqTunio

Uploaded by

arhamusmani000
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
315 views137 pages

S4 Financial Planning With SAC V24

SalesTaxMasterSheet01_STT_SirTariqTunio

Uploaded by

arhamusmani000
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 137

SAP S/4HANA

Integrated Financial Planning


With SAP Analytics Cloud
SAP
February 19, 2024

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

Overview and Architecture

SAP Analytics Cloud for Planning

SAP S/4HANA Integration

SAP Delivered Sample Content for Integrated Financial Planning

SAP Delivered Sample Content for Greenhouse Gas Emission Planning

Relation to Classic Financial Planning in SAP S/4HANA On Premise

Manage Financial Plan Data in SAP S/4HANA

Flexibility, Adaptability, Extensibility

Further Information
Public 3
Overview and Architecture
Mapping of Planning Areas to SAP Products
Logistics Planning Financial Planning

Logistics Planning (SAP IBP / SAP APO / …) SAP Analytics Cloud

Sales and Revenue Balance Sheet


Marketing Planning Sales Planning
Planning Planning

P&L
Demand Planning Profitability Planning
Planning

Production Cost Cost & Activity


S&OP
Planning Planning

SAP S/4HANA
Product Cost
Detailed Scheduling MRP Cost Rates
Estimate

BOM and Routing

Public 5
SAP Analytics Cloud – SAP S/4HANA Integration : Architecture

Plan operations

Public dimensions Plan Data

SAP Analytics Cloud

OData Service OData Service OData Service OData Service

Master Data ACDOCA Cost Estimate ACDOCP ACCOSTRATE FINSSKF

New Availability Universal


Actual Postings Cost Estimate Predictive Allocation
Check

Embedded Manage Financial


CPM Projects Production Orders Group Reporting
Analytics Plan Data

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

SAP Analytics Cloud


Universal Journal - Consolidation
Group Financial Planning Content
Transfer plan to SAP S/4HANA Cloud or S/4HANA on group
object level

Access entity actuals


& plan data for consolidation

Transfer plan to SAP S/4HANA Cloud or


S/4HANA on operational object level SAP Analytics Cloud
Universal Journal - Actuals Universal Journal - Plan Integrated Financial Planning
Content

Use entity actuals as start for planning - master & transaction data

Public 7
Basic Equation

Planning Tool (SAP Analytics Cloud)


+ SAP S/4HANA Integration (SAP S/4HANA Connector)
+ Financial Planning Content
+ Flexibility
= SAP S/4HANA Financial Planning

Public 8
SAP Analytics Cloud for Planning
SAP Analytics Cloud - SaaS Platform

Public 10
SAP Analytics Cloud - Core BI Workflow

Connect and prepare Visualize and build


Share with your team
your data your own views

▪ 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

Simplify Experience Trust

▪ 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

A model is a representation of business data


to define relationships, calculations, and
data of an organization or business
segment

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

Stories are an organized representation


of data, comprising multidimensional data
views for the purpose of analysis, reporting,
and planning

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

Currency conversion settings in the model

Currency Conversion Step

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

Set due date

Attach Story

Create task and assign user

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

Communication system brings in the technical user for


the connection.

Automatically a role for the user is generated with the


authorization to access the OData services of the
communication scenario

These are the URLs of the OData services. URL root is


needed to maintain the SAP S/4HANA connection in
SAP Analytics Cloud

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 URL of the SAP S/4HANA system

Enter User

Enter Password

Public 27
Select OData Service

Public 28
Create Master Data Query Based on OData Service

Select description and


attributes

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

SAP S/4HANA SAP Analytics Cloud

Public 32
Export Plan Data from SAP Analytics Cloud to SAP S/4HANA
Target dimensions

Map source dimension

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

Cash Flow Planning Balance Sheet Planning CAPEX Planning

P&L Planning Depreciation Planning

Sales & Profitability Planning Reporting / Analytics


Management Business
Sales Prices Planning Sales Revenue & Review
Profitability Planning
Consumer Products (CP) Deductions Planning (SAP IBP)
Sales Plan
(SAP Analytics Cloud)
Deductions Percentage
Sales Quantity Planning
Planning
Consensus Demand Plan
(SAP IBP)
Product Cost Planning Reporting / Analytics
Product Cost Estimate Raw Material Price Planning
(SAP S/4HANA & S/4HANA
Cloud)

Resource Planning &


Quantity Structure Product Cost Planning
Calculation

Operating Expense Planning Reporting / Analytics

Activity Price Planning & Workforce Planning


Activity Quantity Planning Calculation Operating Expenses Cost Center Expenses
(SAP Analytics Cloud)

Activity Type Split Allocations Project Expenses

Activity Cost Rates Statistical Key Figures


(SAP S/4HANA & (SAP S/4HANA &
Public S/4HANA Cloud) S/4HANA Cloud) 35
Landing Page

▪ One central access point for all stories of the Integrated Financial Planning content
Public 36
Operating Expense Planning Details
Sales & Profitability
CAPEX Planning
Planning

Operating Expense Planning Reporting / Analytics

Statistical Key Figure


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

Indirect Activity Allocation


Universal Journal
(SAP S/4HANA &
S/4HANA Cloud) Cost Center Activity Price Cost Center Activity Cost Center Cost
Planning Quantity Planning Calculation

Resource
Calculation

Project Activity Quantity


Project Expense Planning Project Cost Calculation Project Cost Allocation
Planning

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

Connect Source and Target Dimensions via Driver Measure


Public 40
Statistical Key Figure as Driver for Activity Type Splitting

Public 41
Activity Type Splitting for Expenses

Create expense data


on cost center / activity type
level
▪ Either via allocation rule
▪ Or directly via manual input

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

This is an alternative to fix / variable splitting


▪ Maintain proportionality factor between activity quantity
output and expense account
Public 44
Activity Output Planning

▪ Copy activity quantities either from Actuals or read from resource planning
▪ Planning of capacities also possible
Public 45
Activity Output Quantity Planning by Partner

Plan sender – receiver based activity quantities


▪ Directly via manual input. Receiver can be cost centers or WBS elements
▪ Split to cost centers according to allocation rule (“indirect activity allocation”)
▪ Inverse calculation according to the activity output of the receiving cost centers
Public 46
Activity Cost Rate Calculation

Activity Cost Rate Calculation


▪ Either with a single G/L account assigned,
i.e. without splitting
▪ Or with a flexible account splitting that
allows to assign different expense and
allocation accounts to different activity cost
rate accounts. This corresponds to the
primary cost component split in the classic
financial planning
▪ If needed, additional split to fix / variable
portion
▪ Iteration possible in case of multi-level or
cyclical activity consumption

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

Plan expenses on WBS element / G/L Account / Period level

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

Allocate project costs to receiving cost centers

Public 52
Product Cost Planning Details Product
Cost Estimate
(SAP S/4HANA &
S/4HANA Cloud)

Product Cost Planning Reporting / Analytics

Sales and
Sales Quantity
Sales Quantities Quantity Structure Product Cost Rates Profitability
Planning
Planning

Cost Center Resource Raw Material Resource Planning


Activity Cost Rates
Calculation & Calculation

Universal
Journal (SAP
S/4HANA &
S/4HANA
Cloud) Raw Material Inventory Raw Material Price Planning

Balance Sheet

Cost Center Planning

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

▪ Proposals are derived from Cost Estimate

Public 55
Activity Cost Rates

▪ Derive activity cost rates either from


cost estimate or read from cost
center plan
▪ In the latter case, splitting of activity
cost rates can be taken over

Public 56
Plan Manufacturing Overheads

▪ Proposals are derived from Cost Estimate

Public 57
Calculate Product Cost Rates

▪ COGS accounts are derived from the original G/L accounts

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

Sales & Profitability Planning Reporting / Analytics

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)

Product Cost Rates

Consumer Products (CP)


Consensus Demand Plan
Sales Plan Product Cost Planning
(SAP IBP)
(SAP Analytics 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

▪ Planning proposal calculated as average from actual deductions and revenues

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

Capital Expense Planning Reporting / Analytics

Asset Acquisition Asset Acquisition


Baseline Planning Delta Planning
Universal Journal
(SAP S/4HANA &
S/4HANA Cloud)
Depreciation Depreciation Calculation
Baseline Planning Delta Planning

Operating Expense Planning

Public 76
Capital Expense Planning - Baseline

▪ Starting point: Actuals from last year


▪ Create new baseline
– Adjust asset additions on an investment account / profit center / period level
– Adjust depreciations on an investment account / cost center / profit center / period level
Public 77
Capital Expense Planning - Delta

▪ Plan extraordinary investments (Delta) on an investment account / cost center / profit center / period level
▪ Calculate depreciations
Public 78
Capital Expense Planning

▪ Report baseline and delta together


▪ Planned asset acquisition can be transferred to balance sheet plan
▪ Planned depreciations can be transferred to cost center planning
Public 79
Capital Expense Planning

▪ Set depreciation parameters: Method and Percentage


Public 80
Financial Statement Planning Details

Sales & Profitability Planning Operating Expense Planning

Financial Statement Planning Reporting / Analytics

Parameter Setting

Universal Journal (SAP


S/4HANA & S/4HANA P&L Planning Split by Trading Partner
Cloud)

Driver Based Planning Balance Sheet Planning Cashflow

CAPEX Planning Raw Material Inventory

Public 81
P&L Planning

▪ Starting point
– “Standalone”: Actuals from last year
– “Integrated”: Underlying profitability and OPEX plans
Public 82
Balance Sheet Planning - Manually

▪ Copy Actuals from last year as starting point


▪ Copy over asset acquisitions from CAPEX plan and raw material inventory changes from resource plan
▪ Manual adjustments for changing or closing values
Public 83
Balance Sheet Planning – Driver Based
▪ Derive DSO and DPO
from last year actuals as
starting point
▪ Manually adjust DSO
and DPO
▪ Calculate Receivables
and Payables

Public 84
Balance Sheet Report

▪ Balance sheet counter accounts for the P&L are calculated


▪ Plan Balance Sheet automatically is in sync

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

Balance Sheet Target Cash Flow Target

P&L Target

▪ Target Setting on group level in group currency


▪ Across company code, optionally on profit center level
▪ Disaggregate the targets to company code level
Public 89
Financial Statement Target Planning
▪ Currency conversion between group
and local currency
▪ Version comparison between bottom
up and target plan in local and group
currency
▪ Switch the UI between different sign
handlings
– Accounting (database view):
revenues negative, costs positive
– Profitability view: revenues positive,
costs negative
– Depending on the account, both
revenues and costs can be shown
positive

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

Click on the arrows to jump directly to a step

Jump to documentation

Run data actions

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

Financial Statement CO2e

Product CO2e

Sales Quantity
Product CO2e
Planning

Raw Material CO2e


Raw Material Raw Material CO2e
Resource Planning Calculation

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

Cost Center CO2e Factor Cost Center CO2e Factor


Activity Type Splitting
Planning Activity-Based Planning Spend-Based

CO2e Activity Rates Activity Quantity


Expense Planning
(SAP S/4HANA & SAP Planning
Public S/4HANA Cloud 100
GHG Emission Planning on Top of Integrated Financial Planning

Product CO2e
Corporate CO2e Financial Statement CO2e Raw Material CO2e
Cost Center CO2e

CO2e Valuation CO2e Allocation

Expenses Quantity Structure

Integrated Financial Planning

Public 101
CO2e Valuation

Product CO2e
Corporate CO2e Financial Statement CO2e Raw Material CO2e
Cost Center CO2e

CO2e Valuation CO2e Allocation

Expenses Quantity Structure

Integrated Financial Planning

Public 102
Raw Material CO2e Valuation

Raw Material Factors

Raw Material CO2e

Public 103
Cost Center CO2e Factors

CO2e Factors – Spend Based

CO2e Factors – Activity Based

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

CO2e Valuation CO2e Allocation

Expenses Quantity Structure

Integrated Financial Planning

Public 107
CO2e Allocation

Products

Quantity Structure based

Manufacturing Cost Centers Revenue Based

Overhead Allocation Activity Allocation

Supporting Cost Centers

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

CO2e Valuation CO2e Allocation

Expenses Quantity Structure

Integrated Financial Planning

Public 114
Raw Material CO2e

Total raw material CO2e not


used for production

Credit: CO2e for raw material


consumed for production

Debit: CO2e of purchased raw


material

Public 115
Cost Center CO2e

Flow of electricity CO2e from supporting to production cost center

Public 116
Product CO2e

Product CO2e via Quantity


Structure

Sales & Admin CO2e allocated


from Cost Centers

Public 117
CO2e in Financial Statement

Total CO2e

Raw material CO2e not used for


production

CO2e of sold products

CO2e from OPEX

Public 118
“CO2e-Flow” Statement

Total CO2e – “direct method”

Total CO2e – “indirect method”

Raw material CO2e not used for


production

CO2e of sold products

CO2e from OPEX

Public 119
Relation to Classic Financial Planning
in SAP S/4HANA On Premise
“Classic” and “New” Financial Planning: Architecture

Classic Planning New Planning


(SAP S/4HANA On Premise Only) (SAP S/4HANA Cloud and On Premise)

“Classic” CO “Classic” CO Embedded Universal SAP


Reporting Planning Analytics Allocation Analytics
(KP06, …) Cloud

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

SAP Analytics Cloud SAP S/4HANA On Premise

Expenses and Activity


Activity Quantity Quantities COSP_BAK,
Planning COSS_BAK
ACDOCP
Expense Planning
Capacity
COSL
Allocations

Activity Cost Rate Activity Cost Rates


Planning ACCOSTRATE COST KEPH

Activity Cost Rates with Split

Statistical Key Figure


Planning FINSSKF Statistical Key Figures COSR

“New” Planning “Classic” Planning

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)

Manual Planning Report Painter - Stories


Distribution Allocation Processor Universal Allocation Allocation
Assessment Allocation Processor Universal Allocation Allocation
Activity Type Split Allocation Processor - Allocation
Indirect Activity Allocation Allocation Processor - Allocation
Activity Price Calculation Allocation Processor, stored in Imported from SAP Analytics Cloud, stored in Scripting
COST ACCOSTRATE
Settlement Settlement Processor - Allocation
Assessment from Cost Objects to Allocation Processor Universal Allocation Allocation
Profitability
Top-Down Distribution CO-PA - Allocation
Valuation with sales price, CO-PA valuation - Scripting
deductions and product cost rate
Revaluation, Forecast and other CO-PA planning function - Scripting
generic planning functions in
Profitability Planning
Availability Control Old availability control New availability control -
Statistical key figures Stored in COSR Stored in FINSSKF Stories
Reporting Report Painter Embedded Analytics Stories
External Interfaces BAPI App “Import Financial plan data”, OData service, RFC File Import, OData, BW, SQLDB, …
Public 123
“Classic” and “New” Financial Planning:
Scenario 1: SAP Analytics Cloud Only

Scenario appropriate for


• For SAP S/4HANA Cloud customers
• For new SAP S/4HANA On Premise customers
• For customers migrating to SAP S/4HANA On Premise that want to implement a new planning solution

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

Scenario appropriate for


• For customers migrating to SAP S/4HANA On Premise that want to modernize the existing, classic planning
implementation

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

Steer Curr. Trans.

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

Predefined functions, own logic,


Planning Grids or Charts Data Action distributions, allocation, …

Layout (Rows, Columns, Filters)


Model

Definition of granularity (e.g.,


SAP S/4HANA Connector product group, product level …)

OData Service OData Service OData Service Additional Sources or changed


queries …
CDS
CDS Views CDS Views
Views
Additional fields …
SAP S/4HANA SAP S/4HANA SAP S/4HANA
Actual Data Master Data Planning Data
Additional fields …
Public 135
Further Information
Further Information

Overview Blog Post


• https://blogs.sap.com/2022/10/18/integrated-financial-planning-an-overview/

Documentation

• SAP S/4HANA On Premise: Financial Planning


https://help.sap.com/docs/SAP_S4HANA_ON-
PREMISE/48f4b4785b8e45938ac44a67be8032d9/debbbd61f0f141f9b0d552e9c5062aa3.html

• SAP S/4HANA Cloud: Financial Planning


https://help.sap.com/docs/SAP_S4HANA_CLOUD/1cbcff7ccd35405ab445b223c1ab1588/debbbd61f0f141f9b0d5
52e9c5062aa3.html

Public 137

You might also like