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
What is the Python regular expression to check if a string is alphanumeric?
In this article, we focus on how to check if a string is alphanumeric using regular expressions in Python. Regular expressions are very useful for pattern matching and validation. To use them, first import the re library, which is included by default in Python. The regular expression ^[a-zA-Z0-9]+$ matches strings that contain only letters (both uppercase and lowercase) and numbers. Let's break down this pattern − ^ − Matches the beginning of the string [a-zA-Z0-9] − Character class that matches any lowercase letter (a-z), uppercase letter (A-Z), or digit ...
Read MoreTruncating multiple strings after 100 characters in ABAP
You can truncate strings to 100 characters in ABAP by defining a character field of 100 bytes and moving your variable to that character field. When you move a longer string to a shorter field, ABAP automatically truncates it to fit the target field length. Example The following example demonstrates how to truncate a string to 100 characters using a fixed-length character field − DATA: lv_original_text TYPE string VALUE 'This is a very long text that exceeds 100 characters and will be truncated when ...
Read MoreHow to get substring of a string in jQuery?
To get substring of a string in jQuery, use the substring() method. It has the following two parameters: from − The from parameter specifies the index where to start the substring. to − The to parameter is optional. It specifies the index where to stop the extraction. When nothing is mentioned, it extracts the remaining string from the start index to the end. Syntax The syntax for the substring() method is − string.substring(from, to) Example You can try to run the following code to learn how ...
Read MoreWriting at the end of report without clearing current screen in SAP ABAP
Yes, it is possible to write at the end of a report without clearing the current screen in SAP ABAP. You can achieve this by using the MODIFY LINE statement, which allows you to update specific lines on the screen without clearing the entire display. Using MODIFY LINE Statement The MODIFY LINE statement enables you to modify existing lines in the output list without affecting other content on the screen. This is particularly useful when you want to append information or update specific parts of your report output. Basic Syntax The basic syntax for using MODIFY ...
Read MoreGetting error- is not an internal table "OCCURS n" specification is missing in SAP method
When working with SAP ABAP methods, you may encounter the error " is not an internal table 'OCCURS n' specification is missing". This error occurs when you try to use a structure type instead of a table type for parameters that expect internal tables. You need to define the et_flights parameter as of type SFLIGHT. As per method defined, you have this type as structure type and also declare transparent table SFLIGHT at the same time. You should use an already available dictionary table type with row structure of SFLIGHT for et_flight. You should declare et_flights inside ...
Read MoreJoin using CE functions in SAP HANA database
You can try using projection node as follows to perform joins in SAP HANA using CE functions. The CE_PROJECTION function allows you to select specific columns and rename them, while CE_JOIN performs the actual join operation between tables. Example Here's how to join two tables using CE functions with column projection and renaming − table1 = CE_PROJECTION(:T1, ["ACCT_ID", "SALARY"]); table2 = CE_PROJECTION(:T2, ["EMPL_ID" AS "ACCT_ID", "ADD", "ZIP", "STATE"]); var_out = CE_JOIN(:table1, :table2, ["ACCT_ID"]); Using Projection node, you can rename the column names. Note that EMPL_ID has been renamed to ACCT_ID in the second projection ...
Read MoreCommunicating with SAP system using PHP
You can communicate with any SAP system from PHP in many ways, but the preferred standard available choices are − RFC (Remote Function Call) − Direct communication protocol for calling SAP functions remotely Web Services − HTTP-based communication using SOAP or REST APIs Communication Methods PHP has got one RFC library to communicate with SAP. But the main job in your problem statement lies with your partner as they are the one dealing with SAP component. You need to check with them what they prefer - services or RFC. ...
Read MoreCreating a table in SAP system using OData service
In order to create a table in an SAP system using OData service, you need to use either *.hdbdd or *.hdbtable files to define your table structure and then expose them with xsodata service definition. The .hdbdd file uses Core Data Services (CDS) syntax for defining database objects, while .hdbtable uses native SQL DDL syntax. Once your table is created, the .xsodata file exposes it as an OData service endpoint. Creating OData Service Definition To expose your table through OData, create a service definition file with the .xsodata extension. The basic syntax includes the service namespace and ...
Read MoreSingle query vs multiple queries to fetch large number of rows in SAP HANA
When dealing with large datasets in SAP HANA, choosing between single query and multiple queries significantly impacts performance. Single query would always be better than the multiple queries. The number of rows does not impact much on performance. It is the way query is written and the data to be fetched which makes the difference. Also, the table should be indexed. Why Single Query Performs Better Single queries outperform multiple queries due to several key factors − Reduced network overhead ...
Read MoreError while connection SAP HANA with .NET
When connecting SAP HANA with .NET applications, you may encounter compatibility issues related to system architecture. You would require installing both the 32-bit and 64-bit SAP HANA client software as Microsoft Visual Studio operates on a 32-bit application framework. Understanding the Architecture Issue The primary reason for this requirement stems from the way .NET applications are compiled and executed. Even on 64-bit systems, Visual Studio's IDE and certain components run in 32-bit mode, which can cause conflicts when trying to connect to SAP HANA databases using only ...
Read More