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: 

Download ALV Output to Excel

Former Member
0 Kudos

Hi,

  I have an issue that in ALV output we have 1 Lakh Records & Columns are dynamically increases.So while I am downloading through standard dump is coming bez of time out .

I already used SCMS_TEXT_TO_BINARY but only first column is displaying in excel.

I already tried it by convert it to String & then to Binary.Because of dynamic internal table it is also taking lot of time.

I searched Forum but I didn't any related document.

Help me to solve this...

Regards

Shek

1 ACCEPTED SOLUTION

Venkat_Sesha
Advisor
Advisor
0 Kudos

Hi Shek I am afraid how you can hold of 1 lakh records in a Excel Sheet.

I guess Max is around 65K right.

Any how try to use GUI_DOWNLOAD before/After the ALV is displayed.

If the Layout is changed then Capture the Field Cat that is being used and download only those Columns using GUI_DOWNLOAD. Hope This helps..

2 REPLIES 2

Venkat_Sesha
Advisor
Advisor
0 Kudos

Hi Shek I am afraid how you can hold of 1 lakh records in a Excel Sheet.

I guess Max is around 65K right.

Any how try to use GUI_DOWNLOAD before/After the ALV is displayed.

If the Layout is changed then Capture the Field Cat that is being used and download only those Columns using GUI_DOWNLOAD. Hope This helps..

0 Kudos

Hi Venkat,

As i tried first,by converting it into binary & download that binary data that only worked.But the problem with that is it is excel file have 200 MB.Any how issue was closed.

But I am trying to reduce the memory occupied by excel.

Thanks for ur help...

Regards