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 Articles
Page 19 of 91
Internal Table itab declaration in SAP and difference between both the declarations
When working with internal tables in SAP ABAP, there are two main declaration approaches that differ in memory allocation and performance characteristics. Declaration Methods The two common ways to declare internal tables are − Method 1: With Initial Size DATA: itab TYPE TABLE OF customer_tab INITIAL SIZE 5. Method 2: Without Initial Size DATA: itab TYPE TABLE OF customer_tab. Key Differences As per my understanding, the key difference between two statements is that in first you are reserving memory space for storing 5 lines of the customer_tab table. ...
Read MoreInserting Array list into HANA database
To insert array lists into a HANA database, you can use JDBC statements with HANA's ARRAY function. This approach allows you to store multiple values as array columns in your database table. Example The following code demonstrates how to insert array data into a HANA database table − Integer[][] myarray = { {1}, {1, 2}, {1, 2, 3, 4, 5} }; String test = "Insert Arrays"; stopWatch.start(test); myDBconn.setAutoCommit(false); Statement stmt = myDBconn.createStatement(); stmt.execute("TRUNCATE TABLE Schema.Table1"); // Running a loop over our array of arrays for (int i = 0 ; i < (myarray.length); i++) { ...
Read MoreI want to round a number to 2 decimal places in SAPUI5. Could anyone help?
The RoundingMode function is used for rounding numbers in SAPUI5 and it uses these parameters: the number to be rounded and how many decimal digits to display. This is particularly useful when working with currency values or percentages that need to be displayed with consistent decimal places. Using Float Type with Format Options You can round a number to 2 decimal places by using the sap.ui.model.type.Float type with specific format options in your data binding − Format Options Explained The format options control how the number is displayed − ...
Read MoreDenormalization of dimension tables in InfoCube in SAP BW
In Data Warehouse systems, data load operations occur less frequently compared to data read operations. When using normalized tables, the system requires more joins, which significantly affects performance when running multiple read statements on the DW system. Denormalization is the process of combining normalized tables to reduce the number of joins required during query execution. When you implement denormalized tables, the response time of queries improves significantly, however, this comes with trade-offs including increased load time and higher memory space requirements. Benefits of Denormalizing Dimension Tables in InfoCube ...
Read MoreDeleting 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 More