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 to join tables in SAP system
If you want to check the relation between different tables, you need to have a minimum read-only access to SAP system. Table joins in SAP allow you to combine data from multiple related tables based on common fields. Dictionary Structure Reference Below is the link to refer information about dictionary structure − https://help.sap.com/saphelp_46c/helpdata/en/ea/e9a3bb4c7211d189520000e829fbbd/frameset.htm Common Table Join Methods in SAP There are several ways to join tables in SAP system − ...
Read MoreHow to put a complete HTML page in a div using jQuery?
To put a complete HTML page in a div using jQuery, use the load() method. The load() method loads data from a server and puts the returned data into the selected element. This is particularly useful when you want to dynamically load content from another HTML file into a specific section of your current page. First, let's create the HTML page that you want to load. Here's the code for new.html − ...
Read MoreAdding items to table using function in SAP
When adding items to a table using functions in SAP, you need to use the correct method to retrieve structure metadata. The following shows how to properly implement this functionality. Replacing the Structure Metadata Method Instead of using the original statement, you need to replace the following code − IRfcStructure articol = repo.GetStructureMetadata("Z_ITEMS") as IRfcStructure; You need to replace this with the corrected approach − IRfcTable table = function.GetTable("Z_ITEMS"); IRfcStructure articol = table.Metadata.LineType; Explanation The original method GetStructureMetadata() may not properly handle table structures in all SAP environments. The ...
Read MoreHow to get value from serialized array in jQuery?
To get value from serialized array, use the serializeArray() method. The serializeArray() method serializes all forms and form elements like the .serialize() method but returns a JSON data structure for you to work with. The serializeArray() method returns an array of objects containing name/value pairs, making it easy to access individual form field values. Each object in the array has two properties: name (the field name) and value (the field value). PHP Backend File Let's say we have the following PHP content in serialize.php file − Example The following example demonstrates ...
Read MoreUsing ABAP, changing a value in itab by getting data from database table
You should do this using a MODIFY statement as shown below − LOOP AT itab. SELECT SINGLE matnr INTO itab-matnr FROM zlldet WHERE palet = itab-palet. MODIFY itab. ENDLOOP. Also note that when you have an internal table itab with a header line, it means that you have a table itab and structure itab and usage of this depends on the situation. Few of the commands like MODIFY and LOOP AT use both at the same time. Modern Approach Without Header Line ...
Read MoreError connecting SAP while sapjco3.jar file is in my library path
When encountering errors connecting to SAP even though the sapjco3.jar file is in your library path, the issue typically stems from a missing native library. You need to copy sapjco3.dll into a folder in your Java library path, as the required library is not sapjco3.jar but rather the sapjco3.dll file. Checking Your Current Library Path You can check your current Java library path in your application using the following − public class LibraryPathChecker { public static void main(String[] args) { String libraryPath = System.getProperty("java.library.path"); ...
Read MoreExecuting an inner join over RFC on database tables in SAP system
You can execute inner joins over RFC on database tables in SAP systems using several approaches. You can do this by creating your own function module that can perform selection as per the requirement. Methods to Perform Inner Joins Method 1: Custom Function Module Create a custom function module in SE80 or SE37 that performs the inner join logic and returns the required dataset. This approach gives you full control over the join operations and performance optimization. FUNCTION Z_CUSTOM_INNER_JOIN. SELECT a.field1, b.field2 FROM table1 AS a ...
Read MoreCreating User roles and profiles in SAP system
This can be done using Legacy Systems Migration Workbench (LSMW) transaction. This workbench works like a sort of macro recorder and allows you to record the steps in a transaction and you can replay that record multiple times as per the requirement. This also allows you to replace the values you used in your recorded transaction with new values. A more complex option would be to write ABAP code and this is more flexible to add different privileges to different roles. Methods for Creating User Roles and Profiles Method 1: Using LSMW (Legacy Systems Migration Workbench) ...
Read MoreLimit number of rows in Webi report in SAP BusinessObjects
When working with SAP BusinessObjects Web Intelligence (WebI) reports, you may need to limit the number of rows returned to improve performance and manage data volume effectively. There are several methods to control row limits depending on your data source and requirements. Universe-Level Row Limits If you are using a Universe as the data source, you can define row limits at the Universe level using the Universe Design Tool (UDT). Navigate to Universe Parameters → Controls to set the maximum size of the result set. This approach provides centralized ...
Read MoreAggregating rows in SAP ABAP with the same name
You can use the COLLECT keyword or some aggregate functions to achieve the result of aggregating rows with the same name in SAP ABAP. You should define appropriate data types to match your specific scenario. The COLLECT statement is particularly useful for accumulating numeric values while grouping rows by key fields. It automatically sums up non-key fields for records that have identical key field values. Example Here's a complete example showing how to aggregate rows using the COLLECT statement − TYPES: BEGIN OF t_my_type, key_a TYPE ...
Read More