Reading Data in ABAP with Open SQL
IC0668

Reading Data in ABAP with Open SQL

As an ABAP developer who is creating and testing ABAP program code, you are reading-from or writing-to your company's SAP databases on a daily basis. In this course, you can take your ABAP skills to the next level by also learning how you can read and filter data from databases using the SAP Flight Model.

5  Reviews   4.8 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


Lesson Plan

1
01:46 mins

2
What is SQL?
01:31 mins
3
Understanding Relational Databases
05:07 mins
4
What is Open SQL?
03:23 mins
5
Discovering the Flight Model
04:42 mins
6
Generating Sample Flight Data
02:58 mins

7
Writing Your First Program
04:03 mins
8
Introducing SELECT Statements
02:52 mins
9
Understanding Variables
03:29 mins
10
The Power of Inline Declarations
01:36 mins
11
Reading Only a Simple Column with SELECT SINGLE
02:29 mins
12
Understanding Work Areas
03:10 mins
13
Reading Multiple Columns with Field List
02:25 mins
14
Reading All Columns with the Wildcard (*)
02:13 mins
15
Understanding Internal Tables
02:17 mins
16
Reading Multiple Records with INTO TABLE
01:51 mins

17
Introducing WHERE Clauses
03:17 mins
18
Displaying the Flights in ALV List
05:25 mins
19
Listing American Airlines Flights with =
02:30 mins
20
Listing Non-American Airlines Flights with <>
00:52 mins
21
Listing Flights with Less than 3 Free Seats with <
01:39 mins
22
Listing Flights with 6 or Fewer Bookings with <=
01:07 mins
23
Showing AA,LH,UA Flights with Free Seats with Boolean Operators
04:11 mins
24
Shortening Multiple OR Conditions with IN
00:47 mins
25
Range Filtering with BETWEEN
02:01 mins
26
Searching for Specific Patterns with LIKE
01:52 mins

27
Summary
02:31 mins
28
Appendix - Source Code download for ABAP 7.5 and 7.0

Instructor

Alex Gonczy

4.6 Average Rating

33 Reviews

133 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
ABAP for SAP Users

Are you a functional SAP specialist looking for technical training that improves your overall skills? Have you heard ...

4.6

Average Rating

View All Courses

Student Feedback

4.8

Average Rating

Reviews

Subscribe to All Courses
Subscribe

Or subscribe to this course for

$69


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

SAP students

621

student views.
Join them!


Related Courses