topic Re: send excel to shared folder in Application Development and Automation Discussions

send excel to shared folder

vallamuthu_madheswaran2 — Tue, 12 Jan 2021 05:54:15 GMT

Hi Friends,

My requirement is that just get the data from the table send the data(excel file) to the shared folder.

Kindly provide the steps. I have searched the existing threads but no fruitful result.

Thanks with Regards,

Vallamuthu M

Re: send excel to shared folder

former_member717457 — Tue, 12 Jan 2021 06:12:11 GMT

Hello Vallamuthu Madeswaran,

Pls. find the below code, it may useful to you for this requirement.

REPORT ZFILE.
TABLES mara.
data it_mara TYPE TABLE OF mara.
data wa_mara like LINE OF it_mara.
data lv_file TYPE rlgrap-filename.
data lv_data type string.

START-OF-SELECTION.
SELECT * FROM mara INTO TABLE it_mara UP TO 10 ROWS.

lv_file = 'sample.xls'.
OPEN DATASET lv_file FOR OUTPUT In TEXT MODE ENCODING DEFAULT.
loop AT it_mara INTO wa_mara.
CONCATENATE wa_mara-matnr
wa_mara-mtart
wa_mara-mbrsh
wa_mara-meins
wa_mara-ernam
wa_mara-ersda
INTO lv_data SEPARATED BY ','.
TRANSFER lv_data to lv_file.
clear: wa_mara.
ENDLOOP.
if sy-subrc IS INITIAL.
MESSAGE 'File stored to FTP path Successfully' TYPE 'I'.
ENDIF.
CLOSE DATASET lv_file.

Thanks

Sathish Kumar Sidhaiyan

Re: send excel to shared folder

former_member717457 — Tue, 12 Jan 2021 06:14:30 GMT

After executing the code the excel file will store into shared file folder and you can check this in Home directory using Transaction AL11.

Thanks

Sathish Kumar Sidhaiyan

Re: send excel to shared folder

vallamuthu_madheswaran2 — Tue, 12 Jan 2021 07:18:53 GMT

Hi Sathish,

Thanks for your update.

We'll not stored in AL11. Shared folder is not in SAP system. it's separate storage path, which was provided by our company.

Thanks with Regards,

Vallamuthu M.

Re: send excel to shared folder

abo — Tue, 12 Jan 2021 09:45:14 GMT

Then you need to ask your Basis consultants to map the directory, otherwise you won't be able to write to it.

Re: send excel to shared folder

SimoneMilesi — Tue, 12 Jan 2021 10:19:16 GMT

In addition to c5e08e0478aa4727abc4482f5be390b2 's words, if the shared folder is mapped on users' PC, you can use the download on local file (but you cannot run the report in background, of course)

Re: send excel to shared folder

matt — Tue, 12 Jan 2021 12:16:44 GMT

That's a CSV, not an Excel file

It's not going to a shared folder.

Re: send excel to shared folder

former_member717457 — Tue, 12 Jan 2021 12:24:11 GMT

Hello Vallamuthu,

Try the below FM to download your Internal table records as excel file (Any file path).

FM: MS_EXCEL_OLE_STANDARD_DAT

Also go-through the link.

Internal Table to Excel http://abaplovers.blogspot.com/2008/05/abap-internal-table-to-excel-sheet.html

Thanks

Sathish Kumar Sidhaiyan

Re: send excel to shared folder

vallamuthu_madheswaran2 — Wed, 13 Jan 2021 11:51:38 GMT

Hi Sathish,

Thanks for your update.

But it'll not download the file in the background.

Thanks with Regards,

Vallamuthu M