Name: ABAP Development for SAP HANA
Brand: SAP
SKU: BOOK-SAPPRESS-EBOOK-2021-9781493218783

Language

🇺🇸 English

Publisher SAP PRESS

Year / Edition 2021 / 1

Pages 645

Authors Mohd Mohsin Ahmed, Sumit Dipak Naik

ABAP Development for SAP HANA

This step-by-step developer’s guide has everything you need to build SAP HANA-optimized ABAP applications. Explore the environment and tools you’ll be using and master development techniques that govern the code-to-data paradigm in SAP HANA. Then jump into backend programming using ABAP Database Connectivity, SQLScript, ABAP-managed database procedures, core data services, and more. Once you’ve coded your apps, maintain them with runtime statistics, traces, and code analysis. Build it your way!

Understand how SAP HANA changes ABAP programming
Access the database with ABAP Database Connectivity, SQLScript, and ABAP-managed database procedures
Model data using calculation views and CDS views

You'll learn about:

Getting Started:
Begin by exploring the architecture and features of SAP HANA, and setting up your development environments, including SAP HANA Studio and ABAP Development Tools. Understand the code pushdown techniques that govern ABAP development on SAP HANA.
Database Programming:
Create, execute, and manage SAP HANA database procedures using native SQL, ABAP Database Connectivity, SQLScript, ABAP-managed database procedures, and more.
Modeling:
Use calculation views and CDS views to model SAP HANA data. Create business objects with the Business Object Processing Framework (BOPF).
Optimizing Applications:
Use runtime statistics, ABAP and SQL traces, ABAP code analysis, and system-wide analysis tools to make sure your ABAP applications are performing efficiently.

Key Highlights:

SAP HANA
ABAP database connectivity (ADBC)
ABAP-managed database procedures (AMDP)
SQL and SQLScript
Data modeling
Core data services (CDS)
Native SQL and ABAP SQL
Business object processing framework (BOPF)
ABAP Test Cockpit
Runtime statistics and analysis
SAP BTP, ABAP Environment

View Full Table of Contents

Acknowledgments
1 SAP HANA Overview
- 1.1 Features
  - 1.1.1 Main Memory and CPU Innovations
  - 1.1.2 Storage Innovations
  - 1.1.3 Data Compression
  - 1.1.4 Data Partitioning
- 1.2 Architecture
- 1.3 Platform Capabilities
- 1.4 Use Cases
  - 1.4.1 Side-by-Side Scenario
  - 1.4.2 Fully Integrated Scenarios
  - 1.4.3 New Applications
- 1.5 Summary
2 Code-to-Data Paradigm
- 2.1 What Is the Code-to-Data Paradigm?
- 2.2 Bottom-Up Approach
  - 2.2.1 Using Native SQL
  - 2.2.2 Using Proxy Objects
- 2.3 Top-Down Approach
  - 2.3.1 Using Transparent Optimization
  - 2.3.2 Using ABAP SQL
  - 2.3.3 Using ABAP-Managed Database Procedures
  - 2.3.4 Using Core Data Services
- 2.4 Performance Benefits of Code-to-Data Techniques
- 2.5 Summary
3 Development Environments
- 3.1 Evolution of Programming Languages and Development Tools
- 3.2 SAP HANA Studio
  - 3.2.1 Compatibility Checks
  - 3.2.2 Download
  - 3.2.3 Installation
  - 3.2.4 Basic Navigation and Actions
  - 3.2.5 ABAP Perspective
  - 3.2.6 Modeler Perspective
  - 3.2.7 Administration Perspective
- 3.3 SAP HANA Client
- 3.4 ABAP Development Tools
  - 3.4.1 Overview
  - 3.4.2 Installation
- 3.5 SAP Business Technology Platform, ABAP Environment
- 3.6 Summary
4 Native SQL
- 4.1 Executing Native SQL Statements
  - 4.1.1 Literals and Host Variables
  - 4.1.2 Statement for Cursor Processing
  - 4.1.3 Database Procedure Calls
  - 4.1.4 Statements for Establishing Database Connections
  - 4.1.5 Data Type Compatibility
