(1) The field name of my structure ty_my_sflight is different from field defined in sflight, so in SQL statement I use the format AS to move the content from DB to the corresponding fields of my internal table.
(2) I want to calculate the percent about how many seat are occupied and put the result into my field my_seatrate. Now I could push the calculation to DB layer instead of calculating it in ABAP side.
(3) The logic to determine the flight price in the example shows that we could define some application logic in open SQL statement.
(4) Since we are using new SQL enhanced syntax in 740, it is required that all variables defined in the application code must be escaped with flag “@” when they are being used in the SQL, as is shown in line 28 and 33.
The original data displayed in SE16:
