Learn Open SQL in New SAPⓇ S/4 HANA® with ABAP®
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
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
Instructor
- 4.3 Instructor Rating
- 9,417 Reviews
- 72,601 Students
- 18 Courses
50+ Years of combined experience in Services, Consulting and Education. With more than a decade of experience in enhancing and implementing cutting-edge technology for major European industries, some of them include big Fortune 500 names.
We believe that sharing makes the World a better place. And our courses are made with a lot of effort to put together complex topics in the most simple way.