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 HANA Articles
Page 3 of 58
Field not getting save from table to transparent table in SAP
When working with SAP tables and transparent tables, you may encounter issues where fields are not getting saved properly. What can be understood from this problem is not a type mismatch but rather a mismatch in field size, as defaults are different for each table type. Understanding the Size Mismatch Issue In SAP, when you create fields in different table types, the system assigns default sizes that may not always match. This discrepancy can prevent data from being saved correctly when transferring information between a regular table and a ...
Read MoreGet all occurrences of the string between any two specific characters in SAP ABAP
I usually use REGEX in all such cases as it is faster and easily readable and would recommend the same to you. You can use something similar as the snippet to get your job done. Example Here's a complete example that extracts all text between ampersand characters − DATA: lv_para TYPE string, lv_result TYPE string. lv_para = ' You &are like& kite &flying& in a &hurricane&'. " Remove all text between & characters including the & symbols lv_result = lv_para. REPLACE ALL OCCURRENCES OF REGEX '&[^&]+&' IN ...
Read MoreIdentify the program to edit an ABAP code
There are several ways to identify the program for editing if you know the transaction code in advance. Each method has its own advantages and use cases in ABAP development. Method 1: Using Transaction SE93 The most reliable method is to use SE93 (Maintain Transaction Codes) for identifying the program based on the transaction code. This transaction allows you to view the program associated with any T-Code. In SE93, simply enter the transaction code you want ...
Read MoreFetch the modified date of table in SAP HANA
In SAP HANA database, you can fetch the modified date of a table using the system view SYS.M_TABLE_STATISTICS. This view provides statistical information about tables, including their last modification timestamps. Using M_TABLE_STATISTICS System View The M_TABLE_STATISTICS system view contains metadata about tables in your SAP HANA database. You can query this table to find information about when a specific table was last modified by ordering the results based on the last modified date. Example Here's how to query the ...
Read MoreWorking on a cost center report in SAP
Generating a cost center report in SAP is straightforward, even for beginners. If you need details about how work orders are related to cost centers, this guide will help you understand the relationship and access the necessary data. All orders, whether they are internal orders or work orders, are linked to a specific cost center. Each order will have an associated cost center, and you can find this relationship by referring to the following Controlling tables: Key SAP Tables for Cost Center Reports COEP Table ...
Read MoreUnderstand more about roles in SAP system
On a high level, both the tables are almost same as both of them deal with storing details about profiles which are generated for a role. Understanding AGR_PROF Table Let's talk about AGR_PROF first. It stores the text of the generated profile which is dependent on language. It stores profile ID as well. So, it results in having only at max one possible combination of a profile and language which is referred to a master profile. To view further details about this Table ...
Read MoreActivation of ABAP table failing with reference error
When activating ABAP tables, reference errors commonly occur when quantity fields or currency fields are defined without proper reference configurations. This issue arises because SAP requires explicit references to determine the correct units and formatting for these special field types. Understanding Reference Fields In ABAP Data Dictionary, quantity and currency fields must reference other fields that define their units of measure or currency codes. This ensures proper display formatting and calculation accuracy throughout the system. Solution Steps To resolve the activation error, follow these steps − Step 1: Identify Problem Fields Check your table ...
Read MoreChange user settings for case sensitivity in SAP 6.0
SAP provides user-specific text settings that allow you to type in uppercase or lowercase according to your preference. To configure these case sensitivity settings, navigate to the ABAP Editor initial screen using T-Code: SE38. Accessing Case Sensitivity Settings To modify your case sensitivity preferences, follow these steps − 1. From the ABAP Editor screen, go to Utilities in the menu bar 2. Select Settings from the Utilities dropdown menu 3. ...
Read MoreReplace Tab with space in SAP ABAP
In SAP ABAP, replacing tab characters with spaces is a common requirement when processing text data. You just need to make a small change by adding an "If condition" for handling the tab character as shown below − Method To replace tab characters with spaces, you need to check if the field contains the tab character using the CO (Contains Only) operator and a hexadecimal constant − if CO gc_hex_char Complete Example Here's a more complete implementation showing how to replace tab characters with spaces − DATA: lv_text TYPE string, ...
Read MoreAnalogous to IN operator of SQL in SAP
You can get similar functionality to SQL's IN operator done in many ways in SAP. You can use an internal table usage or a range table approach. Let me showcase an example with an internal table for your reference. Using Internal Table with FOR ALL ENTRIES The FOR ALL ENTRIES clause in SAP allows you to filter data based on values from an internal table, similar to the IN operator in SQL − SELECT Id, Name, DOB FROM sEmployee INTO ...
Read More