Preface

15

Objective of the Book

15

Target Audience

16

Structure of the Book

16

Acknowledgments

19

1 Introduction

21

1.1 History of SAP BW/4HANA

21

1.2 SAP BW/4HANA Overview and Design Principles

22

1.3 Eclipse and SAP HANA Studio

26

1.3.1 Installing SAP HANA Studio

27

1.3.2 Installing SAP BW/4HANA Modeling Tools

31

1.3.3 Adding an SAP BW/4HANA System

33

1.4 Overview of Operational Data Provisioning

35

1.4.1 ODP Features and Architecture

35

1.4.2 Introduction to ODP SAP Extractors

38

1.4.3 Data Extraction Essentials

41

1.4.4 Data Acquisition Process in ODP

42

1.4.5 Monitoring

45

1.5 Summary

54

2 Data Modeling in SAP BW/4HANA

57

2.1 Creating InfoAreas

57

2.2 Creating Source Systems

58

2.3 Creating Flat File Sources

60

2.4 Creating a DataSource

61

2.5 Creating InfoObjects

66

2.6 Creating Transformations

74

2.7 Creating a Data Transfer Process

76

2.8 Creating Key Figures

83

2.9 InfoObjects Advanced Properties

85

2.9.1 Usable as InfoProvider

85

2.9.2 Enhanced Master Data Update

86

2.9.3 Enable External View

89

2.10 Creating Advanced Data Store Objects

91

2.11 Creating an SAP HANA Composite Provider

99

2.12 Creating an SAP BW Query

102

2.13 Summary

105

3 Creating an Operational Data Provisioning Source System

107

3.1 Introduction to Source Systems

107

3.1.1 Logical System

108

3.1.2 Creating Background Users for SAP BW/4HANA Extraction

110

3.1.3 RFC Destination

113

3.2 Creating an ODP Source System

115

3.2.1 SAP BW/4HANA and ODP Source System Types

115

3.2.2 Creating an ODP Source System for SAP S/4HANA and SAP ERP

117

3.2.3 Creating ODP Source in SAP BW Context

121

3.2.4 Creating an ODP Source System in an SAP HANA Context

124

3.2.5 Creating an ODP Source System in a CDS View Context

127

3.2.6 Access Local SAP HANA Database Schema

129

3.3 Summary

132

4 Working with SAP Extractors

133

4.1 Introduction to SAP Extractors

133

4.2 SAP-Delivered Business Content Extractors

134

4.2.1 Logistics Extractors

135

4.2.2 Finance Extractors

137

4.2.3 HR Extractors

137

4.3 Generic Extractors

138

4.4 Installing SAP BusinessObjects Business Intelligence Content

140

4.5 Summary

142

5 Extracting Logistics Data

143

5.1 Logistics Extraction with the ODP Framework

143

5.1.1 Logistics Extraction Overview

144

5.1.2 Architecture

144

5.1.3 Update Method

152

5.1.4 DataSource Activation

164

5.2 Logistics Data Extraction in SAP S/4HANA

169

5.2.1 Exposing Logistics DataSource to Operational Data Provisioning

169

5.2.2 Logistics Cockpit

170

5.2.3 Filling the Setup Table and Testing the Extraction

171

5.2.4 Testing Setup Table Extraction Replication Using ODP Framework

180

5.3 Logistics Data Extraction in SAP BW/4HANA

182

5.3.1 Replicating ODP DataSources in SAP BW/4HANA

182

5.3.2 Creating aDSOs with Logistics Sales and Distribution DataSources

190

5.3.3 Data Extraction from SAP S/4HANA to SAP BW/4HANA: Full Upload

206

5.4 Transaction ODQMON: Logistics Full Upload

217

5.5 Delta Extraction based on ODP in Logistics Extraction

221

5.5.1 Settings for Logistics Delta Extraction in SAP S/4HANA

221

5.5.2 Post a Delta in SAP S/4HANA

224

5.5.3 Transaction ODQMON Checks for Delta Extraction

239

5.5.4 Loading the Logistics Sales Document Item aDSO Using ODP

244

5.5.5 Transaction ODQMON for Logistics Sales Item

248

5.6 Extracting Logistics DataSources from Other Applications

251

5.6.1 Introduction to Logistics-Based Functional Modules

251

5.6.2 Extraction of Purchasing Data into SAP BW/4HANA

252

5.6.3 Other Logistics-Based Applications and DataSources

268

5.6.4 Asset Management Components in the Logistics Cockpit

276

5.6.5 Setting Up Logistics Extraction for All Applications

280

5.7 Summary

280

6 Extracting Master Data

283

6.1 Introduction to Master Data in SAP S/4HANA

283

6.2 DataSource for Master Data

288

6.2.1 Check the Master DataSource in SAP S/4HANA

288

6.2.2 DataSource for Material Master

295

6.3 Standard Logistics InfoObjects with Master Data

296

6.3.1 Install Master Data InfoObjects from Business Content

296

6.3.2 InfoObjects and Master Data–Based Sources

300

6.3.3 Load the Data from the Master Data Source to the InfoObject

303

6.4 Summary

309

7 Extracting Inventory Management Data

311

7.1 Introduction to Inventory Management in SAP BW/4HANA

312

7.2 Inventory Management Extraction Logic

314

7.2.1 Fundamentals of Inventory and Noncumulative Key Figures

314

7.2.2 Understanding the Inventory Management Extraction Logic in SAP BW/4HANA

318

