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 on Trending Technologies
Technical articles with clear explanations and examples
Read a date filter as input in WEBI report in SAP BO
Your requirement is one of its kinds but can be achieved. What you can try out is first create a brand new object in the context. Let's say you provided the date as first input and 5 as a weekly slice in the second input. Example Here's how you can create a date filter formula using DATEADD function with prompts − [Date+5]=DATEADD(@prompt('Slice', 'X'{'Day', 'Month', 'Year'}, mono, constrained, persistent), 5, @prompt('Date', 'date', mono, free, persistent)) In this formula: X refers to your slice type (Day, Month, or Year) ...
Read MoreUse IFrame and read cookie in ABAP
Using IFrames with cookies in ABAP is achievable through a well-structured approach that combines server-side Business Server Pages (BSP) applications with client-side JavaScript to bridge the communication between third-party components and ABAP code. Implementation Approach The solution involves creating a frameset-based architecture that separates concerns while maintaining seamless data flow between components. Step 1: Create BSP Application First, create a Business Server Pages application on the server. Make sure the application contains a frameset and two IFrames as part of the frameset. ...
Read MoreNeed to schedule script in PowerShell from SAP
When scheduling PowerShell scripts from SAP, you may encounter permission issues where the scheduler cannot access required files or credentials. This commonly occurs because the scheduler service lacks the necessary permissions to read file contents, particularly login credentials stored in external files. Common Permission Issue The scheduler is unable to read the contents, basically the login credentials from the file. This happens because the service account running the scheduled task doesn't have appropriate file system permissions or cannot decrypt stored credentials. Solution: Service Account Authentication As a workaround, create a separate job altogether to capture the ...
Read MoreHow 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 More