Internal Table query

[Former Member]

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.

[Former Member]

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

[Former Member]

HI Tamás,

The report is retrieving almost 60,000 records.

Thnx.

[Former Member]

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.