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 Giri Raju
66 articles
Query returning no data in SAP Business One using Table Relationship
When queries return no data in SAP Business One, this is often caused by incorrect table relationships, particularly when using INNER JOIN statements. The issue typically occurs when one of the joined tables contains no matching records, causing the entire result set to be empty. Solution: Replace INNER JOIN with LEFT JOIN The most effective solution is to replace INNER JOIN with LEFT JOIN for optional relationships. This ensures that records from the main table are returned even when related tables have no matching data. Example Query Here's a corrected payment report query that handles missing ...
Read MoreFinding the table from which data is fetched in SAP
You can get the data if it is displayed in a transaction. Here are the steps you need to follow to find the table from which data is fetched in SAP. Method 1: Using F1 Help and Technical Information This is the most straightforward method to identify the source table for any field displayed in SAP − First, point the cursor on the field for which you want to get the data Press F1 for help. This will open a ...
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 MoreChange user settings for case sensitivity in SAP 6.0
SAP provides user-specific text settings that allow you to type in uppercase or lowercase according to your preference. To configure these case sensitivity settings, navigate to the ABAP Editor initial screen using T-Code: SE38. Accessing Case Sensitivity Settings To modify your case sensitivity preferences, follow these steps − 1. From the ABAP Editor screen, go to Utilities in the menu bar 2. Select Settings from the Utilities dropdown menu 3. ...
Read MoreReferences are not allowed in a SAP remote function call
When working with SAP remote function calls, you are trying to make use of references but you should be aware that references are only accessible within the same stack, and in your case, it is not. You are creating a remote function module and here references will not work. Why References Don't Work in Remote Function Calls In SAP ABAP, references point to memory locations within the current system's stack. When you make a remote function call (RFC), the function executes on a different system or server, which has ...
Read MoreSort data in SQL using Dynamic SQL in SAP HANA
In order to execute dynamic SQL in your stored procedure, you need to use the EXECUTE IMMEDIATE statement. This statement allows you to build and execute SQL queries dynamically at runtime, which is particularly useful when you need to sort data based on variables or user input. Basic Dynamic SQL Syntax You can use SQL as shown below to execute dynamic sorting − EXECUTE IMMEDIATE 'SELECT FROM ORDER BY ' || : || ' DESC'; Complete Example Here's a complete example showing how to implement dynamic sorting in a SAP HANA ...
Read MoreHandling higher level Boolean values in SAP system
As per the general standards and coding practice, you should use abap_bool for handling Boolean values or truth values in SAP systems. When any object is declared as abap_bool type, it can hold values only from the set (abap_true, abap_false, and abap_undefined). However, in older systems, you might not be able to use abap_bool as it is not available. For example, in Web Dynpro ABAP, abap_bool is not available. You need to use WDY_BOOLEAN as an alternative in this case. WDY_BOOLEAN only allows true Boolean values, meaning it allows only ...
Read MoreWhy does the JavaScript void statement evaluate an expression?
The JavaScript void returns an expression to remove the side effect and return the undefined primitive value. This side effect may occur while inserting expression in a web page.Let’s see an example of the void. The void(0) can be used with hyperlinks to obtain the undefined primitive value, Example Understanding JavaScript void(0) Click me not once, but twice. We used JavaScript:void(0) above to prevent the page from reloading when the button is clicked the first time.The code will only ...
Read MoreHow do we send an email using HTML forms?
To send an email using HTML forms, you need to add the email id to the action attribute of the form. In that, add email proceeding with mailto: i.e. mailto:emailid@example.com.ExampleYou can try to run the following code to send an email using HTML forms − Student Contact Form Student Name: Student Subject:
Read MoreHow to empty a C# list?
To empty a C# list, use the Clear() method.Firstly, set a list and add elements −List myList = new List() { "one", "two", "three", "four", "five", "six" };Now, let us empty the list −myList.Clear();Exampleusing System; using System.Collections.Generic; public class Program { public static void Main() { List myList = new List() { "one", "two", "three", "four", "five", "six" }; foreach(string ...
Read More