This can be done by exporting SAP table as csv file and it can be automatically converted to Google Spreadsheet. Also there are various Google drive API’s that can be used to achieve this programmatically.With use of Google Drive REST API, you can download and upload files in Google drive. To know more about this, check out the below link −Google Link

There seems to some mistake in your update modle. PFB the updated oneExampleMODULE update INPUT.       MODIFY snctab INDEX ctrl-current_line.     IF sy-subrc 0.        APPEND snctab.     ENDIF.  ENDMODULE.

The parameter that you are using seems to be a import type and it will require an associated type in order to be of any use.You can define the table parameters for this. You can find them within the tables tab. Once you have defined them then you can use them for either export or import.Hope it works for you!

You are correct as XSA supports the custom error pages but classic does not support custom error messages.In case you need to do in any way, then what you can try out is you need to parse all requests through a load balancer or a proxy and then show custom error message. And it is not a easy and maintainable approach.

As per my understanding, for requirement #1 you can do something as below:SELECT    Prod.Product_ID, JOB.Job_ID, SUM(J.Time) FROM    TABLE_1 Prod  INNER JOIN TABLE_2 Job ON Prod.Job_Id = Job.Job_ID GROUP BY     Prod.Product_ID, Job.Job_IDSAP HANA does not support Pivot built-in as done by SQL but majorly it looks as a UI requirement. So what you can do is send the entire result to report and apply transformation in the report as per your requirement.

If you don’t want to create a custom table then you can for creating a data model with the help of reuse method. You can then save this newly created data model in staging MDG. Other option that you have is Z-table. You can create a Z-table to persist the data.Hope this helps!

I don’t think that there exists a way where you can pass dynamic values to the CDS.In order for DCL to do its assigned activity you need to declare and define the authority object.  Let’s say you cannot do this. Then you can get all the results and then filter the results at Gateway layer using ABAP.

When you are trying to release the object, make sure that you set the query object to null. When you set it to null, it will release the memory for sure. But the scope also plays a role, so make sure it is local to the procedure.Example   Please find a sample snippet for reference    myFunction := TSAPFunctions.Create;     myFunction.Connection := FConnection;     myFunction.RemoveAll;     myQuery := mySAPFunction.Add('interface here');     myQuery.Call;     myQuery := null; // will clear the memory Hope this helps!

You have done partially correct but just missed one step further to get the desired result. The case where after grouping you need to pick one of the rows from the results, use rank number or rank function.You need to partition your data based on your requirement, then order them as per your requirement again then pick the desired row.ExampleFor e.g. partition your data by Item Number and Shop Id. Then order them in descending order of Date column. Then pick the row with row number as 1select date, Order_Number   from   (SELECT  *, row_number() over ( partition by ... Read More

Yes, you can do what you are aspiring for. But it depends upon your actual requirement. Let’s say you need to execute the some custom application or program in SAP, then you can opt for any available connector which reads a file or else. This connector then later establishes a connection to the queue and then sends a message.Let’s say you cannot keep polling for files availability, and then you need to use the remote function call methodology. RFC has a SDK available and its online support is tremendous. You can use it too for sending a message. Read More