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 by SAP Developer
Page 2 of 7
Not 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 MoreUsing JCo to connect SAP with Android
Connecting SAP with Android applications using JCo (Java Connector) presents significant challenges due to platform limitations. While JCo is the standard library for Java-based SAP connectivity, it requires native libraries that are not available for the Android environment. The Challenge with Direct JCo Integration The primary obstacle is that JCo library depends on native system libraries that are incompatible with Android's runtime environment. Android applications run on the Dalvik/ART runtime, which cannot directly utilize the native components required by JCo. Recommended Solution: Web Service Approach The most practical alternative is to implement an intermediary web service ...
Read MoreShow creator name in SAP WEBI report
SAP WEBI provides you a lot of functions which can let you perform a wide range of operations ranging from fetching data to doing some complex calculations. You can get the entire list at help.sap.com. Functions to Display Creator Information For displaying the creator name in your WEBI report, you can use the following functions − DocumentOwner() DocumentAuthor() These functions will not give you directly the name but the user IDs which can be ...
Read MoreSorting List in SAP UI5 project
Yes, you can sort lists in SAP UI5 using the sorter property available on the List control. This property allows you to specify all the required sorting details including the field to sort by, sort order, and grouping options. Example Here's how to implement sorting in a List control − In this example, the employee collection is sorted based on the EmployeeName field in descending order. The group: true property enables grouping while sorting the data, ...
Read MoreHow to map an Object of objects to a SAP List?
The answer to your question is 'NO'. It is not possible to map your complex JSON object (object of objects) to a SAP list as it does not make structural sense. Why This Mapping Doesn't Work SAP lists expect a flat structure of similar objects, while an object of objects creates a nested, hierarchical structure. This fundamental difference in data organization prevents direct mapping. Example Structure Comparison Here's what you might have (object of objects) − { "employee1": { "name": "John", "age": 30 }, "employee2": { "name": "Jane", "age": ...
Read MoreError while connecting to SAP server from Java application: java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path
When connecting to SAP server from a Java application, you may encounter the error java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path. This error indicates that the SAP Java Connector (JCo) native libraries are not properly configured or accessible to the JVM. Understanding the Error The UnsatisfiedLinkError occurs when the Java Virtual Machine cannot locate the required native library (sapjco3) in the system's library path. The SAP Java Connector relies on native libraries that must be properly installed and configured at the server level. Common Configuration Issues ...
Read MoreUse of different files in SAP HANA Cockpit for offline administration
Start, Restart, Stop System Operations: To perform start/stop/restart of HANA systemDiagnosis Files: This is used to access log, trace and other diagnosis files.Troubleshoot Unresponsive System: You can use this to trigger the collection of transactional information and displays this information for troubleshooting performance issues.SAP HANA Documentation - SAP HANA Offline Administration: You can open SAP HANA documentation that describes those administration tasks that you can perform using the SAP HANA cockpit for offline administrationSAP HANA Cockpit: This option is used to open SAP HANA cockpit where you can access all applications for the online administration of SAP HANA system.
Read MoreAdvantages of using Calculation View without Star Join
When you use Calculation view with Star Join, you have the following benefits:It simplifies the design process.You need not create Analytical views and Attribute Views and directly Fact tables can be used as Projections.3NF is possible with Star Join.
Read MoreApplying Variable on calculated column in SAP HANA Modeling view
Yes, you can set a variable on top of “Calculated column”. In the bottom box, you need to select the column on which you want to set a Variable.Click on Add and from the drop-down, you can select “Calculated column” as below:
Read More