into corresponding fields of table和 into table的区别

64 篇文章 1 订阅
types : begin of so_inf.
types flag(1).
types box type box.
include structure ztmm_223a.
TYPES maktx TYPE makt-maktx. "物料描述
types menge1 type ztmm204-menge1. "实际批量
types end of so_inf.


data: gt_so_inf type table of so_inf,
      gs_so_inf type so_inf,
      gw_so_inf type so_inf.
  select a~*,b~maktx, c~menge1  into corresponding fields of table @gt_so_inf
    from ztmm_223a as a
    inner join makt as b on a~matnr = b~matnr
    inner join ztmm204 as c on a~matnr = c~matnr and a~werks = c~werks
    where a~matnr in @s_matnr and a~werks in @s_werks
         and b~spras = 1 .
  sort gt_so_inf by matnr.
  select a~*,b~maktx, c~menge1  into  table @gt_so_inf
    from ztmm_223a as a
    inner join makt as b on a~matnr = b~matnr
    inner join ztmm204 as c on a~matnr = c~matnr and a~werks = c~werks
    where a~matnr in @s_matnr and a~werks in @s_werks
         and b~spras = 1 .
  sort gt_so_inf by matnr.

如果只写INTO TABLE,会提示报错,提示数据不兼容,这是由于 into corresponding fields of table 代表程序会检查变量名之后进入gt_so_inf
而如果不加,默认会按照顺序进入gt_so_inf 所以会报错

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值