Video Lesson 5.5: Open SQL ABAP JOIN Statement

Reading Data from Different Tables (JOIN)

There is often a requirement to read data from different tables and display it.

There are four types of reuse components that select data:

• Logical databases (= data retrieval programs that read data from tables that belong together hierarchically)
• Function modules (= subroutines stored in the function library of the SAP system with encapsulated functions, such as reading from hierarchically related tables)
• BAPIs (= Methods of Business Objects with read function, for example)
• Methods of global classes

• If there are no useable reuse components available for your data selection, you have to implement the read access yourself. using a table join.
• Let's read and output SPFLI records as an example
• for each record, the long name of the respective airline, which is stored in SCARR, is to be output as well.
• you can select all the required data using the SELECT statement.