Open SQL in New ABAP® on HANA® | Open SQL in ABAP® | ABAP® Open SQL-Select, Insert, Update, Modify
▶ Learn Open SQL in ABAP® with 7.4x and 7.5x Syntaxes Using SAP® HANA® Database
Usage of Open SQL Statements of Select, Insert, Update, Modify and Delete within ABAP® Code with New ABAP® Syntax using SAP® S/4 HANA® in BTP
▶ Time and Topics:
00:00:00 Introduction to Open SQL in ABAP® with 7.4x and 7.5x
00:02:36 Open SQL Architecture Overview and Open SQL vs Native SQL
00:14:11 Setting up Sample Tables for Hands-on
00:25:26 Simple Select Usage with Inline Table, Use of UP TO, and Extracting Selective Columns
00:32:40 Usage of Select-Endselect and Appending Data to Internal Table with Select
00:42:56 Insert in Open SQL with Inline and Internal Table Syntax
00:52:52 Update in Open SQL Using Line, Table and Inline Syntax
01:04:49 Update Using SET Keyword and Making it Dynamic
01:13:53 Use of Modify in Open SQL
01:21:19 Delete Using Where and Internal Table in Open SQL
01:34:15 Summary of the Section and Future Pointers
▶ This section is part of Learn ABAP® Essential Development with 7.4x and 7.5x Syntaxes with S/4® HANA® or HANA® in Cloud or SAP® BTP as Backend.
Link to the course: https://www.ui5cn.com/courses/open-sq...
For Discounts and Coupons Please Check the Offer Page: https://www.ui5cn.com/pages/offer-page
▶ Short details about the course:
Learn and Understand SQL in ABAP® with New 7.4x and 7.5x ABAP® Version on HANA®
▶ Key Highlights :
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 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 Comparision
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
#ui5cn
#sapabap
#s4hana
#abaponhana
#sapui5
#sapfiori
