• Post category:StudyBullet-15
  • Reading time:5 mins read


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


Get Instant Notification of New Courses on our Telegram channel.


DealsCrown Telegram Banner
  • 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