abap opensql 官方文档 abap 整洁之道

nongcunqq

已于 2024-03-14 09:08:14 修改

阅读量282

点赞数 3

分类专栏： SAP 文章标签： abap

于 2024-03-14 08:53:31 首次发布

本文链接：https://blog.csdn.net/nongcunqq/article/details/136697558

版权

SAP 专栏收录该内容

47 篇文章 3 订阅

订阅专栏

abap 整洁之道
https://github.com/SAP/styleguides/blob/main/clean-abap/CleanABAP_zh.md

支持 in 语法 in （’12‘，’34‘）

SELECT mainquery_clauses
  [UNION ...]
  INTO|APPENDING target
  [UP TO ...] [OFFSET ...]
  [abap_options].
  ...
[ENDSELECT].

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abapselect.htm

... operand [NOT] IN ( SELECT subquery_clauses [UNION ...] ) ...

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abenwhere_logexp_in_subquery.htm

DATA: carr_id TYPE spfli-carrid VALUE 'LH',
      conn_id TYPE spfli-connid VALUE '400'.


SELECT SINGLE city, latitude, longitude
       FROM sgeocity
       WHERE city IN ( SELECT cityfrom
                              FROM spfli
                              WHERE carrid = @carr_id AND
                                    connid = @conn_id )
       INTO (@DATA(city), @DATA(lati), @DATA(longi)).