Renjith Kumar Palaniswamy is an SAP BW/4HANA architect with more than 15 years of experience working with SAP BW and SAP BW/4HANA. He currently works at SAP America, where he specializes in data extraction and data modeling components, which includes SAP BW/4HANA modeling, native SAP HANA modeling, and mixed modeling. Renjith has also worked as an SAP BW architect for major Fortune 100 companies across North America, where his focus was SAP BW/4HANA, SAP HANA migration, and SAP BW/4HANA conversion. In 2016 and 2017 he led the largest SAP BW powered by SAP HANA migration for a top retail company in North America.

Connect to data sources such as SAP HANA calculation views, CDS views, and other SAP BW systems

· ... 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.4 ... Overview of Operational Data Provisioning ... 35

· 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.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.2 ... Creating an ODP Source System ... 115

· 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.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.2 ... Logistics Data Extraction in SAP S/4HANA ... 169

· 5.3 ... Logistics Data Extraction in SAP BW/4HANA ... 182

· 5.4 ... Transaction ODQMON: Logistics Full Upload ... 217

· 5.5 ... Delta Extraction based on ODP in Logistics Extraction ... 221

· 5.6 ... Extracting Logistics DataSources from Other Applications ... 251

· 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.3 ... Standard Logistics InfoObjects with Master Data ... 296

· 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.3 ... Implementing Inventory Management Extraction Using Logistics Cockpit DataSources ... 342

· 7.4 ... Summary ... 370

· 8 ... Extracting Financial Data ... 373

· 8.1 ... Finance in SAP ERP Systems ... 373

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

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

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

· 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.3 ... Summary ... 426

· 10 ... Generic Extraction from SAP S/4HANA ... 427

· 10.1 ... Introduction to Generic DataSources ... 427

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

· 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.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.4 ... Consume CDS Views in SAP BW/4HANA ... 487

· 12.5 ... Finding Standard CDS Views for SAP Applications ... 509

· 12.6 ... Summary ... 513

· 13 ... Extraction Using Open ODS Views ... 515

· 13.1 ... Creating Open ODS Views ... 516

· 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.3 ... Prerequisites for Consuming SAP HANA Calculation Views ... 553

· 14.4 ... Consuming SAP HANA Calculation Views ... 555

· 14.5 ... Creating Data Models Using SAP HANA Calculation Views ... 568

· 14.6 ... Summary ... 586

· 15 ... Implementing Mixed Modeling in SAP BW/4HANA ... 587

· 15.1 ... Introduction to SAP HANA Smart Data Access ... 587

· 15.2 ... Sample Mixed Modeling Flow ... 595

· 15.3 ... Summary ... 596

· ... The Author ... 597

· ... Index ... 599