Below are the steps to follow:

   1  Create a saved list (by an automatic job every day, every week, Store the extraction to SAP server – It’s THE SAP STANDARD SOLUTION.

          You can create an automatic job with a saved list.  The user can display the list or download the list in excel, MANUALLY,  when he wants (Core solution used by a lot of sites).

a)       You need to adapt the variant in your query

b)       Create the saved list

Add a step in an automatic job -  Query / Variant
PF1 : Create job / step with SAP standard transaction SM36
WP1 : Create job / step with Automator (Adagio)

c)       Display the saved list

2)      Automatic mail to GMAIL with a .TXT in attachment  (by an automatic job every day, every week

Add a step in an automatic job -  Query / Variant
PF1 : Create job / step with SAP standard transaction SM36
WP1 : Create job / step with Automator (Adagio)

with a specific printer

Printers :

PF1 : ZTXT

WP1 : ZTXT

3)      Automatic mail to GMAIL with a .PDF in attachment  (by an automatic job every day, every week, ….)

add a step in an automatic job -  Query / Variant
PF1 : Create job / step with SAP standard transaction SM36
WP1 : Create job / step with Automator (Adagio)

with a specific printer

Printers :

PF1 : ZPDF

WP1 : ZPDF_ANONYMOUS

4)      Automatic mail to GMAIL with an excel file  in attachment  (by an automatic job every day, every week, ….)

a) Used the Solvay’s dev (available in PF1 and WP1) - ZZM_ALV_AS_CSV_PER_MAIL create a specific variant with Query / variant for ZZM_ALV_AS_CSV_PER_MAIL

b)   add a step in an automatic job -  ZZM_ALV_AS_CSV_PER_MAIL / Variant

PF1 : Create job / step with SAP standard transaction SM36
WP1 : Create job / step with Automator (Adagio)

Highlights:

1-The user can create a rule in GMAIL to transfer the message to Gdrive.

For more information / help, please contact Google team (carlos.zamalloanunez-ext@solvay.com).

2-Pelican is a specific tool. You have to install a first version of Pelican on SAP server AND a second version on your external server (ADAGIO)

You need to develop a specific abap to transfer the file from SAP Server to External server.

Example in PF1 : ZZM_REPORTING_FTS
3-We do not recommended this solution, because it’s required to install a PELICAN on each server (Licenses) its  Cost is  very expensive.

4- We recommend,

a-Saved list

b-Automatic mail to GMAIL with an excel file  in attachment  

c-Please check with Adagio (francois.ruffinoni@solvay.com

d-transfer a file created in SAP to an external server.

5-In Solvay legacy, we use PELICAN.