- 4.2 ABAP Database Connectivity
  - 4.2.1 Querying the Database
  - 4.2.2 DDL and DML Operations
  - 4.2.3 Secondary Connections
  - 4.2.4 Precautions While Using ABAP Database Connectivity
- 4.3 Summary
5 SQLScript Programming
- 5.1 What Is SQLScript?
  - 5.1.1 SQL versus SQLScript
  - 5.1.2 Types of SQLScript Statements
  - 5.1.3 Prerequisites
- 5.2 SQL Query Template
  - 5.2.1 Creating a Schema
  - 5.2.2 Creating Tables
- 5.3 Stored Procedures
  - 5.3.1 Creating Procedures
  - 5.3.2 Deleting Procedures
- 5.4 User-Defined Functions
  - 5.4.1 Joins and GROUP BY Clauses
  - 5.4.2 Subqueries
- 5.5 Constructs
  - 5.5.1 Local Scalar Variables
  - 5.5.2 Local Table Variables
  - 5.5.3 Conditional Statements
  - 5.5.4 FOR Loops and WHILE Loops
  - 5.5.5 Operators
  - 5.5.6 Emptiness Check for Tables and Table Variables
  - 5.5.7 Getting the Number of Records for Tables and Table Variables
- 5.6 Cursors
  - 5.6.1 Example Cursor
  - 5.6.2 Looping over Cursors
- 5.7 Transactional Statements
- 5.8 Dynamic SQL
- 5.9 Exception Handing
  - 5.9.1 Continue after Handling
  - 5.9.2 Block Parallel Execution
- 5.10 Arrays
  - 5.10.1 Creating an Array
  - 5.10.2 Accessing the Array
  - 5.10.3 Concatenating Arrays
  - 5.10.4 Converting a Table into an Array
  - 5.10.5 Unpacking an Array into a Table
  - 5.10.6 Deleting or Trimming an Array
  - 5.10.7 Cardinality in Arrays
- 5.11 SQL Injection Prevention Functions
- 5.12 Explicit Parallel Execution
- 5.13 System Variables
- 5.14 Debugging SQLScript
- 5.15 Summary
6 ABAP-Managed Database Procedures
- 6.1 Introduction
  - 6.1.1 ABAP-Managed Database Procedure Framework
  - 6.1.2 Development Environment for AMDP
- 6.2 Creating AMDP Classes
  - 6.2.1 Prerequisites
  - 6.2.2 Implementing AMDP Methods
  - 6.2.3 Calling AMDP Methods in Applications
  - 6.2.4 Using Multiple Selection Criteria
  - 6.2.5 Feature Support Check Using Global Classes
- 6.3 Enhancements
  - 6.3.1 AMDP BAdI Overview
  - 6.3.2 AMDP BAdI Implementation
  - 6.3.3 AMDP BAdI Definition
  - 6.3.4 AMDP BAdI Calls
- 6.4 Exception Handling
- 6.5 Debugging
  - 6.5.1 AMDP Debugging before SAP NetWeaver AS ABAP 7.5
  - 6.5.2 AMDP Debugging with SAP NetWeaver AS ABAP 7.5
  - 6.5.3 AMDP Dump Analysis Using Transaction ST22
- 6.6 Tools
  - 6.6.1 AMDP Dependencies for ABAP and SAP HANA
  - 6.6.2 AMDP Precondition Checks
  - 6.6.3 AMDP Consistency Check for AMDP Table Functions
  - 6.6.4 Delete Obsolete AMDPs
- 6.7 Summary
7 Modeling
- 7.1 What Is Modeling for SAP HANA?
  - 7.1.1 Measures and Attributes
  - 7.1.2 Dimensions
  - 7.1.3 Fact Tables
  - 7.1.4 Star Schemas
  - 7.1.5 Hierarchies
  - 7.1.6 Semantics
  - 7.1.7 Joins
