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
SAP Articles
Page 43 of 91
Everything is stored in database in SAP system
Note that it is easy to store data in form of SAP database tables as compared to files. You can also access files in SAP system but they are available on file system of SAP Application server and not easy to use with.With use of ABAP, you can easily raise queries against database tables and it is safe to run queries to get data. SAP has various tools that allow you to work with table entries and also to manage entire landscape easily.What databases are supported by SAP?PartnerVendorMicrosoft SQL Serverwww.microsoft.comMySQL MaxDBwww.mysql.comIBM DB2 (various versions)www.ibm.comOraclewww.oracle.comAlso SAP has its own in-memory computing ...
Read MoreSending a table from UI5 application to ABAP Function Module
This can be done using an OData service that accepts POST request from your UI5 application and writes data to a database table. While implementing OData service, you have to call ABAP Backend Class method.You have to remember that all application and classes are instantiated for processing and will end as soon as the request is completed. An OData service can be created using SAP Gateway Service Builder (SEGW).Following steps has to be performed for creating an OData service:Creation of Data ModelGenerate Runtime ObjectsRegistration of ServiceService ImplementationOnce you create a project in Gateway Service Builder, you have to create Entity ...
Read MorePort number for SAP HANA Cockpit offline administration
Following perquisites should be met for accessing SAP HANA cockpit for offline administration −To access this, you need credentials of the operating system user (adm user) that was created when the system was installed.Communication port 1129: As this Port 1129 is required for communication with the SAP Host Agent in a standalone browser via HTTPS.HANA Cockpit is configured with HTTP accessWeb browser supports the SAPUI5 library sap.m.
Read MoreSoft and hard stop of HANA system using HANA Studio
To stop a HANA system, right-click the system you want to stop and choose Configuration and Monitoring → Stop System…Following options are available when you stop a system −Soft − The system is stopped after all running statements have finished or the specified timeout is reached.Hard − The system is stopped immediately. Open transactions are aborted and rolled back.
Read MoreStop and start a particular database service in SAP HANA
Yes, you can start/stop a particular service of HANA system. To stop a service, go to Administration editor → Services tab. Right-click the service and choose the required option:
Read MoreAdding a service to a tenant database
To scale out a tenant database and/or distribute it across multiple hosts, you can add further server components, for example, an additional index server or a separate XS server. You add a service to a tenant database using the ALTER DATABASE SQL command.You do this from the system database using the following command −ALTER DATABASE ADD Following perquisites should be met to perform this task −You are logged on to the system database.You have the system privilege DATABASE ADMIN.
Read MoreRemoving a service from a tenant database in SAP HANA
Yes, it is possible to remove a server component, which are no longer required. This can be performed using ALTER DATABASE SQL command.Following perquisites should be met to perform this task −You are logged on to the system database.You have the system privilege DATABASE ADMIN.To remove a service, you need to open SQL console of the SAP HANA studio and run “ALTER DATABASE” statement.ALTER DATABASE DB1 REMOVE '' AT LOCATION 'HOST_A:30XXX'
Read MoreDiagnosis file of unavailable tenant in SAP HANA database
When a tenant database is unavailable due to some performance problems, the tenant database administrator can't access diagnosis files. In this case, a system administrator can access the diagnosis files of the tenant database from the system database using the SAP HANA studio.In the SAP HANA studio, open the Administration editor and choose Diagnosis Files and diagnosis files of the system database are displayed.Using the Database filter, select the tenant database → whose diagnosis files you want to see and diagnosis files of the selected tenant database will be displayed.
Read MoreCopying or moving a tenant database in SAP HANA
When you move or copy a tenant database, data is replicated from the original tenant database to the new tenant database in the target system. Following tables shows type of data replication for different type of data −Data and logs of the tenant databaseYesTrace and log files NoData backups NoConfiguration (*.ini) files with tenant-database-specific values NoCertificates and certificate collections stored in the tenant database Yes
Read MoreLock down of SAP HANA system
A SAP HANA system lockdown in the following scenarios −The temporary license key has expired.When a temporary license key is in use and the hardware key has changed.When permanent license key has expired and it is not renewed within 28 days.When installed license key is an enforced license key and the current memory consumption exceeds the licensed amount plus the tolerance.When all license keys installed in your database are deleted.You can’t run a query in lockdown mode and only a License Administrator can connect to database.
Read More