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.