- 7.2 Information Views
  - 7.2.1 Features
  - 7.2.2 Information View Types
- 7.3 Calculation Views
  - 7.3.1 Creating Dimension Calculation Views
  - 7.3.2 Creating Calculated Attributes
  - 7.3.3 Time Dimension-Based Calculated Views
  - 7.3.4 Base Tables Aliases
  - 7.3.5 Hidden Columns
  - 7.3.6 Labels and Hidden Attributes
  - 7.3.7 Using Measures in Calculation Views
- 7.4 Modeling Functions
  - 7.4.1 Using a Hierarchy
  - 7.4.2 Restricted Columns
  - 7.4.3 Calculated Columns
  - 7.4.4 Filtering Data
  - 7.4.5 Using Variables and Input Parameters
  - 7.4.6 Currency Conversion
  - 7.4.7 Decision Tables
- 7.5 SQL in Information Models
  - 7.5.1 Query a Modeled Hierarchy Using SQLScript
  - 7.5.2 Creating and Using Functions in Information Views
  - 7.5.3 Procedures in Calculation Views
- 7.6 Virtual Data Models
  - 7.6.1 SAP HANA Live
  - 7.6.2 SAP S/4HANA Embedded Analytics and Core Data Services Views
- 7.7 Optimizing Data Models
  - 7.7.1 Tools to Check Model Performance
  - 7.7.2 Good Modeling Practices
- 7.8 Summary
8 Core Data Services
- 8.1 The Evolution of Core Data Services
- 8.2 Introduction
  - 8.2.1 Domain-Specific Languages
  - 8.2.2 Availability and Features
  - 8.2.3 Integration with ABAP
- 8.3 Defining CDS Views
  - 8.3.1 Using Templates
  - 8.3.2 Structure Definition
  - 8.3.3 Creating CDS Views in ADT
  - 8.3.4 Syntax and Naming Guidelines
- 8.4 Built-In Functions and Expressions
  - 8.4.1 Numeric Built-In Functions
  - 8.4.2 String Functions
  - 8.4.3 COALESCE Function
  - 8.4.4 Conversion Functions
  - 8.4.5 Date and Time Functions
- 8.5 Annotations
  - 8.5.1 Scope of Annotations
  - 8.5.2 Types of Annotations
- 8.6 Associations
  - 8.6.1 Defining Associations
  - 8.6.2 Cardinality
  - 8.6.3 Types of Associations
- 8.7 Consuming CDS Views
  - 8.7.1 Using ABAP SQL
  - 8.7.2 Using SAP List Viewer with Integrated Data Access
- 8.8 Enhancements
  - 8.8.1 CDS View Extensions
  - 8.8.2 Limiting CDS View Extensibility
  - 8.8.3 Finding CDS Extensions to Enhance CDS View Definitions
- 8.9 Authorization Concept
  - 8.9.1 Data Control Language Overview
  - 8.9.2 Data Control Language Syntax and Access Conditions
  - 8.9.3 Data Control Language Source Definition
  - 8.9.4 Data Control Language Source Annotations
- 8.10 CDS Table Functions
  - 8.10.1 AMDP Functions
  - 8.10.2 Introduction to CDS Table Functions
  - 8.10.3 Defining CDS Table Functions
- 8.11 Summary
9 Open SQL and ABAP SQL
- 9.1 What Is Open SQL?
- 9.2 Features of Open SQL
- 9.3 ABAP SQL
  - 9.3.1 Code Pushdown in ABAP SQL
  - 9.3.2 Joins
- 9.4 Open SQL versus ABAP SQL Statements
  - 9.4.1 Major Syntax Changes in the SELECT Query
  - 9.4.2 Arithmetic Operations and String Operations
  - 9.4.3 Joins and Unions
- 9.5 ABAP SQL versus CDS Views and AMDPs
  - 9.5.1 CDS Views
  - 9.5.2 ABAP-Managed Database Procedures
