Skip to Content
0
Former Member
Apr 15, 2010 at 11:46 AM

Performance issue .

40 Views

Dear experts,

Is there a way for the following SELECT query to be improved?

The problem that due to this Query....Report is not generated on Production even in bacground for 21 hrs.

How can I improve the data retrieval here?

And I also can't change the SELECT query to be out of the loop ?

LOOP AT it_bkpf INTO wa_bkpf WHERE tcode = 'FB60'.

IF it_bkpf[] IS NOT INITIAL.

SELECT belnr "INVOICE DOC NO.

koart

shkzg

wrbtr "GROSS AMOUNT

wmwst "Tax Amount

lifnr "VENDOR

werks "SITE

FROM bseg

INTO TABLE it_bseg

FOR ALL ENTRIES IN it_bkpf

WHERE belnr = it_bkpf-belnr

AND koart = 'K' .

ENDIF.

IF it_bseg[] IS NOT INITIAL..

SELECT lifnr

name1 "PARTY NAME

FROM lfa1

INTO TABLE it_lfa1

FOR ALL ENTRIES IN it_bseg

WHERE lifnr = it_bseg-lifnr.

ENDIF.

IF it_bkpf[] IS NOT INITIAL.

SELECT belnr

gjahr

buzei

koart

shkzg

wrbtr "AMOUNT

FROM bseg

INTO TABLE it_bseg3

FOR ALL ENTRIES IN it_bkpf

WHERE belnr = it_bkpf-belnr

AND buzei = '2'

AND koart = 'S'.

ENDIF.

IF it_bseg2[] IS NOT INITIAL.

SELECT mwskz

text1 "Text1

FROM t007s

INTO TABLE it_t007s2

FOR ALL ENTRIES IN it_bseg2

WHERE mwskz = it_bseg2-mwskz

AND kalsm = 'TAXINN'

AND spras = 'EN'.

ENDIF.

ENDLOOP.