SAP Expert has Published 132 Answers

Converting BLOB to Char in SAP HANA using SQL

SAP Expert

SAP Expert

Updated on 25-Jun-2020 20:50:38

You can perform varchar casting using following query:SELECT TO_ALPHANUM(col) FROM ......

Converting BLOB to Char in SAP HANA using SQL

SAP Expert

SAP Expert

Updated on 25-Jun-2020 20:49:59

You can perform varchar casting using following query:SELECT TO_ALPHANUM(col) FROM ......

IN statement in SQL doesn’t accept a wild character (SAP)

SAP Expert

SAP Expert

Updated on 25-Jun-2020 20:47:09

Note that IN statement in SQL doesn’t accept a wild character. You have to use OR/AND to make it work as mentioned below:select * from Test1 t INNER JOIN Test2 s ON t.ID = s.RID where t.sdate >= ?1 AND t.edate

Fetching monitoring data in an application using SAP FM's

SAP Expert

SAP Expert

Updated on 25-Jun-2020 20:45:04

You need to login to XM interface and there is different BAPI’s that you can use to read CCMS data.Function Module:BAPI_SYSTEM_ALERT_ACKNOWLEDGE BAPI_SYSTEM_ALERT_GETDETAILS BAPI_SYSTEM_MON_GETLIST BAPI_SYSTEM_MON_GETTEMPLATE BAPI_SYSTEM_MON_GETTREE You can refer this documentation to know more about Function Modules:SAP XM InterfaceRead More

Starting SAP HANA Studio with immediate system logon

SAP Expert

SAP Expert

Updated on 22-Jun-2020 09:16:01

Yes, to perform an immediate login you have to navigate to Installation directory and use the following start parameters −-h  Host name-n  Instance number-u  User nameUser name with special characters should be enclosed in double quotations (“”).Windows OShdbstudio.exe -h hanademo -n 03 -u HANAADMINhdbstudio.exe -h hanademo -n 03 -u "&hanatest"Linux ... Read More

Exporting list of all SAP HANA systems in XML file

SAP Expert

SAP Expert

Updated on 22-Jun-2020 09:09:25

Yes, it is possible to export a list of your SAP HANA systems from the SAP HANA studio as an XML file and then it can be imported to another instance of the SAP HANA studio or use it as a system archive to which other users can link.This can ... Read More

Single Sign-on configuration in SAP HANA system

SAP Expert

SAP Expert

Updated on 22-Jun-2020 09:06:28

SSO can be configured on below authentication methods −SAMLKerberosX.509 client certificates for HTTP access from HANA XS engineSAP Logon/Assertion tickets

Different authentication methods supported in SAP HANA

SAP Expert

SAP Expert

Updated on 22-Jun-2020 09:05:43

Below is the list of authentication methods supported by SAP HANA −User name/PasswordKerberosSAML 2.0SAP Logon ticketsX.509You can configure any of authentication method while creating a new user −

Searching a SAP HANA system in HANA Studio System view

SAP Expert

SAP Expert

Updated on 22-Jun-2020 09:03:53

When you are managing a large number of systems using HANA Studio, this can be used to find a specific system more quickly.To use find system option, the following steps should be performed −From the Systems view toolbar, choose the Find System (Find System) button.2. Enter a search string −You ... Read More

Use of Restricted user in SAP HANA system

SAP Expert

SAP Expert

Updated on 22-Jun-2020 08:58:59

When you compare standard database users, restricted users have the following limitations −With restricted users, it is not possible to create objects in the database as they are not authorized to create objects in their own database schemaRestricted users are not authorized to view any data in the database as ... Read More

1 2 3 4 5 6 7 ... 14 Next
Advertisements