Learn Open SQL in New SAPⓇ S/4 HANA® with ABAP®

Name: Learn Open SQL in New SAPⓇ S/4 HANA® with ABAP®
Rating: 4.3 (31 reviews)

Learn and Understand Open SQL in SAPⓇ New SAPⓇ S/4 HANA® with New 7.4x and 7.5x of ABAP®

Created byUI5 Community Network

Last updated 10/2024

English

What you'll learn

You will learn the use of Open SQL with New ABAP® 7.4x and 7.5x on HANA® using Eclipse with ADT Plugins
The course will start from the basic theory of Open SQL vs Native SQL in SAP® and basic use of Select, Insert, Update, Modify and Delete with examples
You will learn the use of UPTO ROWS, Where and Complex WHERE, Custom Structure, Mapping Columns, Wildcards, Select in Timestamp, use of IN and RANGE Table
You will learn the use of CORRESPONDING FIELDS OF TABLE, making Selection Dynamic or Generic and use of FOR ALL ENTRIES
You will learn the use of Aggregation: COUNT, DISTINCT, MAX, MIN, SUM, AVG GROUP BY and ORDER BY
You will learn the use of Select with Subquery and Insert with Subquery, INNER, LEFT, RIGHT and CROSS JOIN
You will learn the use of Arithmetic SQL Expressions of: +, -, *, CAST, DIVISION, CEIL, FLOOR and ROUND
You will learn COALESCE and SQL String Expressions of: UPPER, LOWER, LENGTH, SUBSTRING, REPLACE, LPAD, RPAD, &&, CASE, CONCAT and CONCAT_WITH_SPACE
You will learn the use of Selection using CDS views and Path Expression
At the End of the course, you will also learn the performance consideration aspect of queries and Open SQL Code

Course content

8 sections • 36 lectures • 4h 34m total length

Introduction to Open SQL in New ABAP® on HANA® Course2:29
Introduction to the Course2:35
Codes and Snippets Examples0:05

Open SQL Basic - Open SQL Architecture Overview and Open SQL vs Native SQL11:30
Open SQL Basic - Setting up Sample Tables for Hands-on11:08
Set up and populate two sample SAP HANA tables: purchase order header and org, using Open SQL basics, with common fields, currency annotations, and simple selects for hands-on ABAP practice.
Open SQL Basic - Usage with Inline Table, UP TO and Extracting Selective Columns7:08
Explore open sql basics in abap, using inline tables, up to n rows, and extracting selective columns with into table, at the rate, and inline data.
Open SQL Basic - Use of Select-Endselect and Append to Internal Table10:15

Open SQL in ABAP® - Insert in Open SQL with Inline and Internal Table Syntax9:49
Open SQL in ABAP® - Update in Open SQL Using Line, Table and Inline Syntax11:55
Explore updating an existing purchase order record with ABAP Open SQL using line, table, and inline syntax, setting net price and the current timestamp as last change timestamp.
Open SQL in ABAP® - Update Using SET Keyword and Making it Dynamic9:01
Open SQL in ABAP® - Use of Modify in Open SQL7:23
Open SQL in ABAP® - Delete Using Where and Internal Table in Open SQL12:51
Open SQL in ABAP® - Summary of the Section and Future Pointers1:20

Open SQL Intermediate - Use of Wildcards _ and %7:27
Open SQL Intermediate - Use of Aggregation Functions10:38
Open SQL Intermediate - Use of Group by, Order by with Aggregation Functions8:35
Open SQL Intermediate - Use of Subqueries with Select6:37
Open SQL Intermediate - Use of Try-Catch with SQL Queries3:26
Open SQL Intermediate - Use of Subqueries and Exists4:13
Open SQL Intermediate - Use of Insert with Subqueries11:00

Open SQL Advanced - Explanations of Types of Joins with Examples6:13
Explore the theory of three join types—inner, left outer, and right outer—using a paired table example to show how matches determine results, blanks when no match, and join priorities.
Open SQL Advanced - Use of Inner Joins7:07
Open SQL Advanced - Use of Left Outer Joins with Right Outer Joins6:14
Open SQL Advanced - Use of Cross Joins6:57
Open SQL Advanced - Union with Select11:36

