print this page
Latest Post

How many ways you take SAP HANA database data backup?

There are different ways and tools to create a data backup.

a) SAP HANA studio
In the Navigator view select the system for which you want to start a backup. Use right mouse click and choose Backup from the context menu. Specify the location (directory) and the backup file prefix
to use. (The default location shows the path specified in the backup parameter basepath_databackup.)

b) SQL commands
You can enter SQL commands either by using the SQL editor in SAP HANA studio, or by using the hdbsql program on the command line.The backup can be started with the following SQL command:
If no absolute path is specified, the default backup location is prepended to the target. In both cases, a
suffix will be appended to the target.

c) Batch mode
To perform data backups in batch mode, we recommend that you use the command line tool hdbsql on operating system level. hdbsql enables you to trigger backups through crontab.

d) DBACockpit (from the ABAP system only)
You can find the DBA Cockpit documentation in the SAP Help Portal

Do I have to stop the SAP HANA database for backup?

No. Data and log areas can only be backed up when the SAP HANA database is online. During data and log backup the system is available as usual.

S/4 HANA 1511 - Netweaver 7.5 components

SAP S/4HANA, on-premise edition 1511 is based on SAP NetWeaver 7.5

 SAP NetWeaver 7.5 for SAP S/4HANA, on-premise edition 1511

Tags:Component Name Comment Application Server ABAP Includes SAP Basis 7.5 Basis Apps UI for Basis Applications 100 Business Warehouse SAP NW 7.40 BI Content Addon 7.57 BI Content Extension BI Content Extension for BI Content 7.57 Adobe Document Services SAP NetWeaver 7.5 Enterprise Services Repository SAP NetWeaver 7.5 ESR Content XI Content SAP ABA_ 75A Advanced Adapter Engine Extnd SAP NetWeaver 7.5 Content Server SAP NetWeaver 7.5 Frontend Adobe Livecycle Designer 11.0 SAP GUI for Java 7.40 SAP GUI for Windows S/4 7.40 SAP Screenreader Extensions ABAP in Eclipse SAP NetWeaver 7.5 SAP Web Dispatcher SAP NetWeaver 7.5 

hdblcmgui display error - GCC Libraries (HANA Installation error)

<servername>:/51051151/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ./hdblcmgui
13:39:54: Error: Unable to initialize GTK+, is DISPLAY set properly?
SAP HANA Installer Runtime Error:
perl compilation error (loading LCM::Gui::App::LCMGuiApp):
cannot load wxWidgets properly: cannot open display
BEGIN failed--compilation aborted at SDB/Install/App/ line 6.
BEGIN failed--compilation aborted at LCM/Gui/App/ line 6.

HANA License FREE with SAP Solution Manager 7.2

All customers with a valid SAP maintenance agreement can use SAP HANA as database for SAP Solution Manager. There is no additional SAP HANA licensing required.

Who should consider this?
This extension of usage rights is especially valuable for customers who are:
– SAP HANA only
– in a transition phase to SAP HANA
– paying maintenance for their SAP Solution Manager database (ex., Oracle, MSSQL)

HANA Memory- How to free up memory by unloading table from memory ?

Under normal circumstances, the SAP HANA database manages the loading and unloading of tables into and from memory independently. Actually, the main aim of SAP HANA database is to keep all relevant data in memory.

But, one can manually load and unload individual tables if necessary. How?....It’s simple, and it can be done from SAP HANA Studio itself.

Select the table by right click and choose the option “Unload …”
And later, manually load the table into memory again, if needed.
Moreover, if somebody fires the query associated to the same unloaded table, SAP HANA will pick & load the same table into memory FULL or PARTIALLY, purely depending upon the executed query.
Again, if one needs to free up memory, he/she can manually trigger the delta merge operation for a column table manually in SAP HANA Studio. The delta merge operation is related to the memory management concept of the column store, i.e, the part of the SAP HANA Database that manages data organized in columns in memory.

So, options are as follows:
“Unload …” – Free up memory by unloading table from memory
“Load …” – Loading the table into memory
“Merge…” – Triggering delta merge operation for a column table

Post By Debajit 

HANA System hangs with high CPU usage - what to do?

Root cause:
Problem caused by the configuration of transparent huge page

What to Check
1. Check Transparent Huge Page whether it is set to [never] by running the command "cat /sys/

Apply KBA 2031375 - SAP HANA: Transparent HugePages (THP) setting on Linux

Tags: SAP HANA system hangs,

Expensive Statements Trace Activation - HANA

File: global.ini
Property: expensive_statement
Default: Inactive

HANA Studio
You activate and configure the expensive statements trace in the Administration editor on either the Trace Configuration tab or the Performance tab.

Additional Info:
You can configure the expensive statement trace further using the following properties in the expensive_statement section of global.ini configuration file.

Maintenance Planner Screens SAP S/4 HANA

Maintenance Planner Screens SAP S/4 HANA

Ex., Preparing the Stack for ERP 6.0 EHP8 S/4 HANA Finance 1605 using Maintenance Planner

