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
How can I get the selected value of a drop-down list with jQuery?
With jQuery, it's easy to get selected text from a drop-down list. This is done using the select id. To get the selected value of a drop-down list, use the val() method, and to get the selected text, use the text() method with the :selected selector. Getting Selected Value and Text There are several ways to retrieve information from a selected dropdown option − Getting Selected Value: Use $("#selectId").val() to get the value attribute of the selected option. Getting Selected Text: Use $("#selectId option:selected").text() to get the display text of the selected option. Example ...
Read MoreGetting month name instead of numeric month number in report in SAP
There are various methods to convert numeric month numbers to month names in SAP reports. Each approach has its own advantages depending on your specific requirements. Method 1: Using Function Module MONTH_NAME_GET Use the Function module MONTH_NAME_GET − This function module is used to return all the month names in the respective language. This is the most recommended approach as it supports internationalization. Example Here's how to implement this function module − DATA: lv_month TYPE i VALUE 3, ...
Read MoreUse of String.compare for a varchar field in SAP
The article you've provided appears to be mismatched with the topic. The existing content discusses SqlFunctions.DateDiff for date operations in Entity Framework, but the topic is about String.compare for varchar fields in SAP. Using String.compare for Varchar Fields in SAP In SAP development, comparing varchar fields requires careful handling to ensure accurate results. The String.compare method provides a reliable way to perform string comparisons in SAP systems, particularly when working with database varchar columns. Basic String Comparison Syntax The basic syntax for string comparison in SAP ABAP is as follows − ...
Read MoreGenerate excel from a report in SAP system
When working with SAP reports, generating Excel files can be challenging, especially when the report runs in the background. The main issue is that background processes cannot determine where to save files locally on user machines. Understanding the Challenge If your report is running in the background, the system has no way of knowing where the file should be saved locally. This is a common limitation when dealing with background job processing in SAP systems. Recommended Approach Here's a practical solution assuming you have the necessary permissions and requirements − Step 1: Generate Excel File ...
Read MoreQuery MDG tables via SAP Studio
An answer to your question is a big "YES". You can execute queries against the MDG (Master Data Governance) tables either if you are using an ABAP program or also you can execute these queries from native SQL environment. Querying MDG Tables with ABAP You can use standard ABAP SELECT statements to query MDG tables just like any other SAP table. The following example demonstrates how to retrieve data from the KNA1 table (Customer Master) − DATA: lt_TBL LIKE TABLE OF KNA1. SELECT * ...
Read MoreBest option for locking bulk user accounts in SAP
As you need to do mass maintenance involving user locking and unlocking, you can opt for using SU10 transaction. This is the most efficient method for bulk user account management in SAP systems. You can also access this from SAP Menu by navigating to this path − Tools → Administration → User Maintenance → User mass maintenance In SAP system, you have different transactions under User Maintenance that you can use for different purposes. ...
Read MoreFetch unique records from table in SAP ABAP
When working with ABAP and SQL, you typically use OpenSQL for your SQL activities. To fetch unique records from a table, you can eliminate duplicate rows using the DISTINCT operator. Using DISTINCT Operator The DISTINCT keyword ensures that only unique records are returned from your query. This is particularly useful when you have duplicate entries in your table and need to retrieve only distinct values − SELECT DISTINCT field1, field2 FROM table_name WHERE condition. Example Here's a practical example ...
Read MoreField not getting save from table to transparent table in SAP
When working with SAP tables and transparent tables, you may encounter issues where fields are not getting saved properly. What can be understood from this problem is not a type mismatch but rather a mismatch in field size, as defaults are different for each table type. Understanding the Size Mismatch Issue In SAP, when you create fields in different table types, the system assigns default sizes that may not always match. This discrepancy can prevent data from being saved correctly when transferring information between a regular table and a ...
Read MoreGet all occurrences of the string between any two specific characters in SAP ABAP
I usually use REGEX in all such cases as it is faster and easily readable and would recommend the same to you. You can use something similar as the snippet to get your job done. Example Here's a complete example that extracts all text between ampersand characters − DATA: lv_para TYPE string, lv_result TYPE string. lv_para = ' You &are like& kite &flying& in a &hurricane&'. " Remove all text between & characters including the & symbols lv_result = lv_para. REPLACE ALL OCCURRENCES OF REGEX '&[^&]+&' IN ...
Read MoreIdentify the program to edit an ABAP code
There are several ways to identify the program for editing if you know the transaction code in advance. Each method has its own advantages and use cases in ABAP development. Method 1: Using Transaction SE93 The most reliable method is to use SE93 (Maintain Transaction Codes) for identifying the program based on the transaction code. This transaction allows you to view the program associated with any T-Code. In SE93, simply enter the transaction code you want ...
Read More