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 varun
65 articles
Handline #Multivalue Error in SAP BO Webi report
This error occurs when your formula returns more than one value and WebI report doesn't know how to aggregate those values. The #MULTIVALUE error can appear in several scenarios − #multivalue in aggregation − When a formula returns multiple values without proper aggregation #multivalue in breaks header or footer − When break sections contain non-aggregated multi-value data #multivalue in section level − When section calculations encounter multiple values Understanding the #MULTIVALUE Error The error occurs because WebI cannot determine which value to display when multiple values ...
Read MoreConnecting SAP B1 via DI API takes too much time
When connecting to SAP Business One via DI API, you may experience slow connection times. This performance issue is commonly caused by accumulated log files that build up over time during DI API operations. Solution To resolve this connection speed issue, delete all files under the following location − %UserProfile%\AppData\Local\SAP\SAP Business One\Log\DIAPI Step-by-Step Process Follow these steps to clear the DI API log files − Close all SAP Business One applications and DI API connections Navigate to the log directory using Windows Explorer or Run ...
Read MoreGenerate Database diagram within SAP
Generating complete database diagrams in SAP, as typically generated in SQL Server or other DBMS systems, is not directly possible. However, there are several approaches that can help you visualize database structures and relationships within the SAP environment. Method 1: Using SAP Object Model Guide You can refer to the Object Model Guide available in the SAP Marketplace. This comprehensive guide explains the most common relationships between popular and frequently used business objects in SAP. While it doesn't cover every aspect of the database structure, it provides detailed coverage of the most commonly used and critical business objects ...
Read MoreAdding a text plus and text written from a parameter type C in ABAP
This can be achieved by using String Expressions or by using the CONCATENATE keyword. With the use of the concatenation operator && you can combine text and parameter values effectively. String Concatenation Methods in ABAP There are several ways to concatenate text with parameter values in ABAP. The most common approaches include using string expressions with the && operator and the traditional CONCATENATE statement. Using String Expressions with && Operator The modern approach uses string expressions with the concatenation operator && − ...
Read MoreViewing an ABAP program outside customer space.
When you encounter an ABAP program prefixed with "AQZZ", this indicates that the program was created by the SAP Query via transaction SQ01. While you might not be able to directly view the query, you can identify the Infoset on which the query relies. You can then enter the Infoset in SQ02 and when you click on 'Description', you can find more details about the program structure and data sources. Ad-hoc Queries T-Code: SQ01 You can use this transaction to create ad-hoc queries (SAP Queries) for reporting ...
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 MoreWorking on a cost center report in SAP
Generating a cost center report in SAP is straightforward, even for beginners. If you need details about how work orders are related to cost centers, this guide will help you understand the relationship and access the necessary data. All orders, whether they are internal orders or work orders, are linked to a specific cost center. Each order will have an associated cost center, and you can find this relationship by referring to the following Controlling tables: Key SAP Tables for Cost Center Reports COEP Table ...
Read MoreChange leaves duration from hours to days in SAP Fiori app
In general, customizing Fiori applications involves customizing the parent SAP application. So, if in the application, it defaults to hours then the Fiori app will also inherit the default behavior and show it in hours. Go ahead and change it to days, it will impact your Fiori app and the app will also start showing in days. In case you cannot afford to make a change in SAP application, then you need to handle it in a custom manner which will require you to ...
Read MoreHow to call a JavaScript function from an onClick event?
The onClick event is the most frequently used event type, which occurs when a user clicks the left button of the mouse. You can put your validation, warning etc., against this event type.ExampleYou can try to run the following code to call a JavaScript function from an onClick event Click the following button and see result
Read MoreString Formatting with ToString in C#
To format a string, first set the value −int value = 55;Now to format the integer, use ToString and let’s say we need to set it for three places −value.ToString("000");The following is the complete code −Exampleusing System; public class Program { public static void Main() { int value = 55; string res = value.ToString("000"); Console.WriteLine(res); } }Output055
Read More