Basic List to Excel

[Former Member]

Hi All,

I have a requirement , i have created a report with basic-list with all subtotal, opening & Closing balance of different customer (i.e customer ledger),

the list is very complex so i didnot create alvlist.

Now my requirement i that, my end user want this report to convert into excel,he can convert this through meenu path list->save->file->spreedsheet,

but i want the menu bar as in alv ,i set the pf status as standard .

it is getting displayed correctly, but the meenu path

list-> export->xmlexport is inactive.

i used CALL FUNCTION 'XXL_FULL_API' but it will not work as my data form diff internal table is getting fetch.

what is the solution,

Thanks & Regards

Lalith

[Former Member]

HI Lalith,

A small suggestion from my side.

You can provide provision for downloading the List to Excel in Program it self.

it's very simple you can call the below function module from program.

call function 'SAP_CONVERT_TO_XLS_FORMAT'
    exporting
      i_filename     = l_file
    tables
      i_tab_sap_data = i_final_output1.

l_file is the file path.and the i_final_output1 is the final internal table.

U can also make the user friendly by getting the file path from selection screen.so that user can enter the desired path.