Skip to Content
0
Former Member
Dec 08, 2006 at 12:52 PM

can we replace this SELECT query by more efficient code

33 Views

can we replace this SELECT query by more efficient code ?:-

SELECT * FROM zv7_custord
     INTO TABLE G_T_ZV7_CUSTORD
     WHERE ( SENDER in S_SENDER and
             ORDNUM in S_ORDER  and
             ZDATE   in S_DATE ) OR
           ( SENDER in S_SENDER AND
             STATUS = SPACE )
     ORDER BY IDOCNUM.