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
SAP HANA Articles
Page 10 of 58
Deleting from temporary table in SAP HANA
The temporary tables in SAP HANA are session specific, which means they exist only within the current database session. For deleting data from temporary tables, you have two main options depending on your SAP HANA release version. Using TRUNCATE Command The preferred method for clearing all data from a temporary table is using the TRUNCATE command − TRUNCATE TABLE #temptable; The TRUNCATE command removes all rows from the temporary table quickly and efficiently, as it deallocates the data pages instead of deleting rows one by one. Using DELETE Command In recent SAP ...
Read MoreIssue regarding JCo SAP Server out of Network
When you encounter network issues with your JCo SAP Server, you need to properly clean up resources and references before stopping the server instance. This prevents memory leaks and ensures graceful shutdown of your SAP connectivity components. Required Actions for JCo Server Cleanup You need to perform the following actions when you are stopping the JCo server instance − Delete server references: Remove all references of your server from the ServerDataEventListener ...
Read MoreProblem with division as output is either 0 or 1 when using ifthenelse condition in ABAP program
The problem occurs when using the ifthenelse condition in ABAP programs for division operations. The issue is that your second parameter is 0 which is an integer, so the output always comes as an integer as ifthenelse takes its data type from the second parameter. In your case, if the division result is less than 0.5, it gets converted to 0, and if it's more than 0.5, it gets converted to 1. This happens because ABAP performs implicit type conversion based on the data type of the second parameter in ...
Read MoreResource routing not working when using SAP Fiori
Resource routing issues in SAP Fiori applications commonly occur due to duplicate application IDs or connectivity problems. This article explains how to resolve these routing conflicts and connectivity issues. Duplicate Application ID Issue The primary issue you are facing is because you have created both the applications with the same ID. Hence, the Launchpad is not able to distinguish between them and load into the correct context. You can change the application ID and all the references of the same to resolve the ...
Read MoreMerging 2 tables with similar column name SAP HANA database
This can be done by using UNION or UNION ALL operator. Both operators allow you to combine rows from two or more tables that have similar column structures. Using UNION Operator The UNION operator combines the result sets of two SELECT statements and removes duplicate rows − SELECT id, Empl_name, DeptId FROM table1 UNION SELECT id, Empl_name, DeptId FROM table2; Using UNION ALL Operator The UNION ALL operator combines the result sets and includes all rows, including duplicates − SELECT id, Empl_name, DeptId FROM table1 UNION ALL SELECT id, Empl_name, DeptId ...
Read MoreHow to refer and import SAP-UI-Core.js within my SAPUI5 project
The SAPUI5 library files are a part of Eclipse SAPUI5 plug-in. The sap-ui-core.js file is the core JavaScript file that bootstraps the SAPUI5 framework and must be properly referenced in your project. If you are running the app by using the Web App preview on the startup page (Go to Run As → select "Web APP Preview"), then Eclipse starts a local HTTP server for development which serves the library at "/resources". Till the preview window is open, you can go ahead and use the URL in any browser of your choice to debug the application. Methods ...
Read MoreCall event function from another method in Controller in SAP
It is advised not to call the event function from any other function but what you can do is refactor the event function implementation in a separate function and call that from any other function as shown below − Best Practice Approach The recommended approach is to create a helper function that contains the actual logic, and then call this helper function from both the event handler and any other methods that need the same functionality. This maintains clean separation of concerns while avoiding direct event function calls. Example Here's how to implement this pattern in ...
Read MoreUsing real Boolean type in SAP ABAP
This approach is called a Predicative Method call. This will work if the initial value is false and false is the initial value for Boolean types in ABAP. Predicative method calls allow you to use method calls directly in logical expressions, making your code more concise and readable. In SAP ABAP, the real Boolean type abap_bool was introduced to provide true Boolean functionality. Unlike character-based flags ('X' and ' '), Boolean types have clear true and false values with false being the initial value. Using Boolean in Predicative Method Calls When using real Boolean types, you can ...
Read MoreGetting MIN and MAX dates in table in SAP Web Intelligence while using a Break
This can be achieved by creating an Indicator as per condition you are looking for − minimum drawn date time for POST-Test and Maximum drawn date time for PRE-Test. Once you create this indicator, it will show "Y" for the rows highlighted in yellow as per condition and "N" for other rows. Method 1: Using Indicator with MIN and MAX Functions Create an indicator variable using the following formula − =If ([Drawn date] = Min([Drawn date]) In ([Patient ABO/RN]) Where ...
Read MoreError while selecting into field-symbol in SAP ABAP
When selecting data into field-symbols in SAP ABAP, you may encounter errors if the field-symbol is not properly declared. The most common issue is attempting to use a field-symbol without declaring it first. Problem Description The error occurs when you try to select data into a field-symbol that has not been declared in your ABAP program. Field-symbols must be declared before they can be used in SELECT statements. Solution To resolve this issue, you need to properly declare your field-symbol before using it. Here are two approaches − Approach 1: Using Work Area Instead ...
Read More