topic Re: select query going to dump in Application Development and Automation Discussions

select query going to dump

Former Member — Wed, 21 Oct 2009 08:23:22 GMT

Hi all,

My select query is going to dump due to huge no of records. I have around 600000 records.

What is the best method we can use to avoid dump. How can we use package.

regards,

Mani

Re: select query going to dump

former_member226519 — Wed, 21 Oct 2009 09:04:28 GMT

use

OPEN CURSOR WITH HOLD C FOR SELECT * FROM table

while <condition>

fetch next cursor C into table itab package size PACK_SIZE

....

endwhile.

challenge is PACK_SIZE

Re: select query going to dump

Former Member — Wed, 21 Oct 2009 09:05:53 GMT

v_size = 20000.

SELECT mandt bukrs belnr gjahr blart bldat

budat monat tcode xblnr dbblg

bktxt waers kursf bstat FROM bkpf INTO TABLE it_bkpf PACKAGE SIZE v_size

WHERE gjahr IN s_ryear

AND bukrs IN s_bukrs

AND bstat IN (' ','A','B').

SELECT mandt bukrs belnr gjahr buzei bschl koart

shkzg mwskz gsber dmbtr wrbtr mwart

sgtxt bewar vorgn kostl vbeln vbel2

saknr hkont kunnr lifnr matnr ebeln

anln1 anln2 anbwa bzdat FROM bseg INTO TABLE it_bseg FOR ALL ENTRIES IN it_bkpf

WHERE bukrs IN s_bukrs

AND belnr = it_bkpf-belnr

AND gjahr IN s_ryear.

IF sy-subrc = 0.

your code

ENDIF.

ENDSELECT.

Re: select query going to dump

kesavadas_thekkillath — Wed, 21 Oct 2009 09:06:27 GMT



SELECT vbeln erdat FROM vbak INTO TABLE lt_vbak PACKAGE SIZE 50. "here it fetches 50 records for a hit

if lt_vbak[] is not initial.

SELECT posnr matnr meins FROM vbap INTO TABLE lt_vbap
FOR ALL ENTRIES IN lt_vbak
WHERE vbeln = lt_vbak-vbeln.

IF sy-subrc = 0.
* Now you have the two internal tables lt_vbak and lt_vbap filled with data.
* Do something with the data - remember to reinitialize internal tables
ENDIF.

clear lt_vbak[].

ENDSELECT.