topic Re: Internal table : Error in Application Development and Automation Discussions

Internal table : Error

Former Member — Mon, 22 Feb 2010 08:32:55 GMT

When i am Selecting the data from the DBtable to Internal table, giving me dump,outof memory. problem due to large number of records are being read from the DBtable. How to handle this kind of situations?

Regards,

Niv

Edited by: NIV on Feb 22, 2010 9:33 AM

Re: Internal table : Error

Former Member — Mon, 22 Feb 2010 08:35:46 GMT

hi...

Define internal table with occurs 0 specification.

Regards,

Lokeswari.

Re: Internal table : Error

Former Member — Mon, 22 Feb 2010 08:36:59 GMT

Hi,

Is the structure of the internal table into which data is being selected matching with the field sequence in your select query?

Regards,

Ganga

Re: Internal table : Error

Former Member — Mon, 22 Feb 2010 08:39:10 GMT

Hi,

This is due to lack of memory in your system.ask your basis people to increase the memory or restrict the select statement with more where condition.

Thanks.

Ramya.

Re: Internal table : Error

Former Member — Mon, 22 Feb 2010 08:42:19 GMT

Hi Niv,

You can do any of these.

1. As sugested y ramya, take basis help.

2. If you do not require so many entries,try to sort it and delete the adjacent duplicates.

Regards,

Amuktha

Re: Internal table : Error

Former Member — Mon, 22 Feb 2010 08:44:44 GMT

Ask the BASIS to increases the memory allocation space.

Re: Internal table : Error

Former Member — Mon, 22 Feb 2010 08:46:38 GMT

Basis is done his Best.

is any other way? filed extracts is one of the option?

Edited by: NIV on Feb 22, 2010 9:46 AM

Re: Internal table : Error

Former Member — Mon, 22 Feb 2010 08:56:22 GMT

Hi Niv,

Ya good one Try using Field extracts. I think it will help.

Here is a small example i have found in of the threads.

REPORT demo_extract.

NODES: spfli, sflight.

FIELD-GROUPS: header, flight_info, flight_date.

START-OF-SELECTION.

INSERT: spfli-carrid spfli-connid sflight-fldate

INTO header,

spfli-cityfrom spfli-cityto

INTO flight_info.

GET spfli.

EXTRACT flight_info.

GET sflight.

EXTRACT flight_date.

END-OF-SELECTION.

SORT STABLE.

LOOP.

AT FIRST.

WRITE / 'Flight list'.

ULINE.

ENDAT.

AT flight_info WITH flight_date.

WRITE: / spfli-carrid , spfli-connid, sflight-fldate,

spfli-cityfrom, spfli-cityto.

ENDAT.

AT flight_date.

WRITE: / spfli-carrid , spfli-connid, sflight-fldate.

ENDAT.

AT LAST.

ULINE.

WRITE: cnt(spfli-carrid), 'Airlines'.

ULINE.

ENDAT.

ENDLOOP.

Regards,

Amuktha

Re: Internal table : Error

Former Member — Mon, 22 Feb 2010 08:58:14 GMT

Hi,

If possible can you please paste the code.

Thanks.

Ramya.

Re: Internal table : Error

Former Member — Sun, 21 Mar 2010 06:54:13 GMT

This message was moderated.

Re: Internal table : Error

former_member189420 — Sun, 21 Mar 2010 19:29:35 GMT

This message was moderated.