Dump

[Former Member]

Hi frds

In our developent system we 1+ lakhs of records.i wants to find the open PO's in that.i hv completed my coding ,its working properly if i give all Parameters(Company code,Plant,Vendor,PO_Date).

But when i give plant and company(Parameters) ,the RUN TIME ERROR is coming as output.

How to increase the DUMP memory of the report .Pls give tips and coding's for solving this problem .

Thanks

PARI VENDHAN.R

[rahul2000]

the dump is surely in that case becuse of large number of record..i guess u will have to use package size in u r select query

[Former Member]

HI Rahul

Give some sample coding for package size.

thanks

Pari Vendhan.R

[Former Member]

hi

check ur select statment once.

[Former Member]

Hi Sridu,

I hv checked my select statment ,thn wat ?

Thanks

Pari

[Former Member]

hi

goto tcode: st22

then u can find dump analysis.

[Former Member]

HI sridu

How to resolve this problem in the report .

Thanks

Pari

[rahul2000]

Check th following link..

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/how%2bto%2bselect%2bdata%2bfrom%2blarge%2bta...

[Former Member]

Pari,

The place where you are selecting the 1 lakh records there change like below code. Check the select statement

DATA: WA TYPE SPFLI,

ITAB TYPE SORTED TABLE OF SPFLI

WITH UNIQUE KEY CARRID CONNID.

SELECT CARRID CONNID

FROM SPFLI

APPENDING CORRESPONDING FIELDS OF TABLE ITAB

PACKAGE SIZE 10000.

ENDSELECT.

Here every time 10000 records will extract and go for next selection of 10000.Like that it will append 1 lakh records to internal table.

Note : adjust(increase / decrease) the package size accoording to your program performance.