Skip to Content
0
Former Member
Dec 02, 2006 at 10:45 AM

Select Query optimisation

29 Views

Hi.

Is there any way to optimise the below code. or can i write a join query for this if yes then how.

SELECT land1

zone1

FROM tzone

INTO CORRESPONDING FIELDS OF TABLE t_land

FOR ALL ENTRIES IN int_delivery

WHERE zone1 = int_delivery-zone1.

IF sy-subrc = 0.

SELECT land1

landx

FROM t005t

INTO CORRESPONDING FIELDS OF TABLE t_landx

FOR ALL ENTRIES IN t_land

WHERE land1 = t_land-land1.

ENDIF.

Thanks

Any help will not go unappreciated..