FI-GL Planning using SAP BPC. Avi Dear Solution Architect BPC Practice YASH Technologies

FI-GL Planning using SAP BPC

Avi Dear

Solution Architect – BPC Practice

YASH Technologies

Agenda

• What is SAP BPC? • What is SAP BPC RDS

• Scope of GL Financial Planning • Users of GL Financial Planning • Architecture & Core Data Structure

• Complete Data Extraction Cycle: ECC>BW>BPC • Demo

YASH Technologies - Quick Facts

•

•

•

•

•

•

rf

Quick Facts

Flexible. Stable. Agile. Customer-Centric.

Mid Size Organization

Quick to respond to customer’s changing business climates

Same Vision of Success –

Flexibility

Realignment and innovation based on customer’s priorities

Customer Centric

Partnership Model

Delivering the right solution to achieve the maximum business results

Enterprise Performance Management (EPM) Suite

• Strategy Management

• Business Planning and Consolidation (Yash Focus)

• Financial Consolidation

• Disclosure Management

• Notes Management

• Intercompany Reconciliation

• Financial Closing Cockpit

• Profitability and Cost Management

• Spend Performance Management

• Supply Chain Performance Management

• Sales and Operation Planning (Yash Focus)

• Asset Analysis

• Technical Perspective

Enterprise Performance Management (EPM) Suite

Business Perspective

BPC is 2-in-1 Business Planning &

Financial Consolidation Application

Part of SAP EPM (Enterprise Performance

Management) Suite

Planning and Consolidation share

common objects

User-level activities are done via EPM

add-in to Excel

Technical Perspective

BPC Cubes and objects installed are

within the NW environment

Actual data from ECC first flows via BW

Cubes before flowing to BPC i.e.

ECC>BW>BPC

Consolidation Planning IFRS GAAP Local GAAP Matrix FI-G/L Headcount S&OP Cost Cen US GAAP

SAP BPC is a 2-in-1 Application

BPC within SAP NW Enterprise Data warehouse (EDW)

SAP Netweaver Portal Any Portal, Any Destination

SAP BEx _Explorer Crystal Reports Web Intelligence Xcelsius

SAP Business Objects Enterprise

SAP Netweaver Business Warehouse

SAP BW _{SAP BPC}

Data Integrator Data Quality Management

Data Services

3rd _{Party Databases and Applications}

CRM SCM SRM PLM Data Quality Mgmt ERP Financials Operations Human Resources Corporate Services

SAP Business Suite

Read-Opti

mized

Write

Opti

mized

What Is included in RDS

• RDS are full-fledged demo environments created by – SAP and Partners

• Data Model • Environments • Applications • Dimensions • Business Rules/Logic • Reports

Business Perspective

• Complete solution within a Fixed

Cost & Time Budget

• No need for gathering

• Internal requirements,

• RFP, RFQ, POC

• Determines strategy for additional

implementation based on Variance

Analysis

• Any area which has maximum

variance should be the next

implementation target

Technical Perspective

• Complete technical build, leveraging

current ECC/BW environment,

includes :

• Cubes

• Info Objects

• Process Chains

• Packages

• Package Links

• Transformation Files

• Conversion Files

• Input and Output Templates

Project Plan with Yash and Customer Responsibility

Prepare Project Kick off workshop Select Options Confirm Installation End-user Training and Organization Change Management Hand over of solution

Go-live and Support Activate Solution

Confirm Activation Implement Options Train Key Users Set up Customer Data Switch to QA User Acceptance Testing Switch to Production

Start Deploy Run

1 2 3

YASH involvement Customer involvement

Complete Income Statement &

Balance Sheet Planning

Supported by Matching Actual Data

from New GL

for

Planning Based

on

Actual-Plan Comparison

FI-GL RDS Benefits

Financial Planning can be supported

by multiple sub-plans

SAP BPC as System of Engagement links to

SAP ECC as System of Record

RDS Audience – Supports

