Learn Open SQL in New SAP ABAP 7.4x and 7.5x, Learn and Understand Open SQL in SAP ABAP with New 7.4x and 7.5x ABAP Version on HANA.
Course Description
- 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 features available since 7.4x and 7.5x of ABAP Language
- Start with the Theory of Open SQL Execution Architecture and the 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