7.3 Implementing Inventory Management Extraction Using Logistics Cockpit DataSources

342

7.3.1 Business Content Extractors and Inventory Dataflow

343

7.3.2 Installing IMO Objects in SAP BW/4HANA

345

7.3.3 Filling the Setup Table for Inventory Data Loading

351

7.3.4 Implementing Logistics-Materials Management Inventory Data Loading

358

7.4 Summary

370

8 Extracting Financial Data

373

8.1 Finance in SAP ERP Systems

373

8.1.1 Finance in SAP

374

8.1.2 FI Classical DataSource Extraction from an SAP ERP System

376

8.1.3 Delta Management in Classical FI DataSources

380

8.2 Finance Extraction with New General Ledger Based on SAP ERP System

383

8.2.1 Extraction Using 0FI_GL_10

384

8.2.2 Extracting Using 0FI_GL_14

387

8.3 Extracting Asset Accounting and Controlling Data from SAP ERP and SAP S/4HANA

393

8.3.1 Asset Accounting

393

8.3.2 Controlling Application–Based Extraction

394

8.4 Extracting Finance Data from SAP S/4HANA to SAP BW/4HANA

396

8.4.1 Introduction to Table ACDOCA in SAP S/4HANA

396

8.4.2 DataSource for Table ACDOCA Extraction

399

8.5 Summary

418

9 Extracting SAP ERP Human Capital Management Data

419

9.1 Introduction to Human Capital Management in SAP BW/4HANA

419

9.2 Human Resources DataSources Overview

422

9.2.1 Human Resources Personnel Administration DataSources

422

9.2.2 Master Data in Human Resources

423

9.2.3 Payroll Data Extraction

424

9.2.4 Planned Time Data Extraction

425

9.3 Summary

426

10 Generic Extraction from SAP S/4HANA

427

10.1 Introduction to Generic DataSources

427

10.1.1 Business Requirements

428

10.1.2 Create the Database View

428

10.1.3 Create the Generic DataSource Based on the View

431

10.1.4 Checking DataSource Metadata

433

10.2 Extract Data into SAP BW/4HANA Using Generic DataSources

438

10.2.1 Replicate the DataSource

438

10.2.2 Data Modeling for Generic DataSources in SAP BW/4HANA

440

10.2.3 Checking the ODQ

444

10.3 Summary

445

11 Extracting SAP BW 7.x Data into SAP BW/4HANA

447

11.1 SAP BW 7.x Extraction in SAP BW/4HANA

447

11.2 SAP BW 7.x Objects for Data Loading

449

11.3 Consuming SAP BW 7.5 Objects in SAP BW/4HANA

451

11.3.1 Replicating SAP BW Objects

451

11.3.2 Creating an SAP BW/4HANA DataSource Using ODP

461

11.4 Summary

468

12 Extracting Data Using CDS Views

469

12.1 Understanding ABAP Dictionary

469

12.2 CDS Introduction

471

12.3 Create Basic CDS Views

473

12.3.1 Create Package

473

12.3.2 Create CDS View with Data Definition

475

12.3.3 Using Joins in CDS Views

482

12.3.4 CDS Views with Associations

485

12.4 Consume CDS Views in SAP BW/4HANA

487

12.4.1 SAP BW CDS Extraction Architecture

487

12.4.2 CDS Views Creation in SAP S/4HANA

488

12.4.3 Creating CDS Views Based on DataSources in SAP BW/4HANA

489

12.4.4 Creating aDSOs Based on CDS View DataSources

494

12.4.5 CDS Views with Delta Extraction

500

12.4.6 Extract the Delta CDS in SAP BW

503

12.5 Finding Standard CDS Views for SAP Applications

509

12.5.1 Finding the CDS Views for Applications Using SAP Table

509

12.5.2 Finding CDS Views in ABAP Development Tools

512

12.6 Summary

513

13 Extraction Using Open ODS Views

515

13.1 Creating Open ODS Views

516

13.1.1 Open ODS Views Based on SAP BW DataSources

516

13.1.2 Open ODS View Based on CDS

525

13.1.3 Open ODS View Based on SAP HANA Database Table

528

13.2 Summary

535

14 Extracting Data Using SAP HANA Calculation Views

537

14.1 Understanding the SAP HANA Admin Perspective

537

14.2 Creating SAP HANA Calculation Views

540

14.2.1 Creating a Package

541

14.2.2 SAP HANA Calculation Views

542

14.3 Prerequisites for Consuming SAP HANA Calculation Views

553

14.4 Consuming SAP HANA Calculation Views

555

14.4.1 Consuming SAP HANA Calculation Views in SAP BW/4HANA as aDSOs

555

14.4.2 Consuming SAP BW/4HANA Calculation Views Using SAP HANA Composite Providers

563

14.5 Creating Data Models Using SAP HANA Calculation Views

568

14.5.1 Creating a New Calculation View

568

14.5.2 Aggregation Behavior

577

14.5.3 Using the Input Parameter

579

14.5.4 Extracting the SAP HANA Calculation View in SAP BW/4HANA

584

14.6 Summary

586

15 Implementing Mixed Modeling in SAP BW/4HANA

587

15.1 Introduction to SAP HANA Smart Data Access

587

15.1.1 Creating Remote Sources

588

15.1.2 SAP HANA Smart Data Integration

592

15.1.3 SAP Landscape Transformation Replication Server to SAP BW/4HANA

593

15.2 Sample Mixed Modeling Flow

595

15.3 Summary

596