Skip to Content
0
Former Member
Feb 27, 2007 at 07:48 AM

is there any other way to do it?

23 Views

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