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.