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
Generate 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 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 More