SAP HANA Articles - Page 39 of 63

Data backup in any RDBMS system comes under Data Persistence layer. SAP HANA holds the bulk of its data in memory for maximum performance, but it still uses persistent storage to provide a fallback in case of failure.When you refer a schema in database, it refers to a namespace in the database. It is not possible to take backup schema wise as you do for complete database.However it is possible to export a schema using below command −EXPORT "MY_SCHEMA".* AS BINARY INTO '/tmp/my_schema' WITH REPLACE;SyntaxEXPORT AS INTO [WITH ] [ ]Note that you shouldn’t take schema ... Read More

There is a number of ways you can achieve this. Here are few of the methods to do the same.a) There are many standard tools in SAP by use of which you can extract the data and also automate the whole process. With the use of an ETL tool, this can be achieved like SAP Data Services, OWB, etc.b) The other option is to write a code in ABAP to fetch the data from the database and the write into a format as per your requirement.c) You can also write a RFC or remote-enable function module which can be called ... Read More

The code you are using \1+ just removes consecutive occurrences only. You can use the below code.SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' OCCURRENCE ALL) FROM DUMMYThe output will come out to be “312”. This will remove all multiple occurrences and only last one will be kept.

You are using the correct Port number for instance number “00”. Port number 300315, here 00 represents instance number of your HANA system.Try using HANA client jar file ngdbc.jar instead of SAP Jar file.try {    Class.forName("com.sap.db.jdbc.Driver");    String url ="jdbc:sap://xx.x.x.xxx:30015/DBNAME"; //IP Address of HANAsystem followed by Port number    String user ="user";    String password = "password";    Connection cn = java.sql.DriverManager.getConnection(url, user, password);    ResultSet rs = cn.createStatement().executeQuery("CALL Test.STORED_PROC");    // ...Enter the action here } catch(Exception e) {    e.printStackTrace(); }

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.

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 More

You need to create a search help with custom data selection by defining a search help exit. To do custom data selection, first, go to the “Definition” tab of search help, remove all the content of “Selection method” input and now input the new function module in the “Search help exit”. The signature of the new module should be same as the F4IF_SHLP_EXIT_EXAMPLE. To do this, you can look into the documentation inside F4IF_SHLP_EXIT_EXAMPLE. Now the data from the second system can be fetched with the help of remote function call.

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 More

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 More

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