abap loop 循环内表只取区间 select 语句 只取 5 条

48 篇文章 3 订阅

select 语句

select * into table gt_itab from sflight up to 5 rows.

Syntax

… [USING KEY keyname]
[FROM idx1] [TO idx2]
[WHERE log_exp|(cond_syntax)] …

Extras:

  1. … USING KEY keyname

  2. … [FROM idx1] [TO idx2]

  3. … WHERE log_exp

  4. … WHERE (cond_syntax)

*&---------------------------------------------------------------------*
*& Report  ZBAP02
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  zbap02.

data: begin of gs_line,
      carrid type sflight-carrid,
      connid type sflight-connid,
      carrname type scarr-carrname,
      end of gs_line.

data gt_itab like table of gs_line.
field-symbols <fs> like gs_line.

select carrid connid into corresponding fields of table gt_itab from sflight.

loop at gt_itab from 1 to 2 into gs_line.
  write :/ gs_line-carrid, gs_line-connid, gs_line-carrname.
endloop.

loop at gt_itab from 1 to 2  assigning <fs>.
  select single carrname into <fs>-carrname from scarr where carrid = <fs>-carrid.

endloop.

loop at gt_itab from 1 to 2 into gs_line.
  write :/ gs_line-carrid, gs_line-connid, gs_line-carrname.
endloop.

在这里插入图片描述

参考
https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-us/abaploop_at_itab_cond.htm

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值