Rishi Raj

Rishi Raj

77 Articles Published

Articles by Rishi Raj

Page 2 of 8

How to set a background image to be fixed with JavaScript DOM?

Rishi Raj
Rishi Raj
Updated on 15-Mar-2026 708 Views

To set a background image to be fixed in JavaScript, use the backgroundAttachment property. This CSS property controls whether the background image scrolls with the content or remains fixed in the viewport. Understanding backgroundAttachment The backgroundAttachment property accepts three values: "scroll" - Background scrolls with content (default) "fixed" - Background stays fixed relative to viewport "local" - Background scrolls with element's content Syntax element.style.backgroundAttachment = "fixed"; Example: Fixed Background Image This example demonstrates how to set a fixed background image that won't scroll with the page content: ...

Read More

How to use JavaScript to hide a DIV when the user clicks outside of it?

Rishi Raj
Rishi Raj
Updated on 15-Mar-2026 1K+ Views

To hide a DIV when the user clicks outside of it, you can listen for click events on the document and check if the clicked element is the target DIV or one of its children. This technique is commonly used for closing modals, dropdowns, and tooltips. Basic Implementation The simplest approach is to attach a click listener to the document and hide the DIV when the click target is not the DIV itself: #hideMe { ...

Read More

Denormalization of dimension tables in InfoCube in SAP BW

Rishi Raj
Rishi Raj
Updated on 13-Mar-2026 266 Views

In Data Warehouse systems, data load operations occur less frequently compared to data read operations. When using normalized tables, the system requires more joins, which significantly affects performance when running multiple read statements on the DW system. Denormalization is the process of combining normalized tables to reduce the number of joins required during query execution. When you implement denormalized tables, the response time of queries improves significantly, however, this comes with trade-offs including increased load time and higher memory space requirements. Benefits of Denormalizing Dimension Tables in InfoCube ...

Read More

Problem with division as output is either 0 or 1 when using ifthenelse condition in ABAP program

Rishi Raj
Rishi Raj
Updated on 13-Mar-2026 268 Views

The problem occurs when using the ifthenelse condition in ABAP programs for division operations. The issue is that your second parameter is 0 which is an integer, so the output always comes as an integer as ifthenelse takes its data type from the second parameter. In your case, if the division result is less than 0.5, it gets converted to 0, and if it's more than 0.5, it gets converted to 1. This happens because ABAP performs implicit type conversion based on the data type of the second parameter in ...

Read More

Error while selecting into field-symbol in SAP ABAP

Rishi Raj
Rishi Raj
Updated on 13-Mar-2026 467 Views

When selecting data into field-symbols in SAP ABAP, you may encounter errors if the field-symbol is not properly declared. The most common issue is attempting to use a field-symbol without declaring it first. Problem Description The error occurs when you try to select data into a field-symbol that has not been declared in your ABAP program. Field-symbols must be declared before they can be used in SELECT statements. Solution To resolve this issue, you need to properly declare your field-symbol before using it. Here are two approaches − Approach 1: Using Work Area Instead ...

Read More

Using AT_FIRST be used to initialize variables used in loop in SAP ABAP

Rishi Raj
Rishi Raj
Updated on 13-Mar-2026 221 Views

In SAP ABAP, the AT_FIRST statement is a useful control flow construct that can be used to initialize variables at the beginning of a loop iteration. Understanding when and how to use AT_FIRST for variable initialization is crucial for writing efficient ABAP code. Understanding AT_FIRST vs. Regular Initialization There would not be much of difference in both ways. The only thing is without AT_FIRST, the counter variables will be cleared in all cases while using AT_FIRST, the counter variables will be cleared only if there is at least one execution of the loop. So, the only difference would ...

Read More

Finding minimum value across different columns in SAP HANA

Rishi Raj
Rishi Raj
Updated on 13-Mar-2026 714 Views

In SAP HANA, when you need to find the minimum value across multiple columns in a single row, you should use the LEAST function instead of the MIN function. The MIN function is an aggregate function that works across rows, while LEAST compares values across columns within the same row. Using LEAST Function The LEAST function syntax allows you to compare multiple column values and returns the smallest value among them − SELECT ID, LEAST(DAY_1, DAY_2, DAY_3) AS MIN_VALUE FROM your_table_name; ...

Read More

Updating default value of new column in SAP system

Rishi Raj
Rishi Raj
Updated on 13-Mar-2026 498 Views

It is not good practice to update default values to a column in SAP as this will not be visible directly in the system and will not be picked up by CTS (Change and Transport System). Also, there is no built-in option in the SAP/ABAP environment for adding default values to existing table columns. Why Default Values Are Problematic If you choose to make a new column have NON-NULL values, you will have to manually update default values across all existing records. This approach has several drawbacks − ...

Read More

Error while using LOOP.....WHERE in SAP ABAP

Rishi Raj
Rishi Raj
Updated on 13-Mar-2026 425 Views

The LOOP...WHERE condition was included recently in SAP ABAP. Could you please verify your version? This will work only on a version of 7.0 EhP2 or higher. Understanding the Version Requirement The LOOP...WHERE statement is a powerful feature that allows you to filter internal table entries directly within the loop statement, eliminating the need for additional IF conditions inside the loop body. However, this functionality is only available in SAP NetWeaver 7.0 Enhancement Package 2 (EhP2) and later versions. Checking Your SAP System Version To check your SAP system version, you can use transaction SYSTEM → ...

Read More

Instance variables in Java

Rishi Raj
Rishi Raj
Updated on 11-Mar-2026 24K+ Views

Instance variables are declared in a class, but outside a method, constructor or any block.When space is allocated for an object in the heap, a slot for each instance variable value is created.Instance variables are created when an object is created with the use of the keyword 'new' and destroyed when the object is destroyed.Instance variables hold values that must be referenced by more than one method, constructor or block, or essential parts of an object's state that must be present throughout the class.Instance variables can be declared at the class level before or after use.Access modifiers can be given ...

Read More
Showing 11–20 of 77 articles
« Prev 1 2 3 4 5 8 Next »
Advertisements