Key Highlights

• You will learn the use of Open SQL with ABAP® with features of Select, Insert, Update, Modify and Delete with SAP® HANA® using Eclipse with ADT
• You will see the new Open SQL syntaxes and feature available since 7.4x and 7.5x of ABAP® Language
• Start with Theory of Open SQL Execution Architecture and Difference between Open SQL vs Native SQL
• Basic usage of Select, Insert, Update, Modify and Delete with examples
• Use of Select-Endselect, Packet Size and where to use what
• Use of INTO and APPEND in Select
• Use of Basic WHERE Clause, UPTO ROWS, SINGLE, SY-DBCNT and SY-SUBRC and Exceptions
• Simple and Complex WHERE with AND, OR and Parenthesis Control etc.
• How to Use Select in Timestamp Comparison
• Use of BETWEEN, IN and RANGE Tables
• Get data in Custom Structure, Mapping Columns, Wildcards etc.
• Use of CORRESPONDING FIELDS OF TABLE, making Selection Dynamic or Generic and use of FOR ALL ENTRIES
• Use of Aggregation: COUNT, DISTINCT, MAX, MIN, SUM, AVG etc.
• Use of GROUP BY and ORDER BY
• Use of Select with Subquery and Insert with Subquery
• Use of Joins with Theory and Hands-on with INNER, LEFT, RIGHT and CROSS JOIN
• Use of Arithmetic SQL Expressions, String SQL Expressions, CASE and COALESCE
• Selection using CDS views and Path Expression

What We Cover in this Course Stage-wise

In Open SQL with ABAP® Basic

• Start with Theory of Open SQL Execution Architecture and Difference between Open SQL vs Native SQL
• Basic usage of Select, Insert, Update, Modify and Delete with examples