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
Dynamically creating parameters from table entries in SAP system
Note that parameter statement compiles into selection screen at compile time, so it is not possible to declare dynamic parameters as traditionally expected. The parameter definitions must be known at design time. An alternative approach is to load the dynpro (dynamic program) and change the screen dynamically at runtime. This involves modifying the screen elements programmatically, then activating and running the report that calls the changed screen. This same approach is used in T-code SE16 to generate a selection screen dynamically from any table structure. The system reads the table's field definitions and creates corresponding input fields on ...
Read MoreUsing GUI upload to attach a file to email in SAP
You have to use parameters correctly in the function. You have to import the file length to an integer value. Importing File Length First, call the gui_upload_file method from the cl_gui_frontend_services class to upload the file and capture its length − CALL METHOD cl_gui_frontend_services=>gui_upload_file EXPORTING window_title = 'Select File' default_extension = '*' file_filter = 'All Files (*.*)|*.*' IMPORTING file_table ...
Read MoreCreating a Function module in ABAP to take any table and write it to the screen
SAP List Viewer (ALV) is used to add an ALV component and provides a flexible environment to display lists and tabular structure. A standard output consists of header, toolbar, and an output table. The user can adjust the settings to add column display, aggregations, and sorting options using additional dialog boxes. Creating a Function Module Using ALV You can use the following code to display any table using the CL_SALV_TABLE class − DATA: go_alv TYPE REF TO cl_salv_table. CALL METHOD cl_salv_table=>factory IMPORTING r_salv_table = ...
Read MoreUsing an Angular app as SAP Fiori application
When moving to SAP, whether it's SAP HANA Cloud platform or a backend SAP system, you can continue with your HTML Angular application by connecting to the backend via an OData service. Angular is a powerful JavaScript framework that adds numerous features to your application. However, one important consideration is that if you are planning to use Fiori Launchpad, integration could present challenges. What is SAP Fiori Launchpad? SAP Fiori Launchpad is a shell that hosts SAP Fiori applications and provides centralized access ...
Read MoreExtracting data from SAP HANA database and load to ORACLE database
There are several methods to extract data from SAP HANA database and load it into Oracle database. Each approach has its own advantages depending on your specific requirements, infrastructure, and technical expertise. Methods for Data Extraction and Loading ETL Tools: Use standard SAP tools like SAP Data Services or Oracle Warehouse Builder (OWB) to extract data and automate the entire process. These tools provide graphical interfaces, built-in transformations, and scheduling capabilities for seamless data integration. ...
Read MoreDate value is not populating while using Native SQL in SAP to insert an Order
When inserting date values using Native SQL in SAP ABAP, you may encounter issues with date population. The primary issue is often related to variable binding syntax in the SQL statement. Solution You need to put a colon (:) before the variable to properly bind it in Native SQL. Here's the corrected syntax − EXEC SQL. INSERT INTO order VALUES('2', :sy-datum) ENDEXEC. The colon (:) is essential for host variable binding in Native SQL. Without it, the system treats sy-datum as a literal string rather than a variable reference. Alternative ...
Read MoreReplacing multiple occurrence by a single occurrence in SAP HANA
The code you are using \1+ just removes consecutive occurrences only. To replace multiple occurrences of any character with a single occurrence, you can use the following approach with REPLACE_REGEXPR function in SAP HANA. Using Regular Expression to Remove Multiple Occurrences The regular expression pattern (.)(?=.*\1) works by capturing any character and looking ahead to see if the same character appears later in the string. This allows us to remove all duplicate occurrences while keeping only the last one − SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' ...
Read MoreProgrammer to be an SAP Functional Consultant - HR or MM
SAP HR is an older module with limited new implementations across companies. SAP HR encompasses several sub-modules including Payroll, Personal Administration, and Time Management. If you pursue a course in SAP HR, it would primarily provide conceptual knowledge, but practical implementation in companies can be challenging without hands-on experience. For SAP Module functional consultant positions, prior experience in the relevant field is highly recommended. Additionally, as a programmer, daily tasks like generating test data, testing reports, and writing specifications may not align with your technical interests. Recommended SAP ...
Read MoreAdding a condition using SQL or an ABAP program and difference in performance
When adding conditions to filter data, you can choose between implementing the logic in SQL or in an ABAP program. For small datasets like 500 records, there would not be much difference in performance between both options. You can use either of them based on your specific requirements. SQL Approach Using SQL WHERE clause directly in the database query is generally more efficient as it filters data at the database level − SELECT * FROM table_name INTO TABLE lt_table WHERE exp > 5. ABAP Program Approach Alternatively, you can ...
Read MoreSetting up a JDBC connection to remote SAP HANA system
To establish a JDBC connection to a remote SAP HANA system, you need to configure the correct port number and use the appropriate JDBC driver. Port Configuration You are using the correct port number for instance number "00". Port number 30015, where 00 represents the instance number of your HANA system. The port format follows the pattern 315 for SQL connections. JDBC Driver Setup Use the HANA client JAR file ngdbc.jar instead of the generic SAP JAR file. This driver is specifically optimized for HANA database connections and provides better performance and compatibility. Example ...
Read More