ABAP Development for SAP HANA

Hermann Gahm is a principal consultant in the performance CoE of SAP Global IT Application Services. In this position, he is primarily responsible for performance analysis and optimization of the internal SAP ABAP systems powered by SAP HANA. Between 2006 and 2012, Hermann worked as an SAP technology consultant at SAP SI AG and as an SAP support consultant in the Technology & Performance division of the Active Global Support department at SAP AG. In this position, his main responsibilities were helping major SAP customers solve performance problems in the context of ABAP developments and system, database, and ABAP program tuning. During his in-service studies of information management, he worked as an ABAP developer in one of the largest commercial enterprises in Germany and as an SAP system administrator for a market-leading industrial mortgage company between 1998 and 2006. During this time, his main responsibilities were performance analysis and optimization of mass data processing in SAP systems. Thorsten Schneider is a product manager in the Product & Innovation HANA Platform department at SAP AG. In this position, he deals with application development using the new in-memory database technology. His main focus is the implementation of business applications based on ABAP and SAP HANA. Prior to working as a product manager, Thorsten was a consultant at SAP Deutschland AG & Co. KG for several years. During this time, he advised national and international organizations on product lifecycle management and project portfolio management matters. Eric Westenberger studied mathematics at the University of Kaiserslautern, Germany, where he was awarded his doctorate degree in the field of singularity theory. Since 2005, he has been working for SAP AG, where he is currently a product manager for SAP HANA and SAP NetWeaver. Prior to this, he was involved in the development of several components of the SAP NetWeaver basis technology as a developer and software architect for several years.

Foreword
Preface
Introduction
Part I: Basic Principles
Overview of SAP HANA
Software Components of SAP HANA
Basic Principles of In-Memory Technology
Architecture of the In-Memory Database
Application Cases and Deployment Options for SAP HANA
How SAP HANA Affects Application Development
Introducing the Development Environment
Overview of Eclipse
SAP's Eclipse Strategy
Installing the Development Environment
Getting Started in the Development System
Database Programming Using SAP NetWeaver Application Server ABAP
SAP NetWeaver Application Server ABAP Architecture
ABAP Database Access
Analyzing Database Accesses Using the SQL Trace
Part II: Introduction to ABAP Programming with SAP HANA
Native Database Development Using SAP HANA
Basic Principles of Native Database Development
SQLScript
Database Procedures
Analytical Models
Integrating Native SAP HANA Development Objects with ABAP
Integrating Analytic Views
Integrating Native Procedures with ABAP
Transport of Native Development Objects
Advanced Database Programming with ABAP 7.4
Introducing Core Data Services
ABAP Core Data Services
SAP HANA Core Data Services
Open SQL Enhancements
ABAP Database Procedures
Runtime and Error Analysis with SAP HANA
Overview of the Tools Available
Troubleshooting
ABAP Code Analysis
Runtime Statistics and Traces
System-Wide Analyses
SQL Performance Optimization
Sample Scenario: Optimizing an Existing Application
Optimization Procedure
Scenario and Requirements
Meeting the Requirements
Part III: Advanced Techniques for ABAP Programming for SAP HANA
Integrating Analytical Functionality
What Is Analytical Functionality?
SAP BusinessObjects Portfolio
Digression: SAP Business Warehouse
Overview of Possible Architectures
Text Search and Analysis of Unstructured Data
Basic Principles of the Text Search in SAP HANA
Types of Text Data and Full Text Indexes in SAP HANA
Using the Text Search via SQL
Using the Text Search in ABAP
Text Analysis
Resource Consumption and Runtime Aspects of the Text Search
Decision Tables in SAP HANA
Basic Principles of Decision Tables
Creating Decision Tables in SAP HANA Studio
Decision Tables Based on SAP HANA Views
Runtime Objects and SQL Access for Decision Tables
Access to Decision Tables from ABAP
Function Libraries in SAP HANA
Basics of the Application Function Library
Business Function Library
Predictive Analysis Library
Processing Geoinformation
Basic Principles of Geoinformation Systems
Geodata Types and Geo-Spatial Functions in SAP HANA
Integrating Geoinformation with ABAP Applications
Practical Tips
General Recommendations
Conventions
Quality Aspects
Performance Recommendations for Open SQL
Performance Recommendations for Native Implementations in SAP HANA
Summary of Recommendations
Appendices
Flight Data Model
Enhancements to the ABAP Programming Language (as of SAP NetWeaver 7.4)
Read and Write Access in the Column Store
SAP Business Application Accelerator Powered by SAP HANA
Installing the Sample Programs
The Authors
Index