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
Inserting an Array to a table in SAP HANA database
As far as I know, there is no direct way of inserting an Array using SQL query in SAP HANA. You will first have to combine the columns (EMPL_Id + Skill Id) using the code and then do a bulk insert to the database. Array to Table Insert Methods In SAP HANA, when you need to insert array data into a table, you have several approaches to handle this limitation − Method 1: Using UNNEST Function The UNNEST function can convert an array into individual rows, which can then be inserted into a table − ...
Read MoreEdit an ABAP Program using Transaction SE93, SE80
You need to go to SE93 and input your transaction code. It will display the program name behind your transaction code. You can edit the programs using SE80 and SE38 transaction codes. Using SE93 to Find Program Name Transaction code SE93 is used to maintain transaction codes and find the associated program names. This is the first step to identify which program you want to edit. Below shows Transaction code SE93 − Editing ABAP Programs Using SE80 − ABAP Development Workbench Transaction Code SE80 opens the ABAP ...
Read MoreViewing field names or tables names of the forms in SAP Business One
It is possible that the older version of SAP B1 may not show you all the fields of all the forms. If you have the latest version, you should be able to see the data sources that are mapped to given field. You need to open the forms in SAP Business One Studio. There are a couple of methods to view fields. Method 1: Using SAP Business One Studio Integration This method allows you to directly edit forms from within SAP Business One using the integrated Visual Studio environment ...
Read MoreCalling a JAVA method through JavaScript in SAPUI5 project
Create a REST service hosted on a server and place java method inside it. Now you can call this REST service from a SAPUI5 application using AJAX by passing required parameters. Understanding the Architecture In SAPUI5, you cannot directly call Java methods from JavaScript. Instead, you need to expose your Java functionality through a REST API that acts as a bridge between your frontend SAPUI5 application and backend Java services. SAPUI5 App REST Service Java ...
Read MoreCreating a variable with dynamic variable type in SAP ABAP
You can use RTTS (Run Time Type Services) related API to create a standard table like RANGE which has components like LOW, HIGH, SIGN, and OPTION. This technique allows you to dynamically create variables with types determined at runtime. Variable Declarations First, declare the necessary variables and references for dynamic type creation − DATA: rr_data TYPE REF TO data, rt_range_string TYPE RANGE OF string, ...
Read MorePerforming total of a column in a temporary column in SAP
In SAP, when you need to calculate the total of a column and display it alongside individual records, you can use a subquery approach with SUM function and GROUP BY clauses. This technique allows you to perform aggregation in a temporary column while maintaining the detail-level data. Using Nested SELECT with SUM Function To perform the total of a column in a temporary column, you need to perform a SELECT operation on your inner query result. The inner query groups the data, while the outer query calculates the total sum. Example Here is a sample query ...
Read MoreGetting details when a table is modified in SAP HANA DB
You can query SYS.M_TABLE_STATISTICS to get modification details by providing the table name and checking the LAST_MODIFY_TIME column. This system view contains statistical information about tables including when they were last modified. Query Syntax Here is the sample SQL query to retrieve table modification details − SELECT "TABLE_NAME", "LAST_MODIFY_TIME" FROM SYS.M_TABLE_STATISTICS WHERE "TABLE_NAME" = 'YOUR_TABLE_NAME' ORDER BY "LAST_MODIFY_TIME" DESC; In the above command, you need to replace YOUR_TABLE_NAME with your actual table name. Example To get modification details for a table named EMPLOYEES − SELECT "TABLE_NAME", "LAST_MODIFY_TIME" FROM ...
Read MoreConnecting to SAP HANA using odbc_connect() on PHP
The error you are getting is because there are no ODBC drivers installed for your PHP client. You would require downloading the appropriate drivers to establish a connection with SAP HANA database. Installing ODBC Drivers for SAP HANA Following steps can be performed to download and install the drivers − Download the drivers from https://www.easysoft.com/cgi-bin/account/login.cgi after registration or alternatively check the ODBC-ODBC Bridge Client platforms at ...
Read MoreHow to add and remove HTML attributes with jQuery?
To add and remove HTML attributes with jQuery, you can use several methods. The addClass() and removeClass() methods work specifically with CSS classes, while attr() and removeAttr() methods handle general HTML attributes. Adding and Removing CSS Classes The addClass() method adds one or more CSS classes to selected elements, while removeClass() removes them. This is the most common way to dynamically modify element styling. Example You can try to run the following code to add and remove CSS classes ...
Read MoreHow to remove all style attributes using jQuery?
To remove an attribute from each tag using jQuery, use the removeAttr() method and use the Universal Selector. Let us see how to use the method to remove all style attributes. Use the universal selector also to select all the elements. The removeAttr() method removes the specified attribute from each element in the matched set. When combined with the universal selector * or specific selectors, you can target all elements or specific elements to remove their style attributes. You can try to run the following code to ...
Read More