he 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的原创文章,请关注公众号"汪子熙":
相关推荐
ABAP 740 新语法 COND FOR SWITH VALUE CONCATION 等等
这个是国外人使用ABAP写的一个类似一SQL Server的查询分析器,它能够直接运行ABAP的OPEN SQL,由于SE11或者是SE16都只能对一表进行查询,但很多的时候我们需要对多个表进行联合查询,这时就可以发挥很大作用了,希望...
讲解了ABAP SQL Functions for Strings的使用
详细讲述SAP ABAP的BADI增强的概述及使用。详细讲述SAP ABAP的BADI增强的概述及使用。详细讲述SAP ABAP的BADI增强的概述及使用。详细讲述SAP ABAP的BADI增强的概述及使用。详细讲述SAP ABAP的BADI增强的概述及使用。...
ABAP
基于SAPR/3系统的ABAP语言OpenSQL应用.pdf
SAP ABAP开发 BADI 屏幕增强资料,含BADI入门,SAP ABAP与JAVA之间通过RFC传递数据实例,SAP屏幕增强示例,SAP用户出口
ABAP 搜索帮助增强. 基于第一代, 步骤写的很清楚.
sap ABAP 配置外界数据库SQL server驱动,官方步骤。
APAP程序 用于open sql 直接查询 database
本程序自主开发,包括SELECT,UPDATE,DELETE,INSERT操作,SELECT 语句可以根据自定义的内表动态的输出ALV 列表,UPDATE DELETE INSERT 语句可以对数据库表进行操作. 切忌谨慎应用此程序对数据库的操作,以免造成数据...
abap SQL优化 abap编程的SQL的性能优化,在编程时注意的地方,可以是程序性能更好!
第一代:基于源码增强(子过程subroutine:Form) 通过SPRO->IMG查找用户出口 通过开发类查找用户出口 用户出口子程序所能使用的数据变量 VA01增强示例 第二代:基于函数出口增强(Function) SMOD与CMOD的区别 查找...
ABAP SQL使用技巧,可以提高程序的运行速度,降低数据交换的时间。
介绍ABAP如何做用户增强,有实例。可以按照实例快速上手。
本文介绍了ABAP语法中的新关键字,适用于S4等新系统,不适用于老系统ECC。其中包括DATA和FIELD-SYMBOL的使用方法。
ABAP中涉及BDC\增强等技术的相关讲解,其中BDC讲的比较细。
介绍ABAP增强的历史,大概介绍三代增强的发展过程。
ABAP中增强的介绍和使用,三种方式的介绍,一代二代三代
关于SQL语句的性能