topic internal table issue in Application Development and Automation Discussions

internal table issue

former_member410927 — Wed, 22 Dec 2010 05:58:49 GMT

Hi experts , my database table has 1 million records , now i want to display it on screen , just like se11 table display ,

if i select it in internal table , will the internal table hold that much data , or if the size keep growing , then how will the internal table hold that huge data , is there any other alternative.

Re: internal table issue

Sandeep_Panghal — Wed, 22 Dec 2010 06:03:31 GMT

Yes, internal table can hold this much of data.

But you should also analyse do you really need to display 1 million records and how this information will be processed or used?

Re: internal table issue

anup_deshmukh4 — Wed, 22 Dec 2010 06:04:56 GMT

Yes....Internal table is capable of handling this much amount of data, ( Ooh..Till it doesnot exceeds the memory allocated report to it during run time )

but it is suggestible to have a strong selection criteria...! display in chunks...!

the man thing is that Will the End User who will be using this data will able to interpret this huge amount of data ?

Re: internal table issue

Former Member — Wed, 22 Dec 2010 06:05:10 GMT

Hi,

Firstly, the size of the internal table depends on the memory. I am not sure if your internal table can hold close to 1M records. By the way, why do you want to display all 1 million records to the user?

Re: internal table issue

Former Member — Wed, 22 Dec 2010 06:06:55 GMT

Hi,

First of all do you want to display all the records of the table like se11 or depending on some condition you want to show the data.

if you want to show all the records. then you already have se11/sm30 you can create a Tcode for displaying the entries instead..

If you want to show it depending on some Condition.

then, use table control/ALV.