Operational Data Provisioning with SAP BW/4HANA

Multilingual Book

🇺🇸 English (Original) 🇪🇸 Spanish (Translation)

✅ All languages are included in your purchase

Publisher SAP PRESS

Year / Edition 2023 / 1

Pages 608

Authors Renjith Kumar Palaniswamy

Operational Data Provisioning with SAP BW/4HANA

Operational data provisioning (ODP) is the new standard for data staging and 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 calculation views, CDS views, open ODS views, and SAP BW. 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!

Model data and create an operational data provisioning source system
Use operational data provisioning to extract SAP S/4HANA finance data, logistics data, and more
Connect to data sources such as SAP HANA calculation views, CDS views, and other SAP BW systems

You'll learn about:

Modeling Data and Creating Source Systems:
Understand the ODP architecture and see how it can be used for data modeling. Learn how it interacts with and connects to different data sources. Then, create your own source system for ODP in SAP BW/4HANA.
Staging Data from SAP S/4HANA:
Follow step-by-step instructions to extract logistics, finance, inventory, HR, and master data from SAP S/4HANA. Manage delta data between your SAP S/4HANA and SAP BW/4HANA systems, and build custom extractors that fit your exact business needs.
Extracting Data from Views and Objects:
Working with other types of data? Configure ODP to consume CDS views, open ODP views, SAP HANA calculation views, and SAP BW objects.

Key Highlights:

Data staging and extraction
Logistics data
Inventory management data
Finance data
Human resources data
Master data
Generic extractors
SAP HANA calculation views
CDS views
Open ODS views
SAP BW objects
SAP BW/4HANA remote conversion

View Full Table of Contents

Preface
- Objective of the Book
- Target Audience
- Structure of the Book
- Acknowledgments
1 Introduction
- 1.1 History of SAP BW/4HANA
- 1.2 SAP BW/4HANA Overview and Design Principles
- 1.3 Eclipse and SAP HANA Studio
  - 1.3.1 Installing SAP HANA Studio
  - 1.3.2 Installing SAP BW/4HANA Modeling Tools
  - 1.3.3 Adding an SAP BW/4HANA System
- 1.4 Overview of Operational Data Provisioning
  - 1.4.1 ODP Features and Architecture
  - 1.4.2 Introduction to ODP SAP Extractors
  - 1.4.3 Data Extraction Essentials
  - 1.4.4 Data Acquisition Process in ODP
  - 1.4.5 Monitoring
- 1.5 Summary
2 Data Modeling in SAP BW/4HANA
- 2.1 Creating InfoAreas
- 2.2 Creating Source Systems
- 2.3 Creating Flat File Sources
- 2.4 Creating a DataSource
- 2.5 Creating InfoObjects
- 2.6 Creating Transformations
- 2.7 Creating a Data Transfer Process
- 2.8 Creating Key Figures
- 2.9 InfoObjects Advanced Properties
  - 2.9.1 Usable as InfoProvider
  - 2.9.2 Enhanced Master Data Update
  - 2.9.3 Enable External View
- 2.10 Creating Advanced Data Store Objects
- 2.11 Creating an SAP HANA Composite Provider
- 2.12 Creating an SAP BW Query
- 2.13 Summary
3 Creating an Operational Data Provisioning Source System
- 3.1 Introduction to Source Systems
  - 3.1.1 Logical System
  - 3.1.2 Creating Background Users for SAP BW/4HANA Extraction
  - 3.1.3 RFC Destination
- 3.2 Creating an ODP Source System
  - 3.2.1 SAP BW/4HANA and ODP Source System Types
  - 3.2.2 Creating an ODP Source System for SAP S/4HANA and SAP ERP
  - 3.2.3 Creating ODP Source in SAP BW Context
  - 3.2.4 Creating an ODP Source System in an SAP HANA Context
  - 3.2.5 Creating an ODP Source System in a CDS View Context
  - 3.2.6 Access Local SAP HANA Database Schema
- 3.3 Summary
4 Working with SAP Extractors
- 4.1 Introduction to SAP Extractors
- 4.2 SAP-Delivered Business Content Extractors
  - 4.2.1 Logistics Extractors
  - 4.2.2 Finance Extractors
  - 4.2.3 HR Extractors
- 4.3 Generic Extractors
- 4.4 Installing SAP BusinessObjects Business Intelligence Content
- 4.5 Summary
5 Extracting Logistics Data
- 5.1 Logistics Extraction with the ODP Framework
  - 5.1.1 Logistics Extraction Overview
  - 5.1.2 Architecture
  - 5.1.3 Update Method
  - 5.1.4 DataSource Activation
- 5.2 Logistics Data Extraction in SAP S/4HANA
  - 5.2.1 Exposing Logistics DataSource to Operational Data Provisioning
  - 5.2.2 Logistics Cockpit
  - 5.2.3 Filling the Setup Table and Testing the Extraction
  - 5.2.4 Testing Setup Table Extraction Replication Using ODP Framework
