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 Basis Articles
Page 2 of 50
Benefits of Transaction SE83- SAP reuse library
The Reuse Library is basically a repository for various functions and classes that can be used across SAP development projects. One of the main benefits is that it contains a number of source code examples for these functions. These examples are quite useful as they can be used as base code, so you don't have to start development from scratch. The library serves as a centralized location where developers can find pre-built, tested components that follow SAP best practices. While it may not be primarily used for documentation ...
Read MoreViewing an ABAP program outside customer space.
When you encounter an ABAP program prefixed with "AQZZ", this indicates that the program was created by the SAP Query via transaction SQ01. While you might not be able to directly view the query, you can identify the Infoset on which the query relies. You can then enter the Infoset in SQ02 and when you click on 'Description', you can find more details about the program structure and data sources. Ad-hoc Queries T-Code: SQ01 You can use this transaction to create ad-hoc queries (SAP Queries) for reporting ...
Read MoreGetting age of tracefiles in SAP HANA database
In SAP HANA database, you have diagnosis files that include log and trace files, along with a mixture of other diagnosis, error, and information files. These files can be checked for diagnosis to find errors in SAP HANA database. In HANA database, trace files are stored separately per host, so to get access to the trace files of a multi-node system you have to check for each host individually. Finding Trace File Location To find the location of trace files in SAP HANA, ...
Read MoreGetting month name instead of numeric month number in report in SAP
There are various methods to convert numeric month numbers to month names in SAP reports. Each approach has its own advantages depending on your specific requirements. Method 1: Using Function Module MONTH_NAME_GET Use the Function module MONTH_NAME_GET − This function module is used to return all the month names in the respective language. This is the most recommended approach as it supports internationalization. Example Here's how to implement this function module − DATA: lv_month TYPE i VALUE 3, ...
Read MoreUse 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 More