Open SQL Advanced - SQL Expressions and Usage Theory2:34
Open SQL Advanced - Use of Arithmetic SQL Expressions - Part 19:10
Open SQL Advanced - Use of Arithmetic SQL Expressions - Part 25:55
Explore open SQL arithmetic expressions, including seal, floor, and rounding, with decimal examples and the rule to avoid dividing by zero. Preview string expressions after demonstrating negative values.
Open SQL Advanced - Use of String SQL Expressions13:03
Open SQL Advanced - Use of CASE and Coalesce7:15

Requirements

Basic coding experience
Basic ABAP® Skills

Description

- Explore New Open SQL Syntaxes and Features: Delve into the enhancements available since versions 7.4x and 7.5x of the ABAP® language.
- Understand Open SQL Execution Architecture: Begin with the theoretical foundation of Open SQL within SAP®, and grasp the differences between Open SQL and Native SQL in the SAP® environment.
- Basic Usage with Practical Examples: Learn the fundamental usage of SELECT, INSERT, UPDATE, MODIFY, and DELETE statements in ABAP® with hands-on examples.
- Optimize Data Retrieval: Understand the use of SELECT-ENDSELECT loops, packet size optimizations, and best practices for various scenarios in SAP® applications.
- Master Data Manipulation Techniques: Gain proficiency in using INTO and APPEND clauses within SELECT statements in ABAP®.
- Handle Conditions and Exceptions: Utilize basic WHERE clauses, UP TO n ROWS, SINGLE SELECT, and manage SY-DBCNT, SY-SUBRC, and exceptions in SAP® ABAP®.
- Construct Complex Queries: Build simple and complex WHERE conditions using AND, OR, and parenthesis control in ABAP® Open SQL.
- Timestamp Comparisons: Discover how to use SELECT statements for timestamp comparisons in SAP® systems.
- Advanced Operators and Range Tables: Implement BETWEEN, IN operators, and RANGE tables in ABAP® Open SQL.
- Custom Data Structures and Mapping: Retrieve data into custom structures, map columns, and employ wildcards in SAP® ABAP®.
- Dynamic Selections and Table Operations: Use CORRESPONDING FIELDS OF TABLE, make selections dynamic or generic, and implement FOR ALL ENTRIES in SAP® Open SQL.
- Aggregation Functions: Apply functions like COUNT, DISTINCT, MAX, MIN, SUM, and AVG in ABAP® Open SQL.
- Grouping and Ordering Data: Utilize GROUP BY and ORDER BY clauses in SAP® ABAP® Open SQL for organized data retrieval.
- Subqueries in SQL Statements: Learn to use SELECT with subqueries and INSERT with subqueries in ABAP®.
- Implementing Joins: Understand and apply joins in SAP® ABAP®, including INNER, LEFT, RIGHT, and CROSS JOIN, supported by theoretical explanations and practical examples.
- SQL Expressions and Functions: Explore arithmetic SQL expressions, string SQL expressions, CASE statements, and the COALESCE function in ABAP® Open SQL.
- CDS Views and Path Expressions: Perform selections using Core Data Services (CDS) views and path expressions in the SAP® ABAP® environment.
- Selection using CDS views and Path Expression

Who this course is for:

SAP® Developers, SAP® Technical, Techno-Functional Consultants and Managers

Learn Open SQL in New SAPⓇ S/4 HANA® with ABAP®

What you'll learn

Explore related topics

Course content

Introduction of the Course3 lectures • 5min

Open SQL in ABAP® - Open SQL vs Native SQL in ABAP® and Basic Select Statements4 lectures • 40min

Open SQL Basic - Insert, Update, Modify and Delete in Open SQL6 lectures • 52min

Open SQL Intermediate - Use of CORRESPONDING FIELDS OF TABLE and FOR ALL ENTRIES3 lectures • 26min

Open SQL Intermediate - Use of Aggregation, Group By, Order By and Subqueries7 lectures • 52min

Open SQL Advanced - Use of Joins Inner, Left Outer, Right Outer and Cross Joins5 lectures • 38min

Open SQL Advanced - String Expressions, Arithmetic Expressions, CASE & Coalesce5 lectures • 38min

Open SQL Advanced - Path Expression, Performance and Best Practices3 lectures • 22min

Requirements

Description

Who this course is for: