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
Articles on Trending Technologies
Technical articles with clear explanations and examples
Use of String.compare for a varchar field in SAP
The article you've provided appears to be mismatched with the topic. The existing content discusses SqlFunctions.DateDiff for date operations in Entity Framework, but the topic is about String.compare for varchar fields in SAP. Using String.compare for Varchar Fields in SAP In SAP development, comparing varchar fields requires careful handling to ensure accurate results. The String.compare method provides a reliable way to perform string comparisons in SAP systems, particularly when working with database varchar columns. Basic String Comparison Syntax The basic syntax for string comparison in SAP ABAP is as follows − ...
Read MoreGenerate excel from a report in SAP system
When working with SAP reports, generating Excel files can be challenging, especially when the report runs in the background. The main issue is that background processes cannot determine where to save files locally on user machines. Understanding the Challenge If your report is running in the background, the system has no way of knowing where the file should be saved locally. This is a common limitation when dealing with background job processing in SAP systems. Recommended Approach Here's a practical solution assuming you have the necessary permissions and requirements − Step 1: Generate Excel File ...
Read MoreQuery MDG tables via SAP Studio
An answer to your question is a big "YES". You can execute queries against the MDG (Master Data Governance) tables either if you are using an ABAP program or also you can execute these queries from native SQL environment. Querying MDG Tables with ABAP You can use standard ABAP SELECT statements to query MDG tables just like any other SAP table. The following example demonstrates how to retrieve data from the KNA1 table (Customer Master) − DATA: lt_TBL LIKE TABLE OF KNA1. SELECT * ...
Read MoreBest option for locking bulk user accounts in SAP
As you need to do mass maintenance involving user locking and unlocking, you can opt for using SU10 transaction. This is the most efficient method for bulk user account management in SAP systems. You can also access this from SAP Menu by navigating to this path − Tools → Administration → User Maintenance → User mass maintenance In SAP system, you have different transactions under User Maintenance that you can use for different purposes. ...
Read MoreFetch unique records from table in SAP ABAP
When working with ABAP and SQL, you typically use OpenSQL for your SQL activities. To fetch unique records from a table, you can eliminate duplicate rows using the DISTINCT operator. Using DISTINCT Operator The DISTINCT keyword ensures that only unique records are returned from your query. This is particularly useful when you have duplicate entries in your table and need to retrieve only distinct values − SELECT DISTINCT field1, field2 FROM table_name WHERE condition. Example Here's a practical example ...
Read MoreField 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 More