topic Re: ABAP -Tcode Excel download in Application Development and Automation Discussions

ABAP -Tcode Excel download

venkatesh_veera2 — Sat, 23 Mar 2019 07:15:37 GMT

Hi Guru,Im having a tcode AR02. Im having a requirement to enhance the existing program... so that when ever we click the execute button it has to extract the tcode output data to excel sheet on desktop or AL11 folder.

P.S. GUI_DOWNLOAD won't work as it will get the data from internal table. In the SAP standard program there are many includes like for header, columns, alv grid etc. I need to get the same out put which we see in tcode after alv etc in my excel sheet.

Can some one plese help.

Re: ABAP -Tcode Excel download

VenkatRamesh_V — Sat, 23 Mar 2019 08:24:54 GMT

Hi,

Try , FM LIST_FROM_MEMORY for getting data from standard.

Re: ABAP -Tcode Excel download

matt — Sat, 23 Mar 2019 09:16:03 GMT

abab2xlsx

Google it.

Re: ABAP -Tcode Excel download

Sandra_Rossi — Sun, 24 Mar 2019 08:34:38 GMT

You mean export the ALV table to Excel file? Isn't there a standard Export button already?

Re: ABAP -Tcode Excel download

DoanManhQuynh — Mon, 25 Mar 2019 01:45:53 GMT

I dont think there is enhancement point to do what you want, its just a simple report with start, end selection. even there is, you have to write your own code to extract the result from report to excel with the same layout ( like color, header, summarize...).maybe you can write a Z report to submit that tcode, get ALV data and layout configuration using CL_SALV_BS_RUNTIME_INFO and rebuild it with abap2xlsx, ooxml...

Re: ABAP -Tcode Excel download

bala_sikkal — Mon, 25 Mar 2019 07:19:21 GMT

hi,

1. Create a custom program, Inside call your standard program by Submit statement

For more info..

Get your standard program output by using class: CL_SALV_BS_RUNTIME_INFO

http://zevolving.com/2015/07/salv-table-22-get-data-directly-after-submit/

2. In your custom program you need to design the excel download format including header, line items, and color similar to the standard output using OLE Method.

https://wiki.scn.sap.com/wiki/display/SI/OLE+concept+for+downloading+the+report+output+into+excel

Re: ABAP -Tcode Excel download

RaymondGiuseppi — Mon, 25 Mar 2019 07:52:05 GMT

There is a paramter on AR02 'Use ALV grid' to generate an ALV grid, why didn't your users check it, if users actually refuse to export the data themselves then copy the selection-screen in a z-report, submit standard report, with 'P_GRID = abap_true', wrapped with CL_SALV_BS_RUNTIME_INFO and export the returned data yourself (many threads/discussions are already available so use search tool)