ABAP Development for SAP HANA
Description
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
More details
Other editions
Previous edition
Persons
Content
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