- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 1044 Articles for SAP
![SAP Developer](https://www.tutorialspoint.com/articles/images/user_icon.png)
640 Views
To implement Text join, create a table −CREATE COLUMN TABLE TEST.P_INFO (PROD_ID BIGINT, P_CAT NVARCHAR(50)); INSERT INTO TEST.P_INFO VALUES (11, ’FURNITURE’); INSERT INTO TEST.P_INFO VALUES (14, ’ELECTRONICS’); INSERT INTO TEST.P_INFO VALUES (25, ’FURNITURE’); INSERT INTO TEST.P_INFO VALUES (76, ’ELECTRONICS’);2nd table −CREATE COLUMN TABLE TEST.PROD_DESC (PROD_ID BIGINT, LANGUAGE NVARCHAR(10), DESCR NVARCHAR(100)); INSERT INTO TEST.PROD_DESC VALUES (11, ’E’, ’Table’); INSERT INTO TEST.PROD_DESC VALUES (11, ’D’, ’Chair’); INSERT INTO TEST.PROD_DESC VALUES (14, ’E’, ’32 LED’); INSERT INTO TEST.PROD_DESC VALUES (14, ’D’, ’32 inch LCD’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Comp Table’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Mixer’);Note that it should have ... Read More
![SAP Developer](https://www.tutorialspoint.com/articles/images/user_icon.png)
251 Views
In SAP HANA, you can use Text join to fetch description based on user’s session language. When a text join is used, it finds out details in user’s preferred language.Text join can be applied on below modeling objects in SAP HANA −Attribute ViewAnalytic ViewCalculation View
![SAP Developer](https://www.tutorialspoint.com/articles/images/user_icon.png)
3K+ Views
You need to follow below steps to install a new license key in SAP HANA −Step 1 −In the SAP HANA studio, navigate to the properties page of the database for which you have requested the license key.Step 2 −On the properties page, choose the button for installing the license key.Steps 3 −Navigate to your license file and select it.Step 4 −After a successful confirmation, the properties page of the system is updated with the new license information if this is valid for the database.
![SAP Developer](https://www.tutorialspoint.com/articles/images/user_icon.png)
463 Views
A new license key is required in the following scenarios −When your current license key is about to expire.You have changed the hardware. As a result, the hardware key has changed. Your database continues to run with a temporary license key that was generated automatically.There is a change of the main memory amount.A change of the system ID of your existing SAP HANA database is planned, for example, due to recovery, copy, and/or renaming. A valid license key for the new system ID must be available for the change to avoid a system standstill.There is a change of the installation ... Read More
![SAP Developer](https://www.tutorialspoint.com/articles/images/user_icon.png)
167 Views
To export this details you first need to have INIFILE ADMIN system privilege. Following hdbsql command can be used −SELECT ROUND(SUM(INSTANCE_TOTAL_MEMORY_USED_SIZE) / 1024 / 1024 / 1024, 0) AS DATABASE_MEMORY_USED_IN_GIGABYTES FROM M_HOST_RESOURCE_UTILIZATION RU, M_LANDSCAPE_HOST_CONFIGURATION HC WHERE RU.HOST = HC.HOST AND HC.INDEXSERVER_ACTUAL_ROLE IN ('MASTER','SLAVE');You can also run this command in SQL editor to get this details −
![SAP Developer](https://www.tutorialspoint.com/articles/images/user_icon.png)
1K+ Views
You need to edit nameserver.ini file. Use the operating system user adm to edit the file /usr/sap//global/hdb/custom/config/nameserver.ini in the file system and add the following lines −[trace] licensing = debugOnce you edit the file → Restart the instance.Check the latest nameserver trace file nameserver_...trc, which is to be found under /usr/sap//HDB//trace/Check the end of that trace file to find the installation and system number in lines.Ex −Licensing AbstractLicenseManager.cpp(00063) : Installation # : "XXXX0XX234X"Licensing AbstractLicenseManager.cpp(00063) : System # : "XXXXXXXXXXXX4234523432434”You have to use this installation number and system number to request a new license key for ... Read More
![SAP Developer](https://www.tutorialspoint.com/articles/images/user_icon.png)
651 Views
A new permanent license key used to replace an expiring permanent license key must contain the same license identification data as are already installed. Only then it can be successfully installed. The license identification data consists of system ID, hardware key, installation number, and system number. Any difference in one of these four identifiers will result in the rejection of the license key. In most cases, this is the reason for the failure in license key installation.You can use Trace function to verify/identify the installation and system number of your database instance. If the current license key is still valid ... Read More
![SAP Developer](https://www.tutorialspoint.com/articles/images/user_icon.png)
503 Views
In a Single-Database system, proceed as follows to perform a system measurement of your SAP HANA system, which includes the system measurement of the SAP HANA database itself as well as of the relevant options and products −In the SAP HANA Studio, select your database in the navigator and choose Properties in the context menu of the system.Click on the "Export System Measurement" button. A File Browser dialog opens up allowing you to store the result of the system measurement, the measurement report, as an XML file to your local file system.Send this XML file to SAP as requestedThe XML ... Read More