- 9.6 Summary
10 Business Object Processing Framework
- 10.1 Introduction to Business Object Processing Framework
- 10.2 Elements of BOPF
  - 10.2.1 Nodes
  - 10.2.2 Attributes
  - 10.2.3 Alternate Keys
  - 10.2.4 Actions
  - 10.2.5 Determinations
  - 10.2.6 Associations
  - 10.2.7 Validations
  - 10.2.8 Queries
- 10.3 BOPF API
  - 10.3.1 BOPF Interface Objects
  - 10.3.2 Business Object Key
  - 10.3.3 BOPF Constants Interface
- 10.4 CRUD Operations Using the BOPF API
  - 10.4.1 Creating Business Object Instances
  - 10.4.2 Searching for Business Object Instances
  - 10.4.3 Updating and Deleting Business Object Instances
- 10.5 Advanced BOPF API Features
  - 10.5.1 Consistency Checks
  - 10.5.2 Triggering Actions
  - 10.5.3 Action Validations
  - 10.5.4 Transaction Management
- 10.6 Enhancement Techniques
  - 10.6.1 Enhancement Workbench
  - 10.6.2 Enhancing the Business Object Data Model
- 10.7 Summary
11 Performance and Optimization
- 11.1 Runtime Statistics Records
- 11.2 Runtime and Statistical Analysis
  - 11.2.1 Transaction SAT
  - 11.2.2 ABAP Profiling Perspective
  - 11.2.3 SQL Performance Trace
  - 11.2.4 Single Transaction Analysis (Transaction ST12)
  - 11.2.5 Explain Plan
  - 11.2.6 SAP HANA Plan Visualizer
- 11.3 ABAP Code Analysis
  - 11.3.1 SAP Global Check Variants
  - 11.3.2 Using the ABAP Test Cockpit
  - 11.3.3 ABAP Test Cockpit Administration
- 11.4 System-Wide Analysis
  - 11.4.1 Database Administrator Cockpit
  - 11.4.2 SQL Monitor
- 11.5 SQL Performance Optimization
  - 11.5.1 Guided Performance Analysis
  - 11.5.2 SQL Performance Tuning Worklist
  - 11.5.3 Recommended Static Checks
- 11.6 Summary
12 SAP Business Technology Platform, ABAP Environment
- 12.1 Introduction to Application Development in the Cloud with SAP
- 12.2 ABAP Environment in the Cloud
  - 12.2.1 Architecture
  - 12.2.2 Creating an ABAP Trial Instance
  - 12.2.3 Connecting SAP HANA Studio to SAP BTP, Cloud Foundry Environment
  - 12.2.4 ABAP Restrictions in the Cloud
  - 12.2.5 Migrating ABAP Applications to the Cloud
- 12.3 Creating ABAP Repository Objects in the Cloud
  - 12.3.1 Creating ABAP Packages in the Cloud
  - 12.3.2 Creating ABAP Database Tables in the Cloud
  - 12.3.3 Creating ABAP Classes in the Cloud
  - 12.3.4 Creating ABAP CDS Views in the Cloud
- 12.4 Summary
Appendices
- A Programming Guidelines
  - A.1 Classic Approach to Retrieve Data in ABAP Context
  - A.2 Usage of Open SQL Statements
  - A.3 Guidelines to Use Open SQL for Any Database
  - A.4 Guidelines to Use Open SQL for an SAP HANA Database
  - A.5 Guidelines to Use Buffered Table
  - A.6 Usage of FOR ALL ENTRIES Clause on an SAP HANA Database
  - A.7 General Rules for the Code Pushdown Paradigm
- B Code Migration
  - B.1 Custom Code Migration for SAP HANA
  - B.2 Global ABAP Test Cockpit Checks for SAP HANA Database Migration
  - B.3 Custom Code Analysis and Adaptation for SAP HANA
- C The Authors
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.

Warranty

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

Free shipping

Free shipping to your email

Would you like a sample course/book?

If you need a sample of a course/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

ABAP Development for SAP HANA

You'll learn about:

Key Highlights:

ℹ️ How to purchase this book?

Disclaimer

ABAP Development for SAP HANA

Related products