SAP Developer has Published 85 Articles

Loading an individual column in SAP HANA using SQL

SAP Developer

SAP Developer

Updated on 13-Mar-2020 07:59:07

222 Views

Yes, you can open SQL console and execute the statement −LOAD (, ...);This SQL query will load or unload entire column into or from main memory. Its load status is TRUE or FALSE. The table's load status is PARTIALLY.

Different Package type in SAP HANA

SAP Developer

SAP Developer

Updated on 12-Mar-2020 11:11:07

221 Views

In SAP HANA, packages are used to store design time repository objects under the Content folder in HANA Studio. You have two types of the package in HANA system:Structural This package only contains sub-packages and doesn’t store repository objects.Non-Structural This package stores both repository objects and sub-packages.Read More

M_Expensive statement in SAP HANA

SAP Developer

SAP Developer

Updated on 12-Mar-2020 10:36:10

1K+ Views

This can be checked using system view M_EXPENSIVE_STATEMENTS.SELECT * FROM M_EXPENSIVE_STATEMENTSIn SAP HANA, the M_EXPENSIVE_STATEMENTS view provides convenient access to the most expensive statements that were executed on the system. A statement is considered being expensive if its runtime exceeds a particular threshold. Please note that the expensive statements trace ... Read More

Information available in M_DISKS view in SAP HANA

SAP Developer

SAP Developer

Updated on 12-Mar-2020 10:28:16

114 Views

M_DISKS System View is used to provide information about disk configuration and utilization of the host machine. The following information is available −

Maximum number of columns in a table in SAP HANA

SAP Developer

SAP Developer

Updated on 12-Mar-2020 10:15:15

602 Views

The maximum number of columns in a table is 1000.

Key characteristics of using Analytic Privilege in SAP HANA Modeling

SAP Developer

SAP Developer

Updated on 12-Mar-2020 08:15:08

98 Views

Analytic Privilege is created inside packages under Content tab.Analytic Privileges are only applied to attributes in an Information View. We cannot add measures to restrict access to Analytic privileges.Analytic Privileges are used to control read access to SAP HANA Information views. You can also hide an information from the specific ... Read More

Checking various details in SAP HANA in multitenant environment

SAP Developer

SAP Developer

Updated on 06-Mar-2020 06:13:28

51 Views

You can check the landscape of HANA system, navigate to Landscape tab in HANA studio. Services show all the services running on HANA system.The following screenshot shows SAP HANA system and all the key services running under system Landscape for the same system.You can see the service name corresponding to ... Read More

Migrating to SAP HANA system

SAP Developer

SAP Developer

Updated on 06-Mar-2020 05:31:54

234 Views

SAP HANA is a combination of HANA Database, Data Modeling, HANA Administration and Data Provisioning in one single suite. Following are key features of SAP HANA −SAP HANA is a combination of software and hardware innovation to process a huge amount of real-time data. Based on multi-core architecture in the distributed ... Read More

In SAP Business One, making HTTP request with SOAP body

SAP Developer

SAP Developer

Updated on 06-Mar-2020 05:16:53

265 Views

You can use web services wrapper provided by SAP which allow programmer to use the services provided by DIS. To perform an easy integration, it is possible to use SoapUI in open source version. The connection is performed using login service and with reference of its wsdl, login request can ... Read More

Validity of SAP HANA permanent license after expiry

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:38:17

300 Views

Note that the validity of your permanent License key is till predefined date and when it is expired, a temporary license key is issued, with a validity for only 28 days. During this period, you have to install a permanent License key again.

Advertisements