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 2 of 91
Use decimal in where clause in SAP ABAP
When working with decimal values in SAP ABAP WHERE clauses, you might encounter issues if you try to use locale-specific decimal separators. ABAP does not support user-specific regional settings for decimal notation in SQL queries. You must always use the standard dot (.) as the decimal separator instead of comma (, ) or other regional separators. Using Decimal Values in WHERE Clause The correct syntax requires using a dot (.) as the decimal separator, regardless of your system's regional settings. Here's the proper approach − SELECT ...
Read MoreConvert CHAR to HEX in SAP system and functions
When working with SAP systems, converting character data to hexadecimal format is a common requirement. However, developers often encounter exceptions when using standard conversion functions due to data type compatibility issues. Understanding CHAR to HEX Conversion Issues When attempting to use standard conversion functions, you may encounter exceptions. Based on system dump analysis, only character type data objects are compatible with most conversion functions. This limitation requires using specific function modules designed for data type conversion. Using CRM_EI_KB_CONV_DEC_TO_HEX Function Module For ECC 6.0 environments, you can utilize the function module 'CRM_EI_KB_CONV_DEC_TO_HEX' which converts decimal values to ...
Read MoreDeclare dynamically in SAP ABAP
In SAP ABAP, you can declare an internal table in a dynamic manner when the table type is not known at compile time. This approach is useful when working with generic programming or when the table structure depends on runtime conditions. Dynamic Internal Table Declaration To declare an internal table dynamically, you need to use data references and field symbols. Here's the basic syntax − DATA: tbl_TEST TYPE REF TO DATA. FIELD-SYMBOLS: TYPE STANDARD TABLE. CREATE DATA tbl_TEST TYPE (Received_Type). ASSIGN tbl_TEST->* TO . Complete Example Here's a complete working example that ...
Read MoreUsing logarithm in SAP ABAP
Yes, there is a log function in SAP ABAP. You can use it to implement logarithmic calculations for your requirements. The LOG function in ABAP calculates the natural logarithm (base e) of a number. To calculate logarithms with different bases, you can use the mathematical formula: logbase(number) = ln(number) / ln(base). Example Here is a code snippet which demonstrates how to calculate logarithm with a custom base − DATA: NUMBER TYPE INT, BASE TYPE INT, RESULT TYPE FLOAT. NUMBER = ...
Read MoreUse workbench along with SAP Business One
The answer is No. Workbench is not present in SAP Business One. The reason being the core of Business One is not based on ABAP or NetWeaver platform. SAP Business One Architecture Business One relies heavily on SQL. It has a SQL database (SQL Server or SAP HANA) and you can write queries for fetching data. These data are then used for creating reports and custom applications. When you compare Business One with ABAP development capabilities, the extension possibilities are more limited in Business One compared to what's available in traditional SAP systems with ABAP workbench. ...
Read MoreCreate an INCLUDE in SAP system
Creating an INCLUDE in an SAP system is a straightforward process that can be accomplished through two main transaction codes. An INCLUDE is a modular programming object in SAP that contains reusable ABAP code segments. Method 1: Using Transaction SE38 The most common way to create an INCLUDE is through transaction SE38 (ABAP Editor). Follow these steps − Open transaction SE38 in your SAP system Enter the desired INCLUDE name in the program field Press the Create button Select Include Program as the program ...
Read MoreSAP Associate Level Exam preparation
First, let me make your core basics clear about SAP system architecture and exam preparation. When you are referring to SAP ECC, you are referring to SAP ERP Central Component which is more or less equivalent to the prior SAP R/3 System. ABAP does not play a direct functional role in ECC modules like FI, CO, MM, or SD. However, ABAP resides in the kernel of SAP which is referred to as SAP BASIS. BASIS forms the technical foundation that supports all SAP applications and modules. Key Study Resources for SAP ...
Read MoreInvalid Connection String in SAP Business One
The answer lies within the exception message itself. The connection string that you are using to connect to the Business object server is wrongly configured. Check for each parameter, you will find something must be wrong and hence why you are receiving this error message. Common Connection String Parameters A typical SAP Business One connection string contains several critical parameters that must be correctly configured − Server − The SAP Business One server address CompanyDB − The company database name UserName − Valid SAP Business One username ...
Read MoreIntegrating JSession in a Web-Service in SAP
Integrating JSession in a SAP web service requires proper configuration of the SOAP manager transaction to maintain session state across HTTP calls. Configuring SOAP Manager Transaction You need to configure the soap manager transaction with the following steps − First, specify the proxy that you have created in the configuration Specify the port number for the web service endpoint Set the access path from transport settings to define the URL pattern Using cl_http_client for Session Management The SAP system makes use ...
Read MoreLDAP_SEARCH function not returning photos stored in Active Directory with LDAP integration in SAP BSP application
When working with LDAP integration in SAP BSP applications, you may encounter issues where the LDAP_SEARCH function module doesn't return photo data stored in Active Directory. This is a common problem that can be resolved by switching to a more appropriate function module. Solution: Use LDAP_READ Instead I would recommend using LDAP_READ instead of LDAP_SEARCH, and you will see that thumbnail photos should be available in a convenient form as XSTRING data type. LDAP_SEARCH is mentioned as obsolete in SAP documentation and may not handle binary data like photos correctly. The LDAP_READ function module is specifically designed ...
Read More