Following Type of Users:

Profit Center Planners Cost Center Planners

Balance Sheet Planners

Operations, Sales and finance management team and executives

Business process scope covered

in

SAP Business Planning and Consolidation

Load Actuals from Source Systems

into

SAP Business Planning and Consolidation

Compare Plan and Forecasts with Actuals

In

SAP Business Planning and Consolidation

M o n t h l y P l a n n i n g C y c l e i n S A P B u s i n e s s P l a n n i n g a n d C o n s o l i d a t i o n

Demo

•

Solution in detail

•

Financial Planning Model

•

Data Integration Model

•

Master Data

•

Transaction Data

•

Templates for Financial Planning & Analysis

•

Output Templates (Reports)

3-Part Implementation

Financial Planning Model

Data Integration Model

Master Data

Transaction Data

Templates for Financial Planning & Analysis

Output Templates (Reports)

Input Templates

Financial Planning Model

What’s Included

Business Benefit

●

Optimized cube based on SAP

ECC:

●

Planning model: covers

financial statement planning and

analysis

●

Rate model: covers

planned foreign exchange

●

Master data tables leverage

key structures already

available in the new G/L in

SAP ECC

●

Best-practice financial

planning data model based on

the new G/L structure of SAP

ECC

●

Documented process to

restore the planning model into

the customer environment

●

Ability to create flexible

financial reports based on data

in BPC

Data Integration Model

Financial Planning Model

Data Integration Model

Master Data

Transaction Data

Templates for Financial Planning & Analysis

Output Templates (Reports)

Input Templates

Data Integration Model

What’s Included

Business Benefit

● Robust data integration

●Automated master data load process for key master data tables based on SAP ECC:

● Account ● Company ● Cost center ●Functional area ● Profit center ● Trading partner

●Support for one hierarchy load for:

●G/L account,

●Cost center and

●Profit Center

●Advanced delta-load process for

●New G/L transaction data

● Faster implementation due to:

● Predefined integration

● Planning process supported by:

● Replication of ECC structures

● Hierarchies

●Load current ECC hierarchies

● User-Interface

●User-friendly interface for the monthly planning process

●FULL load

●No need after delta capabilities from Service Pack 4 onwards

●Integration

●Now implement integration with ECC in week rather than months

Actual Data Flow Extraction of Transaction Data

• BPC

Staging

• BPC

Planning

• BW

Reporting

• ECC

Templates for Financial Planning &

Analysis

Financial Planning Model

Data Integration Model

Master Data

Transaction Data

Templates for Financial Planning & Analysis

Output Templates (Reports)

Input Templates

Demo

of

FI-GL RDS

for

BPC

Package Link is a collection of Package- Each backed by

Process Chains: Data Collection

Extraction of Number of Records to BW and BPC match

 Number of records extracted to 0FIG_C10 from ECC

Demo

•

Solution in detail

•

Financial Planning Model

•

Data Integration Model

•

Master Data

•

Transaction Data

•

Templates for Financial Planning & Analysis

•

Output Templates (Reports)

•

Trend

•

Variance

•

Reconciliation

Demo

•

Solution in detail

•

Financial Planning Model

•

Data Integration Model

•

Master Data

•

Transaction Data

•

Templates for Financial Planning & Analysis

•

Output Templates (Reports)

•

Input Templates

•

Cost Center Input Template

•

Profit Center Input Template

Wrap-Up



SAP BPC FI G/L RDS is the best way to start planning



Based on Variance Analysis of each line item, detailed

level planning can be undertaken.



The infrastructure build with this RDS will continue to

be of value even in the detailed level planning.



It is the best ROI for your Time & Effort.



Most SAP implementation partner will offer a fixed-bid

offer for this RDS implementation

Questions?

Contact Details:

Avi Dear

Senior BPC Architect, YASH Technologies

[email protected]

THANK YOU FOR PARTICIPATING

For ongoing education on this area of focus,

visit ASUG.com