ABAP如何从数据表中取描述

本文探讨了在ABAP中从多个表中提取数据到一个内表的两种方法:使用left outer join直接修改内表和通过循环读取字段。通过具体示例展示了left outer join的语法和循环取数据的实现方式。

背景: 如果我们要从多个表取数据到一个内表中,则可能有两种方法,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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值