ABAP Development for SAP HANA by Gahm, Hermann -- Read -- Imperial Library of Trantor

Index

Dear Reader Notes on Usage Table of Contents Foreword Preface Introduction Part I Basic Principles 1 Overview of SAP HANA

1.1 Software Components of SAP HANA

1.1.1 SAP HANA Database 1.1.2 SAP HANA Studio 1.1.3 SAP HANA Client 1.1.4 SAP HANA Extended Application Services 1.1.5 Additional Options

1.2 Basic Principles of In-Memory Technology

1.2.1 Hardware Innovations 1.2.2 Software Innovations

1.3 Architecture of the In-Memory Database 1.4 Application Cases and Deployment Options for SAP HANA

1.4.1 Application Cases 1.4.2 Deployment Options

1.5 How SAP HANA Affects Application Development

1.5.1 New Technical Options 1.5.2 Code Pushdown 1.5.3 Database as White Box 1.5.4 Required Qualifications for Developers

2 Introducing the Development Environment

2.1 Overview of Eclipse 2.2 SAP’s Eclipse Strategy

2.2.1 Unbundling of Eclipse and SAP Software 2.2.2 Central Update Site

2.3 Installing the Development Environment

2.3.1 Installing the Eclipse IDE for Java Developers 2.3.2 Installing SAP HANA Studio 2.3.3 Installing the ABAP Development Tools for SAP NetWeaver

2.4 Getting Started in the Development System

2.4.1 Basic Principles of Eclipse 2.4.2 ABAP Development Tools for SAP NetWeaver 2.4.3 SAP HANA Studio

3 Database Programming Using SAP NetWeaver Application Server ABAP

3.1 SAP NetWeaver Application Server ABAP Architecture

3.1.1 Database Interface 3.1.2 Role of the Database for the ABAP Application Server 3.1.3 Data Types

3.2 ABAP Database Access

3.2.1 ABAP Data Dictionary 3.2.2 Open SQL 3.2.3 Database Views in the ABAP Data Dictionary 3.2.4 Database Access via Native SQL 3.2.5 Secondary Database Connections

3.3 Analyzing Database Accesses Using the SQL Trace

3.3.1 Statement Transformations 3.3.2 Secondary Connections 3.3.3 Native SQL 3.3.4 Buffer

Part II Introduction to ABAP Programming with SAP HANA 4 Native Database Development Using SAP HANA

4.1 Basic Principles of Native Database Development

4.1.1 Objects in the SAP HANA Database Catalog 4.1.2 SQL Standard and SAP HANA-specific Enhancements

4.2 SQLScript

4.2.1 Basic Principles of SQLScript 4.2.2 SQLScript Programming

4.3 Database Procedures 4.4 Analytical Models

4.4.1 Attribute Views 4.4.2 Analytic Views 4.4.3 Calculation Views 4.4.4 Runtime Objects and SQL Access 4.4.5 Accessing Column Views via Microsoft Excel

5 Integrating Native SAP HANA Development Objects with ABAP

5.1 Integrating Analytic Views

5.1.1 Access via Native SQL 5.1.2 External Views in the ABAP Data Dictionary 5.1.3 Options for Accessing External Views 5.1.4 Recommendations

5.2 Integrating Native Procedures with ABAP

5.2.1 Access via Native SQL 5.2.2 Defining Database Procedure Proxies 5.2.3 Calling Database Procedure Proxies 5.2.4 Adjusting Database Procedure Proxies

5.3 Transport of Native Development Objects

5.3.1 Digression: Development Organization and Transport in SAP HANA 5.3.2 Using the SAP HANA Transport Container

6 Advanced Database Programming with ABAP 7.4

6.1 Introducing Core Data Services 6.2 ABAP Core Data Services

6.2.1 Core Data Services Views 6.2.2 Code Pushdown 6.2.3 View Extensions 6.2.4 Annotations 6.2.5 Using Core Data Services Views in ABAP and in SAP List Viewer with Integrated Data Access 6.2.6 Tips for Using ABAP Core Data Services Views

6.3 SAP HANA Core Data Services 6.4 Open SQL Enhancements 6.5 ABAP Database Procedures

6.5.1 Creating ABAP Managed Database Procedures 6.5.2 Troubleshooting 6.5.3 Enhancements 6.5.4 Practical Tips

7 Runtime and Error Analysis with SAP HANA

7.1 Overview of the Tools Available 7.2 Troubleshooting

7.2.1 Unit Tests 7.2.2 Dump Analysis 7.2.3 Debugging and Tracing in SQLScript

7.3 ABAP Code Analysis

7.3.1 Checks and Check Variants 7.3.2 Checks in the Development Infrastructure 7.3.3 Global Check Runs in the System

7.4 Runtime Statistics and Traces

7.4.1 Runtime Statistics 7.4.2 ABAP Trace and ABAP Profiler 7.4.3 SQL Trace 7.4.4 Single Transaction Analysis 7.4.5 Explain Plan 7.4.6 SAP HANA Plan Visualizer

7.5 System-Wide Analyses

7.5.1 Database Administration Cockpit 7.5.2 SQL Monitor 7.5.3 Runtime Check Monitor

7.6 SQL Performance Optimization

8 Sample Scenario: Optimizing an Existing Application

8.1 Optimization Procedure

8.1.1 Migrating to SAP HANA 8.1.2 System Optimization 8.1.3 Application Optimization

8.2 Scenario and Requirements

8.2.1 Initial Situation 8.2.2 Technical Implementation 8.2.3 Current Problems

8.3 Meeting the Requirements

8.3.1 Narrowing Down the Problem Using Runtime Statistics 8.3.2 Detailed Analysis of the ABAP Program Using Transaction SAT 8.3.3 Detailed Analysis of Database Accesses 8.3.4 Analysis Result 8.3.5 Optimization Using Open SQL 8.3.6 Analysis of the First Optimization 8.3.7 Analysis Result 8.3.8 Optimizing a Database Procedure 8.3.9 Analysis of the Second Optimization 8.3.10 Analysis Result

Part III Advanced Techniques for ABAP Programming for SAP HANA 9 Integrating Analytical Functionality

9.1 What Is Analytical Functionality? 9.2 SAP BusinessObjects Portfolio 9.3 Digression: SAP Business Warehouse

9.3.1 SAP HANA Versus SAP Business Warehouse 9.3.2 Overview of Terminology 9.3.3 InfoProviders When Using SAP HANA

9.4 Overview of Possible Architectures

9.4.1 Direct Access to Analytical Functionality in SAP HANA 9.4.2 Access via SAP NetWeaver AS ABAP

10 Text Search and Analysis of Unstructured Data

10.1 Basic Principles of the Text Search in SAP HANA

10.1.1 Technical Architecture 10.1.2 Error-Tolerant Search 10.1.3 SAP Components and Products for Search

10.2 Types of Text Data and Full Text Indexes in SAP HANA 10.3 Using the Text Search via SQL

10.3.1 Fuzzy Search 10.3.2 Synonyms and Noise Words 10.3.3 Searching across Date Fields and Address Data

10.4 Using the Text Search in ABAP

10.4.1 Direct SQL Access from ABAP 10.4.2 Embedding Input Helps 10.4.3 ABAP Source Code Search

10.5 Text Analysis 10.6 Resource Consumption and Runtime Aspects of the Text Search

11 Decision Tables in SAP HANA

11.1 Basic Principles of Decision Tables 11.2 Creating Decision Tables in SAP HANA Studio 11.3 Decision Tables Based on SAP HANA Views 11.4 Runtime Objects and SQL Access for Decision Tables 11.5 Access to Decision Tables from ABAP

12 Function Libraries in SAP HANA

12.1 Basics of the Application Function Library 12.2 Business Function Library 12.3 Predictive Analysis Library

12.3.1 Generating the K-Means Function via the SQL Console 12.3.2 Using the Application Function Modeler

13 Processing Geoinformation

13.1 Basic Principles of Geoinformation Systems 13.2 Geodata Types and Geo-Spatial Functions in SAP HANA

13.2.1 Data Types 13.2.2 Creating Tables and Reading Data 13.2.3 Operations on Geographical Structures 13.2.4 Integration of External Maps

13.3 Integrating Geoinformation with ABAP Applications

14 Practical Tips

14.1 General Recommendations

14.1.1 Recommendations for Column Stores and Row Stores 14.1.2 SAP HANA-Specific Implementations 14.1.3 Checklist for Database-Specific Implementations 14.1.4 Recommendations for Migration 14.1.5 Development in Landscapes 14.1.6 Modifying Data in SQLScript or Native SQL

14.2 Conventions

14.2.1 Naming Conventions 14.2.2 Encapsulating SAP HANA Packages

14.3 Quality Aspects

14.3.1 Testing Views and Procedures 14.3.2 Robust Programming 14.3.3 Security Aspects

14.4 Performance Recommendations for Open SQL

14.4.1 Rule 1: Keeping Result Sets Small 14.4.2 Rule 2: Keeping Transferred Datasets Small 14.4.3 Rule 3: Reducing the Number of Queries 14.4.4 Rule 4: Minimizing Search Effort 14.4.5 Rule 5: Reducing the Load on the Database 14.4.6 Summary of Rules

14.5 Performance Recommendations for Native Implementations in SAP HANA

14.5.1 Recommendations for Native SQL 14.5.2 Recommendations for SAP HANA Views 14.5.3 Recommendations for SQLScript

14.6 Summary of Recommendations

A Flight Data Model

A.1 Basic Principles of the Flight Data Model A.2 Database Tables for the Flight Data Model

A.2.1 Customizing A.2.2 Master Data A.2.3 Transaction Data A.2.4 Designing the SFLIGHT Data Model

A.3 Data Generation

B Enhancements to the ABAP Programming Language (as of SAP NetWeaver 7.4)

B.1 Inline Declarations B.2 Constructor Expressions B.3 Internal Tables

C Read and Write Access in the Column Store

C.1 Basic Principles C.2 Read Access without an Index C.3 Write Access without an Index C.4 Read Accesses with an Index

D SAP Business Application Accelerator Powered by SAP HANA E Installing the Sample Programs F The Authors Index Service Pages Legal Notes

← Prev
Back
Next →

← Prev
Back
Next →