ALV List's capacity????

[Former Member]

Hi ABAP Gurus,

How much records can be Displayed in an ALV? Any ideas?

ABAPer,

SONU.

[RichHeilman]

A lot. But there will be performance problems when rendering he grid.

Regards,

RIch Heilman

[Former Member]

Hi Rich and Arun,

I have a data of about 100,000 for the ALV grid, it takes a lot of time and ends with a dump.

Also, is the size of the Internal Tables dependent on some system parameter or is it fixed? If it is fixed, then how many records possible?

Regards,

Sonu.

[RichHeilman]

It is a system parameter, but it is a system parameter for the amount of memory that you can use in your internal session. This includes all of your internal tables, so there is not a limit on the rows of internal table, just how much memory you can consume.

100,000 records for an ALV is a lot to render, but understand this, the ALV is supposed to be used by the user for analysis or further processing. So... how is it useful to present 100k records to your user. This amount of data is simply unmanagable. Do you see my point?

Regards,

Rich Heilman

[Former Member]

Thanks Rich,

I got your point. Actually i do have a business requirement where the customer has a huge amount of Data to Manage.

Also i need to know, is it programatically possible to change the system parameter for size of internal table in runtime. If yes, can you please show me a sample code or probably give me an overview as how to do it?

Regards,

Sonu.

[Former Member]

Sonu,

"I got your point. Actually i do have a business requirement where the customer has a huge amount of Data to Manage. "

Rich's point is discuss the foolish nature of this business requirement. The user is simply asking you to create an unusable program... unusable from the perspective that it is simply presenting too much info at one time.

Have the user revisit and redesign their business req... it is THEIR best interest to not waste your time - which means THEIR money.

[Former Member]

Hi John,

Business requirement is never foolish. I thought the same way as pointed out by you, but when i checked the requirement, i too felt ALV list is best possible option to go for. Though the data here might be really huge, but as pointed out by Rich, ALV is suited for further Analysis of the data. What i have here is a query, restricted by the boundries of some limitations, what i want here is a Solution.

ABAPer,

Sonu.

[Former Member]

"Business requirement is never foolish."

If you mean that "any and all" business reqs are never foolish, then you are new to the IT field; and there is a lot of learning ahead for you.

"I thought the same way as pointed out by you, but when i checked the requirement, i too felt ALV list is best possible option to go for."

To provide a solution to such an odd req, we need to know the details of the business requirement.

Without knowing the req, I would suggest pushing the info down to Excel. It is an off-line tool that has much richer functionalities in the DSS areana over an ALV grid.

[RichHeilman]

Analysis over 100,000 records is not manageable, this is the exact reason SAP has provided BW/BI. To take this mass data and consolidate it into managable chunks, or summaries. Something that the end user can actually use.

Regards,

Rich Heilman

[Former Member]

sonu,

There is no limit for number of records to be displayed. But maximum of 90 columns are possible in alv list. if u r selecting all the records then it will lead to a performance issue.

Regards....

Arun.

Reward points if useful.