is there any other way to do it?

hi

is there any other way to do it? if yes please tell me how...

LOOP AT itab.

SELECT SINGLE lgort INTO lv_lgort

FROM zbas

WHERE werks EQ itab-werks

AND lgort EQ itab-lgort.

IF sy-subrc NE 0.

DELETE itab.

ENDIF.

ENDLOOP.

this creates the perforamnce issue that we can not use select inside loop.plz suggest me the other way to do it..

i m tryin to do it this way .. will it work

SELECT SINGLE lgort INTO lv_lgort

FROM zbas

WHERE werks EQ itab-werks

AND lgort EQ itab-lgort.

LOOP AT itab.

IF lv_lgort NE itab-lgort.

DELETE itab.

ENDIF.

ENDLOOP.

thnx