- 5.3 Logistics Data Extraction in SAP BW/4HANA
  - 5.3.1 Replicating ODP DataSources in SAP BW/4HANA
  - 5.3.2 Creating aDSOs with Logistics Sales and Distribution DataSources
  - 5.3.3 Data Extraction from SAP S/4HANA to SAP BW/4HANA: Full Upload
- 5.4 Transaction ODQMON: Logistics Full Upload
- 5.5 Delta Extraction based on ODP in Logistics Extraction
  - 5.5.1 Settings for Logistics Delta Extraction in SAP S/4HANA
  - 5.5.2 Post a Delta in SAP S/4HANA
  - 5.5.3 Transaction ODQMON Checks for Delta Extraction
  - 5.5.4 Loading the Logistics Sales Document Item aDSO Using ODP
  - 5.5.5 Transaction ODQMON for Logistics Sales Item
- 5.6 Extracting Logistics DataSources from Other Applications
  - 5.6.1 Introduction to Logistics-Based Functional Modules
  - 5.6.2 Extraction of Purchasing Data into SAP BW/4HANA
  - 5.6.3 Other Logistics-Based Applications and DataSources
  - 5.6.4 Asset Management Components in the Logistics Cockpit
  - 5.6.5 Setting Up Logistics Extraction for All Applications
- 5.7 Summary
6 Extracting Master Data
- 6.1 Introduction to Master Data in SAP S/4HANA
- 6.2 DataSource for Master Data
  - 6.2.1 Check the Master DataSource in SAP S/4HANA
  - 6.2.2 DataSource for Material Master
- 6.3 Standard Logistics InfoObjects with Master Data
  - 6.3.1 Install Master Data InfoObjects from Business Content
  - 6.3.2 InfoObjects and Master Data–Based Sources
  - 6.3.3 Load the Data from the Master Data Source to the InfoObject
- 6.4 Summary
7 Extracting Inventory Management Data
- 7.1 Introduction to Inventory Management in SAP BW/4HANA
- 7.2 Inventory Management Extraction Logic
  - 7.2.1 Fundamentals of Inventory and Noncumulative Key Figures
  - 7.2.2 Understanding the Inventory Management Extraction Logic in SAP BW/4HANA
- 7.3 Implementing Inventory Management Extraction Using Logistics Cockpit DataSources
  - 7.3.1 Business Content Extractors and Inventory Dataflow
  - 7.3.2 Installing IMO Objects in SAP BW/4HANA
  - 7.3.3 Filling the Setup Table for Inventory Data Loading
  - 7.3.4 Implementing Logistics-Materials Management Inventory Data Loading
- 7.4 Summary
8 Extracting Financial Data
- 8.1 Finance in SAP ERP Systems
  - 8.1.1 Finance in SAP
  - 8.1.2 FI Classical DataSource Extraction from an SAP ERP System
  - 8.1.3 Delta Management in Classical FI DataSources
- 8.2 Finance Extraction with New General Ledger Based on SAP ERP System
  - 8.2.1 Extraction Using 0FI_GL_10
  - 8.2.2 Extracting Using 0FI_GL_14
- 8.3 Extracting Asset Accounting and Controlling Data from SAP ERP and SAP S/4HANA
  - 8.3.1 Asset Accounting
  - 8.3.2 Controlling Application–Based Extraction
- 8.4 Extracting Finance Data from SAP S/4HANA to SAP BW/4HANA
  - 8.4.1 Introduction to Table ACDOCA in SAP S/4HANA
  - 8.4.2 DataSource for Table ACDOCA Extraction
- 8.5 Summary
9 Extracting SAP ERP Human Capital Management Data
- 9.1 Introduction to Human Capital Management in SAP BW/4HANA
- 9.2 Human Resources DataSources Overview
  - 9.2.1 Human Resources Personnel Administration DataSources
  - 9.2.2 Master Data in Human Resources
  - 9.2.3 Payroll Data Extraction
  - 9.2.4 Planned Time Data Extraction
- 9.3 Summary
10 Generic Extraction from SAP S/4HANA
- 10.1 Introduction to Generic DataSources
  - 10.1.1 Business Requirements
  - 10.1.2 Create the Database View
  - 10.1.3 Create the Generic DataSource Based on the View
  - 10.1.4 Checking DataSource Metadata
- 10.2 Extract Data into SAP BW/4HANA Using Generic DataSources
  - 10.2.1 Replicate the DataSource
  - 10.2.2 Data Modeling for Generic DataSources in SAP BW/4HANA
  - 10.2.3 Checking the ODQ
