动态确定where clause condition的一段例子

最新推荐文章于 2022-08-26 23:33:51 发布

lvzhqi

最新推荐文章于 2022-08-26 23:33:51 发布

阅读量1.3k

点赞数

分类专栏： ABAP 文章标签： table

本文链接：https://blog.youkuaiyun.com/lvzhqi/article/details/4304290

版权

ABAP 专栏收录该内容

96 篇文章

订阅专栏

本文介绍了一种使用ABAP编程语言进行数据筛选的方法。通过不同的条件如航班运营商、连接ID及日期等来从数据库中选择航班信息。此外，还介绍了如何根据用户选择的选项（全部、国内或国际航班）来进一步细化查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

   DATA: where_line(40) TYPE c,
        where_table LIKE TABLE OF where_line.
* Checking the output parameters
  CASE mark.
    WHEN all.
** Radiobutton ALL is marked
*      SELECT * FROM dv_flights INTO TABLE it_flights
*        WHERE carrid IN so_car
*          AND connid IN so_con
*          AND fldate IN so_fdt.

    WHEN national.
      where_line = 'countryto = dv_flights~countryfr'.
      APPEND where_line TO where_table.
      CONCATENATE 'AND countryto =' ''''
             INTO where_line SEPARATED BY SPACE.
      CONCATENATE where_line country '''' INTO where_line.
      APPEND where_line TO where_table.
* Radiobutton NATIONAL is marked
*      SELECT * FROM dv_flights INTO TABLE it_flights
*        WHERE carrid IN so_car
*          AND connid IN so_con
*          AND fldate IN so_fdt
*          AND countryto = dv_flights~countryfr
*          AND countryto = country.

    WHEN internat.
      where_line = 'countryto <> dv_flights~countryfr'.
      APPEND where_line TO where_table.
* Radiobutton INTERNAT is marked
*      SELECT * FROM dv_flights INTO TABLE it_flights
*        WHERE carrid IN so_car
*          AND connid IN so_con
*          AND fldate IN so_fdt
*          AND countryto <> dv_flights~countryfr.
  ENDCASE.
  SELECT * FROM dv_flights INTO TABLE it_flights
        WHERE carrid IN so_car
          AND connid IN so_con
          AND fldate IN so_fdt
          AND (where_table).