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®
4.48 (21 reviews)
405
students
4.5 hours
content
Oct 2024
last update
$19.99
regular price
What you will 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 Gallery
Loading charts...
5470192
udemy ID
28/07/2023
course created date
15/08/2023
course indexed date
Bot
course submited by