SAP HANA Administration

HANA Administration — The Engine Behind the Analytics

SAP HANA has, over time, become the heart of the digital enterprise. It is the central database where transactional data flows in, where static, unstructured data is stored and accessed, and where web, mobile, and IoT (Internet of Things) devices connect for delivering superlative customer experience.

Managing such a vital technology solution is increasingly complex. HANA administrators have a critical role to play across the lifecycle of SAP HANA — from the initial setup for optimal storage and access to regular administration for backups and monitoring to periodic performance tuning to finally, on-demand configuration to meet business needs.

HANA Administration — The Engine Behind the Analytics

With the rapid application roadmaps of today, including the move to SAP S/4HANA and the development of cloud applications for analytics, there is increased pressure on HANA administrators to “run like a factory,” as SAP calls it. While keeping up with the speed of execution with efficient change management, HANA administrators need to ensure security and performance.

HANA administrators use the HANA Studio to perform the following activities:

System monitoring
Load distribution
Exceptions
Database monitoring for performance and memory consumption
Performance monitoring
Backup and disaster recovery monitoring
Alerting
Housekeeping

SAP HANA can be deployed in a variety of approaches. This interview with experts from Protiviti discusses choosing the right SAP HANA deployment option and other best practices with SAP HANA administration.

Multiple databases can be set up in a single SAP HANA system. The SAP HANA system itself can be deployed either on a single system or multiple host systems. HANA administrators can assess the performance needs of their organization to balance the load and enable scalability and decide to deploy on a single or multiple systems.

This SAP HANA guide to performance analysis, optimization, and administration techniques provides a deep dive into advanced SAP HANA administration and master techniques and tools for effective analysis of issues, monitoring the workload, and overall management of SAP HANA systems, including multi-tenant databases.

SAP provides many tools to administer SAP HANA.

SAP HANA Cockpit is based on SAP Fiori Launchpad and helps access a long range of HANA applications through a web interface.
SAP HANA Studio helps perform system administration and monitoring activities in a distributed environment. Different administrators can be assigned different access privileges to handle various tasks.
SAP HANA Lifecycle Manager helps to manage SAP HANA components after installation. You can add/remove hosts or rename using the Lifecycle Manager.
SAP Solution Manager helps to integrate your SAP HANA platform with other business solutions.
SAP HANA HW Configuration Check helps to check the interoperability of the SAP HANA system with enterprise storage.

Many vendors such as NetApp, AWS, Google Cloud, HPE, and Microsoft Azure bring significant expertise in deploying, monitoring, and administering SAP HANA so that it powers the modern enterprise.

- Premium
Expand PS Master Data by Adding New Fields to Project Builder

Reading time: 28 mins

The available fields in the PS master data are often insufficient to cover a company’s needs. The author describes partner functionality, user-defined fields, and customer-specific fields, which are three different options to incorporate additional fields into the project master. He discusses their advantages and shortcomings and the steps to implement them. When most businesses implement...…
- Premium
Gain Control of Unresolved A/R Documents or Accounts with the Deduction Management Component

Reading time: 3 mins

The Deduction Management Component is a “bolt on” product provided by SAP’s Global Solution Center to enhance the functionality of the SAP R/3 Accounts Receivable module. This article describes how A/R and Credit groups, when faced with customers who do not pay their Total Amount Due, can gain control of complex resolution issues by using...…
- Premium
Web-Based Asset Accounting with mySAP Financials

Reading time: 4 mins

The Fixed Asset Accounting module of mySAP Financials gives you access to end-user transactions and reports via the Web. This makes possible applications such as Web-based asset procurement, employee self-service updates to an asset’s physical location, and downloading asset numbers to a hand-held bar-coding or scanning device. The mySAP.com version of R/3 makes a number...…
- Premium
Are My A/R and A/P Figures in PCA Wrong?

Reading time: 19 mins

Discrepancies between FI and Profit Center Accounting (PCA) figures often confuse even the most experienced controllers. The author shows how the transfer of balance sheet A/P and A/R accounts from FI to PCA can produce unexpected and bewildering results. He also explains the logic used to obtain PCA data. In numerous projects, I have been...…
- Premium
Are My A/R and A/P Figures in PCA Wrong?

Reading time: 19 mins

Discrepancies between FI and Profit Center Accounting (PCA) figures often confuse even the most experienced controllers. The author shows how the transfer of balance sheet A/P and A/R accounts from FI to PCA can produce unexpected and bewildering results. He also explains the logic used to obtain PCA data. In numerous projects, I have been...…
- Premium
Ask the FI/CO Expert: Use a Simple Workaround to Automatically Release Credit-Hold Blocked Sales Orders After the Error Condition Improves

Reading time: 5 mins

Once a credit block on a sales order is active, what will cause the block to be automatically removed? The author, an SAP consultant from the Netherlands, explains how to set up a “semiautomatic” update to credit management. Key Concept The response to this month’s question is courtesy of guest expert Dr. Stef Cornelissen,...…
- Premium
Prepare Your R/3 System Now for the International Accounting Standards Deadline

Reading time: 14 mins

Impending deadlines for compliance with the International Accounting Standards (IAS) will require hard work on the part of many accountants and R/3 specialists. The problem posed by IAS is that, in most cases, two or more sets of figures have to be managed because of the differences among IAS, US GAAP, and national fiscal reporting....…
- Premium
When You Need a Report They Did Not Build, Consider QuickViewer

Reading time: 7 mins

To quote from a recent experience: “Can you show me how to list manually entered exchange rates and the amounts involved? I want to do a sanity check on possible typos.” To quote from a recent experience: “Can you show me how to list manually entered exchange rates and the amounts involved? I want to...…
- Premium
What You Need to Know About Textbook vs. SAP R/3 Activity-Based Costing

Reading time: 17 mins

The case for Activity-Based Costing (ABC) goes something like this: Traditional accounting methods do a good job of calculating product costs for the purposes of inventory valuation for financial statements, but a poor job of allowing a cost accountant to validate the cause-and-effect relationship assumptions on which managers base their daily decisions. The case for...…
- Premium
New IDoc Helps with Looming SEPA Deadline

Reading time: 14 mins

Become familiar with the structure and application of the recently introduced Intermediate Document (IDoc) type PEXR2003. Understand why SAP developed this IDoc type and how you can use it for your SAP In-House Cash (SAP IHC) implementation. Key Concept SAP In-House Cash allows corporate cash and treasury management departments to set up a payment factory...…