ABAP Development for SAP Hana - Ahmed, Mohd Mohsin

. .

Résumé :
Mohd Mohsin Ahmed is an SAP HANA certified professional with more than 14 years of experience as an SAP technical consultant. He currently specializes in implementing SAP S/4HANA solutions with a variety of methodologies, across various industry sectors, including manufacturing, retail, food and beverage, life science, energy and utilities, public sector, and IT. He holds a degree in has a degree in computer science engineering from Jawaharlal Nehru Technological University in Hyderabad, India....

Biographie:
... 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 ... ...

Sommaire:
... 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 ... ...