Table of Contents

Open all
Close all
Preface
15
Target Audience
15
Book Structure
16
Acknowledgments
18
1 Introduction to Business Reporting with SAP S/4HANA
19
1.1 The What: Introduction to Business Reporting
19
1.1.1 Guiding Principles, Global Requirements, and Drivers
20
1.1.2 Reporting Taxonomy
22
1.2 The Why: Build the Case for Business Reporting with SAP S/4HANA
24
1.2.1 Review Your Pain Points and Envision Your Future
24
1.2.2 Identify the Scope
27
1.2.3 Tap into SAP S/4HANA Embedded Analytics and SAP Fiori
31
1.3 The How: Establish Business Reporting with SAP S/4HANA
37
1.3.1 Architecture and Integration
37
1.3.2 Deployment Options
41
1.4 Summary
41
2 The User Experience
43
2.1 SAP’s New User Experience
43
2.1.1 Design Principles
43
2.1.2 SAP Fiori Apps
45
2.1.3 SAP Fiori Launchpad
47
2.2 SAP Fiori Analytics Powered by SAP S/4HANA Embedded Analytics
53
2.2.1 Extensibility
55
2.2.2 Key User Tools
56
2.3 Summary
66
3 Financial Reporting Use Cases
67
3.1 Financial Reporting Requirements
67
3.2 Ledger-Based Reporting
69
3.2.1 Minimum Setup Requirements in SAP S/4HANA
69
3.2.2 Multi-Ledger
72
3.2.3 Multi-Entity
77
3.2.4 Multi-Currency
78
3.2.5 Enable Restatements
81
3.2.6 Enable Simulation
84
3.2.7 Custom Dimensions
86
3.3 Finance Operations-Based Reporting
90
3.3.1 Minimum Setup Requirements in SAP S/4HANA
90
3.3.2 Finance Operations-Based Analytics
92
3.3.3 Receivables by Top Customers
97
3.3.4 Receivables by Risk Class and Credit Segment
99
3.3.5 Analysis by Overdue Receivables/Payables Ratio
102
3.3.6 Future Receivables and Payables
104
3.3.7 Days Payable Outstanding Insights
107
3.3.8 Days Sales Outstanding Insights
111
3.3.9 Aging Analysis
113
3.4 Asset Accounting-Based Reporting
114
3.4.1 Minimum Setup Requirements in SAP S/4HANA
114
3.4.2 Analytics Based on Fixed Assets
116
3.4.3 Parallel Valuation-Based Analytics
117
3.5 Financial Statements-Based Reporting (Balance Sheet/Income)
120
3.5.1 Minimum Setup Requirements in SAP S/4HANA
121
3.5.2 Financial Statement Insights Using Key Performance Indicators
123
3.5.3 Financial Statements by Financial Statement Version and Financial Statement Item Node
125
3.5.4 Financial Statements by Business (Profit and Loss and Balance Sheet)
128
3.5.5 Financial Statements by Semantic Tags
131
3.6 Financial Cash Flow-Based Reporting
134
3.6.1 Cash Flow Statement: Indirect Method
135
3.6.2 Cash Flow Statements by Semantic Tags
138
3.7 Summary
141
4 Management Reporting Use Cases
143
4.1 Profitability-Based Reporting
144
4.1.1 Minimum Setup Requirements in SAP S/4HANA
144
4.1.2 Product Profitability by Product Sold
147
4.1.3 Product Profitability by Customer Group and Region
150
4.1.4 Margin Analysis by Market Segments
152
4.1.5 Profitability Analysis by Custom Dimensions Region
157
4.1.6 Gross Margin-Based Profitability Analysis
159
4.1.7 Profitability Analysis and Reporting via Custom Key Performance Indicators
163
4.2 Responsibility-Based Reporting
169
4.2.1 Minimum Setup Requirements in SAP S/4HANA
169
4.2.2 Profit Center-Enabled
171
4.2.3 Cost Center-Enabled
177
4.2.4 Functional Area-Enabled
182
4.3 Multiple Valuation-Based Reporting
184
4.3.1 Minimum Setup Requirements in SAP S/4HANA
185
4.3.2 Single Valuation Ledger-Based Reporting
188
4.3.3 Multi-Valuation Ledger-Based Reporting
190
4.3.4 Material Valuation-Based Reporting
193
4.3.5 Operational Inventory Valuation
194
4.4 Restatements-Based Reporting
197
4.4.1 Restatements by Profit Centers
197
4.4.2 Restatements by Extension Ledgers
202
4.5 Summary
203
5 Consolidation Reporting Use Cases
205
5.1 Consolidation Reporting Requirements
206
5.2 Group Data Analysis
208
5.2.1 Minimum Setup Requirements in SAP S/4HANA
208
5.2.2 Group Data Analysis by Financial Statement Item in Group Currency
212
5.2.3 Group Data Analysis Using Reporting Item Hierarchies
215
5.2.4 Group Data Analysis Using Multiple Group Currencies
219
5.2.5 Group Data Analysis Using Posting Levels
223
5.2.6 Validation Result Analysis for Consolidation Units and Consolidation Groups
227
5.2.7 Group Financial Statements for Cash Flow
233
5.3 Intercompany Elimination Analysis
242
5.3.1 Consolidation Reporting and Interunit Elimination Reporting between Consolidation Units
242
5.3.2 Interunit Elimination Analysis between Segments
244
5.4 Summary
245
6 Reconciliation-Based Reporting Use Cases
247
6.1 Reconciliation Reporting Requirements
247
6.2 Reconciliation by Balances
249
6.2.1 Minimum Setup Requirements in SAP S/4HANA
250
6.2.2 Reconciliation Balance Reporting between Trading Companies
252
6.2.3 Reconciliation Balance Reporting in Multiple Currencies
259
6.2.4 Reconciliation Reporting with Balance Carryforward Amounts
264
6.2.5 Up to Now (Year-to-Date) versus Month-on-Month Comparison Reporting
266
6.2.6 Reconciliation Balance Reporting between Consolidation Units
268
6.3 Reconciliation by Reporting Dimensions
274
6.3.1 Reconciliation Reporting by Region/Country Hierarchy
274
6.3.2 Reconciliation Reporting Using Multiple Dimensions
278
6.4 Reconciliation Close Reporting
282
6.4.1 Reconciliation Close between Consolidation Units
282
6.4.2 Reconciliation Close Analysis Using the Reconciliation Status Overview App
284
6.5 Summary
286
7 Statutory/Compliance Reporting Use Cases
287
7.1 Statutory/Compliance Reporting Requirements
287
7.2 Indirect Tax Reporting
289
7.2.1 Minimum Setup Requirements in SAP S/4HANA
289
7.2.2 Document and Reporting Compliance Analytics
292
7.2.3 Run Compliance Reports by Reporting Entity
300
7.2.4 Define Compliance Reports for Customized Requirements
306
7.2.5 Use of SAP Tax Compliance for SAP S/4HANA
315
7.3 Direct Tax Reporting
317
7.3.1 Minimum Setup Requirements in SAP S/4HANA
317
7.3.2 Corporate Income Tax Framework
319
7.4 Summary
319
8 Procurement Use Cases
321
8.1 Procurement-Based Reporting Requirements
321
8.2 General Purchase Order Reporting and Analytics
322
8.2.1 Minimum Setup Requirements in SAP S/4HANA
322
8.2.2 Real-Time Reporting and Monitoring for Procurement
325
8.2.3 Analyze Purchasing Spend Key Performance Indicators
329
8.2.4 Purchase Order-Based Analytics Using Delivery Status
333
8.2.5 Purchase Requisition-Based Analytics
335
8.3 Operational Purchasing Analysis Using Dashboards and Measures
340
8.3.1 Off-Contract Spend Analysis
340
8.3.2 Non-Managed Spend Analysis
343
8.3.3 Analyze Supplier Performance Scenarios
345
8.3.4 Spend Variance Analysis
352
8.3.5 Purchasing Spend Analytics Using the SAP Analytics Cloud-Based Dashboard
353
8.4 Summary
357
9 Sales Use Cases
359
9.1 Sales-Based Reporting Requirements
359
9.2 General Sales Order Reporting and Analytics
360
9.2.1 Minimum Setup Requirements in SAP S/4HANA
360
9.2.2 Real-Time Reporting and Analytics of Sales Activities
364
9.2.3 Order to Cash Analytics Using Dashboards
381
9.3 Delivery Performance Analysis Using Dashboards and Measures
384
9.3.1 Analyze Delivery Performance of Sales Orders
384
9.3.2 Delivery Performance Using Delivery as Committed Ratio and Delay of Committed Delivery (Days)
389
9.3.3 Delivery Performance Using the Blocked Status of Delivery and Billing
391
9.4 Fulfillment-Based Reporting
392
9.5 Summary
397
10 Hierarchy-Based Reporting Use Cases
399
10.1 Hierarchy-Based Reporting Requirements
399
10.2 SAP S/4HANA and the SAP Fiori Approach to Enable Hierarchy Reporting
400
10.2.1 Minimum Setup Requirements in SAP S/4HANA
401
10.2.2 SAP Fiori Apps, SAP Fiori Roles, and Required Master Data
401
10.3 Accounting Hierarchy-Based Reporting Use Cases
403
10.3.1 Cost Center Hierarchy
403
10.3.2 Profit Center Hierarchy
408
10.3.3 Flexible Hierarchies
413
10.3.4 Financial Statement Version
419
10.3.5 Time-Dependent Hierarchies
424
10.3.6 Universal Allocations Hierarchy
427
10.3.7 Custom Hierarchies
431
10.3.8 Bank Account Hierarchies
435
10.4 Logistics Dimension-Based Hierarchies
438
10.4.1 Product Hierarchy and Customer Hierarchy
438
10.4.2 Plant Hierarchy
441
10.4.3 Division and Sales Org Hierarchy
442
10.5 Summary
444
11 Self-Service and Key Performance Indicator-Based Use Cases
445
11.1 Ad Hoc Reporting Requirements
445
11.2 End-to-End Approach for Extensibility
446
11.3 Self-Service and KPI-Based Business Use Cases in SAP S/4HANA
449
11.3.1 Flexible Reporting with Variants and Bookmarks
449
11.3.2 Create Custom Reports with Customized Core Data Services Views
456
11.3.3 Enhance Cost Center - Actuals App Using the Custom Analytical Queries App
458
11.3.4 Enhance Cash Flow Statement by Custom Reporting Structures
463
11.3.5 Build an EBIDTA Statement Key Performance Indicator Using Semantic Tags
470
11.3.6 Build a Gross Profit Key Performance Indicator Report Using Semantic Tags
482
11.4 Summary
487
12 SAP Analytics Cloud-Based Business Reporting
489
12.1 Prerequisites
489
12.2 Standard Business Content-Based Reporting
492
12.2.1 Introduction to Standard Business Content in SAP Analytics Cloud
492
12.2.2 Reporting with SAP Analytics Cloud Stories
493
12.2.3 Reporting with Digital Boardrooms
497
12.3 Enhanced Content-Based Reporting
499
12.3.1 Enhance Cost Center Budgeting Story
499
12.3.2 Enhance SAP Analytics Cloud Stories with Customized Formulas
503
12.4 Example of Finance Models, Stories, and Digital Boardrooms
505
12.5 Summary
507
13 Implementation
509
13.1 Integrated Business Reporting
509
13.1.1 Integration Options for SAP Fiori, SAP Analytics Cloud, and SAP Analysis for Microsoft Office
510
13.1.2 Roles and Authorizations
511
13.2 Deployment Perspectives
513
13.2.1 “SAP Fiori First” Approach
513
13.2.2 Embedded versus Hub Scenario for SAP Fiori
514
13.2.3 Central Access Point for SAP and non-SAP Solutions
518
13.3 Implementation Best Practices
518
13.3.1 Decision Matrix
519
13.3.2 Aggregated Implementation of SAP Fiori Apps
520
13.3.3 Sizing
521
13.4 Learning Resources
522
13.5 Summary
523
The Author
525
Index
527