Wrong results of SELECT with OR condition

Question

It seems that as result the program is getting all sales orders (from VBAK table) only with AUART = 'YI01', and indeed I am getting 1.699.698 sales orders. So it is ignoring the other parameters in select VTWEG = 'Z1', SPART = 'Z1', KUNNR = '0230001039', ERDAT = GT '01.09.2017' for which I should get only 77 results.

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'.

Thanks a lot for your help

If you want to be a programmer, it is a good idea to get to know logic first. — Jagger, Sep 18 '17 at 06:11
hi all, thanks for your help, unfortunately I am still getting wrong results. What I want to do is to extract from VBAK table with following parameters: vkorg = 'Z326' vtweg = 'Z1' spart = 'Z1' kunnr = '0230001039' auart = 'YC01' OR auart = 'YI01' erdat GT '20170901' — hammerman, Sep 18 '17 at 07:27

score 3 · Answer 1 · answered Sep 16 '17 at 10:03

You can do two things: 1) Use parentheses around OR 2) Change date format to '20170901'. In db, dates are stored like 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'.

score 2 · Answer 2 · answered Sep 15 '17 at 17:31

AND has a higher priority than OR, so you're effectively selecting for

( vkorg = 'Z326' AND vtweg = 'Z1' AND spart = 'Z1' AND kund = '0230001039' AND auart = 'YC01' )
  OR
( auart = 'YI01' AND erdet GT '01.09.2017' )

which is most certainly not what you intended to do. Use parentheses around your OR clause.

score 1 · Answer 3 · edited Sep 18 '17 at 06:11

1

Use parentheses around the OR

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'.

edited Sep 18 '17 at 06:11

Jagger

10,350
9
51
93

answered Sep 15 '17 at 17:31

András

1,326
4
16
26

Wrong results of SELECT with OR condition

3 Answers3

Use parentheses around the OR