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 HANA Articles
Page 31 of 58
Finding where-used list of SAP standard programs
You would need to SAPRSEUB. This will enable you to use the where-used functionality of standard SAP programs and provide you with indices of the programs. Please note that this program runs for a long time and require some disk space.SAPRSEUB is a standard Executable ABAP Report available within your SAP system.SAPRSEUT Update Object Lists after TransportSAPRSEUB Generate Where-Used List (For All Programs)SAPRSLOG Refresh Navigation Indexes and Object ListsNote −Note that this report needs around 10 GB space in the DB and takes about 2 days to complete.
Read MoreBenefits 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 MoreDetermining values of parameters of given type on a given selection screen in SAP
The function module RS_SELSCREEN_INFO will provide you with the list of parameters and selection options once the report name is input. You can see full details about this FM by entering the name RS_SELSCREEN_INFO into the relevant SAP T-code like SE37 or SE80You can call this FM RS_SELSCREEN_INFO as below −CALL FUNCTION 'RS_SELSCREEN_INFO' " EXPORTING report = " rsvar-report Report Name TABLES field_info = " scr_info Information about type, reference field, etc. EXCEPTIONS ...
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 More