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.