CSV files in a server through Bex Query

Hi BW Experts,

we have requirement to generate Bex Query output to csv files in a remote folder. Bex query has 61 fields in rows including nav attributes all are mandatory for user . Query output in CYTD (Current year YTD). everymonth user run it and get csv file in that location. How can we achieve this in bw including automating the same flow like process chain etc.?

APD i tried but getting short dumps due to memory issues and it has a limit of 60 fields. If APD is good option we can ask user to cut few fields to reduce 60 field limit.

please advice.

Regards,

RK