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
-
Economics & Finance
Articles by SAP ABAP Expert
Page 7 of 12
Understanding a database view in SAP HANA database
Consider the following example −Example Id Empl. NameEmpl.userEmpl.passwordJoining Date1 Employee 1 Emp1Emp1Pwd 9/11/20162 Employee 2Emp2Emp2Pwd16/08/20153Employee 3 Emp3Emp3Pwd 15/09/20164Employee 4Emp4 Emp4Pwd3/07/20145Employee 5 Emp5 Emp5Pwd 10/09/20126 Employee 6Emp6 Emp6Pwd 1/10/2013 Consider a scenario when a developer needs to analyze some data of Employee Table with the above fields. Using database view, an administrator can create a virtual table which only contains information about Employee Id, Employee name, and date of joining and give permission to developer to use that view.
Read MoreChecking information about executed savepoints in SAP HANA
M_SAVEPOINT_STATISTICS view shows information about executed savepoints.This view contains columns- START_TIME, STATE, VERSION and LAST_* relate to the last executed or currently-executing savepoint.Following information is available −
Read MoreUse of parameter "basepath_datavolumes_es" in global configuration file in SAP HANA
basepath_datavolumes_es parameter provides the default path to the dynamic tiering data directory (data_es). This path must be available to the dynamic tiering host, but need not be available to HANA hosts. Avoid including the default installation directory in the path.Value − File PathDefault − /HANA/data_es/
Read MoreChecking enforced license in SAP HANA
This details can be checked from M_LICENSE view in HANA database. Try executing below query in SQL editor −SELECT EXPIRATION_DATE, ENFORCED, PERMANENT, LOCKED_DOWN FROM "SYS"."M_LICENSE" ;When Enforced value column is shown false so it means that license in use is not Enforced and you are using unenforced license.
Read MoreDifference between SAP ERP and SAP S/4 HANA
SAP S/4 HANA stands for SAP Business Suite for SAP HANA and it provides simplified user experience, business processes and data models.SAP S/4 HANA is built on following features −Simplified data modelsFiori User interfaceGuided Configuration
Read MoreVendors for SAP HANA appliance manufacturing
SAP HANA appliance, SAP has partnered with top IT hardware vendors to provide SAP HANA appliance and licensed is provides by SAP. To provide installation and configuration of SAP HANA platform, there are total 11 vendors for HANA appliance manufacturing.IBMDellHPLenovoCiscoFujitsuNECHuaweiUnisysHitachiSGI
Read MoreChecking all alert types in SAP HANA
This can be checked in Alerts tab under SAP HANA Administration. From drop down, you need to select “All Alerts” as shown below −You can also check occurrence of each alert raised in HANA by double click on Alert description. It shows you date and time when alert was previously raised.
Read MoreConfiguring SMTP in SAP HANA for alerting
You can configure SMTP in Alerts tab under SAP HANA Administration. Click on Configure button and you need to enter the below information −Sender EmailSMTP serverSMTP PortRecipient email
Read MoreDefining threshold values for alerting in SAP HANA
You can define this under Configure → Configure Check Thresholds. You have an option to define Low, Medium and High values for these parameters.
Read MoreChecking version of SAP HANA system
In SAP HANA Studio, select HANA system and right click. Select last option Properties from the list as below −In Properties window, navigate to Version history and you can see the version of your SAP HANA system.
Read More