S/4HANA- Why Sourcing and Procurement Will Never Be the Same with SAP S/4HANA?

Imagine for a moment that you are a procurement officer working for a national retail chain. You just learned that your marketing team is gearing up to launch a national promotional campaign for a product line. The promotion is a very big deal for the company, and many executives are relying on it to meet revenue and profit targets.
But wait a minute: It’s Friday, and you have already planned an exciting weekend off. The last thing you want is this promotion overshadowing it. Now, what if you had all the information you need right now that can help you ensure that the promotion is successful without running out of stock or ending up with lots of excess inventory?
Let’s compile a quick list of critical information you might need:
  • Which vendors currently supply the materials that are part of the promotion?
  • When do their contracts expire, and what are their consumption rates?
  • What are the historic performance scores of these suppliers?
  • Are there other suppliers that were used in the past that you could procure form?
  • How long will it take to onboard these alternative suppliers, if needed?
I’m sure you can think of a few more questions but let’s work off of these for the time being. Now, revisit the above list again and mark down how many of these questions you can answer right now at this very moment. How many of them you can answer within the next 24 hours. How many in 48 hours? More important, how many cannot be answered at all?
…How is that weekend looking so far?

SAP S/4HANA: Three Ways to Make Sourcing and Procurement Strategies More Productive

A significant burden falls on procurement leaders who have to deal with an ever-increasing number of materials, suppliers, and contracts. Real-time insights into supplier spend, evaluations, scores, and contracts can have an immediate impact on their company’s bottom line and competitive position. Yet, many procurement executives are left with legacy technologies that hamper their productivity and diminishes their ability to spot gaps in suppliers’ performance and act immediately.
In sourcing and procurement, SAP S/4HANA can help procurement leaders be more productive by enhancing their ability to manage and optimize operational procurement. Let’s have a deeper look at how S/4HANA is different from classic procurement approaches enabled by pre in-memory enterprise resource planning (ERP) applications running on classical databases. (To find out how SAP S/4HANA is different from pre in-memory solutions in the supply chain line of business check out my previous blog here.)

Instant Material Search

With SAP S/4HANA, you can instantly search for a specific term – such as a supplier, material, or rate – by using a Google-like search field. From there, you can drill down and navigate to various object pages, navigating from supplier object pages to materials pages. This level of insight uncovers suppliers that are delivering the same material and provides alternatives that you can onboard with ease, if needed.  In classical ERP system users had to deal with isolated displays of documents and lacked the ability to execute searches across all documents and master data which sapped their productivity and limited their ability to quickly respond to material shortages.

Supplier Evaluation and Spend Management

SAP S/4HANA brings new real-time insights and advanced analytics to procurement officers. A wide array of real time analytical views are now provided through the Fiori User Experience for Supplier Analytics such as On-time delivery,Price Variance and Quantity Variance, Contract Analytics such as Unused ContractsContract Expiry, and Contract Leakage and Spend Analytics such asNon-Managed SpendPurchasing Spend and Of-Contract Spend to name a few. By running on data in real time without extracting the data into a separate data warehouse, you receive alerts from key performance indicators whenever thresholds are affected. In turn, procurement managers can make instant decisions about which suppliers to choose based on up-to-the-minute information.


Figure 1- Lab preview of SAP S/4HANA Procurement overview page showing filter cards across suppliers, materials, material groups, purchasing category, purchasing, group, plant, company code

Supplier Collaboration

SAP S/4HANA also benefits from native integration with the Ariba Network. In the past, with SAP ERP running on a classical database, a separate add-on was used to integrate into the Ariba Network. Unfortunately, this made the IT system too complex. Now with SAP S/4HANA, integration with the Ariba Network is prebuilt natively into the solution. Order creation, order change, order confirmation, advanced shipping notification, and invoicing can now be sent directly to the Ariba Network from within the software facilitating supplier collaboration.
This allows procurement officers to create orders in SAP S/4HANA and then send them to their suppliers on the Ariba Network for processing. Suppliers can then confirm orders or let their customers know if items are back-ordered. Suppliers can also notify their customers that items have shipped, and send an invoice for payment. Business rules can help enforce process and document compliance. For example, procurement officers can require that a supplier must confirm an order, create a ship notice, or wait for a goods receipt notice before they can send an invoice. Future functionality is planned such as supporting Variable Supplier Response in case suppliers can’t commit to the full order and Advance Shipping Notification in cases where special handling requirements are needed (e.g. special forklift or storage temperature for the delivered items).

Proc 2.PNG

Figure 2 – example of a purchase order and invoice automation between SAP S/4HANA cloud edition and the SAP Ariba Network (note the SAP HANA Cloud Integration layer is optional).

The Before and After Picture

For a quick side by side explanation of how SAP S/4HANA can transform your sourcing and procurement processes compared to pre in-memory solutions (and free up your weekend), check out the “before and after” infographic below.


This story originally appeared on SAP Business Trends.
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved