ABAP-OpenSQL-select查询操作

*&---------------------------------------------------------------------*
*& Report  Z13  https://www.cnblogs.com/sanlly/p/3240795.html
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT z13.

DATA sitab LIKE TABLE OF spfli WITH HEADER LINE.

SELECT
  carrid    "航线代码
  connid    "航班连接 Id
  airpfrom  "起飞机场
  airpto    "目标机场
  FROM spfli INTO CORRESPONDING FIELDS OF TABLE sitab
  WHERE carrid = 'LH'.

IF sy-subrc = 0.
  WRITE '查询成功'.
  SKIP.
  LOOP AT sitab INTO sitab .
    WRITE:/ sitab-carrid.
    WRITE: sitab-connid.
    WRITE: sitab-airpfrom.
    WRITE: sitab-airpto.
  ENDLOOP.

ENDIF.