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