Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by SAP ABAP Expert
Page 10 of 12
System goes out of memory on establishing connection in a SAP-Delphi integrated project
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!
Read MoreFetch max date and other field from the same row of a table grouped by other fields in SAP HANA
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 MoreModification not working for both internal table and control table in SAP ABAP
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.
Read MoreIs Pivot available in SAP HANA
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.
Read MoreUsing Switch Ownership option in SAP HANA
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 one or multiple inactive objects in HANA.You need to select inactive Information objects that you want to take from other user. From drop down list you can select source user and with use of Add button, you can add objects under selected models window.
Read MoreDifference between take over and Switch ownership in SAP HANA
Below is the difference between take over and switch ownership.Take Over: This option is used to take single inactive object from another workspace.Switch Ownership: This option is used to take single or multiple inactive objects from other users.When you expand Switch ownership option in HANA Modeler, you can see description of this option-
Read MoreChanging authoring schema of catalog objects in SAP HANA
In SAP HANA Modeler perspective, you have an option of changing authoring schema of catalog objects.Select the objects for which you want to change the authoring schema from Content tab. You can use Add button to add objects Available -> SelectedFrom drop down, you need to select Authoring Schema details- Source and Target
Read MoreMultilevel object impact in SAP HANA
With use of Where-Used option, you can only check first level of object. Multi-level Object impact or impact due to the change to a table is not directly visible.
Read MoreRepairing repository objects in SAP HANA
In SAP HANA Modeler perspective, you have Repair Dependencies option, which can be used to repair objects. Select packages that have the objects to be repaired. This repair operation will replace the existing objects and save the new object types within the same packages.
Read MoreUsing Repair dependencies option in SAP HANA
Navigate to SAP HANA Modeler Perspective -> Repair Dependencies. You need to select a repair type and folder to save repair job log -> Next
Read More