abap个人笔记——多表查询

多表查询

//定义数据结构
TYPES:BEGIN OF  ty_sflight_s_spfli,
  carrid TYPE sflight-carrid,
  fldate TYPE sflight-fldate,
  price TYPE sflight-price,
  planetype TYPE sflight-planetype,

  cityfrom TYPE spfli-cityfrom,
  cityto TYPE spfli-cityto,
  fltime  TYPE spfli-fltime,
  END OF ty_sflight_s_spfli.

//创建内表和工作区
DATA:gt_itab TYPE TABLE OF ty_sflight_s_spfli,
     wa_itab TYPE ty_sflight_s_spfli.
//进行查询，根据表的不同，查询时加上表名
SELECT
sflight~carrid
sflight~fldate
sflight~price
sflight~planetype

spfli~cityfrom
spfli~cityto
spfli~fltime
  FROM sflight INNER JOIN spfli   //连接两张表
  ON  sflight~connid = spfli~connid  //连接的条件
  INTO TABLE gt_itab 	//将查询的数据记录到内表
  WHERE sflight~planetype = 'DC-10-10'   //查询的条件
  AND sflight~fldate BETWEEN '20190101' AND '20190401'.

//遍历输出数据
LOOP AT gt_itab INTO wa_itab.
  WRITE:/
wa_itab-carrid,
wa_itab-fldate,
wa_itab-price,
wa_itab-planetype,
wa_itab-cityfrom,
wa_itab-cityto,
wa_itab-fltime.
ENDLOOP.

• 查询时，表和后面的属性名的连接符合是波浪号~
• 输出数据，从工作区输出，前置是工作区命名，连接符-，后缀属性名
• 表的连接用inner join，on后面跟连接的条件
• into table表示传入到某个表，这里也可以传入单条数据，into 变量名