Skip to Content
0
Jul 19, 2007 at 09:59 AM

Performance Tuning

17 Views

Hi All,

In Billing Doc, for the doc type of 'RE' I am selecting the field LGORT from table LIPS based on VGBEL & POSNR. Though there is an index for VGBEL in table LIPS, it is taking more time. Is there any other way to reduce the time taken for fetchig data.

The coding is given below:

SELECT VGBEL POSNR LGORT FROM LIPS INTO TABLE ITAB_LIPS1 FOR ALL ENTRIES IN ITAB_VBRP WHERE VGBEL = ITAB_VBRP-VGBEL

AND POSNR = ITAB_VBRP-POSNR.

Thanks,

Vipin.