Skip to Content
0
Former Member
Dec 20, 2007 at 07:26 PM

how can i speed up the excution

107 Views

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