SAP Training: Reading Data in ABAP with Open SQL

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:

Not Enough Reviews Yet

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

Alex Gonczy

4.7 Average Rating

6 Reviews

54 Students

2 Courses

ABAP Developer and Trainer

Budapest, Budapest, Hungary

Alex is an ABAP Developer and Trainer with over 8 years of experience. He is a member of Expertise-Team, a consulting, training, and software development company (expertise-team.com), a group of SAP professionals developing in SAP Business Warehouse, programming with ABAP and delivering Mobile solutions. 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 WebServices in ABAP, ABAP Webdynpro Development, SAP Application Components, and Customizing. Open-minded for learning new technologies and practices. 



More Courses by Alex Gonczy:
ABAP for SAP Users

  (4.7)



Student Feedback

Not Enough Reviews Yet




Level: Beginner
Duration: 1.00 hours
Type:  Instructor-led
Delivery: Online, instructor-led
Release: ECC 6.0
Category: ABAP

Share this course with a friend



15 SAP students

students enrolled.
Join them!


SAP Student testimonial
I have enjoyed your SAP access and it has been very reliable and performance was very good.
-Bob  C.
Supply Chain Optimization and Predictive Analytics
itelligence


Related Training


Training 10 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses