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
SAP Authorization concept and Authorization Objects, Object Class
To clear the air all at once, SAP Authorization Objects and Object Class have nothing much in common with Object Oriented classes and objects and differ vastly from them. Authorization objects detail the current user's privileges which are used to authorize user activities and data availability. The Authorization Object is the place where configurations pertaining to permissions are set up and initialized against fields. An object class, on the other hand, is a grouping of Authorization objects. It may contain one or more authorization objects. Understanding Authorization Objects Authorization objects contain authorization fields that define what ...
Read MoreDistinguish SAP ABAP code between clients
In SAP ABAP, you can distinguish code execution between different clients by using the system field sy-mandt. This field contains the current client (mandant) number and allows you to implement client-specific logic in your programs. Using sy-mandt for Client Identification The sy-mandt system field is automatically populated with the current client number when a user logs into the system. You can use this field in conditional statements to execute different code blocks based on the client − IF sy-mandt = '002'. * do ...
Read MoreEntering a condition to perform SELECT in an existing report in SAP system
When working with SAP ABAP SELECT statements, you need to be careful with spacing and syntax, especially when adding complex conditions. One of the most common mistakes is improper spacing around brackets and logical operators in WHERE clauses. Adding Complex Conditions to SELECT Statements In ABAP, proper spacing is crucial for the parser to correctly interpret your code. When combining multiple conditions with logical operators like AND, OR, and NOT, ensure you have adequate spaces before and after brackets and operators. Example ...
Read MoreHandling higher level Boolean values in SAP system
As per the general standards and coding practice, you should use abap_bool for handling Boolean values or truth values in SAP systems. When any object is declared as abap_bool type, it can hold values only from the set (abap_true, abap_false, and abap_undefined). However, in older systems, you might not be able to use abap_bool as it is not available. For example, in Web Dynpro ABAP, abap_bool is not available. You need to use WDY_BOOLEAN as an alternative in this case. WDY_BOOLEAN only allows true Boolean values, meaning it allows only ...
Read MoreIs it possible to delete the actives while you are running a loop over an internal table in SAP ABAP?
The DELETE command will have a result. You should make sure that once you delete the row, there should not be any reference or use of that row subsequently in the loop. The best practice is to use CONTINUE as soon as you perform deletion. Best Practices for Deleting Records I suggest avoiding "DELETE lt_itab INDEX sy-tabix" because it will change the sy-tabix (table index) and can lead to unexpected behavior. When you delete a row, all subsequent rows shift up, making the index unreliable for the ...
Read MorenParsing IDoc files to extract information from SAP system
There are few third party libraries which can be used to perform this task however they involve some cost. The best way here is to use an SAP Connector. SAP Connectors are available for almost all prevalent programming languages like Java, C#, Python. You can program against these connectors and read data from IDoc. You can do many things with these connectors from reading data to converting them to flat files for further usage. Using Java Connector for IDoc Parsing I have used ...
Read MoreWhat is ABAP? Explain ABAP OOP feature in detail?
ABAP stands for Advanced Business Application Programming. It is one of the primary programming languages used for developing programs and applications for SAP R/3 systems and its related modules. It is a high-level language with respect to SAP as it is understood and known only to SAP environment. The latest version of ABAP which is ABAP Objects follows Object Oriented paradigm. Also, it is fully backward compatible with applications written in previous versions of ABAP whether it is ABAP/4 or other which were highly impressed by COBOL. ...
Read MoreUsing SAP T-code SM37 to check background jobs in SAP system
In SM37 you can only see the scheduled background jobs as it is not used for foreground jobs. This transaction code is essential for monitoring and managing batch processes that run behind the scenes in your SAP system. Accessing SM37 Transaction To access the background job monitoring screen, enter SM37 in the SAP command field and press Enter. Below shows the initial screen of SM37 Transaction code − Key Features of SM37 ...
Read MoreUsing Aggregate function to fetch values from different tables in SAP
When working with SAP databases, you often need to retrieve data from multiple related tables while handling duplicate or varying descriptions for the same entity. Aggregate functions provide an effective solution for consolidating data and selecting specific values when joins result in multiple records. If your query returns different descriptions for the same fund and you want to keep any one description, you can use aggregation functions like MIN() or MAX() to select a single value from the duplicates. Using MIN() Aggregate Function The following example demonstrates how to use the MIN() aggregate function to fetch fund ...
Read MoreInserting an Array to a table in SAP HANA database
As far as I know, there is no direct way of inserting an Array using SQL query in SAP HANA. You will first have to combine the columns (EMPL_Id + Skill Id) using the code and then do a bulk insert to the database. Array to Table Insert Methods In SAP HANA, when you need to insert array data into a table, you have several approaches to handle this limitation − Method 1: Using UNNEST Function The UNNEST function can convert an array into individual rows, which can then be inserted into a table − ...
Read More