internal table issue

[former_member410927]

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.

[Sandeep_Panghal]

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?

[anup_deshmukh4]

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 ?

[Former Member]

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?

[Former Member]

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.