topic Re: Dump in Application Development and Automation Discussions

Dump

Former Member — Tue, 26 Feb 2008 08:16:15 GMT

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

Re: Dump

rahul2000 — Tue, 26 Feb 2008 09:07:33 GMT

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

Re: Dump

Former Member — Tue, 26 Feb 2008 09:13:04 GMT

HI Rahul

Give some sample coding for package size.

thanks

Pari Vendhan.R

Re: Dump

Former Member — Tue, 26 Feb 2008 09:14:26 GMT

check ur select statment once.

Re: Dump

Former Member — Tue, 26 Feb 2008 09:16:25 GMT

Hi Sridu,

I hv checked my select statment ,thn wat ?

Thanks

Pari

Re: Dump

Former Member — Tue, 26 Feb 2008 09:22:09 GMT

goto tcode: st22

then u can find dump analysis.

Re: Dump

Former Member — Tue, 26 Feb 2008 09:31:37 GMT

HI sridu

How to resolve this problem in the report .

Thanks

Pari

Re: Dump

rahul2000 — Thu, 28 Feb 2008 07:17:15 GMT

Check th following link..

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

Re: Dump

Former Member — Thu, 28 Feb 2008 07:26:48 GMT

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.