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.