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 18 of 58
Sort Datetime Type in SAP ABAP
In SAP ABAP, sorting datetime type fields requires understanding how to compare and order date and time values. There are two primary comparison operators LT (Less than) and GT (Greater Than) which you can use to perform basic comparisons between two datetime variables. You can frame the sorting logic as per your requirement whether you have a set of variables or an internal table. If it involves a set of variables then you need to do manual comparisons using conditional statements. Sorting Datetime Variables ...
Read MoreConnect to SAP system from C# application
To connect to an SAP system from a C# application, there is no standard approach, but you need to specify all required connection details for a successful connection. SAP Connection String Format The basic connection string format follows this pattern − XXXX-H/IP Address/S/Port Number Where: H stands for Host IP Address is the IP Address of the SAP server S stands for System ID Port Number is the port number for the SAP system Example Connection String ...
Read MoreForm a dynamic Query in SAP ABAP
You can indeed achieve it by creating dynamic queries in SAP ABAP. Dynamic queries allow you to build SQL statements at runtime based on varying conditions. Just follow the below steps: Steps to Create Dynamic Query Step 1 − Define the input parameters DATA: table_name TYPE string VALUE 'MARA', column_name TYPE string VALUE 'MATNR', name_value TYPE string VALUE 'TEST_MATERIAL'. Step 2 − Create a table ...
Read MoreAuthorize a new user in SAP
Basic things first, even if you are using a trial version, you still need to provide the license information and a developer key. Using BCUSER for Trial Version Instead of using a DDIC user, you can try using a BCUSER for your requirement as it is a part of the trial version. BCUSER is a business client user that comes pre-configured with trial systems and provides appropriate access for development activities. Adding SAP_ALL Profile You can include the SAP_ALL profile for your ...
Read MoreMove data from one warehouse to other in SAP MM
You can perform warehouse-to-warehouse transfer in SAP MM using the existing function module BAPI_GOODSMVT_CREATE. This BAPI allows you to create goods movements for transferring materials between different storage locations or warehouses efficiently. Using BAPI_GOODSMVT_CREATE for Warehouse Transfer The BAPI_GOODSMVT_CREATE function module is designed to handle various types of goods movements in SAP MM, including transfers between warehouses. This BAPI provides a programmatic way to execute material movements that would typically be done through transaction codes like MIGO or MB1B. Key Parameters When using this BAPI for warehouse transfers, you need to configure the following essential parameters ...
Read MoreMaking RFC call from COM/OLE object in SAP
To communicate between SAP systems, there is a need to define a mechanism. One of the most common ways is to define Remote Function Call (RFC Connection) between two systems. By creating a trusted RFC connection between two systems, it allows you to create trusted-trusting relationship between systems wherein, you can communicate and exchange information and data. There are different types of trusted RFC connections − Type 3 Connection − ABAP connection to external system Type I Connection − TCP/IP connection ...
Read MoreGetting an error on creating an Index in SAP HANA
When you encounter the error message "column already indexed" while creating an index in SAP HANA, it indicates that an index already exists on that column. This is a common issue that occurs when you try to create duplicate indexes. Understanding Automatic Index Creation SAP HANA automatically creates indexes on columns with specific data types. If the data type of your column is TEXT, HANA creates an index on it by default. This automatic indexing helps optimize text searches and queries. Solution: Change Data Type to BLOB For better performance and to avoid the indexing conflict, ...
Read MoreError in JavaServer Faces JSF application in SAP NWDS
When working with JavaServer Faces (JSF) applications in SAP NetWeaver Developer Studio (NWDS), you may encounter rendering issues or validation errors related to the HTML DOCTYPE declaration. This problem typically occurs when the DOCTYPE is incompatible with JSF components or when the HTML structure doesn't align with JSF requirements. Common DOCTYPE Issue in JSF Applications The most frequent issue arises from using an outdated or incompatible DOCTYPE declaration. If you're experiencing rendering problems or validation errors, try updating the DOCTYPE declaration in your JSF pages. Solution Replace the problematic DOCTYPE declaration with the following corrected version ...
Read MoreHow to split SAP Smartform templates
Splitting SAP Smartform templates is not directly achievable using the standard template concept of Smart Forms. The template functionality in Smart Forms has limitations when it comes to creating complex split layouts. Alternative Approach for Content Splitting To overcome this limitation, you need to use separate windows instead of relying on templates. This approach allows you to distribute content across different sections of your form effectively. Implementation Strategy The recommended approach involves − Creating multiple windows ...
Read MoreDe-normalization and Analytic views in SAP HANA
Note that HANA is not primarily designed for de-normalization; however, it stores data in columnar format so all aggregations are performed on the fly. This columnar storage approach allows for efficient query processing without the need for traditional de-normalization techniques. You can create multiple views but this will add duplicate data and require extra effort to maintain them. The number of views normally depends on business needs, because views contain data in many aspects so they can be reused. In case you have multiple measures to handle in ...
Read More