Need suggestion, how to place alv output data file in al11 path

[former_member244346]

Hello Experts,

i am facing some issue while place file to some al11 path.

I mean my requirement is one alv program in foreground giving time out error but in background spool generating, The problem is from spool i can't get data to excel because in my setting 10 page only can get. So i am planning to download that internal table data to al11 path/ share folder path. Anybody can help on this is there any better solution or how to write internal table data to excel file.

Thanks,

[raymond_giuseppi]

I would suggest

• Use in the backgroun job! methods such as cl_salv_bs_runtime_info to get result of ALV, and methods such as cl_salv_ex_util=factory_result_data_table and cl_salv_bs_tt_util=if_salv_bs_tt_util~transform to generate a mhtml export of the result then save this on application server with some dataset statements.
• You can create a transaction to display/export to Excel this data: methods such as cl_salv_export_xml_dialog=execute and any xml display class.

[Sandra_Rossi]

10 pages it's only the default filter I say. The filter, changing, you can.

[former_member596005]

if you dont want in excel format Simply write open data set and run your program it will save in application server as file ..you can access that file with your internal table data from Al11 .

If you want in excel use convert to csv function module and write open dataset.

Regards ,

Jagadeesh.

[former_member182550]

If your code is timing out in the foreground, I would start by looking at that problem because no program that is written correctly should time out..

[former_member596005]

Richard Harper is right because recently myself wrote on abap program and is is working good without any timeout errors morevover its fetching nearly one million records.

me too faced timeout error initially due to path selection to store my file later resolved and working fine now , so if you focus on correcting foreground timeout error no hurdles will be there.