Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ALV List's capacity????

Former Member
0 Kudos
132

Hi ABAP Gurus,

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

ABAPer,

SONU.

1 ACCEPTED SOLUTION

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos
81

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

Regards,

RIch Heilman

9 REPLIES 9

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos
82

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

Regards,

RIch Heilman

0 Kudos
81

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.

0 Kudos
81

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

0 Kudos
81

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.

0 Kudos
81

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.

0 Kudos
81

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.

0 Kudos
81

"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.

0 Kudos
81

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
0 Kudos
81

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.