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
SAP Articles
Page 6 of 91
Use existing authentication along with SAP BO
It is one of the most common extension points in an existing ecosystem. With the latest release of SAP BusinessObjects (BO), you can use Active Directory based logins mapped under Windows Server. Authentication Integration Options SAP BusinessObjects provides several authentication methods that can integrate with your existing infrastructure − Windows Active Directory (AD) − Seamless integration with domain credentials LDAP Authentication − Connect to existing LDAP directories Single Sign-On (SSO) − Use existing SSO solutions like SAML or Kerberos Database Authentication − Leverage existing ...
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 MoreRead 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 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 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