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.
3 Reviews 4.7 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
Exam/Certificate
- Certificate of Completion (more certification info)
Lesson Plan
| # | Description | |
|---|---|---|
| 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
4.6 Average Rating
28 Reviews
110 Students
2 Courses
Alex Gonczy
ABAP Developer and Trainer
Alex is an ABAP Developer and Trainer with over 10 years of experience and skills. He is a hardcore member of the Expertise-Team, a consulting, training, and software development company (expertise-team.com), a group of SAP professionals developing mostly in SAP Business Warehouse, programming with ABAP and delivering Mobile solutions (like Xamarin, ...). Alex is an experienced ABAP Developer with a wide range of IT skills and experience such as Test Driven Development in ABAP, Object Oriented ABAP, XML and Web Services in ABAP, ABAP Webdynpro Development, SAP Application Components, Customizing and many more. He is always open-minded for learning new technologies and practices because he believes that one became more and more valuable with the useful and popular IT technologies. You can enjoy many, simplified real-life examples by watching his courses. This is the best way of learning new things. Isn't it?
More Courses by Alex Gonczy:
ABAP for SAP Users
Are you a functional SAP specialist looking for technical training that improves your overall skills? Have you heard ...
Student Feedback
4.7
Average Rating
Reviews |
Training 5 or more people?
Unlimited access for your entire SAP team including admin platform and premium reporting.SAP Training for Businesses
| Language: | English |
| Level: | Beginner |
| Duration: | 1.0 hours |
| Type: | Instructor-led |
| Release: |
ECC 6.0 |
| Category: | ABAP |
