SELECT with OR condition的错误结果

Question

结果似乎是程序只在AUART='yi01'的情况下获得所有销售订单（从vbak表），而实际上我获得的是1.699.698个销售订单。因此，它忽略了selectvtweg='z1',spart='z1',kunnr='023001039',erdat=>'01.09.2017'中的其他参数，对于这些参数，我应该只得到77个结果。

TYPES: BEGIN OF lw_odv_vbak,
        vbeln TYPE vbak-vbeln,
        vkorg TYPE vbak-vkorg,
        vtweg TYPE vbak-vtweg,
        spart TYPE vbak-spart,
        netwr TYPE vbak-netwr,
        kunnr TYPE vbak-kunnr,
        erdat type vbak-erdat,
      END OF lw_odv_vbak.


DATA: it_odv_vbak TYPE STANDARD TABLE OF lw_odv_vbak INITIAL SIZE 0.



SELECT vbeln
     FROM vbak
      INTO TABLE it_odv_vbak
      WHERE vkorg = 'Z326'
      AND vtweg = 'Z1'
      AND spart = 'Z1'
      AND kunnr = '0230001039'
      AND auart = 'YC01' OR
          auart = 'YI01'
        AND erdat GT '01.09.2017'.

非常感谢你的帮助

Answer 1

您可以做两件事：1）使用圆括号或2）将日期格式更改为“20170901”。在db中，日期像yyyymmdd一样存储。

SELECT vbeln
 FROM vbak
  INTO TABLE it_odv_vbak
  WHERE vkorg = 'Z326'
  AND vtweg = 'Z1'
  AND spart = 'Z1'
  AND kunnr = '0230001039'
  AND ( auart = 'YC01' OR auart = 'YI01') 
  AND erdat GT '20170901'.