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
Displaying distinct values in a column filtered on other column in SAP BO report
There are multiple ways to display distinct values in a column filtered on other columns in SAP BO reports. The two most common approaches are using count variables and the PREVIOUS() function. Method 1: Using Count Variable The first method involves creating a variable that counts distinct occurrences based on a grouping column − Terms Count = Count([Terms Code]) in ([Sales #]) Add this variable to your report structure. The variable will display 1 for all records with Sales # 1000 and 2 for all records with Sales # 1001, effectively counting distinct terms ...
Read MoreRequest Timeout while using Odata call to a gateway in SAPUI5 application
When encountering request timeout issues while making OData calls to a gateway in SAPUI5 applications, the problem often lies in the server-side timeout configurations rather than the client-side code. This typically occurs when ICM (Internet Communication Manager) and Web Dispatcher timeout settings are insufficient for your application's requirements. Understanding SAP Timeout Parameters In SAP systems, ICM and Web Dispatcher control different types of timeouts through specific parameters − Connection timeout: icm/conn_timeout − Controls the timeout for opening a connection Request timeout: icm/traffic_control − Controls the timeout for receiving ...
Read MoreInstalling free version of SAP ERP to learn ABAP
You can install a free trial from the SAP site, but for that, you require an SAP Partner ID. SAP also provides a developer trial which you can access through the following link − https://developers.sap.com/trials-downloads.html License Requirements The SAP NetWeaver Application Server ABAP comes with a temporary license that allows you to log on to the system. As a first step before using the system, you need to install a 90-day Minisap license to ...
Read MoreConnecting SAP B1 via DI API takes too much time
When connecting to SAP Business One via DI API, you may experience slow connection times. This performance issue is commonly caused by accumulated log files that build up over time during DI API operations. Solution To resolve this connection speed issue, delete all files under the following location − %UserProfile%\AppData\Local\SAP\SAP Business One\Log\DIAPI Step-by-Step Process Follow these steps to clear the DI API log files − Close all SAP Business One applications and DI API connections Navigate to the log directory using Windows Explorer or Run ...
Read MoreUsing Group by hour in SAP HANA table
When working with SAP HANA tables, grouping data by hour is a common requirement for time-based analysis. This can be achieved using different approaches depending on your specific needs. Method 1: Using DATE() and HOUR() Functions You can try this method to convert time to date and hour format − select to_varchar(time, 'YYYY-MM-DD'), hour(time), sum(r_time) as r_time, sum(p_time) as p_time from t1 group by date(time), hour(time) order by to_varchar(time, 'YYYY-MM-DD'), hour(time); This approach extracts the date and hour components separately from the timestamp column. The DATE() function extracts the date part, while HOUR() extracts ...
Read MorePrevent XML re-formatting in WAS response in SAP Windows Activation Service
No, there is no other possibility of preventing XML re-formatting in Windows Activation Service (WAS) response until you code everything on your own. It seems to be an issue during de-serialization. Most probably it is relevant to the parameters that you are sending in the response. The WAS response mechanism automatically formats XML content based on its internal serialization process. Understanding the Issue When SAP Windows Activation Service processes XML responses, it applies default formatting rules during the de-serialization process. This automatic formatting can alter your original XML structure, whitespace, and indentation. Troubleshooting Steps You ...
Read MoreRFC returns exception while using SAP RFC_READ_TABLE to output data to software
When working with SAP RFC_READ_TABLE function module, you may encounter RFC exceptions that prevent data extraction to external software. You can check if there are any short dumps in the SAP system using T-Code: ST22. When there are short dumps, it leaves the ABAP Processor in an invalid state. This results in a failed call with an unspecified error message. Checking Short Dumps in SAP To diagnose RFC exceptions with RFC_READ_TABLE, follow these steps − Step 1: Access the SAP system and navigate to transaction code ST22 (ABAP Runtime Error Analysis). Step 2: Review ...
Read MoreConnecting to SAP R/3 system via JCo client and JCo Server
In JCo3.0, Java client JCO.Client is replaced by JCoDestinations. You can connect to SAP system via Inbound RFC Communication (Java calls ABAP) or via Outbound RFC Communication (ABAP calls Java). JCo Connection Types For inbound RFC communication, you need to use JCoDestination for executing a remote function module at ABAP side. To use inbound RFCs, you have to use JCoDestination which executes a Function module remotely at ABAP side and while using outbound RFCs, you have to configure a JCoServer at the SAP gateway that is responsible to receive incoming requests from ABAP side and process remote function ...
Read MoreHow to set HTML content of an element using jQuery?
To set the HTML content of an element, use the html() method. This method allows you to replace the existing HTML content inside a selected element with new HTML markup. Syntax The basic syntax for setting HTML content is − $(selector).html(content) Where content is the HTML string you want to insert into the element. Example You can try to run the following code to set HTML content of an element using jQuery − ...
Read MoreHow to disable right click using jQuery?
To disable right click on a page, use the jQuery bind() method. This prevents users from accessing the context menu that typically appears when right-clicking on web elements. Example You can try to run the following code to learn how to disable right click − $(document).ready(function(){ $(document).bind("contextmenu", function(e){ return false; ...
Read More