...

The connection to SAP WP1 is already in context g_CNX_SAP_WP1

Extract data

From the ECC, we can extract only information from the table.  To get metadata it is highly recommended to get if from

1. Table (tSAPTableInput)

1.1 Retrieve metadata

Metadata > SAP Connection > (Server) > right click and select Retrieve SAP Table

...

1.2 Copy the reference job J030J020_ECC_Table_to_GCS to the new job 

...

The rest of the job will extract the data from SAP and generate the file on the local folder, then upload it to the bucket that we enter in point 1.6

The job will not delete the file in GCP but overwrite it. Therefore, be careful if the next run has number of file less than pervious one, the old data will be existing in the files and possible to be wrong data to load to staging.  Or it is better to name the file with timestamp in order to avoid overwrite wrongly.