Transcript
Finance in SAP S/4 HANA – General Ledger Accounting (based on S/4HANA 1511)
August’2016
1
TCS Internal
| Copyright © 2015 Tata Consultancy Services Limited
Objective
Objective
The objective of this presentation is to get a brief understanding of what has changed in General Ledger Accounting in S/4HANA. This presentation is relevant for SAP Finance consultant and Solution Architects.
Note: The content in this presentation is subject to change due to continuous change in S/4HANA. Please contact SAP CoE for latest version when needed for customer interaction.
2
TCS Internal
Agenda 01 01
About S/4HANA
02 01
General Ledger Accounting in S/4HANA - Overview 03 01
S/4HANA vs. S/4HANA Finance for GL Accounting 04 01
Process demo 05 01
Configuration demo
06 01
Summary
3
TCS Internal TCS Internal
Agenda
About S/4HANA
4
TCS Internal TCS Internal
SAP S/4HANA On-premise Edition (OPE) S/4HANA S/4HANA on premise edition 1511 11/2016
02/2016
05/2016
S/4HANA on premise edition 1610
Finance and logistics innovations On-premise editions
02/2016
FPS
S/4HANA Finance SAP Simple Finance Add-On 1.0
S/4HANA on premise edition 1503 (aka sFIN 2.0) 03/2015
05/2015
11/2015
S/4HANA on premise edition 1605 (aka sFIN 3.0)
08/2015
05/2016
02/2016
SP level
SP level
5
TCS Internal TCS Internal
Finance innovations
SAP S/4HANA 1511 SAP S/4HANA Compatibility Packs Additional features and applications to enhance specific LoB functions or localization SAP S/4HANA Line of Business for specific SAP S/4HANA Line of Business
industries Industry and line of business specific applications to enhance core functions
Line of business specific applications to enhance core functions
SAP S/4HANA Enterprise Management Core Core solution to manage mission critical processes 6
TCS Internal TCS Internal
Finance in SAP S/4HANA Finance related components in SAP S/4HANA S/4HANA Core
S/4HANA LoB products
SAP Accounting powered by SAP HANA
BPC for S/4HANA (Planning)
SAP Cash Management powered by SAP HANA
SAP Central Finance
7
Name changes Smart finance -> simple finance -> S/4HANA Finance OPE Central journal -> central finance Integrated business planning for finance -> BPC for S/4HANA
TCS Internal
Deployment Architecture
HANA Live/ Embedded Analytics
BO
Fiori
SAP ECC
SAP ECC
HANA DB 1 2 3
Any DB 1 2 3
2
Fiori S/4HANA
HANA DB 1
Any DB 1 2 3
Middleware
HANA Live/ Embedded Analytics
S/4HANA
Non-SAP
3 HANA DB 1
2
3
Simplified Landscape Finance Process
Central Finance 1 Transactions 8
2 Closing
3 Analytics TCS Internal TCS Internal
BO
SAP LT replication server
SAP S/4HANA – Core Changes Suite on HANA SAP ERP
S/4HANA Finance SAP Simple Finance Onpremise edition YYDD
Fiori
HANA DB
SAP ERP
Core changes
HANA DB
S/4HANA ERP SAP ERP
SAP S/4HANA YYDD
Any DB
HANA DB
9
TCS Internal TCS Internal
Agenda
General Ledger Accounting in S/4HANA - Overview
10
TCS Internal TCS Internal
General Ledger Accounting in S/4HANA Universal journal, single source of truth for FI including AA, CO, acct based CO-PA, ML Merged GL account and cost element
11
TCS Internal
General Ledger Accounting in S/4HANA 01 01
Universal Journal
12
TCS Internal
Universal Journal Universal Journal contains financial postings for all transactions within the enterprise Multi GAAP reporting
Ledger approach – one accounting principle is assigned one ledger
Accounts approach – multiple accounting principles are assigned to one ledger
Multi currency reporting
FI, CO currencies updated in Universal Journal
Additional currency types
Types of ledger available in Universal Journal
Leading ledger
Non-leading ledger
Extension ledger
13
TCS Internal
Universal Journal Multiple dimension reporting in Universal Journal
Profit centre, segment, business area, functional area
Characteristics for account based COPA
Custom dimensions
CO postings generated via secondary cost elements are also updated in Universal Journal CO is integrated with FI via version assignment i.e. version ‘0’ is assigned to leading ledger Document splitting is available in Universal Journal
During postings to GL accounts for secondary and primary costs, FI period lock is also checked along with CO period check Real-time FICO reconciliation / Reconciliation ledger obsolete due to merged GL account and cost element
14
TCS Internal
Universal Journal Transaction codes related to newGL are used such as FB50L for postings to single ledger group New types of postings in Universal Journal
COGS split in universal journal based on cost components
Variance analysis in universal journal with variance categories
New transactions for period close
FAGL_FCV - Foreign Currency Valuation- HANA optimization
FAGLGVTR - Balance Carry forward (New)-Single transaction code for GL,AP,AR and AA balance carry forward
New transactions for reporting
FAGLL03H – Line item browser
FAGLB03 – Display balances
FAGLL03 – Display/ change items 15
TCS Internal
Universal Journal During migration from classical GL, data is converted to leading ledger data Restrictions for newGL optimization for S/4HANA conversion
Additional ledgers cannot be added
Splitting cannot be added
Profit centers related restrictions
Development of tool for newGL optimization in in process
16
TCS Internal
Universal Journal Revenue & Costs
Salary posting Depreciation posting Material procurement Overheads – travel, training, stationary Indirect materials Sub-contracting External services Inventory consumption COGS Revenue Cash and Bank …..
Cost centre Internal order Manufacturing Orders
Sales order Projects
Universal Journal Assessment
Settlement Settlement Settlement
Settlement
Direct postings
17
Type of Postings Financial posting Controlling postings
TCS Internal
Reporting dimensions Segment Profit centre Functional area Business area CO objects COPA characteristics
Ledger in Universal Journal Types of Ledger
Standard
Extension
Leading
Non-leading
Normally used for group reporting
Normally used for local GAAP and local tax
18
Extension Ledger (aka appendix ledger)
Used for Management and internal reporting
TCS Internal
Ledger in Universal Journal Extension ledger is used for management/ internal reporting
Assigned to a standard ledger as base ledger
All postings from base ledgers are replicated in the extension ledger
Manual postings can be done in extension ledger which is not updated in base ledger
Posting period variant in extension ledger is different than base ledger. It enables posting for management reporting even if periods are closed for legal accounting
Accounting principle is not assigned to the extension ledger
19
TCS Internal
Ledger in Universal Journal - Example Ledger Group – 0L
Jan-Dec
Key points E1-Extension
0L-Leading Ledger
IFRS
E2-Extension
Apr-Mar E3 Extension
L1-Non Leading Ledger
Ledger Group – Z1 Jan-Dec Local GAAP A1-Non Leading Ledger (Representative ledger)
20
Ledger group is assigned to ledger Extension ledger is assigned to a base ledger, which can be leading or non-leading In case of non-leading ledger has different fiscal year and asset accounting is used, new ledger group would need assignment of two ledgers with two fiscal years
TCS TCS Internal Internal
Currency in Universal Journal Standard Currency Type- These currency types are predefined by SAP 10 Company Code Currency 20 Controlling Area Currency 30 Group Currency 40 Hard Currency 50 Index-Based Currency 60 Global Company Currency Customer Defined Currency Types- name space should start with Y* and Z*
Filled by foreign currency valuation run, manual valuation posting run (Fiori App) or BAPI ACC_DOCUMENT_POST
No dependency on leading ledger
If you want use standard currency type for non leading ledger then the same should be used in leading ledger
21
TCS Internal
Currency in Universal Journal Prior to S/4 HANA
Finance (FAGLFLEXA/ BSEG)
S/4HANA (1511)
Controlling (COEP)
Universal Journal (ACDOCA) TSL
Transaction Currency
WSL
Document Currency
HSL
Local Currency
WRBTR
Transaction currency
WOGBTR
Object Currency
DMBTR
Company Code Currency
WKGBTR
CO Area Currency
KSL
Global Currency
DMBE2
2nd Local Currency
OSL
1st Additional currency
DMBE3
3rd Local Currency
VSL
2nd Additional currency
CO_OSL
22
TCS Internal
CO Object Currency
General Ledger Accounting in S/4HANA 02 01
GL Account and cost element master data
23
TCS Internal
General Ledger Account and Cost Element in S/4HANA All cost elements, primary and secondary, are created during GL account creation
New account types in GL account (refer to next slide for details) Cost element category to be specified in GL master Default cost object assignment no longer possible in cost element master data, must be defined in OKB9 Cost element deletion not possible, GL accounts can be blocked for postings Cost element still updated in master data tables CSKA, CSKB along with SKA1, SKB1 Cost element group can be used like before in reports and in allocation cycles GL accounts for secondary costs are required to be added in account group, financial statement versions Multiple account assignment still possible for P&L accounts
Cost element category 90 is replaced by an indicator ‘apply acct assignment statistically in Fixed Asset/ Material Acct’ 24
TCS Internal
General Ledger Account and Cost Element in S/4HANA GL Account Types
X
Balance Sheet Account
N
Non-operating income or expense
P
Primary cost or revenue
P&L accounts, created with primary cost element category
S
Secondary costs
P&L accounts, created with secondary cost element category
Can be created as statistical cost elements (category 90) in fixed assets and inventory accounts P&L accounts, not created as cost elements
GL account
Demo file: S4 HANA FIN-P01-S4C-FS00 GL Master data creation 25
TCS TCS Internal Internal
General Ledger Account and Cost Element – Obsolete Transactions Area
Description
Removed or New
Automatic Creation of Primary and Secondary Cost Elements [structure node]
Removed
Cost Element Accounting
Create Selection Variants for Cost Elements
Removed
Cost Element Accounting
Define Cost Element Attributes
Removed
Cost Element Accounting
Define Cost Element Attribute Mix
Removed
Cost Element Accounting
Determine Time-Based Fields for Cost Elements
Removed
Cost Element Accounting
Develop Enhancements for Cost Element Master Data
Removed
Cost Element Accounting
Path
26
TCS Internal
Additional Info/ Impact
S/4HANA impact on Chart of Accounts New GL accounts for secondary cost elements
New GL accounts for technical APC accounts in asset accounting Block GL accounts used in reconciliation ledger/ FI-CO real time reconciliation New GL accounts for revenue reporting at condition type level if moving from costing based CO-PA to account based CO-PA New GL accounts for COGS split at cost component level New GL accounts for manufacturing variance split
27
TCS Internal
Agenda
S/4HANA vs S/4HANA Finance for GL Accounting
28
TCS Internal
S/4HANA vs S/4HANA Finance S/4HANA Finance 1503
S/4HANA Finance 1605
S/4HANA 1511
Applicable
Applicable
Applicable
Applicable
Available
Applicable
Business Partner In S/4 HANA business Partner replaces customer/ vendor master. All accounts receivables and payables transactions are reflected against Business Partner
Not applicable
Not applicable
Applicable
General Ledger - Universal Journal Universal Journal is a new ledger is S/4HANA which contains data from FI, CO, ML, AA, Acct based CO-PA
Applicable
Applicable
Applicable
Transfer Prices/ Parallel Delta Versions Multiple valuation approach i.e. group valuation an profit center valuation with transfer pricing
Not available
Available
Not available
Feature Data Model Changes in FIN Line item based processing and reporting Elimination of index and aggregate tables Creation of compatibility views to ensure reporting/ processing as per old data structure Cost Elements Functionality not available in SAP S/4HANA (functional equivalent available)
Note – includes key changes, does not include all
29
TCS Internal
S/4HANA 1503 vs 1605 vs 1511 S/4HANA Finance 1503
S/4HANA Finance 1605
S/4HANA 1511
User defined currency types Additional currency types can be created in addition to SAP standard currency type with following features: 1.Real time currency conversion for all currency types are possible 2. Balance zero guaranteed for each currency Controlling area currency is now calculated for all accounts (also non cost elements) 3. "Clearing like logic" amounts are selected with historical data( supports open item-FIGL,FI-AP,FI-AR and CO & GL allocations. Not support to deprecation, ML and CO settlement) 4. currency in non-leading ledger can be different from leading ledger 5. Currency conversion can be based on any source currency
Not available
Available (with eight freely types currency types)
Available (with three freely types currency types)
Activate derivation for GL items without Profitability Segment Possible to activate the derivation of profitability characteristics for income statement items even if posting is not made to CO-PA
Not applicable
Applicable
Not applicable
Feature
Note – includes key changes, does not include all 30
TCS Internal
Agenda
Process Demo
31
TCS Internal
Demo 01 01
Postings in Universal Journal
Post to expense cost center
Scenario description: A company is needs to report at group level as per IFRS. They also need to report per local tax in Germany. They are using multiple ledgers to manage group and local reporting. The scenario demonstrates posting of various types of expenses, cost allocation and reporting of same Note: Demo is based on S/4HANA 1511
32
TCS Internal
Process flow: posting of expenses to cost center 1
2 Electricity expense posting to facility cost centre
Primary cost
Bank Accountant
4
Cost allocations
Electricity cost centre allocation to production cost centres
3 Post provision for rent expenses via recurring document
Advertisement expense posting to internal order
5 Reject Settlement to COPA for marketing costs
7
6
Reporting
SAP transaction
FI line item display
33
TCS Internal
ABAP query Universal Journal
8 Fiori app
Process demo: posting of expenses to cost center Path/Transact ion Code
Description
Impact /Additional information
FB50
Enter G/L Account Document
Electricity expense posting to facility cost centre
FB03
Display FI document
Display FI document along with cost objects
KSV5
Distribution
Electricity cost centre allocation to production cost centres
FB50
Enter G/L Account Document
Advertisement expense posting to internal order
KO88
Individual Processing
Settlement to COPA for marketing costs
FDS1
Recurring Document
F.14
Execute
SM35
Execute batch
FAGLL03H
Process batch to post recurring document
Recording file S4 HANA FIN-P01S4C_Post to Cost center and allocation (03:22) S4 HANA FIN-P02S4C_Marketing expenses & settlement (02:23) S4 HANA FIN-P03S4C_Recurring Entries (02:01) S4 HANA FIN-R03S4C_FAGLL03H FI line item browser (02:09)
Display line item browser 34
TCS Internal
Demo 02 01
Posting in extension ledger
a) Post document is extension ledger for reversal of expenses
Scenario description: For internal reporting, part of expenses are transferred to a provisional account.
Note: Demo is based on S/4HANA 1511
35
TCS Internal
Process flow – Posting in extension ledger
Bank Accountant
Post to cost centre in ledger EL
Display line items in extension ledger
Path/Transaction Code
Description
FB50L
Enter G/L Account Document for Ledger Group Reject
Manager
FB03
SAP transaction
Compare financial statement in 0L and EL
Impact /Additional information
Approve
Display FI document
36
TCS Internal
Recording file
S4 HANA FIN-P02-S4CReposting in extension ledger (02:27)
Agenda
Configuration Demo
37
TCS Internal TCS Internal
Agenda 01 01
GL configuration demo in S/4HANA a) b) c) d)
Definition and assignment of company code, controlling area, operating concern Ledger and currency set-up Document types and number ranges Data aging
e)
Note: does not include all configuration related of GL accounting
38
TCS Internal
Configuration demo Path
Description
Impact /Additional information
Recording file
SPRO->Enterprise Structure->Definition>Controlling->Create Operating Concern
Create Operation Concern
Represents an organizational unit in company for which the sales market has a uniform structure. It is the valuation level for Profitability Analysis (CO-PA).
S4 HANA FIN-1-S4CDefine Operating Concern(00.11)
SPRO->Enterprise Structure->Definition>Financial Accounting->Edit, Copy, Delete, Check Company Code
Define Company code
It will give legal reporting and any other local reporting .
S4 HANA FIN-2-S4CDefine Company Code (00:46)
SPRO->Financial Accounting (New)>General Ledger Accounting (New)>Master Data->G/L Accounts>Preparations
Define chart of accounts
Chart of accounts will provide all list of GL accounts. Chart of accounts can be used different company codes.
S4 HANA FIN-3-S4CDefine and assign Chart of accounts(00:54)
SPRO->Enterprise Structure->Definition>Controlling->Maintain Controlling Area
Define Controlling area
Controlling area provides information for internal management decision.
S4 HANA FIN-4-S4CDefine Controlling Area (00:12)
Assign number ranges for none leading ledgers.
Common transactions same document type and number ranges can be used for leading and none leading ledger. For none leading ledger specific postings a different document type will be assigned.
S4 HANA FIN-5-S4CDocument types and number ranges (00:45)
SPRO->Financial Accounting (New)>General Ledger Accounting (New)>Document->Document Types->Define Document Types for Entry View in a Ledger
39
TCS Internal
Configuration demo Path
Description
Impact /Additional information
Recording file
SPRO->Financial Accounting (New)>Financial Accounting Global Settings (New)->Ledgers->Fiscal Year and Posting Periods->Posting Periods>Define Variants for Open Posting Periods
Define variants for open posting periods
Separate posting period variant needs to be assigned. For extension ledger it should different from base ledger.
S4 HANA FIN-6S4C-Posting period variant (00:24)
Define accounting principles for parallel accounting
Accounting principles are defined for each GAAP which is to be implemented in general ledger. This configuration is required to be done in both parallel ledger and parallel accounts approach.
S4 HANA FIN-7S4C-Define Accounting principles (00:26)
New transaction - Ledgers are created and assigned to company codes. Currencies, accounting principle, fiscal year variant is defined for the ledgers
S4 HANA FIN-8S4C-Define ledgers and currency settings (02:53)
SPRO -> Financial Accounting (New) > Financial Accounting Global Settings (New) -> Ledgers ->Parallel Accounting -> Define Accounting Principles SPRO->Financial Accounting (New)>Financial Accounting Global Settings (New)->Ledgers->Ledger->Define Settings for Journal Entry Ledger
Define Settings for Journal Entry Ledger
40
TCS Internal
Configuration demo Path SPRO-> Financial Accounting (New)> Financial Accounting Global Settings (New)->Ledgers->Define Ledger Group
SPRO -> Financial Accounting (New)>Financial Accounting Global Settings (New)->Ledgers>Integration of Controlling with Financial Accounting
Description
Impact /Additional information Parallel ledger approach: ledger groups are assigned to different ledger.
Define ledger group and assign ledgers to ledger group
Parallel accounts approach: ledger groups are assigned to same ledger. New transaction: a)Define and assign document type for financial postings originated due to CO transactions b)Possible to define default ledger for CO. If default ledger is blank, data originated during CO transactions is posted to all ledgers c)Version ‘0’ assigned to leading ledger. Data from the ledger assigned to version 0 is used for all CO transactions
Integration of Controlling with Financial Accounting [structure node]
41
TCS Internal
Recording file S4 HANA FIN09-S4C-Define ledger group (00:41)
S4 HANA FIN10-S4CIntegration of Controlling with Financial Accounting (01:13)
Configuration demo Path
Configuration Node
Additional information
Demo file
Financial Accounting (New) -> Financial Accounting Global Settings (New) -> Tools > Data Aging for Accounting Documents
Define Life for Account Types
Specify document life in days for the company code and account type
S4 HANA FIN-11-S4C-FI Data aging (00:29)
Define Life for Document Types
Specify document life in years and days for the company code and document type
42
TCS Internal
Demo 02 01
List of impacted configuration transaction in S/4HANA
43
TCS Internal
Impacted IMG transactions – new / removed/ replaced Area
Path
Description
Removed or New
Additional Info/ Impact
FI global settings (new)
Ledgers Fields -> Standard Fields -> Functional Area for Cost of Sales -> Accounting -> Enter Functional Area
Enter Functional Area in Cost Element Master Data
Removed
Functional area derived via substitution OR via account assignment object OR via GL account OR can be entered during financial posting
FI global settings (new)
Ledgers -> Fields -> Customer Fields
Display Scenarios for General Ledger Accounting
Removed
Available by default. However, activation of specific functions might be required. For example – cost of sales accounting activation required for functional area
FI global settings (new)
Ledgers
Real-Time Integration of Controlling with Financial Accounting [structure node]
Removed
No need of real time integration as FI and CO data is posted to single table ACDOCA (universal Journal)
44
TCS Internal
Impacted IMG transactions – new / removed/ replaced Area
Path
FI global settings (new)
SPRO-Financial Accounting (New)->Financial Accounting Global Settings (New)->Ledgers>Define Ledgers for General Ledger Accounting
FI global settings (new)
FI global settings (new)
SPRO-Financial Accounting (New)->Financial Accounting Global Settings (New)->Ledgers>Define Currencies of Leading Ledger SPRO-Financial Accounting (New)->Financial Accounting Global Settings (New)->Ledgers>Define and Activate NonLeading Ledgers
Description
Removed or New
Define Ledgers for General Ledger Accounting
Removed
Define Currencies of Leading Ledger
Removed
Define and Activate Non-Leading Ledgers
45
Removed
TCS Internal
Additional Info/ Impact New configuration node ‘Define Settings for Journal Entry Ledger’ New configuration node ‘Define Settings for Journal Entry Ledger’ New configuration node ‘Deactivate Ledger for a Company Code’
Impacted IMG transactions – new / removed/ replaced Area
Path
Description
Removed or New
Additional Info/ Impact
FI global settings (new)
Ledgers -> Integration of Controlling with Financial Accounting
Integration of Controlling with Financial Accounting [structure node]
New
a) Define and assign document type for financial postings originated due to CO transactions b) Possible to define default ledger for CO. If default ledger is blank, data originated during CO transactions is posted to all ledgers c) Version ‘0’ assigned to leading ledger. Data from the ledger assigned to version 0 is used for all CO transactions
FI global settings (new)
Ledgers -> ledger
Define Settings for Journal Entry Ledger
FI global settings (new)
Ledgers -> ledger
Deactivate Ledger for a Company Code
Ledgers are created and assigned to company codes. Currencies, accounting principle, fiscal year variant is defined for the ledgers
New
Non-leading ledgers can be deactivated for a company code for future years
New
46
TCS Internal
Impacted IMG transactions – new / removed/ replaced Area
Path
Description
Removed or New
FI global settings (new)
Ledgers -> ledger
Assign Scenarios and Customer Fields to Ledgers
Removed
FI global settings (new)
Document -> Document types
Define Document Types for General Ledger View
Removed
FI global settings (new)
Document -> Document number ranges
Documents in General Ledger View [structure node]
Removed
General Ledger Accounting (New)
Master Data -> G/L Accounts
Create Cost Elements
Removed
General Ledger Accounting (New)
Periodic Processing -> Allocation
Define Field Usage for Distribution/ assessment
Transaction GCA6 has been replaced by transaction GLGCA6
General Ledger Accounting (New)
Periodic Processing
Rollup [structure node]
removed
47
TCS Internal
Additional Info/ Impact
FAGLFLEXT table replaced by ACDOCT view which is based on ACDOCA table
Impacted IMG transactions – new / removed/ replaced Area
Path
Preparations for Consolidation (New)
Basic Settings -> Assign Scenarios and Customer Fields to Ledgers -> Assign Scenarios and Customer Fields to Ledgers
Financial Accounting Global Settings (New)
Tools -> Data aging for accounting documents
Description
Removed or New
Additional Info/ Impact
Removed
Specify the minimum number of days before accounting document can be moved to cold area
48
Data aging replaces archiving function New
TCS Internal
Consistency should be maintained during definition of the age for the source document, related objects and accounting document.
Agenda 01
Summary
49
TCS Internal
Summary Universal Journal
S/4HANA Innovations (what is new) Universal Journal with integrated data model for FI, CO, AA, Acct based COPA, ML Integrated legal and management accounting with merged GL account and cost element Extension ledger for management reporting
50
TCS Internal
In CONCLUSION…S/4HANA Core Changes & Benefits Fiori
Core Changes
Simplified business process
Real time analytics
Improved user experience 51
Improved performance TCS Internal TCS Internal
Simplified architecture
Thank You A presentation by TCS EntSol - SAP CoE For more information on this presentation, mailto:
[email protected] OR
[email protected]
Last updated on 24-08-2016
IT Services Business Solutions Consulting