Skip to Content
0
Former Member
Nov 22, 2006 at 04:11 PM

peformance improvement of query

62 Views

Hi guru's,

Can any one help me in knowing how can i improve performance of this query

OPEN CURSOR WITH HOLD s_cursor FOR

SELECT a~vbeln

a~posnr

b~vdatu

b~vsnmr_v

a~abgru

a~kwmeng

a~matnr

a~bedae

a~lgort

a~sernr

a~vrkme

a~werks

c~edatu

a~aedat

a~erdat

FROM ( vbap AS a

INNER JOIN vbak AS b

ON avbeln = bvbeln

AND b~vbtyp = 'W' "C0006-R2

INNER JOIN vbep AS c

ON avbeln = cvbeln

AND aposnr = cposnr

AND c~etenr = '1' )

WHERE a~vbeln IN

( SELECT objectid

FROM cdhdr

WHERE objectclas = 'VERKBELEG'

  • AND tcode = 'VA02'

AND udate IN l_r_aedat )

OR a~erdat IN l_r_aedat.

ENDIF. "Full or Delta ?

ENDIF. "First data package ?

  • Fetch records into e_t_data

FETCH NEXT CURSOR s_cursor

INTO CORRESPONDING FIELDS

OF TABLE l_t_data

PACKAGE SIZE s_s_if-maxsize.

IF sy-subrc <> 0.

CLOSE CURSOR s_cursor.

can i make use of for all entries will it improve my query performance? this query is used to extract data to datasource in bw

thanks in advance.

rahul.