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
Missing SAP Java Connector libraries JCo- librfc32.dll, com.sap.utils and com.sap.mw
Please note that all these library files - librfc32.dll, com.sap.utils and com.sap.mw come under JCo 2.1. With release of JCo 3.0, it’s classes were also relocated from packages com.sap.mw.jco.* to com.sap.conn.jco.*For running with SAP JCo 3.0, you need these files at runtime - sapjco3.jar and sapjco3.dll (on Windows). You can follow below procedure for installation of JCo files:Installing JCo on Windows platform −In Windows OS, you have to copy sapjco3.jar file into ITDI_HOME/jars/3rdparty/others.Copy the sapjco3.dll file into ITDI_HOME/libs. On Windows, JCo 3 requires additional Microsoft Visual C++ 2005 libraries to be installed. Installation details for the package that contains these ...
Read MoreUsage of Operator +n and (n) to pass data in ABAP
If my date format is in the form DDMMYYYY then Z_Period(4) equals DDMM so (4) means first four characters.If my date format is in the form DDMMYYYY then Z_Period +4 equals YYYY so +4 means after the first four characters.So If I say Z_PERIOD+2(2) then this would result MM- i.e. 2 characters after first 2.Let us see how to use them in a program −\Sample program to understand use of +n and n bit operators data: lv_text(10) type c. lv_text = "World". write: / lv_text+2(2).Output of this code would be “rl”“+n” specifies a string offset“n” specifies length of the ...
Read MoreFinding 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 More