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
Articles on Trending Technologies
Technical articles with clear explanations and examples
Single 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 MoreInserting new line to the output using WS_Download in ABAP
First of all, don't use WS_DOWNLOAD as this function module is obsolete and deprecated in modern ABAP development. Using cl_abap_char_utilities for Line Breaks You can use a character type field and set it to cl_abap_char_utilities=>cr_lf. This utility class provides constants for various character operations, including carriage return and line feed combinations. Now use this field at places where you want to insert the new line. Example Here's how to implement line breaks when downloading data using modern ABAP approaches − ...
Read MoreDeleting subsequent heading from report in SAP system
You need to add NO STANDARD PAGE HEADING to suppress the default heading that SAP automatically generates for reports. This statement must be included in the report declaration section as follows − Syntax REPORT report_name MESSAGE-ID message_class NO STANDARD PAGE HEADING. Example Here's a complete example showing how to implement a report without the standard page heading − REPORT z_custom_report MESSAGE-ID z_custom_messages NO STANDARD PAGE HEADING. DATA: lv_text TYPE string VALUE 'Custom Report Output'. START-OF-SELECTION. WRITE: / 'This report has no standard SAP heading', ...
Read MoreUsing combination of “AND” and “OR” in SELECT in ABAP
You can combine AND and OR operators in ABAP SELECT statements to create complex filtering conditions. This allows you to specify multiple criteria that must be met simultaneously while also providing alternative options for certain fields. Using AND with OR in Parentheses You can use the following query to combine conditions − SELECT * FROM my_table WHERE condition_1 AND condition_2 AND ( id EQ '2' OR id EQ '3' ). Note: There should be space after and before the bracket for proper syntax formatting. In this example, both condition_1 and condition_2 must be ...
Read MoreGetting class of given method using T-code SE80 in SAP
To find the class of a given method in SAP, you need to use transaction code SE80 and navigate through the Repository Information System. This allows you to search for methods and identify which class they belong to. Steps to Find Class of a Method Follow these steps to locate the class containing a specific method − Step 1: Call transaction SE80 in the SAP system. Step 2: Navigate to the Repository Info System from the main ...
Read MoreAdapter properties dropdown not updated with list even after installation (SAP 7.2 adapter)
When working with SAP 7.2 adapters in BizTalk Server, you may encounter an issue where the adapter properties dropdown remains empty even after successful installation. This is a common problem that occurs when specific assembly files are not properly deployed to the BizTalk group. Root Cause The issue typically occurs because the BizTalkPropertySchema assembly, which is responsible for Microsoft adapter properties, is not deployed correctly during the installation process. This assembly contains the property schema definitions that populate the dropdown options in the adapter configuration. Solution Steps To resolve this issue, follow these manual deployment steps ...
Read MoreIdentify the qualification and Employee relationship table in SAP system
In SAP systems, qualification and employee relationship data is distributed across multiple tables rather than stored in a single location. Understanding these table relationships is crucial for HR data management and reporting. Primary Tables for Qualifications Qualifications in SAP are stored as object type 'Q' in the Personnel Development (PD) tables. The main tables involved are − HRP1000 − Stores qualification master data with object type 'Q' HRP1001 − Captures the relationship between qualifications and employees HRPAD31 − Contains qualification ratings and assessment data ...
Read MoreGetting day of the year from DD/MM/YYYY using function in SAP system
In SAP systems, you can calculate the day of the year from a DD/MM/YYYY date using a simple function. The day of the year represents which day number it is within that specific year (1-366). You can achieve this with the following line of code − DATA(l_day) = m_date - CONV d(m_date(4) && '0101' ) + 1. Where m_date is the input date that needs to be of type d. Note that the format of type d is YYYYMMDD. This code works by: Extracting the year from the input ...
Read MoreMissing SAP Java Connector libraries JCo- librfc32.dll, com.sap.utils and com.sap.mw
Please note that all these library files − librfc32.dll, com.sap.utils and com.sap.mw come under JCo 2.1. With release of JCo 3.0, its classes were also relocated from packages com.sap.mw.jco.* to com.sap.conn.jco.* For running with SAP JCo 3.0, you need these files at runtime − sapjco3.jar and sapjco3.dll (on Windows). You can follow below procedure for installation of JCo files: Installing JCo on Windows Platform In Windows OS, you have to copy sapjco3.jar file into ITDI_HOME/jars/3rdparty/others. Copy the ...
Read More