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 ... Read More

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 ... Read More

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.

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 ... Read More

You need to use the function RSAQ_REMOTE_QUERY_CALL_CATALOG for fetching the list of SQVI queries for a user.

I think I got what the problem is. Try updating below code line:

You can try using below code:                                                                

Note that sold to party and ship to party are mandate fields. You need to add the created structures and tables to the function as shown in below code:RfcRepository repo = destination.Repository; IRfcFunction salesDoc = repo.CreateFunction("BAPI_SALESORDER_CREATEFROMDAT1"); IRfcStructure salesHeader = salesDoc.GetStructure("ORDER_HEADER_IN"); salesHeader.SetValue("DOC_TYPE", "ZDLR"); salesDoc.SetStructure(salesHeader); salesDoc.Invoke(destination);For more details you can check BAPI_SALESORDER_CREATEFROMDAT1 ... Read More

With use of switch ownership you can take single or multiple inactive objects from other users. Multiple Information views can be created in HANA system and all these views remains inactive until they are activated in HANA Studio. With use of Switch Ownership option, one user can take ownership of ... Read More

Switch Ownership option is available under SAP HANA Modeler Perspective. IF you don’t see it under Modeler perspective, try to reset from top.