Please corrrect me .

[Former Member]

Instead of using

SELECT BUKRS BELNR GJAHR BLART BLDAT BUDAT XBLNR HWAER

FROM BKPF INTO TABLE TBKPF

WHERE BUKRS IN COMPCODE

AND BSTAT NE 'M'

AND BSTAT NE 'D'

AND BUDAT IN POSTDATE

AND BLART IN R_BLART

%_HINTS ORACLE 'INDEX (BKPF BKPF______Z1)'.

• order by primary key.

Is it better to use :

SELECT BUKRS BELNR GJAHR BLART BLDAT BUDAT XBLNR HWAER

FROM BKPF INTO TABLE TBKPF

WHERE BUKRS IN COMPCODE

AND BUDAT IN POSTDATE

AND BLART IN R_BLART

%_HINTS ORACLE 'INDEX (BKPF BKPF______Z1)'.

• order by primary key.

DELETE TBKPF WHERE bstat <> 'M' AND bstat <> 'D'.

[Former Member]

Neither. So ling as COMPCODE has values, this should be what you want:

SELECT bukrs belnr gjahr blart bldat budat xblnr hwaer
  FROM bkpf INTO TABLE tbkpf
  WHERE bukrs IN compcode
  AND bstat IN (' ', 'A', 'B', 'S', 'V', 'W', 'Z')
  AND budat IN postdate
  AND blart IN r_blart

Rob

Take out the HINTS. It's likely forcing the wrong index.

Message was edited by:

Rob Burbank