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
SAP HANA Articles
Page 17 of 58
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 MoreDifferentiate dynamic parameter from others in SAP
It's a straightforward way to differentiate dynamic parameters from static parameters in SAP systems. Using Transaction RZ11 to Check Parameter Type To determine whether a parameter is dynamic or static, you need to navigate to transaction RZ11. This transaction displays system parameters and their properties. In the parameter details screen, look for the Dynamic field checkbox − If the Dynamic field checkbox is checked, it indicates that the parameter is a dynamic parameter ...
Read MoreIdentify SQVI queries formed by a user in SAP project
You need to use the function RSAQ_REMOTE_QUERY_CALL_CATALOG for fetching the list of SQVI queries for a user in SAP. This function module allows you to retrieve information about queries created in the SAP Query (SQVI) transaction. Understanding RSAQ_REMOTE_QUERY_CALL_CATALOG Function The RSAQ_REMOTE_QUERY_CALL_CATALOG function module is designed to programmatically access the catalog of SQVI queries. It provides details about queries created by specific users, including query names, descriptions, and associated parameters. Example Implementation Here's how to implement this function to retrieve ...
Read MoreExport Data from a SAP system
SAP stores data in database structures that are not conventional and quite complex. To export data from a SAP system, you need to develop custom code on top of SAP to support data export to external systems, and you are free to choose the format of your choice. Using SQVI (Quick Viewer) for Data Export One effective method to export data from SAP is to identify user-specific SQVI queries in ABAP/BAPI. Quick Viewer (SQVI) is a powerful tool for generating reports and extracting data from SAP tables. SAP Query ...
Read MoreFilter output columns in Table in SAP application
I think there can be a better option to do this. What you can try is fetch only the fields of the table which match the fields present in the table. Do not fetch all the fields of the table but the selected fields. This approach helps optimize performance by retrieving only the necessary columns instead of all available table fields. The displayField collection contains the specific column names you want to filter and display. Filtering Table Columns Example Here's how to filter output columns when working with SAP JCo Tables − // Here Table ...
Read More