- 10.3 Summary
11 Extracting SAP BW 7.x Data into SAP BW/4HANA
- 11.1 SAP BW 7.x Extraction in SAP BW/4HANA
- 11.2 SAP BW 7.x Objects for Data Loading
- 11.3 Consuming SAP BW 7.5 Objects in SAP BW/4HANA
  - 11.3.1 Replicating SAP BW Objects
  - 11.3.2 Creating an SAP BW/4HANA DataSource Using ODP
- 11.4 Summary
12 Extracting Data Using CDS Views
- 12.1 Understanding ABAP Dictionary
- 12.2 CDS Introduction
- 12.3 Create Basic CDS Views
  - 12.3.1 Create Package
  - 12.3.2 Create CDS View with Data Definition
  - 12.3.3 Using Joins in CDS Views
  - 12.3.4 CDS Views with Associations
- 12.4 Consume CDS Views in SAP BW/4HANA
  - 12.4.1 SAP BW CDS Extraction Architecture
  - 12.4.2 CDS Views Creation in SAP S/4HANA
  - 12.4.3 Creating CDS Views Based on DataSources in SAP BW/4HANA
  - 12.4.4 Creating aDSOs Based on CDS View DataSources
  - 12.4.5 CDS Views with Delta Extraction
  - 12.4.6 Extract the Delta CDS in SAP BW
- 12.5 Finding Standard CDS Views for SAP Applications
  - 12.5.1 Finding the CDS Views for Applications Using SAP Table
  - 12.5.2 Finding CDS Views in ABAP Development Tools
- 12.6 Summary
13 Extraction Using Open ODS Views
- 13.1 Creating Open ODS Views
  - 13.1.1 Open ODS Views Based on SAP BW DataSources
  - 13.1.2 Open ODS View Based on CDS
  - 13.1.3 Open ODS View Based on SAP HANA Database Table
- 13.2 Summary
14 Extracting Data Using SAP HANA Calculation Views
- 14.1 Understanding the SAP HANA Admin Perspective
- 14.2 Creating SAP HANA Calculation Views
  - 14.2.1 Creating a Package
  - 14.2.2 SAP HANA Calculation Views
- 14.3 Prerequisites for Consuming SAP HANA Calculation Views
- 14.4 Consuming SAP HANA Calculation Views
  - 14.4.1 Consuming SAP HANA Calculation Views in SAP BW/4HANA as aDSOs
  - 14.4.2 Consuming SAP BW/4HANA Calculation Views Using SAP HANA Composite Providers
- 14.5 Creating Data Models Using SAP HANA Calculation Views
  - 14.5.1 Creating a New Calculation View
  - 14.5.2 Aggregation Behavior
  - 14.5.3 Using the Input Parameter
  - 14.5.4 Extracting the SAP HANA Calculation View in SAP BW/4HANA
- 14.6 Summary
15 Implementing Mixed Modeling in SAP BW/4HANA
- 15.1 Introduction to SAP HANA Smart Data Access
  - 15.1.1 Creating Remote Sources
  - 15.1.2 SAP HANA Smart Data Integration
  - 15.1.3 SAP Landscape Transformation Replication Server to SAP BW/4HANA
- 15.2 Sample Mixed Modeling Flow
- 15.3 Summary
The Author
Index

ℹ️ How to purchase this book?

This product has a special price upon request. You can start your order or clarify any doubts using the Contact for Price button on the page.

We have also prepared a step-by-step guide to explain how to easily request your quote.

Read the guide here →

Disclaimer

SAP, other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Our Company is not affiliated to SAP SE or any of its affiliated companies including but not limited to: Sybase, Business Objects, Hybris, Ariba and SuccessFactors. All other names, brands, logos, etc. are registered trade or service marks of their respective owners.

Home > SAP Books > Multilingual Books > Operational Data Provisioning with SAP BW/4HANA

Operational Data Provisioning with SAP BW/4HANA

Name: Operational Data Provisioning with SAP BW/4HANA
Brand: SAP
SKU: BOOK-SAPPRESS-EBOOK-2023-9781493224074
Availability: InStock

Warranty

Receive the product you were expecting or we will refund your money

Would you like to see a sample of the course or book?

If you need a sample of the course or book, request it in the chat below and we will be happy to provide it to you.

1 installment of $0.00 USD without interest		Total $0.00 USD
2 installments of $0.00 USD without interest		Total $0.00 USD
3 installments of $0.00 USD without interest		Total $0.00 USD
4 installments of $0.00 USD without interest		Total $0.00 USD
5 installments of $0.00 USD without interest		Total $0.00 USD
6 installments of $0.00 USD without interest		Total $0.00 USD

Operational Data Provisioning with SAP BW/4HANA

You'll learn about:

Key Highlights:

ℹ️ How to purchase this book?

Disclaimer

Operational Data Provisioning with SAP BW/4HANA

Related products