Question

我可以选择更多的选择和选择。 4个表格(最后一个表格只是收集所有数据)

但现在认为,要选择所有领域的方法,只需要一份选择说明。这里是巨大的选择:

  SELECT vbak~vbeln vbak~audat
         tvakt~bezei
         vbap~posnr vbap~matnr vbap~kwmeng vbap~vrkme
         lips~vbeln lips~posnr lips~werks lips~lfimg
         vbfa~vbtyp_n
    FROM vbak JOIN vbap ON vbak~vbeln = vbap~vbeln
              JOIN tvakt ON vbak~auart = tvakt~auart
              LEFT JOIN vbfa ON vbfa~vbelv = vbak~vbeln AND vbfa~posnv = vbap~posnr
              JOIN lips ON vbfa~vbeln = lips~vbeln AND vbfa~posnn = lips~posnr
    INTO TABLE gt_salord
    WHERE tvakt~spras =  EN  AND
          vbak~vbeln IN s_vbeln AND
          vbak~audat IN s_audat.

The problem is this doesn t work. When i try to activate it throws this error: " Unable to compare with "VBAP~POSNR". A table can be joined with a maximum of one other table using LEFT OUTER JOIN " If i don t use LEFT JOIN and only JOIN it works but i don t get all what i want. I need to get all the SALES ORDERS even if they don t have a DELIVERY ORDER assigned. Is there a way to do that, or do i really have to split my select?

Answer 1

我在SAP中注意到,简化选择说明和着手处理不参与数据选择的表格的LOOP和SlectT SINGLE的工作效率更高。

在您的案例中,表VBFA的数据在数据选择之后可以检索(这并不限制与非行的数据数量)。

当然,这取决于指数、应用服务器缓冲...,但即使它可能是对专家的反攻,在SAP中保留某些并非过于复杂的声明也是最好的。

Answer 2

您可以尝试以下选择:

SELECT vbak~vbeln vbak~audat
       tvakt~bezei
       vbap~posnr vbap~matnr vbap~kwmeng vbap~vrkme
       lips~vbeln lips~posnr lips~werks lips~lfimg
       vbfa~vbtyp_n
  FROM vbak JOIN vbap ON vbak~vbeln = vbap~vbeln
            JOIN tvakt ON vbak~auart = tvakt~auart
            LEFT JOIN vbfa ON vbfa~vbelv = vbap~vbeln AND vbfa~posnv = vbap~posnr
            JOIN lips ON vbfa~vbeln = lips~vbeln AND vbfa~posnn = lips~posnr
  INTO TABLE gt_salord
  WHERE tvakt~spras =  EN  AND
        vbak~vbeln IN s_vbeln AND
        vbak~audat IN s_audat.

I can t test the result, but the syntax check say: ok.

只有一个小差:

                                                  x---- difference
                                                  v
                LEFT JOIN vbfa ON vbfa~vbelv = vbap~vbeln AND vbfa~posnv = vbap~posnr 
                LEFT JOIN vbfa ON vbfa~vbelv = vbak~vbeln AND vbfa~posnv = vbap~posnr

http://code>vbfa~vbelv with vbak~vbeln, I do it with vbap~vbeln. 两者都具有同样的价值,但在<代码>on-clause,你再次使用vbap。

Answer 3

我非常了解SAP Abap。但从观点看,如果在SAP中支持,你可以使用衍生的查询。

下面是一些做法:

select * from
(
select * from
table1 inner join table2 on table1.key=table2.key
inner join table3 on table1.key=table3.key
) a left outer join table4 b 
on a.key=b.key

由于问题被拖到Kingk。希望能发挥作用

Answer 4

要求修改左边条款中的表格田顺序。 Put vbap~vbeln = vbfa~vbelv

友情链接