topic Re: Internal Table query in Application Development and Automation Discussions

Internal Table query

Former Member — Wed, 08 Aug 2007 10:04:36 GMT

Hi experts ,

I'm trying to extract the data from database and importing it into Text file on local server ...while executing the program it is dumping and giving the error messege

"No storage space available for extending the internal table."

Refer the following dumpcode.

EXPORTING

i_selections = p_$_selections

I_CONVERT_CURRENCY =

I_USE_ACCOUNT_CONTRL =

i_show_errors = $_c_x

i_show_progess = $_c_x

IMPORTING

E_LOG_HANDLE =

TABLES

e_bkpf = $_bkpf

e_bseg = $_bseg

E_BSIS =

E_BSAS =

E_BSAD =

E_BSAK =

E_BSIP =

E_BSIM =

I_ARCH_SEL =

EXCEPTIONS

no_infostruc_found = 1

selections_error = 2

conversion_error = 3

OTHERS = 4

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

APPEND LINES OF $_bkpf TO p_$_bkpf.

> APPEND LINES OF $_bseg TO p_$_bseg.

ENDFORM. " read_archive

Please help me out in this regard...

Thnx.

Re: Internal Table query

Former Member — Wed, 08 Aug 2007 10:07:56 GMT

Hi!

You might try out this syntax also:

REFRESH p_$_bkpf.

p_$_bkpf[] = $_bkpf[].

How many records are present? If the number is too much, you might try to concentrate only to the relevant colums. For example if it is enough for you using the BELNR, GJAHR columns, then don't use the full BKPF structure, only this 2...

Use TYPES to define your own structure. With this you can save a lot of memory.

And don't forget to use the same structure to excahnge data between 2 internal tables.

Regards

Tamás

Message was edited by:

Tamás Nyisztor

Re: Internal Table query

Former Member — Wed, 08 Aug 2007 10:08:38 GMT

Error No storage space available for extending the internal table means say u have declared ur internal tabe with 4 fields.

Now, ur selecting data from a table and ur trying to select 5 fields and pushing the data into the internal table, in such cases the above error message is displayed and the program goes into dump.

Re: Internal Table query

Former Member — Wed, 08 Aug 2007 10:12:27 GMT

HI Tamás,

The report is retrieving almost 60,000 records.

Thnx.