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
SAP Basis Articles
Page 26 of 50
Benefits of Transaction SE83- SAP reuse library
Reuse library is basically a repository for various function and classes that can be used. One of the main benefits is that it has a number of source code examples for these functions present. These examples are quite useful as these could be used as a base code and you don’t have to start from scratch. I don’t think that it is used for documentation of internal functions, although it varies from user to user and can be used for keeping the documentation.There are no regular updates scheduled with various releases.Menu Path for transaction SE83 −SAP Menu→Tools→ABAP Workbench→Overview→Reuse LibraryTransaction Description: ...
Read MoreViewing an ABAP program outside customer space.
The program is prefixed with “AQZZ”. This indicates that this is either created by the SAP query via transaction SQ01. You might not be able to look at the query but 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. Ad-hoc Queries T-Code: SQ01 You can use this transaction to create ad-hoc queries/SAP Queries for reporting off the infoset in SAP module. When you run this T-code, you have to enter the following: Give the name of the query you want to create ...
Read MoreGetting age of tracefiles in SAP HANA database
In SAP HANA database, you have diagnosis files include log and trace files, 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 db, you have trace files stored separated per host, so to get access to the trace files of a multi-node system you have to check for each host individually.To find the location of trace files in SAP HANA you can run the following SQL statement −SELECT* FROM M_DISKS WHERE USAGE_TYPE ='TRACE';To access tracefiles using the command line, you can use cdtrace as below −You ...
Read MoreGetting month name instead of numeric month number in report in SAP
There are various methods this can be donea) Use the Function module MONTH_NAME_GET - This Function module is used to return all the month and names in the respective language.b) You can also use the below formula −cstr(monthname(month({inputdate})))where “inputdate” is the date for which month name is required.c) Find the numeric value of month and use if condition. For example -IF month = “01” THEN January
Read MoreUse of String.compare for a varchar field in SAP
Try to use SqlFunctions.DateDiff method overload which requires 3 inputs as follows −var res = from a in db.Set() where SqlFunctions.DateDiff("dd", a.Date, "20161922") >= 0 && SqlFunctions.DateDiff("dd", a.Date, "20161122") < 0 select a
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.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 purpose.T-Code − SU10 User Mass MaintenanceYou can select multiple users at one time and lock/unlock them directly. To select multiple users, you need to select a checkbox and click on lock/unlock button.
Read MoreFetch unique records from table in SAP ABAP
As you said you are working in ABAP and SQL, so I would expect that you would be using OpenSQL for your SQL activities.You can get the unique records just by using a DISTINCT operator.SELECT DISTINCT Name from where
Read MoreField not getting save from table to transparent table in SAP
What I can understand from the problem is not type mismatch but the mismatch in size as defaults are different for each. If you change the size as per your needs, it should work.
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.DATA: lv_para TYPE string. lv_para = ' You &are like& kite &flying& in a &hurricane&'. REPLACE ALL OCCURRENCES OF REGEX '&[^&]+&' IN lv_para WITH ''. WRITE lv_para.Let me explain the regex for you. It should match the first ‘&’, then you can have any combination with multiple occurrences of ‘&’ and the last occurrence of ‘&’ must be matched.
Read MoreIdentify the program to edit an ABAP code
There are few ways in which you can identify the program for editing if you know the transaction code in advance.Firstly you can useSE93 for identifying the program on basis of the transaction.Secondly, you can run the TCode, and then drill down to program from menu. You can lead to program from System → Status → SAP Data → Repository Data →Program.Lastly, when you run the T-Code, in the SAP GUI you can see an arrow in the bottom of the editor, Just click on it to get more information about the transaction. You can get details including the program ...
Read More