Table of Contents

Open all
Close all
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
The Author
597
Index
599