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

最新推荐文章于 2024-07-23 17:47:21 发布

lvzhqi

最新推荐文章于 2024-07-23 17:47:21 发布

阅读量1.2k

点赞数

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

本文链接：https://blog.csdn.net/lvzhqi/article/details/4304290

版权

ABAP 专栏收录该内容

96 篇文章 2 订阅

订阅专栏

   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).