ABAP如何从数据表中取描述

背景: 如果我们要从多个表取数据到一个内表中,则可能有两种方法,1种是可以outer join直接修改内表,另外一种则可以是用循环,下面是两个例子。

以下是left outer join的用法

 SELECT T1~ZDZNY AS A1,   T1~BUKRS AS A2,  T1~WERKS AS A3, T1~EKORG AS A4,  T1~LIFNR AS A5,  T1~MATNR AS A6,   T1~MEINS AS A7,   T1~QCSL AS A8,  T1~HGSL AS A9,  T1~THSL AS A10,
     T1~KPSL AS A11,  T1~JCSL AS A12, T1~BHSL AS A13, T1~ZBEIZ AS A14, T1~ERDAT AS A15, T1~ERNAM AS A16 , T1~UZEIT AS A17,T2~MAKTX AS A18, T3~NAME1 AS A19
     FROM ZSRMDZD as t1
     left outer join  LFA1 as t3  on t3~LIFNR = t1~LIFNR
    left outer join  makt as t2  on t2~MATNR = t1~MATNR
     INTO TABLE @ITEM
   WHERE T1~ZDZNY IN @S_ZDZNY
   AND T1~BUKRS  IN  @S_BUKRS
   AND T1~WERKS IN  @S_WERKS
   AND T1~EKORG IN  @S_EKORG
    AND T1~LIFNR IN  @S_LIFNR
    AND T1~MATNR IN   @S_MATNR.

以下是循环来取字段
for all entri in + read table

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

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值