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 SAP Expert
Page 2 of 12
Converting BLOB to Char in SAP HANA using SQL
In SAP HANA, you may need to convert BLOB (Binary Large Object) data to character format for display or processing purposes. BLOB data stores binary information like images, documents, or encoded text that needs to be converted to readable character format. Converting BLOB to Character Data You can perform BLOB to character conversion using the TO_ALPHANUM function. This function converts binary data to alphanumeric character representation − SELECT TO_ALPHANUM(blob_column) FROM your_table_name; Complete Example Here's a practical example showing how to convert BLOB data to character format − -- Create a sample ...
Read MoreSorting Prompt values in SAP BO Webi report
In Business Objects 4.1, you can sort prompt values (List of Values - LOV) to display them in a specific order when users make selections. This can be done by following the below steps in the Universe − Steps to Sort Prompt Values Step 1: Navigate to Parameters and LOV Open your Universe in Information Design Tool and navigate to the Parameters and LOV section where your prompts are defined. Step 2: Edit SQL Query Next, go to the Edit SQL ...
Read MoreIN statement in SQL doesn’t accept a wild character (SAP)
The IN statement in SQL doesn't accept wild characters directly. When working with SAP systems, you need to use OR/AND conditions to handle wildcard functionality with the IN operator. Workaround Solution To implement wildcard behavior with the IN statement, you can use a conditional approach that checks for a wildcard parameter first, then applies the IN condition − select * from Test1 t INNER JOIN Test2 s ON t.ID = s.RID where t.sdate >= ?1 AND t.edate
Read MoreNo error while inserting record in child table with no match in master table in SAP
Note that when you perform an insertion using an ABAP program, there is no check on foreign key constraint. Even when you define checks in data dictionary SE11, there is still no check at database level. Application Level vs Database Level Validation When you execute using an ABAP code, this checks consistency at application level and not at database level. Errors you see in SE16 show records rejected at application level, but direct database insertions bypass these checks. Example − ...
Read MoreGenerating an IDoc file to generate orders in SAP R/3 system
BELNR is not required however it is useful for tracking and duplicate order management. Let us say a customer places an order and as he is not sure, he places the order again. Now there are 2 orders and you are not sure if there are two IDocs for the same order. Using BELNR for Order Management With BELNR (Document Number), it contains the order number of the customer system and you can add an optional field with Order Number. In case the same order is used, it can ...
Read MoreGetting information from pooled tables in SAP system
Note that you can't access Pooled tables directly and it should be accessed via Application server. When a pooled table is created, it involves creation of a suitable transparent table with a suitable delivery class and then it is changed to a pooled table. A pooled table can be flagged as transparent in its technical settings, which is a simple way of transforming it to a transparent table. To fetch information from Pooled tables, you need to write an ABAP code that can extract the data as per requirement. What are Pooled Tables? Pooled tables are ...
Read MoreCUID format in SAP BO Server Repository
As per my understanding, CUID (Cluster Unique Identifier) is a 35-character string that normally starts with A, B, C, F, K, and M. To know formatting of different ID types, you can refer to this − SAP Note: 1285103: What are the different types of IDs used in the BusinessObjects Enterprise repository? What is CUID? CUID stands for Cluster Unique Identifier. CUIDs are Globally Unique Identifiers that uniquely identify an InfoObject, both within a single CMS cluster and across multiple CMS clusters. Because ...
Read MoreFetching monitoring data in an application using SAP FM\'s
To fetch monitoring data in SAP applications, you need to login to the XM interface and utilize specific BAPIs (Business Application Programming Interfaces) designed to read CCMS (Computing Center Management System) data. CCMS provides comprehensive monitoring capabilities for SAP systems, allowing you to track system performance, alerts, and operational status. Available Function Modules SAP provides several function modules specifically designed for monitoring data retrieval − BAPI_SYSTEM_ALERT_ACKNOWLEDGE BAPI_SYSTEM_ALERT_GETDETAILS BAPI_SYSTEM_MON_GETLIST BAPI_SYSTEM_MON_GETTEMPLATE BAPI_SYSTEM_MON_GETTREE Function Module Descriptions BAPI_SYSTEM_ALERT_ACKNOWLEDGE − Used to acknowledge system alerts that have been identified and reviewed by administrators. BAPI_SYSTEM_ALERT_GETDETAILS − Retrieves detailed ...
Read MoreIn SAPUI5, how two add two icons in StandardListItem
Instead of using StandardListItem, you should use CustomListItem. With the use of CustomListItem, you can add any kind of content including multiple icons. Understanding CustomListItem As per SAP documentation, CustomListItem has the following use: This control with a content aggregation can be used to customize standard list items that SAP doesn't provide. List mode and ListItem type are applied to CustomListItems as well. Note: Even though the content aggregation allows any control, complex responsive layout controls (e.g. Table, Form) should not be aggregated as content. Reference: SAP CustomListItem Constructor Syntax The constructor for ...
Read MoreMoving BAPI, Function Module, and Business Object from one SAP system to other
Moving BAPI, Function Module, and Business Object from one SAP system to another can be performed using the Change and Transport System (CTS). CTS is a comprehensive tool that can be used to move ABAP objects, Java objects, and other development artifacts across your SAP system landscape. Transport Management System Overview Transport management is one of the key components in SAP system landscape and is used to perform the following activities − Defining Transport Domain Controller ...
Read More