Query related to Internal Table

[Former Member]

Hi ,

I have a small query related to internal table , can we dump millions of records to an internal .

The actual requirment is like i need to develop a report in BI side where i have to dump records into an internal table from PSA tables without filtering .

Can we do so ....

or do we have any other option to dump the data to an internal tables .

need some tips on the same .

Thanks ,

VInay.

[Former Member]

Hi

yes you can dump all the data into an internal table

<b>select * from table into table itab where .....</b>

no need to write the where condition also

it will get all the data into internal table at a time

reward if usefull

[Former Member]

Hi Naresh ,

will the internal table can handle millions of records at a time do we have to have like you know like sorted or harshed table like .

if you explain me a little bit more could be help ful

Thanks ,

Vinay .

[Former Member]

Hello Vinay,

I believe the following extract will give you a brief idea on the size limitations for an internal table.......

Internal tables are dynamic data objects, since they can contain any number of lines of a particular type. The only restriction on the number of lines an internal table may contain are the limits of your system installation. <u><i>The maximum memory that can be occupied by an internal table (including its internal administration) is 2 gigabytes. A more realistic figure is up to 500 megabytes. An additional restriction for hashed tables is that they may not contain more than 2 million entries.</i></u>

Hope it proved useful

Reward if helpful

Regards

Byju

[messier31]

Hi,

Yeah you can do that... but then ther might be performance issue..So better you binary search while accessing such internal. if possible make use of all key while reading..

Enjoy SAP.

Pankaj Singh.

[Former Member]

hi,

u can dump so many records as u can to internal table as they are runtime entities.

using select statement u can dump all records from PSA tables to internal tables.

data: bwdump like STANDARD TABLE OF PSA WITH HEADER LINE.

select * from PSA into table bwdump where ...................................

if helpful reward some points.

with regards,

Suresh Aluri.

[Former Member]

Hi ,,

Since the PSA table contains large number of records like 1.5 million per day .

do the internal table handle this much of records .

Need your advice on this .

Thanks ,

Vinay .

[Former Member]

Hello ,

if you select millions of records in internal table it will give short dump.

In select clause there is provision to fetch data step by step

..........

[Former Member]

Just need you comments