IC0668
Reading Data in ABAP with Open SQL
As an ABAP developer creating and testing your ABAP code means that you are reading from or writing to SAP databases daily. This course takes you to the next step in your ABAP learning with lessons on how to read and filter data from databases using the SAP Flight Model.
In this course you will learn:
2 Reviews 4.5 of 5.0
Course Goal
- Understand differences in SQL vs. Open SQL
- Understand how relational databases work
- Learn the syntax and usage of SELECT statements
- Understand the purpose of Inline Declarations
- Learn the different usage of WHERE clause
Audience
- Consultants
- End users
- IT/Business analysts
- Project Managers
- Project team members
Lesson Plan
| Lesson | Description | Preview |
| Course Introduction | ||
| 1 | Course Overview | Preview |
| Introduction to SQL | ||
| 2 | What is SQL? | |
| 3 | Understanding Relational Databases | |
| 4 | What is Open SQL? | |
| 5 | Discovering the Flight Model | |
| 6 | Generating Sample Flight Data | |
| Reading Data with the SELECT Statement | ||
| 7 | Writing Your First Program | |
| 8 | Introducing SELECT Statements | |
| 9 | Understanding Variables | |
| 10 | The Power of Inline Declarations | |
| 11 | Reading Only a Simple Column with SELECT SINGLE | |
| 12 | Understanding Work Areas | |
| 13 | Reading Multiple Columns with Field List | |
| 14 | Reading All Columns with the Wildcard (*) | |
| 15 | Understanding Internal Tables | |
| 16 | Reading Multiple Records with INTO TABLE | |
| Filtering Data with the WHERE Clause | ||
| 17 | Introducing WHERE Clauses | |
| 18 | Displaying the Flights in ALV List | |
| 19 | Listing American Airlines Flights with = | |
| 20 | Listing Non-American Airlines Flights with <> | |
| 21 | Listing Flights with Less than 3 Free Seats with < | |
| 22 | Listing Flights with 6 or Fewer Bookings with <= | |
| 23 | Showing AA,LH,UA Flights with Free Seats with Boolean Operators | |
| 24 | Shortening Multiple OR Conditions with IN | |
| 25 | Range Filtering with BETWEEN | |
| 26 | Searching for Specific Patterns with LIKE | |
| Course Summary | ||
| 27 | Summary | |
| 28 | Appendix - Source Code download for ABAP 7.5 and 7.0 | |
Instructor
21 Reviews
94 Students
2 Courses
ABAP Developer and Trainer
Budapest, Budapest, Hungary
More Courses by Alex Gonczy:
Student Feedback
4.5
Average Rating50%
50%
0%
0%
0%
Reviews
| Language: | English |
| Level: | Beginner |
| Duration: | 1.0 hours |
| Type: | Instructor-led |
| Delivery: | Online, instructor-led |
| Release: |
ECC 6.0 |
| Category: | ABAP |
Share this course with a friend
286
student views.
Join them!
-Lionel J.
National DCP
Related Training
Training 10 or more people?
Unlimited access for your entire SAP team including admin platform and premium reporting.SAP Training for Businesses
