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
Change no data text for Search in SAPUI5
You just need to use the noDataText property to sort out your requirement. This property allows you to customize the message displayed when a search returns no results or when a list/table has no data to show. You have two options, either you can change in controller or you can change in the XML. Option 1: Using Controller Method Call the setNoDataText method in the init method of your controller − this.byId("").setNoDataText("") Complete Example Here's a complete example showing how to implement this in a controller − onInit: function() { ...
Read MoreCommit changes on SAP BAPI Transaction
You are correct that in order for the changes done by BAPI to come into effect, you need to call the commit function. The BAPI_TRANSACTION_COMMIT function module is essential for persisting changes made through BAPI calls to the database. It will commit all the changes which are uncommitted, not only the last transaction. This means that if you have multiple BAPI calls or database operations in your program, calling BAPI_TRANSACTION_COMMIT will save all pending changes. BAPI_TRANSACTION_COMMIT vs COMMIT WORK There are two primary ...
Read MoreApply CSS on a table cell based on the content in SAPUI5
You are having one of the most common requirements in the case of the table. You can achieve the end result using formatter function exposed on the cells of a table. This approach allows you to conditionally apply CSS styles based on the content value of each cell. Implementation Example Here is a complete code snippet for your reference which you can alter as per your use case − cells: [ new sap.m.Text({ text: { path: "/name", ...
Read MoreInstantiation of Export Options throws an Exception in SAP Crystal Report
Even after referencing the correct version of the dll, if you are still getting the error then it means that the runtime for the Crystal Reports is not properly installed. The issue typically occurs when you use the MSI installer instead of the EXE installer for SAP Crystal Reports installation. The MSI installer has a known shortcoming that it does not properly incorporate Crystal Reports with Visual Studio, leading to instantiation exceptions when working with export options. Solution To resolve this issue, follow these steps − Step 1: Uninstall the current Crystal Reports runtime that was ...
Read MoreConnect to dynamic URL within OData in SAP project
You can create a dynamic URL in your code which you can read from configuration files or XML. This approach allows you to modify the OData service endpoint without hardcoding it in your application. Dynamic URL Connection Example Here is a complete code snippet that demonstrates connecting to a dynamic OData URL − using System; using System.IO; using System.Net; class Program { static void Main() { // Read ...
Read MoreBest way to connect to SAP system from JAVA
There are lots of possibilities to connect to SAP systems from Java, but a lot depends upon your exact requirements and needs. Let's explore the most effective approaches. Java Connector (JCo) You can use the SAP Java Connector (JCo), which is the most prevalent option for Java-SAP integration. JCo provides a robust middleware component that enables Java applications to communicate with SAP systems using Remote Function Calls (RFCs). It has extensive support available online and offers high performance for enterprise applications. Example Here's a basic structure for connecting using JCo − import com.sap.conn.jco.*; ...
Read MoreUsing a SQL View in SAP BusinessOne
Yes, it is possible to use a SQL view in SAP Business One client and you can use it effectively for your business reporting needs. Using SQL Views in SAP Business One A view in SAP Business One is a virtual table that displays data from one or more underlying tables. Views are particularly useful for creating custom reports and simplifying complex queries by presenting a pre-defined data structure. Query Syntax Please find below the standard format that you should be using ...
Read MoreAdd Authentication details in the AJAX request in SAPUI5
In SAPUI5, when making AJAX requests that require authentication, you need to exploit the beforeSend function of jQuery AJAX to add authentication details to the request headers. This is commonly required when accessing secured backend services or APIs. Here is a basic code snippet that demonstrates how to add Basic Authentication to your AJAX request − function AddToHeader(xhr) { var user = "your_username"; // Define the username var pwd = "your_password"; // Get the password ...
Read MoreNot able to get the difference between two dates (SAP)
Calculating the difference between two dates is a very basic operation that you do in database systems. In SAP environments, you can try using the DATEADD function available and use the date overload of the function. You need to pass one date as negative so that the actual difference is calculated. Using DATEADD Function The DATEADD function allows you to add or subtract a specified time interval from a date. By passing a negative value for one of the dates, you effectively calculate the difference between two dates. ...
Read MoreReduce number of columns of a result set from a Transaction in SAP system
The simple answer to your question is NO. This is SAP standard behavior, and if you want to restrict the number of columns to be returned, it will require you to change the original source code of SAP implementation. Why Column Reduction is Not Recommended The change will be quite exhaustive and it will also mean that you are violating the contract and hence, no support from SAP on any issue encountered later. Modifying SAP's core transaction logic breaks the standard functionality and voids official support agreements. ...
Read More