Learn and Understand Open SQL in SAP ABAP with New 7.4x and 7.5x ABAP Version on HANA
What you will learn
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
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
English
language
Content
Introduction of the Course
Introduction to Open SQL in New ABAP® on HANA® Course
Introduction to the Course
Open SQL in ABAP® – Open SQL vs Native SQL in ABAP® and Basic Select Statements
Open SQL Basic – Open SQL Architecture Overview and Open SQL vs Native SQL
Open SQL Basic – Setting up Sample Tables for Hands-on
Open SQL Basic – Usage with Inline Table, UP TO and Extracting Selective Columns
Open SQL Basic – Use of Select-Endselect and Append to Internal Table
Open SQL Basic – Insert, Update, Modify and Delete in Open SQL
Open SQL in ABAP® – Insert in Open SQL with Inline and Internal Table Syntax
Open SQL in ABAP® – Update in Open SQL Using Line, Table and Inline Syntax
Open SQL in ABAP® – Update Using SET Keyword and Making it Dynamic
Open SQL in ABAP® – Use of Modify in Open SQL
Open SQL in ABAP® – Delete Using Where and Internal Table in Open SQL
Open SQL in ABAP® – Summary of the Section and Future Pointers
Open SQL Intermediate – Use of CORRESPONDING FIELDS OF TABLE and FOR ALL ENTRIES
Open SQL Intermediate – Use of CORRESPONDING FIELDS OF TABLE
Open SQL Intermediate – Making Selection Dynamic/Generic