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 on Trending Technologies
Technical articles with clear explanations and examples
Getting Error message "Object doesn't support property or method 'attachEvent'" in IE11 to call SAP system
Note that attachEvent is no longer supported in IE11 and you should use addEventListener that can be used to bind specific function to an event. Using attachEvent in Older IE Versions In older versions of IE (IE8 and below), you can use attachEvent like this − object.attachEvent(event, pDisp) Parameters event [in] Type: String A String that specifies any of the standard DHTML Events. ...
Read MoreLinking ABAP Dynpro screen elements to program variables
You can make the connection between ABAP Dynpro screen elements and program variables by using the name of Global variables. A Global variable can be defined by using this code − DATA matnr TYPE MATNR. This creates a global variable matnr of type MATNR. You can also define DDIC structure or table references using the TABLES statement − TABLES: MARA. Once you have declared the table or structure, you can reference the fields of table/structure ...
Read MoreHow to change first and last elements of a list using jQuery?
To change the first and last elements of a list, you can use jQuery's eq() method along with first() and last() methods. The eq() method allows you to select elements by their index position, where the first element has an index of 0. Methods for Selecting First and Last Elements jQuery provides several methods to target the first and last elements − :first or first() − Selects the first element :last or last() − Selects the last element ...
Read MoreInternal 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 MoreHow to access element with nth index in jQuery?
To access element with nth index from an HTML page, use the jQuery eq() method. It is used to access the index of an element in jQuery. The eq() method refers to the position of the element. The eq() method accepts a zero-based index parameter, meaning the first element is at index 0, the second element is at index 1, and so on. This method returns a jQuery object containing only the element at the specified index position. Syntax The ...
Read MoreHow to access index of an element in jQuery?
To access the index of an element in jQuery, use the eq() method. The eq() method refers to the position of the element and allows you to select a specific element from a matched set based on its zero-based index position. Syntax The basic syntax for the eq() method is − $(selector).eq(index) Where index is a zero-based integer indicating the position of the element you want to select. Example You can try to run the following code to learn how to access index of an element in jQuery − ...
Read MoreDelete duplicate alphanumeric entries from column data in SQL
You can use regular expressions to remove duplicate consecutive alphanumeric characters from column data in SQL. The REPLACE_REGEXPR function with pattern matching allows you to identify and replace repeated characters with a single occurrence. Syntax The basic syntax for removing duplicate alphanumeric entries using regular expressions is − REPLACE_REGEXPR ('([A-Za-z0-9])\1+' in column_name WITH '\1' OCCURRENCE ALL) Where ([A-Za-z0-9])\1+ is the regex pattern that captures any alphanumeric character and matches one or more consecutive occurrences ...
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 More