Internal table : Error

[Former Member]

Hi

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

[Former Member]

hi...

Define internal table with occurs 0 specification.

Regards,

Lokeswari.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

Hi,

If possible can you please paste the code.

Thanks.

Ramya.

[Former Member]

Ask the BASIS to increases the memory allocation space.

[Former Member]

This message was moderated.

[former_member189420]

This message was moderated.