Operational Data Provisioning with SAP BW/4HANA

1. Auflage 2024
ISBN: 978-1-4932-2406-7
Verlag: Rheinwerk Verlag GmbH

Buch, Englisch, 608 Seiten, Format (B × H): 187 mm x 257 mm, Gewicht: 1402 g

Reihe: SAP PRESS Englisch

Operational data provisioning (ODP) is the new standard for data extraction in SAP BW/4HANA—are you ready for it? Use ODP to extract information from SAP S/4HANA and connect to other key data sources, including SAP HANA information views, CDS views, SAP BW, and flat files. Use SAP Landscape Transformation Replication Server to replicate data, and review the prerequisites for SAP BW/4HANA remote conversion projects. With detailed instructions throughout, this hands-on guide has all the information you need to master ODP!Highlights include:1) Logistics data2) Inventory management data3) Finance data4) Human resources data5) Master data6) Custom extractors7) SAP HANA information views8) CDS views9) SAP BW objects10) SAP BW/4HANA remote conversion11) Data replication12) Performance optimization

Autoren/Hrsg.

Kumar Palaniswamy, Renjith

Fachgebiete

• Wirtschaftswissenschaften Betriebswirtschaft Wirtschaftsinformatik, SAP, IT-Management
• Mathematik | Informatik EDV | Informatik Business Application Unternehmenssoftware SAP
• Mathematik | Informatik EDV | Informatik Angewandte Informatik Wirtschaftsinformatik

Inhaltsverzeichnis

· ... 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

Über Autor(innen)

Kumar Palaniswamy, Renjith
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.