Hi Experts.
i am extracting Account payable transaction data using tables
BSAS,BSEG and PAYR. in development sytem my programing wrking fine it is extracting 3000 records
in quality sytem i scheduled jon in background with minimal slection criteria ,the problem is since 10. hours my job is running,still the status is active it mean its consuming more time. i know iam using cluster table(BSEG) ,
please tell me do i use performance technics in select querys? if yes what are that. i already informted that i can create any indexs on BSEG.
part of code
SELECT bukrs augdt augbl gjahr belnr buzei budat
bldat waers dmbtr mwsts blart shkzg bstat
FROM bsas INTO CORRESPONDING FIELDS OF TABLE i_bsas
WHERE bukrs IN s_bukrs OR
gjahr IN s_gjahr.
IF i_bsas[] IS INITIAL.
WRITE:/ text-004.
EXIT.
ENDIF.
SORT i_bsas BY belnr.
SELECT zbukr rzawe chect lifnr vblnr gjahr laufd waers rwbtr BANCD
znme1 znme2 znme3 znme4 zpstl zort1 zstra zpfac
zland zregi zbnks zbnkn zbnkl voidr voidd voidu
checv hbkiv hktiv ichec rwskt FROM payr
INTO CORRESPONDING FIELDS OF TABLE i_payr
FOR ALL ENTRIES IN i_bsas
WHERE vblnr = i_bsas-belnr.
IF i_payr[] IS INITIAL.
WRITE : / text-003.
EXIT.
ENDIF.
SORT i_payr BY lifnr vblnr.
SELECT lifnr bukrs belnr GJAHR AUGBL rebzg rewrt shkzg zzcheckno
zzchckdate augdt zterm ebeln zlsch wrbtr dmbtr nebtr
wmwst pswsl sknto SGTXT FROM bseg
INTO CORRESPONDING FIELDS OF TABLE i_bseg
FOR ALL ENTRIES IN i_payr
WHERE belnr = i_payr-vblnr AND
lifnr = i_payr-lifnr .
please go throuh the code and let me know the solution.
thanks in adavnce
regards
niru