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

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

Created by: UI5 Community Network
Experts in Services, Consulting and Education

What Will I 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

Requirements

• Basic coding experience
• Basic ABAP® Skills

Target audience

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