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!

a) 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.

b) Database Programming
Create, execute, and manage SAP HANA database procedures using native SQL, ABAP Database Connectivity, SQLScript, ABAP-managed database procedures, and more.

c) Modeling
Use calculation views and CDS views to model SAP HANA data. Create business objects with the Business Object Processing Framework (BOPF).

d) 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.

1) SAP HANA
2) ABAP database connectivity (ADBC)
3) ABAP-managed database procedures (AMDP)
4) SQL and SQLScript
5) Data modeling
6) Core data services (CDS)
7) Native SQL and ABAP SQL
8) Business object processing framework (BOPF)
9) ABAP Test Cockpit
10) Runtime statistics and analysis
11) SAP BTP, ABAP Environment

Model data using calculation views and CDS views

Inhalt
... Acknowledgments ... 17

1 ... SAP HANA Overview ... 19

1.1 ... Features ... 19

1.2 ... Architecture ... 27

1.3 ... Platform Capabilities ... 29

1.4 ... Use Cases ... 30

1.5 ... Summary ... 33

2 ... Code-to-Data Paradigm ... 35

2.1 ... What Is the Code-to-Data Paradigm? ... 35

2.2 ... Bottom-Up Approach ... 38

2.3 ... Top-Down Approach ... 41

2.4 ... Performance Benefits of Code-to-Data Techniques ... 46

2.5 ... Summary ... 49

3 ... Development Environments ... 51

3.1 ... Evolution of Programming Languages and Development Tools ... 51

3.2 ... SAP HANA Studio ... 54

3.3 ... SAP HANA Client ... 87

3.4 ... ABAP Development Tools ... 88

3.5 ... SAP Business Technology Platform, ABAP Environment ... 99

3.6 ... Summary ... 101

4 ... Native SQL ... 103

4.1 ... Executing Native SQL Statements ... 104

4.2 ... ABAP Database Connectivity ... 109

4.3 ... Summary ... 121

5 ... SQLScript Programming ... 123

5.1 ... What Is SQLScript? ... 123

5.2 ... SQL Query Template ... 128

5.3 ... Stored Procedures ... 131

5.4 ... User-Defined Functions ... 133

5.5 ... Constructs ... 139

5.6 ... Cursors ... 144

5.7 ... Transactional Statements ... 147

5.8 ... Dynamic SQL ... 148

5.9 ... Exception Handing ... 149

5.10 ... Arrays ... 150

5.11 ... SQL Injection Prevention Functions ... 153

5.12 ... Explicit Parallel Execution ... 154

5.13 ... System Variables ... 155

5.14 ... Debugging SQLScript ... 156

5.15 ... Summary ... 158

6 ... ABAP-Managed Database Procedures ... 159

6.1 ... Introduction ... 159

6.2 ... Creating AMDP Classes ... 166

6.3 ... Enhancements ... 180

6.4 ... Exception Handling ... 199

6.5 ... Debugging ... 202

6.6 ... Tools ... 214

6.7 ... Summary ... 218

7 ... Modeling ... 219

7.1 ... What Is Modeling for SAP HANA? ... 219

7.2 ... Information Views ... 229

7.3 ... Calculation Views ... 232

7.4 ... Modeling Functions ... 243

7.5 ... SQL in Information Models ... 270

7.6 ... Virtual Data Models ... 275

7.7 ... Optimizing Data Models ... 284

7.8 ... Summary ... 290

8 ... Core Data Services ... 291

8.1 ... The Evolution of Core Data Services ... 291

8.2 ... Introduction ... 295

8.3 ... Defining CDS Views ... 298

8.4 ... Built-In Functions and Expressions ... 312

8.5 ... Annotations ... 349

8.6 ... Associations ... 351

8.7 ... Consuming CDS Views ... 358

8.8 ... Enhancements ... 364

8.9 ... Authorization Concept ... 370

8.10 ... CDS Table Functions ... 386

8.11 ... Summary ... 399

9 ... Open SQL and ABAP SQL ... 401

9.1 ... What Is Open SQL? ... 401

9.2 ... Features of Open SQL ... 403

9.3 ... ABAP SQL ... 410

9.4 ... Open SQL versus ABAP SQL Statements ... 430

9.5 ... ABAP SQL versus CDS Views and AMDPs ... 432

9.6 ... Summary ... 434

10 ... Business Object Processing Framework ... 435

10.1 ... Introduction to Business Object Processing Framework ... 435

10.2 ... Elements of BOPF ... 438

10.3 ... BOPF API ... 449

10.4 ... CRUD Operations Using the BOPF API ... 453

10.5 ... Advanced BOPF API Features ... 458

10.6 ... Enhancement Techniques ... 462

10.7 ... Summary ... 469

11 ... Performance and Optimization ... 471

11.1 ... Runtime Statistics Records ... 472

11.2 ... Runtime and Statistical Analysis ... 475

11.3 ... ABAP Code Analysis ... 509

11.4 ... System-Wide Analysis ... 521

11.5 ... SQL Performance Optimization ... 526

11.6 ... Summary ... 533

12 ... SAP Business Technology Platform, ABAP Environment ... 535

12.1 ... Introduction to Application Development in the Cloud with SAP ... 535

12.2 ... ABAP Environment in the Cloud ... 540

12.3 ... Creating ABAP Repository Objects in the Cloud ... 555

12.4 ... Summary ... 572

... Appendices ... 575

A ... Programming Guidelines ... 577

B ... Code Migration ... 589

C ... The Authors ... 637

... Index ... 639