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

Autorentext
Sumit Dipak Naik is an experienced ABAP and SAP HANA certified professional. He has more than 16 years of technical consulting, solutioning, and management experience. His focus is in implementing SAP ERP and SAP S/4HANA solutions, across various industry sectors, including telecommunications, food and beverages, manufacturing, retail, life sciences, energy and utilities, public sector, and IT. He has extensive experience with different implementation methodologies, approaches, and accelerators.

Klappentext

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

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 Performan…