Skip to Content
0
Former Member
Sep 15, 2007 at 07:32 AM

Performance

40 Views

Hi Gurus,

SELECT * FROM mbew WHERE matnr IN s_matnr

AND bwkey IN s_werks

AND bwtty EQ space.

SELECT SINGLE * FROM mara WHERE matnr = mbew-matnr

AND mtart = 'FERT'.

IF sy-subrc NE 0.

CONTINUE.

ENDIF.

SELECT * FROM mcha WHERE matnr = mbew-matnr

AND werks = mbew-bwkey.

SELECT * FROM mchb WHERE matnr = mcha-matnr

AND werks = mcha-werks

AND charg = mcha-charg.

MOVE mchb-matnr TO itab-matnr.

MOVE mchb-werks TO itab-werks.

MOVE mchb-lgort TO itab-lgort.

MOVE mchb-charg TO itab-charg.

MOVE mchb-clabs TO itab-clabs.

APPEND itab.

ENDSELECT.

ENDSELECT.

ENDSELECT.

I need to replace the above code with for all entries by avoiding select endselect and for improving the performance with out affecting the result.

If possible please send me the better code to do this.

Thanks a lot for your help.