topic Re: While loading the data to the presentation server if too big in Application Development and Automation Discussions

While loading the data to the presentation server if too big

Former Member — Sat, 17 May 2008 10:03:51 GMT

Hi all,

While loading the data to the presentation server or writing them to an internal table if I find that the size of the data is too large for the internal table then what to do?

Thanks.

Re: While loading the data to the presentation server if too big

Former Member — Sat, 17 May 2008 10:21:57 GMT

Hi,

Writing to an extract writes the data to disk, rather than memory. I'm sure that your system has much more disk space than memory. Once you have populated the extract, you can loop through it just like you would to an internal table.

Extract help from SAP:

http://help.sap.com/saphelp_470/helpdat ... ameset.htm

Example program :

*>> Field-Group definition << rpt_fg hold the entire report output

data: w_kostl(10), w_line(200). " fields used in insert

field-groups: rpt_fg. " Define field-groups, no header

insert w_kostl " insert data element or table field

w_line " insert data element or table field

into rpt_fg. " field group

*>> <<

w_kostl = e_report-kostl.

w_line = e_report-line.

extract rpt_fg.

loop.

at rpt_fg.

if w_kostl = 'XXXX'.

i_rpt = w_line.

*>> do something <<

endif.

endat.

endloop.

Reward if helpfull...

Cheers,

Sowjanya.

Re: While loading the data to the presentation server if too big

Former Member — Sat, 17 May 2008 10:37:28 GMT

hi check this...

actually the internal table holds 8kb if it fills then it will get 10mb and if it fills then it will take 500mb if it fills it will take 2gb(if is set by the basis people)..or one thing...get the data into different internal tables..like this..

if the index in between 1 to 10000 then pass this data to itab1

if the index in between 10000 to 20000 then pass this data to itab2..

regards,

venkat