ABAP 740新的OPEN SQL增強特性
The following open SQL statement looks a little weird, however it could really works in 740.
(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:
The content of internal table lt_flight is listed below. We observed that the price for the 2013-2-13 and 2013-3-13 is reduced correctly, also the seat occupation percent.
By the way, here below is a slide which talks about the optimization on two ERP transaction in HANA. There are several kinds of optimization categories and one of them also uses the similar syntax described in this blog:
The performance before HANA optimization:
The performance after optimization in HANA:
要獲取更多Jerry的原創文章,請關注公眾號"汪子熙":
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24475491/viewspace-2712206/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ABAP 740裡的新語法 - LET表示式
- Oracle12c功能增強 新特性之管理功能的增強Oracle
- Java 16 新特性:instanceof增強Java
- C# 9 新特性 —— 增強的 foreachC#
- C# 9 新特性 —— 增強的模式匹配C#模式
- ABAP OPEN SQL裡OPEN CURSOR和SELECT的比較SQL
- Java8 新特性(一)- 介面增強Java
- ABAP 7.55 新特性 (一)
- Oracle11新特性——分割槽功能增強Oracle
- Oracle11新特性——分割槽功能增強(五)Oracle
- Oracle11新特性——分割槽功能增強(四)Oracle
- Oracle11新特性——分割槽功能增強(三)Oracle
- Oracle11新特性——分割槽功能增強(二)Oracle
- Oracle11新特性——分割槽功能增強(一)Oracle
- 利用ABAP 740的新關鍵字REDUCE完成一個實際工作任務
- ABAP 740的新語法 - 使用BO association的方式進行內表連線操作
- ABAP-MB56欄位增強
- LightDB23.1新特性支援Oracle hint增強DB2Oracle
- Oracle 12c新特性 - Active Data Guard功能增強Oracle
- Oracle11新特性——備份恢復功能增強Oracle
- Oracle11g新特性——LOB型別功能增強Oracle型別
- 深度解讀 MongoDB 最全面的增強版本 4.4 新特性MongoDB
- Oracle 12c新特性 - Data Pump (expdp/impdp) 功能增強Oracle
- Oracle11新特性——備份恢復功能增強(六)Oracle
- Oracle11新特性——備份恢復功能增強(五)Oracle
- Oracle11新特性——備份恢復功能增強(四)Oracle
- Oracle11新特性——備份恢復功能增強(三)Oracle
- Oracle11新特性——備份恢復功能增強(二)Oracle
- Oracle11新特性——備份恢復功能增強(一)Oracle
- Oracle11新特性——備份恢復功能增強(十)Oracle
- Oracle11新特性——備份恢復功能增強(九)Oracle
- Oracle11新特性——備份恢復功能增強(八)Oracle
- Oracle11新特性——備份恢復功能增強(七)Oracle
- Oracle11新特性——備份恢復功能增強(十一)Oracle
- Oracle11新特性——線上操作功能增強(七)Oracle
- Oracle11新特性——線上操作功能增強(六)Oracle
- Oracle11新特性——線上操作功能增強(五)Oracle
- Oracle11新特性——線上操作功能增強(四)Oracle